OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Connection error (10.2.0.1)

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

Connection error [message #278362]

Sat, 03 November 2007 06:29

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

I am trying to access my STANDBY (Managed recovery mode )from PRIMARY LOCATION .

SQL> conn sys/oracle@stdby1 as sysdba;
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

i tried TNSPING stdby1 , and it works !!!

I tried the first connection string from STANDBY server itself and it works fine .

Any particular reason for this ??

Thanks

Report message to a moderator

Re: Connection error [message #278363 is a reply to message #278362]

Sat, 03 November 2007 06:37

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Search within this section. There are lots of threads related this problem. Hope those will help you.

Report message to a moderator

Re: Connection error [message #278427 is a reply to message #278362]

Sun, 04 November 2007 01:27

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

I created a new tnsnames.ora file in PRIMARY and then i could connect.
There is no learning Confused

Just recreation of tnsnames.ora with the same entry worked !!!

In another post see DHCP can also cause a problem.If we use correct IP address in tnsnames..it should work .I dont thinnk just because DHCP there can be issues.

Report message to a moderator

Re: Connection error [message #278428 is a reply to message #278427]

Sun, 04 November 2007 01:30

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

With Oracle, you must use static IP. Dynamic IP was never supported (afaik).

Regards
Michel

Report message to a moderator

Previous Topic:	Does using Toad or SQLNavigator solve Firewall issue
Next Topic:	Ora-12170 Connection time out

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 15:20:56 CST 2024