OraFAQ Forum: Windows » Unable to connect as SYSDBA

Home » Infrastructure » Windows » Unable to connect as SYSDBA

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to connect as SYSDBA [message #152519]

Fri, 23 December 2005 11:33

vang
Messages: 8
Registered: October 2005

Junior Member

Received error: ORA-01033: ORACLE initializaton or shutdown in process

Trying to recover the database by shutting down and recover datafile. As a result, trying to log onto Database (sqlplus) but cannot.

I have attempted to log on using "connect /as sysdba" and "connect system/manger as sysdba" but am getting ora-01031: insufficient priviledge"

Any suggestion on how to shutdown database and startup - or in the event of a datafile recovery?

Report message to a moderator

Re: Unable to connect as SYSDBA [message #152814 is a reply to message #152519]

Tue, 27 December 2005 02:40

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Yur unix account must belong to the "dba" group:

$ id
uid=203(oracle) gid=200(dba) groups=303(nbadmin)

Best regards.

Frank

Report message to a moderator

Previous Topic:	To the VB Experts !!
Next Topic:	stop service: OracleOra9iasInfraEMWebsite

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 12 23:14:42 CDT 2026