Home » RDBMS Server » Backup & Recovery » Cannot connect to Oracle Database
Cannot connect to Oracle Database [message #152540] Fri, 23 December 2005 13:53 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: Cannot connect to Oracle Database [message #152697 is a reply to message #152540] Mon, 26 December 2005 10:59 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member
did you see if you have any password file setting enabled ?? also ensure that you are trying to login as sysdba from the same user who own the oracle base ..

-Sai Jeedigunta

Report message to a moderator

Re: Cannot connect to Oracle Database [message #153381 is a reply to message #152697] Sun, 01 January 2006 23:53 Go to previous message
waseem_aijaz
Messages: 16
Registered: December 2005
Location: Kingdom of Saudi Arabia
Junior Member
First, Check your alert_SID.log file. You will get hints. You got the error ORA-01033 because you tried to login immediately after issuing shutdown command.

Try it once more. It is better if you have test environment.

Report message to a moderator

Previous Topic: Catalog database
Next Topic: backup policy help needed
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 07:55:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.