ORA-01034: ORACLE not available on win2k

[slok]

I got the following error while trying to logon via SQLPlus.

I have check the services and only one is not started.
====
OracleOraHome81Agent Started Automatic
OracleOraHome81ClientCache Started Automatic
OracleOraHome81DataGatherer Started Automatic
OracleOraHome81ManagementServer Automatic
OracleOraHome81TNSListener Started Automatic
OracleServiceMUGCA Started Automatic
OracleWebAssistant0 Started Automatic
====

what could be the problem?

 

[slok]

Also, from Toad, I got the following messages...

================


Details:
oci.dll found
2) Oracle Home Key is SOFTWARE\ORACLE\HOME0
Looking for TNS_ADMIN environmental variable
TNS_ADMIN environmental variable doesnt exist,
looking for TNS_ADMIN reg key using home key: >SOFTWARE\ORACLE\HOME0<
TNS_ADMIN does not exist in SOFTWARE\ORACLE\HOME0
looking for TNS_ADMIN reg key in \Oracle: >SOFTWARE\ORACLE\HOME0<
Looking for OracleHomeKey\ORACLE_HOME
Oracle Path is now C:\Oracle\Ora81\Network\Admin
Looking for C:\Oracle\Ora81\Network\Admin\tnsnames.ora
tnsnames.ora found
tnsnames entry: MUGCA
tnsnames entry: EXTPROC_CONNECTION_DATA
tnsnames.ora found
tnsnames entry: MUGCA
tnsnames entry: EXTPROC_CONNECTION_DATA

 

[karluk]

Have you checked the alert log to make sure that your database is up?

 

[slok]

where is alert log?

thanks

 

[karluk]

It's in whatever directory you have specified as your background dump destination.

 

[slok]

ok, I am not sure whether this is the alert log.
But I do find some form of log file at this location...

C:\Oracle\admin\mugca\bdump\mugcaALRT.LOG

&quot;mugca&quot; is my database instance.

and the last entries in the log file shows 18 April.
I have since rebooted the machine a couple of times, there is
no entries for 19 April and 20 April.

the last entries read something like this...

====
Thu Apr 18 23:29:32 2002
Successful mount of redo thread 1, with mount id 636453531.
Thu Apr 18 23:29:32 2002
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Apr 18 23:29:32 2002
alter database open
Beginning crash recovery of 1 threads
Thu Apr 18 23:29:36 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 127 Reading mem 0
Mem# 0 errs 0: C:\ORACLE\ORADATA\MUGCA\REDO03.LOG
Thu Apr 18 23:29:36 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Apr 18 23:29:41 2002
Thread 1 advanced to log sequence 128
Thread 1 opened at log sequence 128
Current log# 2 seq# 128 mem# 0: C:\ORACLE\ORADATA\MUGCA\REDO02.LOG
Successful open of redo thread 1.
Thu Apr 18 23:29:42 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Thu Apr 18 23:30:45 2002
Completed: alter database open
=====

 

[karluk]

If you've rebooted since the last alert log entry, your database is probably down. Every time Oracle starts your instance you should see messages similar to the ones in your post. Their absence indicates that the db was never restarted after the reboot.

If you can log in as sysdba, please try to issue a startup command and see what happens.