Scenario job has been failed with OCIERROR: ORA-12154: TNS:could not resolve the connect identifier specified (Doc ID 2833730.1)

Last updated on JUNE 06, 2024

Applies to:

Symptoms

On : 8.1.1 version, Web UI

After upgrading to 811 behaviour detection is failing with below error.
$ ./start_mantas.sh 116 -nd

[AESCryptorImpl.handleJVM]->INFO:JVM created successfully...
ClsUSmsConnect::ClsUSmsConnect, Forming Login Info statement
ClsUSmsConnect::retrieveInformation, Executed Query = SELECT A.APPIPADDRESS,
A.DBIPADDRESS, B.V_DB_NAME META_DB_NAME, B.V_DB_TYPE META_DB_TYPE,
H.V_DB_NAME INFO_DB_NAME, H.V_DB_TYPE INFO_DB_TYPE, E.FTPDRIVE,
C.SCRIPTSPATH, C.DBLOGPATH, C.MDBPATH, G.FTPDRIVE, G.FTPFOLDER, F.FTPDRIVE,
C.ERWINFILEPATH, C.OLAPTYPE, D.OLAPIPADDRESS, D.OLAPUSERID1, D.OLAPPASSWD1
FROM FICSYSMASTER A, AAI_DB_DETAIL B, DSNMASTER C, OLAP_MASTER D,
DB_SERVER_INFO E, DB_SERVER_INFO F, DB_SERVER_INFO G, AAI_DB_DETAIL H WHERE
C.OLAPIPADDRESS = D.OLAPIPADDRESS(+) AND C.OLAPTYPE = D.OLAPTYPE(+) AND
A.DBIPADDRESS = F.DBIPADDRESS AND A.DBIPADDRESS = G.DBIPADDRESS AND
A.DBIPADDRESS = E.DBIPADDRESS AND A.DBIPADDRESS = C.DBSERVER AND
B.V_DB_SERVER = C.DBSERVER AND B.V_DB_NAME = C.DBNAME AND B.V_DB_SERVER =
A.DBIPADDRESS AND H.V_DB_SERVER = C.V_INFO_DB_SERVER AND H.V_DB_NAME =
C.V_INFO_DB_NAME AND H.V_DB_SERVER = A.DBIPADDRESS AND E.FTPFOLDER =
'SCRIPTS' AND F.FTPFOLDER = 'ERWIN' AND G.FTPFOLDER = 'STAGE' AND C.DSNID =
'FCCMINFO'
Select query fired for the property : DB_DATE_FORMAT and DB Name :XXX
Select query fired for the property : DATA_SOURCE_STR and DB Name :XXX
Select query fired for the property : AUTH_ALIAS and DB Name :XXX
lstrQry =SELECT V_AUTH_USERNAME, V_AUTH_STRING FROM AAI_DB_AUTH_ALIAS WHERE
V_AUTH_ALIAS = 'XXX'
Select query fired for the property : DB_DATE_FORMAT and DB Name :XXX
Select query fired for the property : DATA_SOURCE_STR and DB Name :XXX
Select query fired for the property : AUTH_ALIAS and DB Name :XXX
lstrQry =SELECT V_AUTH_USERNAME, V_AUTH_STRING FROM AAI_DB_AUTH_ALIAS WHERE
V_AUTH_ALIAS = 'XXX'
FAILED: create_oci_session() - error attaching to server using
OCIServerAttach()...
LIBDB: FAILED: log_on() : OCIERROR: ORA-12154: TNS:could not resolve the
connect identifier specified

Failed to get job ids from Clone process

$ vi start_mantas_116.10-JAN-2022.log
ERROR: { subsystem: login authentication } { message: Invalid Database
Connection:
Database Name = XXX
User Name =XXX
}
terminate called after throwing an instance of 'KDDexception'
./start_mantas.sh: line 340: 19387: Abort
ERROR: { subsystem: login authentication } { message: Invalid Database
Connection:
Database Name =XXX
User Name =XXX
}
terminate called after throwing an instance of 'KDDexception'

Cause

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