64-bit Windows Error: 61: Unknown error

C:\Users\Administrator>sqlplus / as sysdba


SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 21 22:14:20 2013


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




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


C:\Users\Administrator>lsnrctl status


LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 21-SEP-2013 22:14:26


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


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-AOOR098QTLC)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 2: No such file or directory


C:\Users\Administrator>lsnrctl start


LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 21-SEP-2013 22:14:36


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


Starting tnslsnr: please wait...


Failed to open service <OracleOraDb11g_home1TNSListener>, error 1060.
TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
Log messages written to d:\app\administrator\diag\tnslsnr\WIN-AOOR098QTLC\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-AOOR098QTLC)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-AOOR098QTLC)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date                21-SEP-2013 22:14:41
Uptime                    0 days 0 hr. 0 min. 5 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         d:\app\administrator\diag\tnslsnr\WIN-AOOR098QTLC\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-AOOR098QTLC)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 2 handler(s) for this service...
The command completed successfully


C:\Users\Administrator>sqlplus / as sysdba


SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 21 22:21:29 2013


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




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> show parameter inst


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
active_instance_count                integer
cluster_database_instances           integer     1
instance_groups                      string
instance_name                        string      orcl
instance_number                      integer     0
instance_type                        string      RDBMS
open_links_per_instance              integer     4
parallel_instance_group              string
parallel_server_instances            integer     1
SQL> alter system register
  2  ;


System altered.


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


C:\Users\Administrator>lsnrctl status


LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 21-SEP-2013 22:21:50


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


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-AOOR098QTLC)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date                21-SEP-2013 22:14:41
Uptime                    0 days 0 hr. 7 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         d:\app\administrator\diag\tnslsnr\WIN-AOOR098QTLC\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-AOOR098QTLC)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.31)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 2 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully


C:\Users\Administrator>sqlpus / sysdba
'sqlpus' is not recognized as an internal or external command,
operable program or batch file.


C:\Users\Administrator>sqlplus / as sysdba


SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 21 22:22:02 2013


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




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> alter user icms identified by icms123
  2  ;


User altered.


问题描述和绝决方案:

在windows2008英文企业版服务器上面安装完oracle11gR2之后,发现监听器总是启动不起来,并且新建监听器1521端口也使用不了,最后发先,默认的监听器的名称不叫LISTENER,而是LISTENER_ORCL,上面那个错误改了一下主机名,然后再hosts文件添加相应的解析后就就可以了。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值