Solved

ORA-12158 problem

Posted on 1998-12-29
1
1,442 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle Finace 3 67
oracle report printing 2 pages in one page 2 58
Outer Query not returning data - SQL HELP 16 50
Oracle query output question 4 36
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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…

861 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

20 Experts available now in Live!

Get 1:1 Help Now