Re: Oracle supervision

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 12 Jun 2003 10:51:34 -0700
Message-ID: <92eeeff0.0306120951.278cb94f@posting.google.com>

"Joe Smith" <nospam_at_nospam.com> wrote in message news:<bca0nn$7em$1_at_news-reader14.wanadoo.fr>...
> Hi,
>
> I'm using Oracle 8.1.7 for Windows.
>
> From command line, I have to verify that Oracle is ok and running. With
> cygwin utils (using ps), I can verify that there is a oracle.exe application
> running.

On Windows, presence of oracle.exe process in Task manager does not automatically mean that Oracle database is started and accepting connections. When you start OracleService<SID> (if ORA_<SID>_AUTOSTART registry entry is set to FALSE), it just starts an instance and allocates initial resources. You would have to startup the database from server manager afterwards.

To check (without any doubts) if database is started, you would have to attempt a connection from sqlplus or svrmgrl.

echo exit|sqlplus username/password_at_database|find /i "connected to:"
>nul

if errorlevel 0 echo Connect successfull

> Is there any tool (from Oracle or other) to do this 'properly', or to obtain
> a more detailed information (initialisation errors, for example)?
>

Oracle dumps all relevant information on startup/shutdown in alert log in background dump destination.

Regards
/Rauf Sarwar Received on Thu Jun 12 2003 - 12:51:34 CDT