ORA-24324 & ORA-01041 reboot Database Error
Yesterday, when the Oracle database was restarted, an error was reported, ORA-24324 and ORA-01041 error, the following restore the error process and the process of solving the problem.
1. Prepare the
When a database server executes shutdown immediate, it encounters the following Ora error, as follows: $ sqlplus/as SYSDBA
Sql*plus:release 10.2.0.4.0-production on Fri 5 10:56:24 2016
Copyright (c) 1982, Oracle. All rights Reserved.
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
After the database is closed remotely, it cannot be started.ORA-12514 & ORA-24324 errors
Simulate the solution process:
SQL> conn sys/×××× @ liangwei as sysdbaConnected.SQL> shutdown immediateThe database has been closed.The database has been
The workaround is to quit and then conn the SYS again and start the database with startup normal.
Microsoft Windows [version 5.2.3790](C) Copyright 1985-2003 Microsoft Corp.D:/documents and Settings/administrator>sqlplus/nologSql*plus:
Today, when the database is locked in the test environment, shutdownimmediate cannot be used to shut down the database, so I use ps-fuoracle | grepecds | awk.
Today, when the database is locked in the test environment, shutdown immediate cannot be
ORA-24324: Service handle not initialized, not allowed, closing-connection not allowed problem C:/Documents and Settings/Administrator> sqlplus "/as sysdba" SQL> startup mount www.2cto.com ORA-01081: unable to start ORACLE that is already
Yesterday, when the Oracle database was restarted, an error was reported, ORA-24324 and ORA-01041 error, the following restore the error process and the process of solving the problem.
Yesterday, when the Oracle database was restarted, an error was
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.