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
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
ORA-00001: violation of unique constraints (.) ORA-00017: Request session to set trace event ORA-00018: exceeds Max sessions ORA-00019: exceeds Max session licenses ORA-00020: exceeds Max processes () ORA-00021: Session is attached to some other
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:
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
ORA-03113 error occurs when Oracle database is shut down:
SQL> shutdown immediateORA-03113: end-of-file on communication channelProcess ID: 3437The Session ID is 125 Serial number: 5.
SQL> startupThe ORA-24324: service handle not initialized.ORA-0104
Native IP Address: 192.168.1.163[Email protected] ~]$ Sqlplus/nologSql*plus:release 10.2.0.2.0-production on Sun 4 19:32:13 2014Copyright (c) 1982, 2005, Oracle. All rights Reserved.@>conn sys/oracleerror:ora-01034:oracle not
Local IP Address: 192.168.1.163[Oracle @ rtest ~] $ Sqlplus/nologSQL * Plus: Release 10.2.0.2.0-Production on Sun May 4 19:32:13 2014Copyright (c) 1982,200 5, Oracle. All Rights Reserved.@> Conn sys/oracle ERROR: ORA-01034: ORACLE not available ORA-2
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.