Chinaunix

标题: listener 静态注册后无法远程连接，动态注册后可以 [打印本页]

作者: znn19850323 时间: 2014-08-23 14:56
标题: listener 静态注册后无法远程连接，动态注册后可以
我的listner是静态注册的，能成功启动：

[oracle@localhost admin]$ lsnrctl status LSN2

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-AUG-2014 14:07:28

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.5)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                   LSN2
Version                TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date             23-AUG-2014 13:43:01
Uptime                   0 days 0 hr. 24 min. 27 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File       /u01/app/oracle/diag/tnslsnr/localhost/lsn2/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.5)(PORT=1522)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

但是我在windows下面sqlplus，
sqllus sys/password @orcl2 as sysdba

报错：ORA-12560 TNS adapter error

如果我先在虚拟机中把数据库起来，然后等动态注册成功后，可以远程登录，但是不起数据库，用静态注册就是远程不进去。

下面贴出我windows 客户端的tnsnames.ora:

ORCL =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
)
(CONNECT_DATA =
   (SERVICE_NAME = orcl)
)
  )

ORCL2 =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
)
(CONNECT_DATA =
   (SERVICE_NAME = orcl)
)
  )

不知道为什么不能通过静态注册远程连接？？请教高手

作者: www_xylove 时间: 2014-08-23 20:48
tnsping orcl

作者: znn19850323 时间: 2014-08-24 20:27
我宿主机（windows7）上装的是oracle client，没有tnsping命令，再说我linstener动态注册成功后可以 sqlplus sys/password@orcl , 应该不是service_name的事儿吧？

作者: znn19850323 时间: 2014-08-24 20:30
回复 2# www_xylove

静态注册成功后，

sqlplus sys/password @orcl2 as sysdba 就上上不去，一直抱listener错误，等动态注册成功后， sqlplus sys/password @orcl as sysdba 才可以远程，

我想远程启动数据库啊！为什么不可以？

作者: www_xylove 时间: 2014-08-24 21:25
设定ORACLE_SID试试看

作者: znn19850323 时间: 2014-09-02 10:57
回复 5# www_xylove

还是不行

作者: dzminglong 时间: 2014-09-04 19:00
贴出来你的listener.ora看看

作者: Tonylion888 时间: 2014-09-11 17:20
orcl2是哪来的

sqlplus sys/password@ip/orcl as sysdba

作者: znn19850323 时间: 2014-09-27 21:58
回复 8# Tonylion888

ORCL2 是我手动添加在windows 客户端的tnsnames.ora里的，

下面贴出我windows 客户端的tnsnames.ora:

ORCL =
(DESCRIPTION =
   (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
   )
   (CONNECT_DATA =
   (SERVICE_NAME = orcl)
   )
)

ORCL2 =
(DESCRIPTION =
   (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
   )
   (CONNECT_DATA =
   (SERVICE_NAME = orcl)
   )
)

作者: aric 时间: 2014-09-29 10:23
本帖最后由 aric 于 2014-09-29 10:24 编辑

静态注册成功后， sqlplus sys/password @orcl2 as sysdba 就上上不去，一直抱listener错误，
等动态注册成功后， sqlplus sys/password @orcl as sysdba 才可以远程，
这2个怎么不一样？7楼不是说贴出来listener.ora看看吗？

作者: znn19850323 时间: 2014-10-12 21:34
回复 10# aric

  下面是我linux 服务器上的listener.ora:

[oracle@localhost admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LSN2 =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
)
  )

SID_LIST_LSN2 =
(SID_LIST =
(SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = orcl)
   )
)

ADR_BASE_LISTENER = /u01/app/oracle

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)