45 liens privés
-
Download patches
-
backup precheck
cd precheck
ps -ef |grep pmon > current_instance.txt
ps -ef |grep tns > current_tns.txt
cat /etc/oratab > current_oratab.txt
$ORACLE_HOME/OPatch/opatch lsinventory > before_current_lsinventory.txt -
Check conflicts
export PATH=$ORACLE_HOME/OPatch:$PATH
opatch version
unzip <patch.zip> && cd <path folder>
opatch prereq CheckConflictAgainstOHWithDetail -ph ./ -
Stop oracle database and listeners
-
Check
ps -ef|grep pmon
ps -ef|grep tns
ps -ef|grep exp
ps -ef|grep rman -
Apply patch
opatch apply -
Check
opatch lsinventory > after_current_lsinventory.txt -
Start only oracle database (not the listener)
-
Patch data
datapatch -verbose -
Check
sqlplus / as sysdba
SET LINESIZE 400
COLUMN action_time FORMAT A20
COLUMN action FORMAT A10
COLUMN status FORMAT A10
COLUMN description FORMAT A40
COLUMN version FORMAT A10
COLUMN bundle_series FORMAT A10
SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,action,status,description,patch_id FROM sys.dba_registry_sqlpatch ORDER by action_time;
-
Check stop and start
sqlplus / as sysdba
shutdown immediate
startup
select name,open_mode from v$database; -
Start the listener