ORA-24324 & ORA-01041

After the database is closed remotely, it cannot be started.ORA-12514 & ORA-24324 errors

Simulate the solution process:

SQL> conn sys/×××× @ liangwei as sysdba
Connected.
SQL> shutdown immediate
The database has been closed.
The database has been detached.
The Oracle routine has been disabled.

SQL> startup
ORA-12514: TNS: The Listener currently cannot identify the Service requested in the connection Descriptor

SQL> host LSNRCTL status

LSNRCTL for 32-bit windows: Version 11.2.0.1.0-production on 2011 17:00:22
Copyright (c) 1991,201 0, Oracle. All rights reserved.
Connecting to (description = (address = (Protocol = IPC) (Key = extproc1521 )))
Listener status
------------------------
Alias listener
Version tnslsnr for 32-bit windows: Version 11.2.0.1.0-Production
Start Date: 15-3 months-2011 15:58:30
Normal operation time 0 days 1 hour 1 minute 56 seconds
Tracking level off
Security on: Local OS Authentication
SNMP off
Listener parameter file D:/Oracle/liangwei/product/11.2.0/dbhome_1/Network/admin/listener. ora
Listener log file D:/Oracle/liangwei/diag/tnslsnr/SS-liangwei/listener/alert/log. xml
Listener endpoint overview...
(Description = (address = (Protocol = IPC) (pipename = //./pipe/extproc1521ipc )))
(Description = (address = (Protocol = TCP) (host = SS-liangwei) (Port = 1521 )))
Service summary ..
The Service "clrextproc" contains one instance.
Instance "clrextproc", status unknown, contains one handler of this service...
Command executed successfully

 

 

SQL>Host LSNRCTL RELOAD
LSNRCTL for 32-bit windows: Version 11.2.0.1.0-production on 2011 17:15:34
Copyright (c) 1991,201 0, Oracle. All rights reserved.
Connecting to (description = (address = (Protocol = IPC) (Key = extproc1521 )))
Command executed successfully

 

SQL> startup
ORA-24324: Service handle not initialized
ORA-01041: Internal error, hostdef extension does not exist

The reason is that the instance registration information is no longer available in the listener, so it is okay to log on to and restart the local machine.

C:/users/liangwei> sqlplus/As sysdba

SQL * Plus: Release 11.2.0.1.0 production on Tuesday March 15 17:05:47 2011
Copyright (c) 1982,201 0, Oracle. All rights reserved.
Already connected to the idle routine.

SQL>Startup
The Oracle routine has been started.

Total system global area 535662592 bytes
Fixed size 1375792 bytes
Variable Size 293601744 bytes
Database buffers 234881024 bytes
Redo buffers 5804032 bytes
The database has been loaded.
The database has been opened.

SQL>Host LSNRCTL

LSNRCTL for 32-bit windows: Version 11.2.0.1.0-production on 2011 17:11:01

Copyright (c) 1991,201 0, Oracle. All rights reserved.

Welcome to LSNRCTL. Enter "help" for information.

LSNRCTL> Status
Connecting to (description = (address = (Protocol = IPC) (Key = extproc1521 )))
Listener status
------------------------
Alias listener
Version tnslsnr for 32-bit windows: Version 11.2.0.1.0-Production
Start Date: 15-3 months-2011 17:04:33
Normal operation time 0 days 0 hours 6 minutes 34 seconds
Tracking level off
Security on: Local OS Authentication
SNMP off
Listener parameter file D:/Oracle/liangwei/product/11.2.0/dbhome_1/Network/admin/listener. ora
Listener log file D:/Oracle/liangwei/diag/tnslsnr/SS-liangwei/listener/alert/log. xml
Listener endpoint overview...
(Description = (address = (Protocol = IPC) (pipename = //./pipe/extproc1521ipc )))
(Description = (address = (Protocol = TCP) (host = SS-liangwei) (Port = 1521 )))
Service summary ..
The Service "clrextproc" contains one instance.
Instance "clrextproc", status unknown, contains one handler of this service...
The Service "liangwei" contains two instances.
Instance "liangwei", status unknown, contains 1 handler of this service...
Instance "liangwei", status ready, contains 1 handler of this service...
The Service "liangweixdb" contains one instance.
Instance "liangwei", status ready, contains 1 handler of this service...
Command executed successfully