This is the first in a series of blurbs on common Oracle errors. Enjoy! Most people get ORA-00904 because they forgot to put quotes around a literal string in their SQL. Example: … [Read more...]
ORA-00600: internal error code, arguments: [keltnfy-ldminit]
This ORA-600 is a result of the Oracle server's server alert subsystem (DBMS_SERVER_ALERT) being unable to determine the local host name. Most frequently, this is due to DNS (domain name service) not being available. This error can result in instance failure (crash) or inability to start up. Patches for 10.2.0.2 and 10.2.0.3 available for: … [Read more...]
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]
This error may appear during instance shutdown. You may safely ignore this error, as it is raised only after the database has been closed. No action or corrective steps on the part of the DBA are required. The condition that causes this error to be raised is caught and handled starting in 11.1.0.6. No patches available Although the occasional … [Read more...]
ORA-06512: at “%s”, line %d
The ORA-06512 error doesn't tell you what is wrong, it tells you in which object at which line the error occurred. The error doesn't mean much by itself. It is simply the catch-all Oracle error for PL/SQL (procedural SQL) exceptions. This error is almost always preceded by a different message stating the reason for the error. Check the error that … [Read more...]
ORA-12154: TNS:could not resolve the connect identifier specified
The error also appears in some versions as: "ORA-12154: TNS:could not resolve service name." When a program needs to connect to an Oracle service via Oracle Networking (SQL*Net), it must look up the connect data for that service somewhere. When the lookup fails, the Oracle client code raises ORA-12154. Most people will encounter this error when … [Read more...]