Arcot UDS startup failure due to error ORA-12514

Products

• CA Rapid App Security
• CA Advanced Authentication
• CA API Gateway

Issue/Introduction

Arcot UDS fails to start due to oracle error - "ORA-12514, TNS:listener does not currently know of service requested in connect descriptor". The CA Arcot UDS log (arcotuds.log) has the following log lines:

========================================= excerpt from arcotuds.log===========================================================
2013-05-18 02:50:46,779 EDT : [Thread-9] : ERROR : common.database.DBFOManagerImpl(65) : Failed to retrieve Database error 
codes for Datasource[1]. Error: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
 )
2013-05-18 02:50:46,779 EDT : [Thread-9] : INFO  : common.database.DBFOManagerImpl(70) : Adding Datasource[1] to the datasource list.
2013-05-18 02:50:46,779 EDT : [Thread-9] : ERROR : common.database.DBFOManagerImpl(74) : Datasource[1] is not currently active.
2013-05-18 02:50:46,998 EDT : [Thread-9] : ERROR : com.arcot.uds(787) : [31002] UDS not initialized.
2013-05-18 02:50:46,998 EDT : [Thread-9] : FATAL : com.arcot.uds(788) : [31002] UDS not initialized.
2013-05-18 02:50:46,998 EDT : [Thread-15] : ERROR : plugin.config.ConfigManager(122) : No Datasource is set.
=======================================  end of excerpt ======================================================================

Resolution

1. Ensure that the database is started.
    
2. If the database is started, probably the database has not yet registered with the listener. Generally, this issue is resolved by waiting a few minutes to allow the registration to complete.
    
3. Check the following in the TNSNAMES.ORA
    
   1. SERVICE_NAME specified should be a service known to the Listener. Run the command "lsnrctl services " to list the services known to the listener.
       
   2. Check the Oracle net connectivity (from client to server) using the command "tnsping SERVICE_NAME ".