OraFAQ Forum: Server Administration » Not able to open database.

Home » RDBMS Server » Server Administration » Not able to open database.

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

Not able to open database. [message #579131]

Fri, 08 March 2013 01:18

Indra Parmar
Messages: 6
Registered: March 2013
Location: Surat

Junior Member

Hello Everyone .. I am using oracle 10gXE just for basic practice but its showing folliwing Errors .. what could be the reason and how i can solve it..??

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 8 11:46:34 2

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL>
SQL>
SQL>
SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down fir
SQL>
SQL>
SQL>
SQL> select * from dept;
select * from dept
*
ERROR at line 1:
ORA-01012: not logged on

SQL>
SQL>
SQL>
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01090: shutdown in progress - connection is not permitted
SQL>
SQL>

Regards,
Indra Parmar

Report message to a moderator

Re: Not able to open database. [message #579134 is a reply to message #579131]

Fri, 08 March 2013 01:35

Michel Cadot
Messages: 66687
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Windows?

Regards
Michel

Report message to a moderator

Re: Not able to open database. [message #579141 is a reply to message #579134]

Fri, 08 March 2013 03:16

Indra Parmar
Messages: 6
Registered: March 2013
Location: Surat

Junior Member

Yes Michel Windows..

Regards
Indra

Report message to a moderator

Re: Not able to open database. [message #579156 is a reply to message #579141]

Fri, 08 March 2013 03:54

Michel Cadot
Messages: 66687
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Stop and restart the Oracle database service.
Then connect as sysdba and check if the database is open:

select status, open_mode from v$database, v$instance;

Regards
Michel

Report message to a moderator

Previous Topic:	Event alert created sucessfully on custom table but not firing
Next Topic:	About oracle memory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 17 16:26:15 CST 2019