connection problem in oracle9i?

March 30, 2009 at 11:34:52
Specs: Windows XP, -
Hi,

I have installed oracle9i with my personal PC
two years back and it was working until on
yesterday. But today i tried to login its giving
the below error
"ORA-01033: ORACLE initialization or
shutdown in progress" i don't what was happen
? yesterday i was working with the same login
credentials.

i saw the below error message in alert file in
(E:\oracle\admin\psiva\bdump)
-----------------------
ORA-1507 signalled during: alter database
open
...
Mon Mar 30 23:31:23 2009
alter database mount

ORA-214 signalled during: alter database
mount
...
Mon Mar 30 23:31:31 2009
alter database open

ORA-1507 signalled during: alter database
open
----------------------------

Any one please help me on this.


See More: connection problem in oracle9i?

Report •


#1
June 4, 2009 at 14:50:02
check your services to confirm the expected Oracle services are running ( tnslistener, database ).

What do you get when you try to connect with sqlplus ?

sqlplus username/password

?


Report •

#2
June 4, 2009 at 22:13:12
Thanks david,
when i tried to connect the database using sqlplus. i got the below error

ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

Pls help me on this to resovle the problem


Report •

#3
June 5, 2009 at 08:33:38
“The ORA-01033: ORACLE initialization or shutdown in progress” error happens when the database is not open. After you create the control file issue the command:

“alter database open”

That should stop the ORA-01033 error and make the database available for general use.

The “ORA-01033: ORACLE initialization or shutdown in progress.” error can also happen when Oracle is attempting startup or shutdown and is "hanging" on a resource such as a failed disk, writing to redo, etc.

See if the following example might help you.

F:\oracle\ora92\bin>sqlplus/nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Sun Sep 9 19:37:13 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
Connected.
------------------------------------------------------------
SQL> shutdown
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.


Report •

Related Solutions

#4
June 8, 2009 at 04:03:27
Hi David,

When i tried to connect the database in dba mode, its giving the below error
username: scott
PasswordLtiger
Host string: SYSDBA
Error:
ORA-12154: TNS: could not resolve service name

Pls help me on this to resolve the problem.


Report •

#5
June 8, 2009 at 12:20:21
I did not say to connect to the host sysdba. Change this part to include auth info relevant to your environment

sqlplus sys/PASSWORD@SID /nolog

http://www.adp-gmbh.ch/ora/admin/co...


Report •


Ask Question