Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level. Action: Either remove the unique restriction or do not insert the key.
This error appears when the process of starting up a dedicated server process failed and it could be either because the executable could not be found or the environment isn’t set up correctly. Turn on tracing at the ADMIN level and re-execute the operation. Tracing can be set by adding following clause in listener.ora file…
There are several requests to a DBA for changing the Database Name & DBID of a database, suppose user wants to clone one his env. (say PROD01) to make it a dev or test instance, so he clones the VM but this would give a database with the same Database Name as that of the…
This post is to share the links for Oracle books for better understanding of Oracle Internals and other exam guides to prepare for Oracle exam. Oracle 12c Books:- OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060) OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) OCA Oracle Database 12c Installation…
Oracle Database Internal Mechanism 