ORA-24324ORA-01041 reboot Database Error

Source: Internet
Author: User
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 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 reported, ORA-24324 and ORA-01041 error, the following restore the error process and the process of solving the problem.

1. Prepare the environment
We performed the test in Oracle 10g + Windows Server 2008. Note that multiple databases are created on the server. Therefore, you must specify the service name for logon.

C: \ Users \ Administrator> sqlplus/@ hoegh as sysdba

SQL * Plus: Release 10.2.0.4.0-Production on Tuesday May 19 11:25:33 2015

Copyright (c) 1982,200 7, Oracle. All Rights Reserved.

Connect:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

SQL> select * from v $ version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bi

PL/SQL Release 10.2.0.4.0-Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0-Production

NLSRTL Version 10.2.0.4.0-Production

SQL>


2. Error
First execute shutdown to close the database, then execute startup mount to restart the database, reported ORA-24324 and ORA-01041 error.

SQL> shutdown immediate

The database has been closed.

The database has been detached.

The ORACLE routine has been disabled.

SQL>

SQL>

SQL> startup mount;

ORA-24324: Service handle not initialized

ORA-01041: Internal error, hostdef extension does not exist

SQL>
Then I tried logging on to sqlplus again and still reported a ORA-01041 Error


SQL>

SQL> exit

From Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options disconnected

C: \ Users \ Administrator> sqlplus/@ hoegh as sysdba

SQL * Plus: Release 10.2.0.4.0-Production on Wednesday May 20 09:28:00 2015

Copyright (c) 1982,200 7, Oracle. All Rights Reserved.

ERROR:

ORA-01041: Internal error, hostdef extension does not exist

Enter the User Name:


3. Trouble-shooting
The root cause of this error is that the instance registration information is no longer available in the listener. It may be related to multiple databases, so I tried to specify ORACLE_SID to Solve the Problem smoothly.


C: \ Users \ Administrator>

C: \ Users \ Administrator> set ORACLE_SID = HOEGH

C: \ Users \ Administrator> sqlplus/as sysdba

SQL * Plus: Release 10.2.0.4.0-Production on Wednesday May 20 09:31:03 2015

Copyright (c) 1982,200 7, Oracle. All Rights Reserved.

Already connected to the idle routine.

SQL> startup mount;

The ORACLE routine has been started.

Total System Global Area 2415919104 bytes

Fixed Size 2165960 bytes

Variable Size 1767568184 bytes

Database Buffers 637534208 bytes

Redo Buffers 8650752 bytes

The database has been loaded.

SQL>


4. Summary
The root cause of this error is that the instance registration information is no longer available in the listener. I specified ORACLE_SID to provide the instance information and solved the problem smoothly; the above content is just to provide you with a solution to the problem. I think there are other solutions on the Internet. It may be that the fault scenarios are different. You can refer to it when solving similar problems, including:
1. Restart the listener;
2. Restart sqlplus;
3. log on to the server and restart the database;

This article permanently updates the link address:

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.