Oracle 12c DB Patching 12.1.0.1.2

18007742678
=============



OPatch succeeded.
[oracle@welsfargo12c ~]$ date
Wed Sep  9 18:46:18 EDT 2015
[oracle@welsfargo12c ~]$ . oraenv
ORACLE_SID = [CDBTES] ? CDBTES
The Oracle base remains unchanged with value /data/oracle
[oracle@welsfargo12c ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 9 18:46:50 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.



SQL> startup;
ORACLE instance started.

Total System Global Area 1048576000 bytes
Fixed Size                  2932336 bytes
Variable Size             654311824 bytes
Database Buffers          385875968 bytes
Redo Buffers                5455872 bytes
Database mounted.
Database opened.

SQL>  set linesize 1000
SQL>  set page size 1000
SQL>  column instance_name for a30
SQL>  column ,Host_name for a20
SQL>  column  version for a30
SQL>  column  status for a20

SQL>  select instance_name ,Host_name , version, status from v$instance

INSTANCE_NAME                  HOST_NAME                                                        VERSION                        STATUS
------------------------------ ---------------------------------------------------------------- ------------------------------ --------------------
CDBTES                         welsfargo12c                                                     12.1.0.2.0                     OPEN

                                                                                                    ce;

SQL> select to_char(action_time,'DD-MON-YYYY HH:MI:SS AM') patched_on,description,patch_id action,status ,con_id from cdb_registry_sqlpatch
  2  ORDER by patch_id,action;

no rows selected

SQL>exit

export ORACLE_HOME=/data/oracle/product/12.1.0.2/db_1
export PATH=$ORACLE_HOME/bin:$PATH:$ORACLE_HOME/OPatch

PATH=$PATH:$HOME/bin:/data/oracle/product/12.1.0.2/db_1/OPatch/"
 echo $PATH


OPatch succeeded.
[oracle@welsfargo12c ~]$ opatch version
OPatch Version: 12.1.0.1.3




[oracle@welsfargo12c ~]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2015, Oracle Corporation.  All rights reserved.


Oracle Home       : /data/oracle/product/12.1.0.2/db_1
Central Inventory : /data/oraInventory
   from           : /data/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.1.0.1.3
OUI version       : 12.1.0.2.0
Log file location : /data/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2015-09-09_18-43-38PM_1.log

Lsinventory Output file location : /data/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-09-09_18-43-38PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


--------------------------------------------------------------------------------

OPatch succeeded.



cd $ORACLE_HOME/OPatch/opatch version
$ORACLE_HOME/OPatch/opatch lsinventory




GO TO PATCH LOCATION


cd /software/downloads
db_p17027533_1210011.zip
unzip /sofrware/downloads/db_p17027533_1210011.zip
after unzipping
cd 17027533/
pwd
/sofrware/downloads/17027533
ll
check to conflict for one of command
17027533}$ORACLE_HOME/opatch prereq checkconflictAgainstOHWithDeta -ph./

MAKE SURE CHECK PASSED
cd /software/downloads
db_p17027533_1210011.zip
unzip /sofrware/downloads/db_p17027533_1210011.zip
after unzipping
cd 17027533/
pwd
/sofrware/downloads/17027533
ll
check to conflict for one of command
17027533}$ORACLE_HOME/opatch prereq checkconflictAgainstOHWithDeta -ph./

MAKE SURE CHECK PASSED

sqlplus / as sysdba
SQL>shutdown immediate;
SQL>startup mount;


TAKE A BACKUP OF DATABASE BEFORE APPLYING ANY
rman
backup database plus archivelogs;
EXIT

AFTER BACKUP SHUTDOWN THE DATABASE

sqlplus / as sysdba
SQL>shutdown immediate;
STOP LISTENER
lsnrctl stop

GO INTO DOWN LOADED PATCH FOLDER WHERE YOU EXTARCTED

pwd
17027533}$ORACLE_HOME/OPatch/opatch apply
y

AFTER OPATCH SUCCEEDS

SQL>sqlplus / as sysdba

SQL>Startup

SQL>exit

APPLY PATCH TO DATABASE
cd /u01/app/oracle/product/12.1.0/dbHome_1/OPatch/
pwd

/u01/app/oracle/product/12.1.0/dbHome_1/OPatch/} ./datapatch -verbose
check the status of PATCH

CHECK THE PATCH STATUS

$ORACLE_HOME/OPatch/opatch lsinventory

lsnrctl status
lsnrctl start
lsnrctl status

sqlplus / as sysdba
SQL>select instance_name ,Host_name , version, status from v$instance;


for vesrion 12
SQL>select to_char(action_time,'DD-MON-YYYY HH:MI:SS AM') patched_on,
description,patch_id action,status ,con_id from cdb_registry_sqlpatch
ORDER by patch_id,action;
exit