Troubleshooting
Problem
This technote describe a solution to resolve the Oracle error ORA-12514. The error appears when configuring the connection to a Oracle based IBM Rational RequisitePro project, the error comes up during the validation. When trying to connect to the Oracle database using an Oracle client, the same error message appears.
Symptom
The full error message is as follows: -Unable to connect to the database. -Ensure that the configuration and account information are valid.
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Cause
The fully qualified service name is not used.
Resolving The Problem
In the Oracle client, update the service name so that it uses the fully qualified service name as seen in the below example.
After updating the service name, test the connection using the Oracle client. The Oracle client should now be able to connect to the database, and the validation in RequisitePro should be successful as well.
Example:
TNSNAMES.ORA entry before change:
REQPRO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server.company.com)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = REQPRO)
)
)
TNSNAMES.ORA entry after change:
REQPRO.COMPANY.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server.company.com)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = REQPRO)
)
)
Product Synonym
ReqPro
Was this topic helpful?
Document Information
Modified date:
23 June 2018
UID
swg21404131