Hi!!
I have oracle 8i&oracle 9i installed on my machine.
I have set the tnsnames.ora file for Oracle 8i also.
But whenevr i try to access the oracle 8i it throws the error: ORA 12154 TNS could not resolve service name.
Please advice!!
2  17385   Niheel 2,456
Recognized Expert Moderator Top Contributor
Did you go through this already: Cause:
This error indicates that the service (or TNS alias) specified when trying to connect does not exist.
‘TNS aliases’ or ‘service names’ are defined locally to each workstation. Thus different workstations could have a completely different alias to refer to the same database. Remedy:
Check what aliases are defined on the workstation, either use one that is defined or add an appropriate one. - The following methods can be used to view the TNS names:
- Look in the file ‘ORANT\ Network\ Admin\ Tnsnames.ora’ (for versions of Oracle prior to 8.1) or ‘Oracle\ Ora81\ Network\ Admin\ Tnsnames.ora’ (for versions of Oracle from 8.1 onwards). In this file each defined name will normally have ‘.world’ appended to it.
- For Oracle 8, run ‘Oracle Net8 Easy Config’. This will list the available service names.
- For Oracle 7, run ‘SQL Net Easy Configuration’. This provides the option to list the available service names.
- For Oracle 8.1 onwards: Try specifying the full service name, i.e. as it appears in the tnsnames file.
If a connection alias is not being explicitly provided then try to identify what alias Oracle thinks you are using. This will typically be contained in the ‘sqlnet.log’ file that the Oracle client will produce. Possible places where Oracle could be getting this (default) alias from: - The environment variable ‘LOCAL’.
Did you go through this already:
Cause:
This error indicates that the service (or TNS alias) specified when trying to connect does not exist.
‘TNS aliases’ or ‘service names’ are defined locally to each workstation. Thus different workstations could have a completely different alias to refer to the same database.
Remedy:
Check what aliases are defined on the workstation, either use one that is defined or add an appropriate one.- The following methods can be used to view the TNS names:
- Look in the file ‘ORANT\ Network\ Admin\ Tnsnames.ora’ (for versions of Oracle prior to 8.1) or ‘Oracle\ Ora81\ Network\ Admin\ Tnsnames.ora’ (for versions of Oracle from 8.1 onwards). In this file each defined name will normally have ‘.world’ appended to it.
- For Oracle 8, run ‘Oracle Net8 Easy Config’. This will list the available service names.
- For Oracle 7, run ‘SQL Net Easy Configuration’. This provides the option to list the available service names.
- For Oracle 8.1 onwards: Try specifying the full service name, i.e. as it appears in the tnsnames file.
If a connection alias is not being explicitly provided then try to identify what alias Oracle thinks you are using. This will typically be contained in the ‘sqlnet.log’ file that the Oracle client will produce. Possible places where Oracle could be getting this (default) alias from: - The environment variable ‘LOCAL’.
Hi!!
The service exists & my other collegues are using the same tnsnames.ora file to refer to the same server.but problem persists only for my machine.
I have also set the oracle home & set TNS_ADMIN=C:\or acle\ora81\netw ork\ADMIN\.
Also checked sqlnet.log file but could not get anything useful.
Please advice !!
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Subrahmanyam Arya |
last post by:
Dear oracle gurus,
I am unable to get past the error ORA-12154: TNS: could not resolve
service name on my host when using hsodbc to talk to a remote mysql
database. i got from the meta link all the needed documenatation to
configure inithsodbc.ora,listener.ora,tnsnames.ora and related errors
Here is what it says
ORA-12154:
SQL> select * from all_catalog@demo;
|
by: John |
last post by:
Hi
Right password -> ORA-12154: TNS:Could not resolve service name
wrong password => ORA-01017: invalid username/password; logon denied
Tested on a Windows XP client connecting to Oracle on an AIX server.
Using toad and sqlplusw
Everything working fin connecting to other 8.1.7 Oracle servers on windows
|
by: DavidTurcotte |
last post by:
Hi
I have been working on this bugs for the last 2 days and i am out of
gas.
i have a ORA-12154: TNS:could not resolve service name error message
when i try to acces an Oracle database
The same piece of code work in VB.NET
|
by: jstmehr4u3 |
last post by:
I just installed ODP.net 10.2.02 on my local machine (Windows XP Pro)
running IIS.
I have created a sample webservice in VS2003, connecting to localhost.
I am getting:
Oracle.DataAccess.Client.OracleException ORA-12154: TNS:could not
resolve the connect identifier specified at
Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32
errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx*
pOpoSqlValCtx, Object src,...
|
by: noha2m |
last post by:
hello
we have a network oracle 9I in server and forms in other clients
sudden we found message in the server" clear the event viewer " and the other clients have a message" ORA-12154: TNS: could not resolve service name"
please send me the solution of this problem .
| | |
by: bacterium |
last post by:
Hi,
Is there any way to solve the question :'ORA-12154: TNS:could not resolve service name' ,I import database in Oracle , but I can not logon into the database , while login through the SQL PLUS, it notes 'ORA-12154: TNS:could not resolve service name', I configured at net8s configure assistant , at the end it notes : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor. but on the file tnsnames.ora :
KANKYO =
...
|
by: gowthams123 |
last post by:
Dear All,
Plz help me with this oracle form builder installation?
I have installed SQL *PLUS Release 9.2.0.1.0 and then installed form builder 9.0.2.7.0. When i enter the following
username password database
scott tiger oracle
system seshadri (which i have set) oracle
I get the folowing error ;
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
| | |
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
