Re: Oracle Not Available

From: Roy Varghese <rvarghese_at_ibm.net>
Date: 1997/11/30
Message-ID: <3481fd82.0@news1.ibm.net>#1/1

Stephen Robbins wrote in message ...
>A server that has been well behaved for weeks is now refusing connections
>with the message Oracle Not Available.
>
>A check of the NT host shows that it and all it's components have
>started. Stopping and restarting does not help?
>
>What obvious thing am I overlooking????
>
>Thanks
>STeve

Are you able to connect directly on the Server. i.e by running sqlplus on the server without going thru SQLNET. If not then try checking path to ORACLE_HOME.
Having different versions of Oracle on the same machine and forgetting to update ORACLE_HOME can sometimes cause this.
If you are able to connect directly but not thru SQLNET try checking SID, ORACLE_HOME & port in LISTENER.ORA

Let us know what happens Received on Sun Nov 30 1997 - 00:00:00 CST