Re: Administration script to check DB

From: <sybrandb_at_yahoo.com>
Date: 15 Sep 2004 00:46:00 -0700
Message-ID: <a1d154f4.0409142345.127b0279@posting.google.com>

fbiguet_at_yahoo.fr (F. Biguet) wrote in message news:<c20c89f0.0409140218.357ed924_at_posting.google.com>...
> Hello,
>
> I want to create a generic script that connects to Oracle databases
> (from 7.3.4 to 9.2 version) with a guest user. This script should
> return 1 if connection is successful and 0 if not.
> My problem is due to the 3 requests for password when the connection
> fails. I can't find any option that allows to ask for password only
> one time.
>
> Has anyone already written a such script?
>
> Thank you in advance.
>
> Fanny

No need for such a script. Oracle Enterprise Manager deals with this nicely. and OEM already existed in the stone age.

Sybrand Bakker
Senior Oracle DBA Received on Wed Sep 15 2004 - 02:46:00 CDT