Home » Infrastructure » Unix » Unable to connect as SYSDBA
Unable to connect as SYSDBA [message #152516] Fri, 23 December 2005 11:13 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?

Report message to a moderator

Re: Unable to connect as SYSDBA [message #156150 is a reply to message #152516] Mon, 23 January 2006 02:13 Go to previous message
klaas052
Messages: 12
Registered: October 2005
Junior Member
have u set the right environment ?
ORACLE_HOME and ORACLE_SID ?

Report message to a moderator

Previous Topic: Time taken to compress a file
Next Topic: Installation of Oracle database 10g Release 2 Grid Control on Solaris 5.9 (64bit)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 10:25:05 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.