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

Last updated on MAY 24, 2017

Applies to:

Oracle WebCenter Content - Version 7.5.1 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms