ORA-24324 & ORA-01041 restart Database Error

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 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;