ORA-00600: internal error code, arguments:[kpdbModAdminPasswd InRoot: not CDB],[], [], [], [] ....Oracle 12c Release 1 Bug.

Oracle 12c Release 1 Bug.

Cause: while changing password. We are getting ORA - 600



Solution: To fix the above error, we need to apply opatch


oracle@localhost.localdomain:/u01/app/oracle/product/12.1.0/db_1/OPatch [brmdb] >./opatch lsinventory                                                                   Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2013-10-22_20-51-20PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2013-10-22_20-51-20PM.txt

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

Oracle Database 12c                                                  12.1.0.1.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
oracle@localhost.localdomain:/u01/app/oracle/product/12.1.0/db_1/OPatch [brmdb] >./opatch prereq CheckConflictAgainstOHWithDetail
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2013-10-22_20-51-27PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" is not executed.

The details are:
No patch location specified.

OPatch failed with error code 2
oracle@localhost.localdomain:/u01/app/oracle/product/12.1.0/db_1/OPatch [brmdb] >cd /u01/16901482/
oracle@localhost.localdomain:/u01/16901482 [brmdb] >./opatch prereq CheckConflictAgainstOHWithDetail
bash: ./opatch: No such file or directory
oracle@localhost.localdomain:/u01/16901482 [brmdb] >cd $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
bash: cd: /u01/app/oracle/product/12.1.0/db_1/OPatch/opatch: Not a directory
oracle@localhost.localdomain:/u01/16901482 [brmdb] >cd /u01/app/oracle/product/12.1.0/db_1/OPatch/
oracle@localhost.localdomain:/u01/app/oracle/product/12.1.0/db_1/OPatch [brmdb] >opatch apply
bash: opatch: command not found
oracle@localhost.localdomain:/u01/app/oracle/product/12.1.0/db_1/OPatch [brmdb] >./opatch apply
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2013-10-22_20-54-22PM_1.log

Failed to load the patch object.  Possible causes are:
  The specified path is not an interim Patch shiphome
  Meta-data files are missing from the patch area
  Patch location = /u01/app/oracle/product/12.1.0/db_1/OPatch
  Details = PatchObject constructor: Input file "/u01/app/oracle/product/12.1.0/db_1/OPatch/etc/config/actions" or "/u01/app/oracle/product/12.1.0/db_1/OPatch/etc/config/inventory" does not exist.

OPatch failed: PatchObject constructor: Input file "/u01/app/oracle/product/12.1.0/db_1/OPatch/etc/config/actions" or "/u01/app/oracle/product/12.1.0/db_1/OPatch/etc/config/inventory" does not exist.
Log file location: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2013-10-22_20-54-22PM_1.log

OPatch failed with error code 73
oracle@localhost.localdomain:/u01/app/oracle/product/12.1.0/db_1/OPatch [brmdb] >cat /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2013-10-22_20-54-22PM_1.log
[Oct 22, 2013 8:54:23 PM]    OPatch invoked as follows: 'apply -invPtrLoc /u01/app/oracle/product/12.1.0/db_1/oraInst.loc '
[Oct 22, 2013 8:54:23 PM]    OUI-67077:
                             Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
                             Central Inventory : /u01/app/oraInventory
                                from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
                             OPatch version    : 12.1.0.1.0
                             OUI version       : 12.1.0.1.0
                             OUI location      : /u01/app/oracle/product/12.1.0/db_1/oui
                             Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2013-10-22_20-54-22PM_1.log
[Oct 22, 2013 8:54:23 PM]    Patch history file: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt
[Oct 22, 2013 8:54:23 PM]    Starting ApplySession at Tue Oct 22 20:54:23 MYT 2013
[Oct 22, 2013 8:54:23 PM]    Starting Apply Session at Tue Oct 22 20:54:23 MYT 2013
[Oct 22, 2013 8:54:23 PM]    OUI-67075:Failed to load the patch object.  Possible causes are:
                               The specified path is not an interim Patch shiphome
                               Meta-data files are missing from the patch area
                               Patch location = /u01/app/oracle/product/12.1.0/db_1/OPatch
                               Details = PatchObject constructor: Input file "/u01/app/oracle/product/12.1.0/db_1/OPatch/etc/config/actions" or "/u01/app/oracle/product/12.1.0/db_1/OPatch/etc/config/inventory" does not exist.
