Oracle Database Administration: The Essential Refe

Some Common ORA Errors, Causes, and Corrective Actions

Table 5.3 summarizes the most common ORA errors, why they occur, and how you can correct them.

Table 5-3. Common ORA Errors

Error	Description	Corrective Action
ORA-12154	The service name could not be found in tnsnames.ora.	Check the service name.
ORA-12162	The connection description has an error.	Check tnanames.ora for syntax, especially mismatched parentheses.
ORA-12163	The connection description is too long.	Correct the problem by shortening the connection description.
ORA-12197	The connection description has an error.	Check tnsnames.ora for syntax errors.
ORA-12198	A path could not be found via interchanges.	Check tnsnav.ora for errors.
ORA-12203	Unable to connect to destination.	Check the underlying network problems, including physical problems or non-functioning routers.
ORA-12208	tnsnav.ora could not be found.	Make sure tnsnav.ora is in the correct directory.
ORA-12210	Improper configuration of tnsnav.ora.	Check tnsnav.ora syntax.
ORA-12500	Could not start a dedicated server process.	Check process count in the operating system and listener.ora parameters.
ORA-12504	SID could not be resolved.	Check CONNECT_DATA in tnsnames.ora and verify that SID is specified correctly.
ORA-12505	SID could not be resolved.	Check listener.ora on the server or run lsnrctl status to make sure a listener is running for the specified SID.
ORA-12510	No dispatcher available to accept a connection using the ...