OraFAQ Forum: Networking and Gateways » ORA-12154: TNS:could not resolve service name.

Home » RDBMS Server » Networking and Gateways » ORA-12154: TNS:could not resolve service name.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12154: TNS:could not resolve service name. [message #245076]

Fri, 15 June 2007 02:17

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.

Report message to a moderator

Re: ORA-12154: TNS:could not resolve service name. [message #245080 is a reply to message #245076]

Fri, 15 June 2007 02:20

sachin.shinde
Messages: 2
Registered: July 2006
Location: india

Junior Member

sachin.shinde wrote on Fri, 15 June 2007 02:17

Report message to a moderator

Re: ORA-12154: TNS:could not resolve service name. [message #245088 is a reply to message #245080]

Fri, 15 June 2007 02:32

Michel Cadot
Messages: 68645
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.
/forum/fa/448/0/

Regards
Michel

Report message to a moderator

Re: ORA-12154: TNS:could not resolve service name. [message #245108 is a reply to message #245076]

Fri, 15 June 2007 03:33

babuknb
Messages: 1736
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)
)
)

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 23:49:43 CDT 2024