问题描述
今天删除了本机安装的Oracle 11g数据库,使用drop database命令:
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
启动数据库出现了TNS-00583错误:
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\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...
专家解答
检查发现,是SQLNET.ORA 文件中的Wallet参数配置影响,删除该参数后监听器恢复正常:
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
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。