Home » RDBMS Server » Server Administration » unable to connect to second database on same machine
unable to connect to second database on same machine [message #200480] Tue, 31 October 2006 01:37 Go to next message
khushi2006
Messages: 13
Registered: October 2006
Junior Member
Hi,
I have installed one more database on the same machine. Now when i am trying to connect to the second database using sqlplus, it is giving me "ORA-12154: TNS:could not resolve service name" error. How can i resolve this? Also, i want two sql sessions to be opened , each connected to different database at the same time. Please help.

Thanks and Regards
Khushi
Re: unable to connect to second database on same machine [message #200484 is a reply to message #200480] Tue, 31 October 2006 01:43 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

How can you try to connect.
like
1.sql>conn scott/tiger
or
2.sql>conn scott/tiger@db_name

if you trying to connect 2nd option then

check ur tnsnames.ora file ( service parameter)

Or if you trying to connect 1st option then try 2nd option
like
sql>conn scott/tiger@db_name
Re: unable to connect to second database on same machine [message #200490 is a reply to message #200480] Tue, 31 October 2006 02:10 Go to previous messageGo to next message
khushi2006
Messages: 13
Registered: October 2006
Junior Member
I have tried all the options and checked the tnsnames.ora file also. The service names are correct. But the port used is same. Do i have to change. what else could be the reason?

[Updated on: Tue, 31 October 2006 02:13]

Report message to a moderator

Re: unable to connect to second database on same machine [message #200491 is a reply to message #200490] Tue, 31 October 2006 02:11 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Can you plz. post exact error here.
Re: unable to connect to second database on same machine [message #200492 is a reply to message #200480] Tue, 31 October 2006 02:18 Go to previous messageGo to next message
khushi2006
Messages: 13
Registered: October 2006
Junior Member
ORA-12154: TNS:could not resolve service name
Re: unable to connect to second database on same machine [message #200494 is a reply to message #200492] Tue, 31 October 2006 02:26 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi
You get generic error plz. go through below link

http://www.dbmotive.com/oracle_error_codes.php?errcode=12154

let us know.




Previous Topic: installing 2 databases on same machine
Next Topic: Hard Parsing
Goto Forum:
  


Current Time: Sat Dec 10 11:14:59 CST 2016

Total time taken to generate the page: 0.16885 seconds