Hi
Steps:-
1.)Negotiate the firewall first.
2.)check the TNSNAMES for correct Alias.
3.)check the LISTENER is running.
4.)Check that "TNSNAMES" is listed as one of the values of the
NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)
Thanks & Regards,
Rajesh Kumar Mathur
TechMahindra Ltd.
Sharda Center
Pune - 04
-----Original Message-----
From: GM
[mailto:oracledba-ezmlmshield-x27816716.[Email address protected]
Sent: Thursday, August 31, 2006 1:36 PM
To: LazyDBA Discussion
Subject: connection probs
Hi all,
Am trying to connect to a db via a VPN connection and am getting
ORA-12154:
TNS:could not resolve service name errors.
Tried to ping, tnsping etc and all time out, so have thrown to networks
/
firewalls to take a look. VPN connection is fine though.
Seemed the most logical thing to do to me, but sometimes I get surprised
with what eventually works out to be the prob. Has anyone else ever
encountered the above? and was it just a firewall prob or something? or
was
it something completely different?
TIA
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
============================================================================================================================
Tech Mahindra, formerly Mahindra-British Telecom.
Disclaimer:
This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
============================================================================================================================
Oracle LazyDBA home page