You are hereOracle Database Administration / ORA Error Guide
ORA Error Guide
ORA-12154 TNS:could not resolve service name
ORA-12154 is generated by the oracle network layer. TNS error message is thrown during the logon process to a database. This error indicates that the communication software in Oracle ( SQL *Net or Net8 ) did not recognize the host/service name specified in the connection parameters. This error almost always indicates a misconfiguration of the oracle tns entries
ORA-12638 Credential retrieval failed
ORA-12638 Credential retrieval failed error is thrown when the authentication service fails to retrieve the required credentials of the user. ORA-12638 is a server side error and the user may not have too much control over resolving this error other than turning on the tracing on the client front. If you are unsure about how to troubleshoot the issue, please follow the steps mentioned below and provide the information to your database administrator.
ORA-12541 TNS no listener
ORA-12541 TNS no listener error is generated by oracle network layer. This error occurs when the listener for the oracle server you are trying to reach is down or unreachable. This error cannot be fixed by the user and should be resolved by the DBA. You can use the document and the links below to perform the basic troubleshooting before you open a ticket with the database administration team
ora-19007-and-xml-schema
ORA-19007 error is thrown by oracle if your XML Schema document does not match the expected schema name. Typically this error occurs due to issues in the XML Schema instance declaration.
ORA-12155 :TNS received bad datatype
ORA-12155 TNS:Received bad datatype in NSWMARKER packet
Cause: Internal error during break handling.
Action: Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.
ORA-07582 : ORA_SID has illegal value
ORA-07582 is a typical Vax/VMS based instance startup error. In a Vax/VMS based oracle system, the failure to set the correct ORACLE_SID or the failure to change the ORACLE_SID to the correct logical name will create an ORA-07582 Error.
Oracle Rep-159
Oracle Rep-159 is an internal error generated by oracle reports. Oracle Rep-159 is generated in multiple situations which cannot be documented in detail, but a few of the situations that I have run into are listed below..
ORA-00932 : Inconsistent Data Types
ORA-00932 error is typically caused due to an attempt by the program on incompatible data types. This error also happens when the user tries to perform operations that are not allowed, including operations by users on system tables that are not to be modified by the user.
ORA-01555 : Snapshot Too Old in Oracle
ORA-01555, Snapshot too old error in oracle indicates that something else other than your current process is creating the issue. Oracle typically creates a read consistent view of the table so that it looks the same at the start and end of a sql operation. ORA-01555 indicates something has overwritten the undo area that keeps the data to maintain such a view.
ORA-01031 : Insufficient Privileges
ORA-01031 is generated by oracle in most cases when the user lacks privileges to perform the particular operation. In generic cases, ORA-01031 error is thrown when the user is unable to create an object like table, view procedure etc., due to an incorrect setup in the security layer. In some cases ORA-01031 can also happen during instance startup.
