Home » RDBMS Server » Server Administration » Problem because of heterogeneous Service?
Problem because of heterogeneous Service? [message #125832] Wed, 29 June 2005 07:56 Go to next message
Achchan
Messages: 86
Registered: June 2005
Member
I have tried to enable HS and I do all the steps in

Link successfully.
At the end when I tried to do select from database link I got error.After that I tried to

connect to my previous non-HS database but it throws ORA-12154.
I checked tnsnames and listener and there are fine but surprisingly Net Manager

can not see then and shows nothing in services and listeners tabs.
Is there anybody faced such a thing before?
-Thanks in advance
Re: Problem because of heterogeneous Service? [message #125850 is a reply to message #125832] Wed, 29 June 2005 08:55 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
You might have a syntax error in your TNSNAMES.ORA file. Try to remove your HS entries and see if you can tnsping your services.

Best regards.

Frank
Re: Problem because of heterogeneous Service? [message #126247 is a reply to message #125850] Fri, 01 July 2005 23:49 Go to previous message
Achchan
Messages: 86
Registered: June 2005
Member
No,I have no syntax error in tnsnames.ora,I checked it many times.
Previous Topic: Database fragmentation and shrinking
Next Topic: What are these files GOOD for ?
Goto Forum:
  


Current Time: Fri Sep 27 00:17:54 CDT 2024