Home » RDBMS Server » Networking and Gateways » reg connection to remote database by config thru net8
reg connection to remote database by config thru net8 [message #66762] Sat, 21 December 2002 01:18 Go to next message
PRAKASH PRATAPE
Messages: 5
Registered: April 2002
Junior Member
i am connecting a remote server by tns.

mu tnsping works correctly

but when i am connecting it thru sql then
it says 'name lookup failure'

i have made change in tnsnames.ora also but even
it is not working.

it is required urgently.

thanks
Re: reg connection to remote database by config thru net8 [message #66763 is a reply to message #66762] Mon, 23 December 2002 06:37 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
first,Ensure that you can ping the server and client by its ip address and hostname from the server and client machine.

Ensure that your client and server machine includes the client & server ip address and hostname in its HOSTS file.

If problem still persists, enable client tracing to level 16 for additional details.
Previous Topic: could not connect to apps
Next Topic: ORA-12560 TNS :ERROR(oracle9i)
Goto Forum:
  


Current Time: Tue Dec 17 23:15:10 CST 2024