When attempting to start java awapi, an ORA-12514 error shows in the logs

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Error Message :
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

When attempting to start the Application Manager java processes the start script hangs on "waiting for java awapi to start".

A review of the $AW_HOME/log/RmiServer.log shows the following error message.
 

11:42:56.756 main: .AxOptions: NoErrorMsgProperties=false
ErrorMsg: AwE-5001 Database Query Error (8/31/15 11:42 AM)
Details: getConnection
    null
java.sql.SQLException: Listener refused the connection with the following error:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Note this error is generated by the Oracle database and is being parsed into the Application Manager logs.
The error ORA-12514 indicates that a listener received a request to establish a connection to a database or other service, however the connect descriptor received by the listener is unknown.

Investigation

Check which services are currently known by the listener as follows.

1.  Log into to SQL*Plus as the SYS user and enter the following command:

SQL> show parameter service
 

Or 

2. The following command at the command line will reply with the Services and Instances available on the machine:

lsnrctl status

 

Environment

OS Version: N/A

Cause

Cause type:
Other
Root Cause: The Oracle database is unreachable.

Resolution

Consult with a Database Administrator to resolve the Oracle error.
 

Fix Status: No Fix

Fix Version(s):
N/A

Additional Information

Workaround :
N/A