ORA-24324: Service handle not initialized, this value is not allowed, closing-no connection allowed

Source: Internet
Author: User
Tags sqlplus
ORA-24324: Service handle not initialized, this value is not allowed, closing-no connection allowedC:/Documents and Settings/administrator>sqlplus "/as sysdba"
Sql> Startup Mount
ORA-01081: Unable to start ORACLE already running-Please close it first
sql> shutdown
-long time no close, CTRL + C
C:/Documents and Settings/administrator>sqlplus "/as sysdba"
is connected.
sql> shutdown Immediate
ORA-24324: Service Handle not initialized
ORA-24323: This value is not allowed
ORA-01090: Closing-no connection allowed
sql> shutdown Immediate
ORA-24324: Service Handle not initialized
ORA-24323: This value is not allowed
ORA-01090: Closing-no connection allowed
sql> Shutdown Abort
Ora-01031:insufficient Privileges
Sql> quit
The connection has been disconnected
C:/Documents and Settings/administrator>sqlplus/nolog
Sql> Conn Sys/oracle as Sysdba
You are connected to an idle routine.
sql> Shutdown Abort
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has started.
Total System Global area 1073741824 bytes
Fixed Size 1253072 bytes
Variable Size 281018672 bytes
Database buffers 784334848 bytes
Redo buffers 7135232 bytes
Database loading complete.
The database is already open.
Sql>


From the cause of the problem, we can see that the database is due to the shutdown process is interrupted, then the shutdown command can not shut down the database, so it is conceivable that the normal shutdown and immediate shutdown is not working, we can use shutdown abort to abort the current database instance.
Shutdown Abort aborts an instance with the following characteristics:
L The Oracle server immediately aborts the SQL statement currently being processed;
L The Oracle server will not wait for the user currently connected to the database to disconnect;
L Data Redo log buffering is not written to disk;
L Unfinished transactions are not rolled back;
L instance terminates without closing the file;
• Oracle shuts down and uninstalls databases;
L The next boot requires an instance recovery, which is automatic.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.