Home » RDBMS Server » Server Administration » Not able to open database.
Not able to open database. [message #579131] Fri, 08 March 2013 01:18 Go to next message
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
Re: Not able to open database. [message #579134 is a reply to message #579131] Fri, 08 March 2013 01:35 Go to previous messageGo to next message
Michel Cadot
Messages: 59083
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Windows?

Regards
Michel
Re: Not able to open database. [message #579141 is a reply to message #579134] Fri, 08 March 2013 03:16 Go to previous messageGo to next message
Indra Parmar
Messages: 6
Registered: March 2013
Location: Surat
Junior Member
Yes Michel Windows..

Regards
Indra
Re: Not able to open database. [message #579156 is a reply to message #579141] Fri, 08 March 2013 03:54 Go to previous message
Michel Cadot
Messages: 59083
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
Previous Topic: Event alert created sucessfully on custom table but not firing
Next Topic: About oracle memory
Goto Forum:
  


Current Time: Tue Sep 16 09:14:14 CDT 2014

Total time taken to generate the page: 0.09907 seconds