Home » SQL & PL/SQL » SQL & PL/SQL » DB Shutdown error code
DB Shutdown error code [message #20819] Sun, 23 June 2002 21:49 Go to next message
Balaji
Messages: 102
Registered: October 2000
Senior Member
Hai all,
Iam investigating on a problem iam facing
i need to know a way out to find whether a DB is in shutdown state.
i need to give the user a retry operation based on this.
can anyone help me out..????

regards
balaji
Re: DB Shutdown error code [message #20824 is a reply to message #20819] Mon, 24 June 2002 02:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you can ping the database.
like

tnsping <host_string>;
tnsping prod1;
Re: DB Shutdown error code [message #20828 is a reply to message #20819] Mon, 24 June 2002 03:03 Go to previous message
Balaji
Messages: 102
Registered: October 2000
Senior Member
Hai Mahesh,
when i tried to shutdown the DB using Oracle Instance
Manager, and tried running tnsping80..it is still
succeding.
i think this utility will succeed when a entry is there in the tnsnames.ora file and not whether db is up or not..???

can u give me the error code of "Oracle Not Available"
exception.
Previous Topic: comparing triggers and procedures
Next Topic: Please , why Table or View does not exist by XP ?
Goto Forum:
  


Current Time: Thu Apr 18 20:30:31 CDT 2024