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 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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset