TNS-00583 错误解决案例一则

SQL> startup restrict;
ORACLE instance started.

Total System Global Area  535662592 bytes
Fixed Size                  1384752 bytes
Variable Size             268439248 bytes
Database Buffers          260046848 bytes
Redo Buffers                5791744 bytes
Database mounted.
Database opened.
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-01586: database must be mounted EXCLUSIVE and not open for this operation


SQL> alter database close;

Database altered.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:\\ORACLE\\11.2.0\\DATABASE\\INITORA11G.ORA'
SQL> exit
Disconnected

E:\\>lsnrctl start

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 12-JAN-2012 17:07:56

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
System parameter file is D:\\Oracle\\11.2.0\
etwork\\admin\\listener.ora
Log messages written to D:\\Oracle\\diag\\tnslsnr\\oracle-vm\\listener\\alert\\log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
 TNS-00583: Valid node checking: unable to parse configuration parameters


Listener failed to start. See the error message(s) above...

ENCRYPTION_WALLET_LOCATION=
  (SOURCE=(METHOD=FILE)(METHOD_DATA=
    (DIRECTORY=D:\\Oracle\\11.2.0\\NETWORK\\ADMIN\\encryption_wallet\\)))

E:\\>lsnrctl start

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 12-JAN-2012 17:09:27

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
System parameter file is D:\\Oracle\\11.2.0\
etwork\\admin\\listener.ora
Log messages written to D:\\Oracle\\diag\\tnslsnr\\oracle-vm\\listener\\alert\\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date                12-JAN-2012 17:09:30
Uptime                    0 days 0 hr. 0 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\\Oracle\\11.2.0\
etwork\\admin\\listener.ora
Listener Log File         D:\\Oracle\\diag\\tnslsnr\\oracle-vm\\listener\\alert\\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "ora11g" has 1 instance(s).
  Instance "ora11g", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully