CA Strong Authentication Windows Installation Guide › Troubleshooting CA Strong Authentication Issues › Database-Related Errors

Database-Related Errors

Problem:

Connection to the database fails with the following entry in the Server log file:

ReportError: SQL Error State:08001, Native Error Code: 30FD, ODBC Error: [DataDirect][ODBC Oracle driver][Oracle]ORA-12541: TNS:no listener

Solution:

Check for the following:

• Listener service on your database server.
• The TNSnames.ora file settings on the system where Server is installed.

Problem:

Connection to the database fails with the following entry in the Server log file:

TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Solution:

Check for the following:

• Database is started. If it is not, you will get the above message.
• If the database is running, probably the database has not registered yet with the listener. This occurs when the database or listener just starts up. Normally this problem should be solved by waiting a minute or so.
• If you are using static registration, ensure the SERVICE_NAME entry used in the connection string (TNSNAMES.ORA, NAMES, OID, ...) matches a valid service know by the listener.
• You can use C:>tnsping SERVICE_NAME - to check the status or C:>lsnrctl services - to verify all the services known to listener.

Problem:

Connection to the database fails with the following entry in the Server log file:

Database password could not be obtained from securestore.enc

Cause:

The database details might not be available in securestore.enc file.

Solution:

Use the DBUtil tool to update the securestore.enc file with the database details. See CA CA Strong Authentication Administration Guide for more information about how to use DBUtil.

Problem:

Connection to the database fails with the following entry in the Server log file:

RA-03113: end-of-file on communication channel

Cause:

This is a generic error that indicates that the connection has been lost. This can be caused by many reasons such as:

• Network issues or problems
• Forceful disconnection of a Server session
• Oracle Database crash
• Database Server crash
• Oracle internal errors, such as ORA-00600 or ORA-07445, causing aborts
• Oracle Client or TNS layer inability to handle the connections

Solution:

Check for the possible causes mentioned in the preceding list.