C:\Users\JIANG>lsnrctl statusLSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 26-SEP-2014 09:42 :44Copyright (c) 1991, 2010, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ ction Start Date 26-SEP-2014 09:39:22 Uptime 0 days 0 hr. 3 min. 21 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File D:\app\JIANG\product\instantclient_11_2\listener.ora Listener Log File d:\app\jiang\diag\tnslsnr\JIANG-PC\listener\alert\log. xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "orcl" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully监听状态是正常。 安装oracle的时候,默认建了一个数据库orcl,然后配置了oracle客户端后可以使用,plsql和sqlplus都能访问。 之后重新创建另一个数据库,就报监听错误,估计是我调整那块的监听给弄坏了设置。现在orcl库都连不上了。
TNSPING 能通吗?是不是localhost没有解析啊,换成ip试试
先看看监听的状态
(SID_DESC =
(GLOBAL_DBNAME = XX)
(ORACLE_HOME = XXXX)
(SID_NAME = XX)
)
http://www.blogjava.net/usherlight/archive/2007/02/12/99566.html
PL/SQL可以在win7 64位中运行,现在本人在用
这个问题,可以试试重新配置Oracle服务
你如果在cmd下是不是可以访问的?
TNSPING 能通吗?是不是localhost没有解析啊,换成ip试试TNSPING 能通。换成127也还是没法访问。
C:\Users\JIANG>lsnrctl statusLSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 26-SEP-2014 09:42
:44Copyright (c) 1991, 2010, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 26-SEP-2014 09:39:22
Uptime 0 days 0 hr. 3 min. 21 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\JIANG\product\instantclient_11_2\listener.ora
Listener Log File d:\app\jiang\diag\tnslsnr\JIANG-PC\listener\alert\log.
xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully监听状态是正常。
安装oracle的时候,默认建了一个数据库orcl,然后配置了oracle客户端后可以使用,plsql和sqlplus都能访问。
之后重新创建另一个数据库,就报监听错误,估计是我调整那块的监听给弄坏了设置。现在orcl库都连不上了。
额,oracle客户端配置没有问题。 是cmd下sqlplus也无法访问。如果sqlplus能访问,才是客户端问题。
oracle装载虚拟机上,主机上没装oracle client,
plsql dev 仍可以使用环境:
win7 64位
Oracle 11g 64位
Vmware 中装的也是 win7 64位