Home » RDBMS Server » Networking and Gateways » Connection error (10.2.0.1)
Connection error [message #278362] Sat, 03 November 2007 06:29 Go to next message
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
Re: Connection error [message #278363 is a reply to message #278362] Sat, 03 November 2007 06:37 Go to previous messageGo to next message
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.
Re: Connection error [message #278427 is a reply to message #278362] Sun, 04 November 2007 01:27 Go to previous messageGo to next message
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.
Re: Connection error [message #278428 is a reply to message #278427] Sun, 04 November 2007 01:30 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
With Oracle, you must use static IP. Dynamic IP was never supported (afaik).

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


Current Time: Thu Mar 28 04:03:03 CDT 2024