[Oct 22, 2013 8:54:23 PM]    OPatch will clean up 'restore.sh,make.txt' files and 'scratch,backup' directories.
                             You will be still able to rollback patches after this cleanup.
                             Do you want to proceed? [y|n]
[Oct 22, 2013 8:54:26 PM]    Y (auto-answered by -silent)
[Oct 22, 2013 8:54:26 PM]    User Responded with: Y
[Oct 22, 2013 8:54:26 PM]    No patch storage area for given Oracle Home.
[Oct 22, 2013 8:54:26 PM]    UtilSession: Backup area for restore has been cleaned up. For a complete list of files/directories
                             deleted, Please refer log file.
[Oct 22, 2013 8:54:26 PM]    OUI-67073:OPatch failed: PatchObject constructor: Input file "/u01/app/oracle/product/12.1.0/db_1/OPatch/etc/config/actions" or "/u01/app/oracle/product/12.1.0/db_1/OPatch/etc/config/inventory" does not exist.
[Oct 22, 2013 8:54:26 PM]    OUI-67035:System is intact, OPatch will not restore the system
[Oct 22, 2013 8:54:26 PM]    Finishing ApplySession at Tue Oct 22 20:54:26 MYT 2013
[Oct 22, 2013 8:54:26 PM]    Total time spent waiting for user-input is 0 seconds.  Finish at Tue Oct 22 20:54:26 MYT 2013
[Oct 22, 2013 8:54:26 PM]    Log file location: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2013-10-22_20-54-22PM_1.log
[Oct 22, 2013 8:54:26 PM]    Stack Description: java.lang.RuntimeException: PatchObject constructor: Input file "/u01/app/oracle/product/12.1.0/db_1/OPatch/etc/config/actions" or "/u01/app/oracle/product/12.1.0/db_1/OPatch/etc/config/inventory" does not exist.
[Oct 22, 2013 8:54:26 PM]    StackTrace: oracle.opatch.PatchObject.createPatchObject(PatchObject.java:2453)
[Oct 22, 2013 8:54:26 PM]    StackTrace: oracle.opatch.PatchObject.(PatchObject.java:2024)
[Oct 22, 2013 8:54:26 PM]    StackTrace: oracle.opatch.PatchObjectUtil.loadPatch(PatchObjectUtil.java:2338)
[Oct 22, 2013 8:54:26 PM]    StackTrace: oracle.opatch.ApplySession.loadAndInitPatchObject(ApplySession.java:1560)
[Oct 22, 2013 8:54:26 PM]    StackTrace: oracle.opatch.ApplySession.process(ApplySession.java:5863)
[Oct 22, 2013 8:54:26 PM]    StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2383)
[Oct 22, 2013 8:54:26 PM]    StackTrace: oracle.opatch.OPatch.main(OPatch.java:674)
oracle@localhost.localdomain:/u01/app/oracle/product/12.1.0/db_1/OPatch [brmdb] >cd
oracle@localhost.localdomain:/home/oracle [brmdb] >
oracle@localhost.localdomain:/home/oracle [brmdb] >
oracle@localhost.localdomain:/home/oracle [brmdb] >
oracle@localhost.localdomain:/home/oracle [brmdb] >$ORACLE_HOME/OPatch/opatch lsinventory -detail | grep 16901482
oracle@localhost.localdomain:/home/oracle [brmdb] >cd /u01/16901482/
oracle@localhost.localdomain:/u01/16901482 [brmdb] >ls
etc  files  online  README.txt
oracle@localhost.localdomain:/u01/16901482 [brmdb] >$ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/16901482_Oct_22_2013_21_15_18/apply2013-10-22_21-15-17PM_1.log

Applying interim patch '16901482' to OH '/u01/app/oracle/product/12.1.0/db_1'
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:


Following executables are active :
/u01/app/oracle/product/12.1.0/db_1/bin/oracle
Log file location: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/16901482_Oct_22_2013_21_15_18/apply2013-10-22_21-15-17PM_1.log

Recommended actions: OPatch needs to modify files which are being used by some processes.

