Table 5.3 summarizes the most common ORA errors, why they occur, and how you can correct them.
Error |
Description |
Corrective Action |
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 multithreaded server. |
Increase the number of dispatchers available. |
ORA-12511 |
Dispatchers are too busy using the multithreaded server. |
Try again or increase the number of dispatchers available. |