This procedure is used to resolve Oracle Bug on 11.2.0.3
Bug 13528814 ORA-600 [17182] on redefinition with many referential constraints
1. download p13572659_112030_AIX64-5L.zip from MOS and upload it to rtdkz2odb01.
2. stop related Bacth and OC4J applications, check it in DTC.
use root:
/etc/init.d/bcd_BCSTORESXX stop
use ora10gas:
opmnctl stopall
3. stop agent / database / listener
use root:
cd /etc/rc.d/init.d/;./dbora stop;./dbora status
4. apply patch
use oracle:
export PATH=$PATH:/u01/app/oracle/product/1120/db11g01/OPatch;
cd $ORACLE_HOME/OPatch
unzip p13572659_112030_AIX64-5L.zip
cd 13572659
cat README.txt
cat README.txt
./opatch apply
5. opatch verification
./opatch lsinventory | grep 13572659
6. start database service
art
;./dbora status
7. check database status
sqlplus / as sysdba
SQL>select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
[oracle@bditz1odb02 /u01/app/oracle/product/12102/db12c01/OPatch]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 24-JUL-2016 11:11:42
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bditz1odb02.dktetrix.net)(PORT=1532)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 21-APR-2016 17:38:26
Uptime 93 days 17 hr. 33 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12102/db12c01/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/bditz1odb02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bditz1odb02.dktetrix.net)(PORT=1532)))
Services Summary...
Service "tetrix01_bditz1odb02.dktetrix.net" has 1 instance(s).
Instance "tetrix01", status READY, has 1 handler(s) for this service...
Service "tetrix01_infra.dktetrix.net" has 1 instance(s).
Instance "tetrix01", status READY, has 1 handler(s) for this service...
Service "tetrix01_svc.dktetrix.net" has 1 instance(s).
Instance "tetrix01", status READY, has 1 handler(s) for this service...
The command completed successfully
7. start application check and check the status.
OPEN_MODE
--------------------
READ WRITE
[oracle@bditz1odb02 /u01/app/oracle/product/12102/db12c01/OPatch]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 24-JUL-2016 11:11:42
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bditz1odb02.dktetrix.net)(PORT=1532)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 21-APR-2016 17:38:26
Uptime 93 days 17 hr. 33 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12102/db12c01/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/bditz1odb02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bditz1odb02.dktetrix.net)(PORT=1532)))
Services Summary...
Service "tetrix01_bditz1odb02.dktetrix.net" has 1 instance(s).
Instance "tetrix01", status READY, has 1 handler(s) for this service...
Service "tetrix01_infra.dktetrix.net" has 1 instance(s).
Instance "tetrix01", status READY, has 1 handler(s) for this service...
Service "tetrix01_svc.dktetrix.net" has 1 instance(s).
Instance "tetrix01", status READY, has 1 handler(s) for this service...
The command completed successfully
/home/oracle
[oracle@bditz1odb02 ~]$ cd $ORACLE_HOME/OPatch
/u01/app/oracle/product/12102/db12c01/OPatch
[oracle@bditz1odb02 /u01/app/oracle/product/12102/db12c01/OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.8
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12102/db12c01
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12102/db12c01/oraInst.loc
OPatch version : 12.1.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12102/db12c01/cfgtoollogs/opatch/opatch2016-07-24_10-59-56AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12102/db12c01/cfgtoollogs/opatch/lsinv/lsinventory2016-07-24_10-59-56AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: bditz1odb02.dktetrix.net
ARU platform id: 226
ARU platform description:: Linux x86-64
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.
//stop agent / database / listener
su $ORACLE -c "$ORACLE_HOME/bin/emctl stop agent"
su $ORACLE -c "$ORACLE_HOME/bin/sqlplus -S /nolog <<-HERE
connect / as sysdba
shutdown immediate
exit
HERE" >>
su $ORACLE -c "$ORACLE_HOME/bin/lsnrctl stop"
//start agent / listener / database
su $ORACLE -c "$ORACLE_HOME/bin/emctl start agent"
su $ORACLE -c "$ORACLE_HOME/bin/lsnrctl start"
su $ORACLE -c "$ORACLE_HOME/bin/sqlplus -S /nolog <<-HERE
connect / as sysdba
startup $STANDBY
exit
HERE" >>