Solved

ORA-12158 problem

Posted on 1998-12-29
1
1,428 Views
Last Modified: 2008-02-20
I have installed Oracle8 client (8.0.4.0.0) on my NTWS 4.0SP3. The server is located on a NTS 4.0SP3.
The problem is that I cannot operate sqlplus in the proper service.
When I test the connection (For example: In the network assistant) I get the following message:

ORA-12158: TNS:could not initialize parameter subsystem

I copied the configuration (Net80/Admin) files from a working WS and got the same results. I also did all the instructions of the "Problem Determination" section, in the Net8 manual.
What can be the problem?
0
Comment
Question by:Gadi031698
1 Comment
 
LVL 1

Accepted Solution

by:
mlonnrot earned 50 total points
ID: 1083502
ora-12158 usually means that the sqlnet/net8 client libs failed to locate the tnsnames.ora file. There can be several reasons for this - usually one or more environment variables are not set correctly, you have no privs to read the tnsnames.ora file etc. Check your manual for NT specific env vars, set them, and use tnsping.exe to test the net8 configuration instead of sqlplus.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now