Home » RDBMS Server » Networking and Gateways » ORA-12154: TNS:could not resolve service name.
ORA-12154: TNS:could not resolve service name. [message #245076] Fri, 15 June 2007 02:17 Go to next message
sachin.shinde
Messages: 2
Registered: July 2006
Location: india
Junior Member
Hi

I am installing 10gR2 Db and 9i client in local m/c.
I am creating DB sucessfully.I am also able to connect that db
(system/Asimil8@ORA10DB) Now when I want Oracle 9i client and 10gR2 Database...I am getting error
ORA-12154: TNS:could not resolve service name.


Step 1. I have copy tns entry to 10gR2 DB to 9i client.
Step 2. restart all Oracle services(listener,DB,Oracle 9iClient cache)

and try to login ....

I am getting error
ERROR:
ORA-12154: TNS:could not resolve service name.

Please let me know what is the problem

Reply

Regards
-Sachin Shinde.




Re: ORA-12154: TNS:could not resolve service name. [message #245080 is a reply to message #245076] Fri, 15 June 2007 02:20 Go to previous messageGo to next message
sachin.shinde
Messages: 2
Registered: July 2006
Location: india
Junior Member
sachin.shinde wrote on Fri, 15 June 2007 02:17
Hi

I am installing 10gR2 Db and 9i client in local m/c.
I am creating DB sucessfully.I am also able to connect that db
(system/Asimil8@ORA10DB) Now when I want Oracle 9i client and 10gR2 Database...I am getting error
ORA-12154: TNS:could not resolve service name.


Step 1. I have copy tns entry to 10gR2 DB to 9i client.
Step 2. restart all Oracle services(listener,DB,Oracle 9iClient cache)

and try to login ....

I am getting error
ERROR:
ORA-12154: TNS:could not resolve service name.

Please let me know what is the problem

Reply

Regards
-Sachin Shinde.






Re: ORA-12154: TNS:could not resolve service name. [message #245088 is a reply to message #245080] Fri, 15 June 2007 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are half of a dozen of questions with ORA-12154 in their susbject in the first page of the forum.
Please read them.
This one is closed.
./fa/448/0/
Regards
Michel
Re: ORA-12154: TNS:could not resolve service name. [message #245108 is a reply to message #245076] Fri, 15 June 2007 03:33 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member



ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

You must configure your service name in

$ ORACLE_HOME/NETWORK/ADMIN/ tnsnames.ora.

Examle :

ADAPTIME =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = adaptime75)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ADAP)
)
)

Previous Topic: Heterogenous Services
Next Topic: can't insert data to SQL server within an oracle trigger
Goto Forum:
  


Current Time: Mon Dec 05 18:46:15 CST 2016

Total time taken to generate the page: 0.10418 seconds