Error Starting RQ: ORA-12154: TNS:Could Not Resolve the Connect Identifier Specified (Doc ID 437249.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Financial Data Manager - Version 4.5.39 to 4.5.41
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5.39

Symptoms

After upgrading the OFSA database from Oracle 9i to Oracle 10g, you cannot start the OFSA Request Queue (RQ).  You receive the following error after entering the RQ start command on the server:

$ rq -b <Database Name> rq.log
Request Queue
Version 4.5.39
Copyright (c) Oracle Corporation, 1995-2000
All rights reserved worldwide.

Login: ofsademo
Password:

Working directory now: /app/ofsa/ofsa4.5.39/log
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [0] - olon(), orlon()
Oracle Error: [12154] - ORA-12154: TNS:could not resolve the connect identifier specified

Driver Function: drv_oci::Connect()

MB(AttachDB()) Error attaching to database: <Database Name>

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