The TNS Name Cannot be Resolved in an Oracle Database (Doc ID 739952.1)

Last updated on SEPTEMBER 14, 2023

Applies to:

Symptoms

While attempting to connect to the database, the connection attempt returns the following error:

csJdbcUnableToCreateConnection\,SystemDatabase\,jdbc:oracle:oci:@PECMAWORM\!$ORA-12154: TNS:could not resolve service name
intradoc.common.ServiceException:
!csServiceDataException,CHECKIN_UNIVERSAL,IcheckinItems!$!csSystemError,\!csJdbcUnableToCreateConnection\,SystemDatabase\,jdbc:oracle:oci:@PECMAWORM

!$ORA-12154: TNS:could not resolve service name

at intradoc.server.Service.buildServiceException(Unknown Source)
at intradoc.server.Service.createServiceExceptionEx(Unknown Source)
at intradoc.server.Service.createServiceException(Unknown Source)
at intradoc.server.Service.doAction(Unknown Source)
at intradoc.server.Service.doActions(Unknown Source)
at intradoc.server.Service.executeSubServiceCode(Unknown Source)
at intradoc.server.Service.executeServiceEx(Unknown Source)
at intradoc.server.Service.executeService(Unknown Source)
at intradoc.server.ArchiveCheckinHandler.determineCheckin(Unknown Source)
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at intradoc.server.ServiceHandler.executeAction(Unknown Source)
at intradoc.server.Service.doCodeEx(Unknown Source)
at intradoc.server.Service.doCode(Unknown Source)
at intradoc.server.Service.doAction(Unknown Source)
at intradoc.server.Service.doActions(Unknown Source)
at intradoc.server.Service.doRequest(Unknown Source)
at intradoc.server.ServiceManager.processCommand(Unknown Source)
at intradoc.server.IdcServerThread.run(Unknown Source)
Caused by: intradoc.data.DataException:
!csJdbcUnableToCreateConnection,SystemDatabase,jdbc:oracle:oci:@PECMAWORM!$ORA-12154: TNS:could
not resolve service name

at intradoc.jdbc.JdbcConnection.init(Unknown Source)
at intradoc.provider.ProviderPoolManager.createConnection(Unknown Source)
at intradoc.jdbc.JdbcManager.createConnection(Unknown Source)
at intradoc.provider.ProviderPoolManager.getConnection(Unknown Source)
at intradoc.jdbc.JdbcWorkspace.getJdbcConnection(Unknown Source)
at intradoc.jdbc.JdbcWorkspace.execute(Unknown Source)
.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.