Re: Command line script to check Oracle login and logoff

Jens Riedel <JensRie_at_gmx.de> wrote in message news:<312tniF34vgk8U1_at_uni-berlin.de>...
> Hello,
>
> I want to test in an application if an Oracle DB is available and a
> login is successfull.
> Now I'm looking for a batch script which I can run under WinNT. It
> should proceed a logon at the database (which is installed on the same
> system) and logoff again and then give back a return value which
> indicates if the process was successfull.
>
> I'm not very familiar with Oracle and its build-in tools so please
> excuse if this question seems stupid.
>
> Can anybody give me a hint how to realize this?
>
> Thanks,
> Jens

Oracle Enterprise Manager (comes free of charge with Oracle) has tools to check for database availability. The overhead for your proposed solution is usually very high.

Sybrand Bakker
Senior Oracle DBA Received on Tue Nov 30 2004 - 09:51:55 CST