Getting TNS Error ORA-12154 Logging into 16-Bit Sql*Plus After OFSA Install (Doc ID 250546.1)

Last updated on OCTOBER 23, 2009

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Financial Data Manager - Version: 4.5 to 4.5.39
Microsoft Windows
Checked for relevance on 23-Oct-2009.

Symptoms

After installing Oracle Financial Services Applications (OFSA) 4.5.39, you get a TNS error logging into SQL*Plus 3.3 on the client-side PC:

ORA-12154: TNS:could not resolve service name

If you go into the 16-bit SQL*Net Easy Configuration utility and add a database alias, only Bequeath is listed under the network protocols.

Steps to reproduce

  1. Go to Start > All Programs
  2. Go to "Oracle for Windows"
  3. Go to SQL Plus 3.3 and/or SQL Net Easy Configuration

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