ORA-12505, TNS:listener Does Not Currently Know Of SID Given In Connect Descriptor (Doc ID 2856617.1)

Last updated on NOVEMBER 28, 2022

Applies to:

Symptoms

On : 8.0.8 version, Web UI

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Client moved FCCM 808 DB to another location on EXA DB with a new IP & hostname.

We have changed tnsnames.ora, weblogic datasources jdbc strings & etc/hosts file. But FCCM services are not starting.


$ tail -f nohup.out
Starting Reveleus Server
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=1024M; support was removed in 8.0
FIC_HOME:/s01/fccm/
starting FICServer
Result of Config File Read operation 0
#read ip port with :DAPPINST99996666
#Comparing---DAPPINST99996666---DAPPINST99996666
DEFAULTLOGGER:DEFAULTLOG DEFAULTLOGLEVEL:0
LogConstants.log4jInited = true
#Comparing---DAPPINST99996666---DAPPINST99996666
Configuring log from: /s01/fccm/ficapp/common/FICServer/conf/log4j.conf.properties
com.ofs.aai.exception.OFSAAException: DB Connection failed for DBName: ofsaafccmakblprod, DBType: ORACLE
at com.ofs.aai.database.impl.GenericOFSAAConnectionFactory.getConnection(GenericOFSAAConnectionFactory.java:405)
at com.ofs.aai.database.impl.GenericOFSAAConnectionFactory.getConnection(GenericOFSAAConnectionFactory.java:294)
at com.ofs.aai.database.impl.GenericOFSAAConnectionFactory.getMetaConnection(GenericOFSAAConnectionFactory.java:143)
at com.iflex.fic.metadata.services.DatabaseModelReader.getConnection(DatabaseModelReader.java:127)
at com.iflex.fic.metadata.services.DatabaseModelReader.readDBModel(DatabaseModelReader.java:142)
at com.iflex.fic.metadata.cache.MetadataIOManager.readMetadata(MetadataIOManager.java:249)
at com.iflex.fic.metadata.cache.MetadataCacheManager.getMetadata(MetadataCacheManager.java:157)
at com.iflex.fic.metadata.services.MetadataServiceProvider$CacheOnStartUp.cacheModelOnStartup(MetadataServiceProvider.java:2725)
at com.iflex.fic.metadata.services.MetadataServiceProvider$CacheOnStartUp.run(MetadataServiceProvider.java:2648)
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Cause

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