Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12514: TNS error

Re: ORA-12514: TNS error

From: David <dmagnatek_at_yahoo.com>
Date: 27 Feb 2003 05:50:00 -0800
Message-ID: <a841290b.0302270550.1dfcae11@posting.google.com>


Additional info...this is happening with two seperate servers with Oracle on them (one test and one production). I dont believe the listener would not be working on both of the servers (both of which are getting the same error).

"Gabriel Gonzalez" <no-spam_at_no-spam.com> wrote in message news:<3e5ce097$1_2_at_text-west.newsgroups.com>...
> 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:
>
> 1) Ping the server from the client. If this does not work, then it's a
> firewall issue.
>
> 2) 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:
>
> a) Firewall may not be allowing the Oracle port (defaults to 1521, but may
> be chaned at the server's listener config)
>
> b) 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...)
>
> c) 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 Thu Feb 27 2003 - 07:50:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US