If you don't like plaintext passwords (and who does), you could resort to OS
authentication. Also, we all agree what an 'up' database is, but I have seen
occasions where 'show sga' responded as expected, but the database was down
because of a corrupted rollback segment (full archive destination disk will do
likewise). Instead of 'show sga' try 'select sysdate from dual;'. Since dual is
a real table (defined in sql.bsq) in the system tablespace, this requires greater
'upness' to work correctly.
Andy Johnson
Jack of all trades, master of some.
Received on Mon Jul 06 1998 - 23:07:07 CDT
