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/nolog Sql*plus:release 10.2.0.1.0-production on Thursday September 24 11:59:43 2009 Copyright (c) 1982, +, Oracle. All rights reserved. Sql> Conn sys/*** @orcl as Sysdba |
is connected.
sql> shutdown Normal
The database has been closed.
The database has been unloaded.
The ORACLE routine has been closed.
Sql> Startup Mount
Ora-12514:tns: The listener is currently unable to recognize the service requested in the connection descriptor
Sql> Startup Mount
ORA-24324: Service Handle not initialized
ORA-01041: Internal error, Hostdef extension does not exist
Sql>
You must connect again, or you will not be able to start the database!!!!! It is useless to say anything about changing your listening files or sqlnet files on the Web!!!
Sql> Conn SYS/FH123@ORCL as Sysdba
You are connected to an idle routine.
Sql> Startup
The ORACLE routine has started.