Getting TNS-12545 and TNS-00515 in Sqlnet.Log Running OFSA Allocations (Doc ID 279148.1)

Last updated on MAY 24, 2017

Applies to:

Oracle Profitability Manager - Version 4.5 to 4.5.39 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer - Version: 4.5 to 4.5.39
Allocation ID

Symptoms

You get sporadic errors in the Sqlnet.log and Request Queue log when running 4.5 Performance Analyzer (PA) Allocations on the server after moving the Oracle Financial Services Applications (OFSA) installation from one server to another server.  These errors only occur on the Server side local connections.  Client-side connections do not get these errors.

The errors below are repeated over and over in the respective log files.

Sqlnet.log errors:

nr err code: 12206
TNS-12206: TNS:received a TNS error during navigation
ns main err code: 12545
TNS-12545: Connect failed because target host or object does not exist
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Connect failed because target host or object does not exist
nt secondary err code: 2
nt OS err code: 0

RQ log errors:

Tue Jul 20 09:34:31 2004 : Command: /ofsa/bin/ofspa
Tue Jul 20 09:34:31 2004 : Job number 25947 started with process id 24876.
Tue Jul 20 09:34:31 2004 : Process 24876: failed with unknown error. Status: 1009.
Tue Jul 20 09:34:31 2004 : Process ID 24876: completed with return code 1009.
Tue Jul 20 09:35:43 2004 : Job: 25948. Request: PING. User: OFSADEMO. Priority: 1. Application ID: 0.

Changes

Moved OFSA database instance to a new server.

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