Shulou(Shulou.com)06/01 Report--

1. Backup / shutdown / off monitoring

Rman backup

Shutdown immediate

Lsnrctl stop

two。 Install 11.2.0.4 softwar

Picture outline

Mkdir new directory

3. Modify environment variable / listening file / dbs content

Modify .bash _ profile content

Content under cp network/admin

Content under cp dbs/

4. Database executes upgrade script

SQL > startup upgrade

ORACLE instance started.

Total System Global Area 5044088832 bytes

Fixed Size 2237048 bytes

Variable Size 922750344 bytes

Database Buffers 4110417920 bytes

Redo Buffers 8683520 bytes

Database mounted.

Database opened.

SQL > @? / rdbms/admin/utlu112i.sql-perform pre-upgrade check

Oracle Database 11.2 Pre-Upgrade Information Tool 08-31-2017 22:39:24

Script Version: 11.2.0.3.0 Build: 001

.

*

Database:

*

-- > name: MYTEST

-> version: 11.2.0.3.0

-- > compatible: 11.2.0.0.0

-> blocksize: 8192

-- > timezone file: V14

.

Database already upgraded; to rerun upgrade use rdbms/admin/catupgrd.sql.

-- this display is incorrect. To delete the relevant pmon kill, delete the lk under dbs, and then open the library.

SQL > @? / rdbms/admin/catupgrd.sql-execute script

SQL > startup

ORACLE instance started.

Total System Global Area 5044088832 bytes

Fixed Size 2237048 bytes

Variable Size 939527560 bytes

Database Buffers 4093640704 bytes

Redo Buffers 8683520 bytes

Database mounted.

Database opened.

SQL > @? / rdbms/admin/utlrp-Statistics invalid objects

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.