Home » RDBMS Server » Server Administration » Oracle Server status
Oracle Server status [message #49925] Mon, 18 February 2002 20:56 Go to next message
Yuvarajan JT
Messages: 9
Registered: February 2002
Junior Member
Hello,
We are writing a NT Service, this depends upon Oracle server.
The requirement is to run a SQL after the DB is open.

Is there a flag to check the status of the database?
We are using Oracle 8.0.5.(Does not have events)

Please give us a suggestion to solve this.

Thanks & Regards,
Yuvarajan JT

Report message to a moderator

Re: Oracle Server status [message #49935 is a reply to message #49925] Tue, 19 February 2002 07:23 Go to previous messageGo to next message
shivkumar
Messages: 8
Registered: February 2002
Junior Member
Change the compatibility to 8.1.0 and start the oracle data gather service

bye
shiv

Report message to a moderator

Re: Oracle Server status [message #49940 is a reply to message #49925] Tue, 19 February 2002 13:05 Go to previous message
Jadie
Messages: 64
Registered: January 2002
Member
Check the column STATUS of V$instance

Report message to a moderator

Previous Topic: Urgent - Listener Problem on Solaris
Next Topic: Re: Installation problem in Oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Aug 06 15:25:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.