Home » RDBMS Server » Server Administration » ORA-01033 ERROR!!!!!!!!!!!
ORA-01033 ERROR!!!!!!!!!!! [message #51506] Mon, 27 May 2002 20:46 Go to next message
Deepak V.V.
Messages: 1
Registered: May 2002
Junior Member
Hi,
I keep getting the ORA-01033 error message when I try to log on to the database. As per the information I got from this site,I am unable to repair my database. It says I am to connect as internal/oracle as sysdba but the point is I am unable to get in. Please give me a clear reply and how to repair the same.

Report message to a moderator

Re: ORA-01033 ERROR!!!!!!!!!!! [message #51507 is a reply to message #51506] Mon, 27 May 2002 21:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
hi,
can you pls furnish more information? version, OS..etc
if by chance your OS is NT, try to restart the oracle service from the control panel.

Mahesh Rajendran

Report message to a moderator

Re: ORA-01033 ERROR!!!!!!!!!!! [message #52915 is a reply to message #51506] Tue, 20 August 2002 09:07 Go to previous messageGo to next message
Rocco Marotta
Messages: 1
Registered: August 2002
Junior Member
I received this error once when I was bouncing between two databases on the same server. When I wanted to use one or the other, I would set the appropriate system variables (%pfile%, %oracle_sid%, etc.) and rename the password files from PWDnnnn.ora to PWDnnnn.ora.save for the former database and PWDnnnn.ora.save to PWDnnnn.ora for the current database. When I forgot to rename the password file, I received the dreaded ORA-01033 error.

Report message to a moderator

Re: ORA-01033 ERROR!!!!!!!!!!! [message #52932 is a reply to message #51506] Wed, 21 August 2002 03:36 Go to previous messageGo to next message
Herman Haentjens
Messages: 2
Registered: August 2002
Junior Member
hi,
Best you check your trace file (search in oracle directory ) for the last *.trc file
As such you find probably the cause of your problem.
In my case it was I had deleted whole directory with th database files system01......
As such I had to recreate the database and reload a recent dump into it.

Report message to a moderator

Re: ORA-01033 ERROR!!!!!!!!!!! [message #52934 is a reply to message #51506] Wed, 21 August 2002 04:15 Go to previous message
Herman Haentjens
Messages: 2
Registered: August 2002
Junior Member
hi,
Best you check your trace file (search in oracle directory ) for the last *.trc file
As such you find probably the cause of your problem.
In my case it was I had deleted whole directory with th database files system01......
As such I had to recreate the database and reload a recent dump into it.
Note that although about all database files were missing, the related service was still starting properly(???)

Report message to a moderator

Previous Topic: Re: FREE ORACLE ILT BOOKS(oracle university)with OCP KITS.
Next Topic: Trigger Err (Insert into another DB)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 04:21:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.