ORA-01034 - Oracle not available

[Avi123india]

Hi,

I m new to this forum.

I m using Oracle 8.0.5 on windows NT and last 2 days i m not able to connect to oracle.

1. i hv check all oracle services - running successful
2. try to connect - server manager - svrmgr30 with internal user but fail to connect.
3. it seems to be SGA or OS level problems

can anyone help me to up the databse again. or anyother solution.



Thanks and regards

Avi.

[akhadar]

May be problem with your password file.create another with orapwd utility and try.

[abhaysk]

Originally posted by Avi123india
Hi,

2. try to connect - server manager - svrmgr30 with internal user but fail to connect.
Avi.

Wass the error?

Abhay.

[nir_s]

On version 8.0.5 ,SVRMGR is issued by svrmgrl and not by svrmgr30.

See the following example (On Unix):

hp64 23: svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production

SVRMGR> connect internal
Connected.

On your NT machine,try fisrst the command:
set oracle_sid = ;
and then : svrmgrl

send us the output of those commands.

Regards,

Nir

[jmodic]

Originally posted by nir_s
On version 8.0.5 ,SVRMGR is issued by svrmgrl and not by svrmgr30.

He clearly stated his OS is Windows NT, and on NT there is no such thing as "svrmgrl" on 8.0.5 - command line Server Manager on that release is "svrmgr30".

[Avi123india]

Hi,

Thanks for immediate response

my observation :

1. I found from log/trace file that one of the data file stored in
another Hard disk, which is crashed. is there anyway to recover data as on date. all other datafile are safe in another hard disk.

2. why user internal is not connecting to server manager
error message : invalid username/password
if i use orapwd utility , can i able to connected to server ?

3. last option i hv some old back(user) can be useful.

Regards,

Ari.

[abhaysk]

Originally posted by Avi123india
Hi,

Thanks for immediate response

my observation :

1. data file stored in another Hard disk, which is crashed. is there anyway to recover data as on date. all other datafile are safe in another hard disk.

If hard disk is crashed, check with NT admin guys if its recoverable.

2. why user internal is not connecting to server manager
error message : invalid username/password
if i use orapwd utility , can i able to connected to server ?

Yes