Oracle Database PSU Upgrade (this experiment is to upgrade 10.2.0.3.12 to 10.2.0.3.15)

PSU Upgrade (This experiment is to upgrade 10.2.0.3.12 to 10.2.0.3.15)

First, unpack the installation package
Custom storage Path is/home/oracle/yjb/psu/10.2.0.3.15
cd/home/oracle/yjb/psu/10.2.0.3.15
Unzip P6880880_112000_04-sep-2015_linux-x86-64.zip
Unzip p20760997_112030_15_linux-x86-64.zip-d 1120315

Second, check the PSU patch to see if there is a conflict
/home/oracle/yjb/psu/10.2.0.3.15/opatch/opatch prereq CHECKCONFLICTAGAINSTOHWITHDETAIL-PHBASEDIR/HOME/ORACLE/YJB /psu/10.2.0.3.15/1120315

Iii. Collection of information
--View component information
Set Linesize pagesize 600
Col Comp_name for A30
Select Comp_id,comp_name,version,status from Dba_registry;
--Check the patch situation
Set Linesize pagesize 600
Col Action_time for A30
Col COMMENTS for A30
Select Action_time, ACTION, COMMENTS from Sys. Dba_registry_history;
--View Invalid objects
Select COUNT (*) from dba_objects where status<> ' VALID ';

Iv. Stopping the database
--Stop the database external process
ps-ef|grep-v grep |grep Local=no|awk ' {print $} ' |xargs kill-9
--Stop the Library
Alter system checkpoint
Shutdown immediate
--Stop monitoring
Lsnrctl stop

--View the start/stop log
/home/oracle/diag/rdbms/sccp/sccp/trace/alert*.log

Five, backup
Use ROOT to back up Oracle_home (full backup of #oracle_home parent directory)
TAR-ZCVPF db_20151103.tar.gz db_1

Six, hit the PSU
Su-oracle
cd/home/oracle/yjb/psu/10.2.0.3.15/1120315/20760997---20760997 the directory extracted for the compressed package (do not enter the directory, apply will error)
/home/oracle/yjb/psu/10.2.0.3.15/opatch/opatch Apply

----If the following error occurs during a patch
Opatch Error Prerequisite Check "Checkactivefilesandexecutables" failed
Following executables is active:
/opt/oracle/product/10.2.0/bin/oracle
Applysession failed during prerequisite checks:prerequisite check "Checkactivefilesandexecutables" failed.

Locate the process that is consuming the file by using the following command, and then kill the process
Fuser/opt/oracle/product/10.2.0/bin/oracle

Vii. Checking the database
Su–oracle
$ORACLE _home/opatch/opatch LSINV

Update data dictionary, compile invalid object
Su-oracle
CD $ORACLE _home/rdbms/admin
Sql> Connect/as SYSDBA
Sql> STARTUP
sql> @catbundle. SQL PSU Apply
sql> @utlrp. sql

Nine, restart the database
Shutdown immediate
Startup

X. Checking the status of the database
--View component information
Set Linesize pagesize 600
Col Comp_name for A30
Select Comp_id,comp_name,version,status from Dba_registry;
--Check the patch situation
Set Linesize pagesize 600
Col Action_time for A30
Col COMMENTS for A30
Select Action_time, ACTION, COMMENTS from Sys. Dba_registry_history;
--View Invalid objects
Select COUNT (*) from dba_objects where status<> ' VALID ';

Xi. Start Monitoring
Lsnrctl start
ps-ef|grep-v grep |grep local=no|wc-l
Sql> Connect/as SYSDBA
Sql>alter system Register;

If the listener fails to start
CD $ORACLE _home/network/admin
MV Sqlnet.ora Sqlnet.orabak
Lsnrctl start
ps-ef|grep-v grep |grep local=no|wc-l
Sql> Connect/as SYSDBA
Sql>alter system Regiter
Sql>exit
MV Sqlnet.orabak Sqlnet.ora

Oracle Database PSU Upgrade (this experiment is to upgrade 10.2.0.3.12 to 10.2.0.3.15)