Monday, December 22, 2014

Upgrade 10201 to 10204

Shutdown all running components

$ isqlplusctl stop
$ emctl stop dbconsole
$ lsnrctl stop
$ sqlplus / as sysdba
SQL> shutdown immediate

Update Binaries

$ cd /home/oracle
$ unzip p6810189_10204_Linux-x86.zip
$ cd Disk1/
$ ./runInstaller

Post upgrade steps

SQL> startup upgrade
SQL> spool pre_upgrade.log
SQL> @utlu102i.sql
SQL> spool upgrade.log
SQL> @catupgrd.sql
SQL> spool off
SQL> shutdown immediate

SQL> startup
SQL> conn / as sysdba
SQL> spool recompile.log
SQL> @utlrp.sql
SQL> spool off


#Check the all components are upgraded.

SQL>
set lines 10000
set pages 1000
column comp_name format a40
column version format a12
column status format a6
select comp_name, version, status from sys.dba_registry;

No comments:

Post a Comment