OPatch failed with error code 41
oracle@localhost.localdomain:/u01/16901482 [brmdb] >dba
bash: dba: command not found
oracle@localhost.localdomain:/u01/16901482 [brmdb] >cd
oracle@localhost.localdomain:/home/oracle [brmdb] >ps -ef |grep pmon
oracle   10234     1  0 15:20 ?        00:00:01 ora_pmon_brmdb
oracle   14978 14090  0 21:15 pts/3    00:00:00 grep pmon
oracle@localhost.localdomain:/home/oracle [brmdb] >
oracle@localhost.localdomain:/home/oracle [brmdb] >
oracle@localhost.localdomain:/home/oracle [brmdb] >dba
bash: dba: command not found
oracle@localhost.localdomain:/home/oracle [brmdb] >kill -9 10234
oracle@localhost.localdomain:/home/oracle [brmdb] >ps -ef |grep pmon
oracle   14981 14090  0 21:16 pts/3    00:00:00 grep pmon
oracle@localhost.localdomain:/home/oracle [brmdb] >
oracle@localhost.localdomain:/home/oracle [brmdb] >
oracle@localhost.localdomain:/home/oracle [brmdb] >
oracle@localhost.localdomain:/home/oracle [brmdb] >cd /u01/16901482/
oracle@localhost.localdomain:/u01/16901482 [brmdb] >$ORACLE_HOME/OPatch/opatch a
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/16901

Applying interim patch '16901482' to OH '/u01/app/oracle/product/12.1.0/db_1'
Verifying environment and performing prerequisite checks...
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local sy
(Oracle Home = '/u01/app/oracle/product/12.1.0/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...

Patching component oracle.rdbms, 12.1.0.1.0...

Verifying the update...
Patch 16901482 successfully applied
Log file location: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/16901482_Oct_22_2013_21_16_34/apply2013-10-22_21-16-34PM_1.log

OPatch succeeded.




Comments

Post a Comment

Popular posts from this blog

Reboot Exadata Machine

Image
1) Log in to the first database server as root. 2) Change to the OneCommand directory # cd /opt/oracle.SupportTools/onecommand 3) Note whether the Grid Infrastructure is currently enabled for autostart, so that this state can be restored later: # dcli -g dbs_group -l root /u01/app/11.2.0/grid/bin/crsctl config crs 4) Disable the Grid Infrastructure for autostart on the database servers if the previous step indicated it is currently enabled for autostart. # dcli -g dbs_group -l root /u01/app/11.2.0/grid/bin/crsctl disable crs Note: This is step is [Optional] and it can required during maintenance operation like “firmware patches” which requires to reboot the Compute Node several times. 5) Stop the Grid Infrastructure stack on the database servers (compute nodes): # dcli -g dbs_group -l root /u01/app/11.2.0/grid/bin/crsctl stop crs 6) Verify that the Grid Infrastructure stack has shutdown successfully on the database servers. The follow...
Read more

ORA-01565: error in identifying file '?/dbs/spfile@.ora'

QL> startup ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated SQL> create pfile from spfile; create pfile from spfile * ERROR at line 1: ORA-01565: error in identifying file '?/dbs/spfile@.ora' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3   SQL> shut abort SQL> create pfile='/home/oracle/initORA11G.ora' from spfile='+DATA/ORA11G/spfileORA11G.ora'; File created. oracle@rac1.localdomain:/home/oracle [ORA11G1] >dba SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 6 20:15:29 2016 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup pfile='/home/oracle/initORA11G.ora'; ORACLE instance started. Total System Global Area 1653518336 bytes Fixed Size                  2228904 by...
Read more

STEPS TO troubleshoot long running concurrent request in R12.2.x

USUALLY we are getting concurrent program running longer and concurrent request not picking jobs, etc. those are very frequent issue we expected from development team. Collect basis level of information to development team A. Oracle seeded program/Custom program? B. How much time it used earlier? C. Is there any recent code change done in concurrent program? D. Is this program fetching higher data compare to last run? E. Does this job running any specific time/ It can be run any time? F. Does this job fetching data using DB link? G. Does the problem happen on both the test and production instance? Once asked above questions to development team in meanwhile we need to start basic sanity check in our environment. A. Verify the status of the concurrent program select REQUEST_ID,phase_code,status_code,ORACLE_SESSION_ID from apps.fnd_concurrent_requests where request_id=’23432345’; B. Find which concurrent manger ran a specific concurrent request select b.USER_CONCURRENT_QUEUE_NAME from fnd...
Read more