Getting ORA-12222 After Net8 and Sql*Plus Install with OFSA and Discoverer
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.
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
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