alert log.$ORACLE_HOME

[Former Member]

Hi,

Using the Alert log under $ORACLE_HOME/saptrace/background.

Is it possible to determine whether the database is currently in an intermediate start or stop phase.???

If it so how can i proceed the process for alert log?

with regards

vijay

[Former Member]

Hi,

Yes u can view the status of ur db thru alertsid.log

Regards, Umesh K

[Former Member]

Hi Vijay...

If you want to check the state of the Database.. you can do that with the following SQL statement..

SQL>select distinst status from v$instance;

If you have to check the alert.log.. you have to go cd /oracle/SID/saptrace/background/alert.log and then you can do either more alert.log to view the information.

I hope this answers your Question.

Regards,

Ershad Ahmed.

[lbreddemann]

Hi Vijay,

look for "Starting ORACLE instance" or "Completed: ALTER DATABASE CLOSE NORMAL".

Between these statements you should find things like "ALTER DATABASE OPEN" or "ALTER DATABASE CLOSE" and so on.

With that you may get quite close to find out the current state of the instance.

But much easier and more precise is just asking the instance itself:

[code]sqlplus "/as sysdba"

select status from v$instance;

STATUS

-

---

OPEN[/code]

KR Lars