FCCM BD 8.1.1.2.0 - Dispatcher OCIERROR (Doc ID 2864142.1)

Last updated on APRIL 24, 2023

Applies to:

Symptoms

On : 8.1.1 version, Web UI

ACTUAL BEHAVIOR
---------------
FCCM BD 8.1.1.2.0 - Dispatcher OCIERROR

while starting dispatcher of 8.1.1.2 version, getting below error. however connecting via SQLPLUS is success on the linux server. Kindly review and let me know the solutions

[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'
lstrQry =SELECT V_AUTH_USERNAME, V_AUTH_STRING FROM AAI_DB_AUTH_ALIAS WHERE V_AUTH_ALIAS = 'ofsaafccm'
Select query fired for the property : DB_DATE_FORMAT and DB Name : ofsaafccm
Select query fired for the property : DATA_SOURCE_STR and DB Name : ofsaafccm
Select query fired for the property : AUTH_ALIAS and DB Name : ofsaafccm
lstrQry =SELECT V_AUTH_USERNAME, V_AUTH_STRING FROM AAI_DB_AUTH_ALIAS WHERE V_AUTH_ALIAS = 'ofsaafccm'
FAILED: create_oci_session() - error creating the session using OCISessionBegin()...
LIBDB: FAILED: log_on() : OCIERROR: ORA-01017: invalid username/password; logon denied

Cause

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