Getting TNS Error ORA-12154 Logging into 16-Bit Sql*Plus After OFSA Install
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
Checked for relevance on 23-Oct-2009.
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
- Go to Start > All Programs
- Go to "Oracle for Windows"
- Go to SQL Plus 3.3 and/or SQL Net Easy Configuration
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