Getting ORA-12222 After Net8 and Sql*Plus Install with OFSA and Discoverer (Doc ID 258186.1)

Last updated on NOVEMBER 19, 2015

Applies to:

Oracle Discoverer - Version 4.1.37 to 4.1.46 [Release 4.1]
Oracle Financial Data Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

After installing Net8 and SQL*Plus from the Discoverer or Oracle Financial Services Applications (OFSA) 4.5 installers, you receive the following error when logging into SQL*Plus and Discoverer:

ORA-12222: TNS: no such protocol adapter

The TCP/IP Protocol Adapter is installed.

You also receive the following error when trying to launch the Oracle Installer located in Start > All Programs > Oracle for Windows NT:

$|.stp(0): FILE_NOT_FOUND while setting up nt

You can log into the OFSA database using 16-bit SQL*Plus and you have copied the tnsnames.ora file from the 16-bit orawin\network\admin directory to the orant\net80\admin 32-bit directory.

On your PC, you have multiple Oracle Homes. You may have an additional home for the Oracle Application Server (OAS) or Oracle Express installations.   You can check for multiple homes by going to:

Start > All Programs > Oracle for Windows NT > Oracle Home Selector

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