« Mysql数据库 当前连接用户及会话查询 | Blog首页 | ACOUG 2012年2月 Ask Tom and Eygle - 上海 »
TNS-00583 错误解决案例一则
作者:eygle | 【转载请注出处】|【云和恩墨 领先的zData数据库一体机 | zCloud PaaS云管平台 | SQM SQL审核平台 | ZDBM 数据库备份一体机】
链接:https://www.eygle.com/archives/2012/01/tns-00583.html
今天删除了本机安装的Oracle 11g数据库,使用drop database命令:链接:https://www.eygle.com/archives/2012/01/tns-00583.html
SQL> startup restrict;启动数据库出现了TNS-00583错误:
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检查发现,是SQLNET.ORA 文件中的Wallet参数配置影响,删除该参数后监听器恢复正常:
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\network\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\network\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\network\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
-The End-
历史上的今天...
>> 2021-01-12文章:
>> 2016-01-12文章:
>> 2011-01-12文章:
>> 2009-01-12文章:
>> 2008-01-12文章:
>> 2006-01-12文章:
>> 2005-01-12文章:
By eygle on 2012-01-12 17:19 | Comments (0) | Case | 2944 |