Re: Command line script to check Oracle login and logoff

From: Bricklen <bricklen_at_zyahoo.zcomz>
Date: Tue, 30 Nov 2004 16:03:38 GMT
Message-ID: <uR0rd.210069$df2.135680@edtnps89>

sybrandb_at_yahoo.com wrote:

> 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

alternatively, look into LOGON/LOGOFF triggers

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_76a.htm or check asktom.oracle.com Received on Tue Nov 30 2004 - 10:03:38 CST