First, the dumb question (you do not state this on your question): Is the
firewall between the client and the server?
Also you should troubleshoot in this order:
- Ping the server from the client. If this does not work, then it's a
firewall issue.
- use TNS ping from the client to the server (ie, tnsping orclsvr1).
tnsping is installed with the Oracle client. If this does not work, then
one of these things may be wrong:
- Firewall may not be allowing the Oracle port (defaults to 1521, but may
be chaned at the server's listener config)
- Client might not have the correct settings (ORA-12514 does not
necessarily mean serevr unreachable, there might be a servioce shut down, a
listener that is not working, etc...)
- As aluded to in the previous item, server might not have all services
running/configured. Test the connection in such a way that it does not have
to go through the firewall. If that fails, and nothing has changed on the
client or server config, then I'd bet the server listener is not working,
has crashed, etc...
Try some of these things and tell us what you found.
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----
Received on Wed Feb 26 2003 - 11:40:17 CST
