OraFAQ Forum: Server Administration » unable to connect to second database on same machine

Home » RDBMS Server » Server Administration » unable to connect to second database on same machine

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

unable to connect to second database on same machine [message #200480]

Tue, 31 October 2006 01:37

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

Report message to a moderator

Re: unable to connect to second database on same machine [message #200484 is a reply to message #200480]

Tue, 31 October 2006 01:43

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

Report message to a moderator

Re: unable to connect to second database on same machine [message #200490 is a reply to message #200480]

Tue, 31 October 2006 02:10

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