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)