Home » Infrastructure » Windows » Unable to connect as SYSDBA
Unable to connect as SYSDBA [message #152519] Fri, 23 December 2005 11:33 Go to next message
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?
Re: Unable to connect as SYSDBA [message #152814 is a reply to message #152519] Tue, 27 December 2005 02:40 Go to previous message
Frank Naude
Messages: 4579
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
Previous Topic: To the VB Experts !!
Next Topic: stop service: OracleOra9iasInfraEMWebsite
Goto Forum:
  


Current Time: Thu Mar 28 07:24:34 CDT 2024