OraFAQ Forum: Server Utilities » ORA-01033: ORACLE initialization or shutdown in progress

Home » RDBMS Server » Server Utilities » ORA-01033: ORACLE initialization or shutdown in progress

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

ORA-01033: ORACLE initialization or shutdown in progress [message #70746]

Fri, 19 July 2002 17:32

Jeff
Messages: 63
Registered: July 1999

Member

When I try to login to SQL Plus using System/manager and my host I get the following error:
ORA-01033: ORACLE initialization or shutdown in progress. When I check my services the listener is started. What else could be the cause?

Thanks

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #70748 is a reply to message #70746]

Fri, 19 July 2002 23:00

Anil
Messages: 80
Registered: September 2001

Member

Hi,

What OS you are using?? And make it sure your database
is mounted and open properly. Then try connecting to the DB.

plz reply.
take care.

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #70750 is a reply to message #70746]

Sat, 20 July 2002 01:21

sunil bhola
Messages: 58
Registered: July 2002

Member

this is happening b'coz the database is not properly mounted/opened. wait for some time, if it is still displaying this, then go to server manager in command promot by typing c:>svrmgrl and press enter
svrmgrl>connect sys/change_on_install as sysdba
svrmgrl>shutdown immediate;
svrmgrl>startup;

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #70759 is a reply to message #70746]

Sat, 20 July 2002 04:17

Jeff
Messages: 63
Registered: July 1999

Member

After I type connect sys/change_on_install as sysdba an press enter I get the following error ORA-01031 insufficient privileges. I also tried system/manager but get the ORA-01033 error. I am using 8.1.5 personnel oracle version.

Thanks

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #70787 is a reply to message #70759]

Tue, 23 July 2002 06:15

ctg
Messages: 146
Registered: July 2002

Senior Member

Look into your init.ora file, what is REMOTE_LOGIN_PASSWORDFILE set to?

If it is set to SHARED or EXCLUSIVE, give this a try:

got to your ORACLE_HOME/Database
rename your password file (pwd<SID>.ora)
then in a dos window use the orapwd utility to recreate the password file.
EX: orapwd file=ORACLE_HOME/database/pwd<SID>.ora password=oracle

then go to sqlplus
SQL> connect sys/oracle as sysdba
SQL> select instance_name, status from v$instance;
this will show what mode your database is in.
SQL> ALTER DATABASE MOUNT/OPEN;
SQL> ALTER USER sys IDENTIFIED BY new_pwd;

Report message to a moderator

Previous Topic:	Export gives invalid col name
Next Topic:	New sqlldr user having problems loading date column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 11:36:55 CDT 2024