客户端如何配置监听?我想在客户端里用SQLPLUS,服务器的监听正常,就是客户端的监听无法监听到实例,服务器的
客户端如何配置监听?
我想在客户端里用SQLPLUS,服务器的监听正常,就是客户端的监听无法监听到实例,
服务器的监听配置:
SQL code# listener.oraSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = YONGDB.yongyy.com) (SID_NAME = YONGDB) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST =yongyy.com)(PORT = 1521)) ) )ADR_BASE_LISTENER = /yongyy/u01/app/oracle#------------------------------------------tnsnames.oraYONGDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = yongyy.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = YONGDB.yongyy.com) ) )#-------------------------------# sqlnet.oraNAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)ADR_BASE = /yongyy/u01/app/oracle-----------------------------------------------------客户端的配置:[color=#FF0000]listener.ora[/color]LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.24.128)(PORT = 1521)) --本来是 YONGYY-PC :是客户端的主机名 ) )ADR_BASE_LISTENER = D:\OracleYONGDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.24.128)(PORT = 1521)) -- 服务器的IP (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = YONGDB) ) )[color=#FF0000]sqlnet.ora[/color]SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)[color=#FF0000]tnsnames[/color]YONGDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.24.128)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = YONGDB) ) )
相关参数:
------服务器参数---------------------
ORACLE_SID=YONGDB
全局SID : YONGDB.yongyy.com
192.168.24.128 yongyy.com yongyy # Added by NetworkManager
127.0.0.1 localhost.localdomain localhost
::1 yongyy.com yongyy localhost6.localdomain6 localhost6
说明:
防火墙神马的关了;sqldeveloper可以轻松连接,因为sqldeveloper太占内存了,所以换其他的
报错信息:
-------客户端-----------
使用命令:
>lsnrctl stop 或者 lsnrctl start 或者 lsnrctl status 都报下面的错误
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=yongyy.com)(PORT=1521)))
TNS-01189: 监听程序无法验证用户
>tnsping yongyy.com
已使用的参数文件:
D:\Oracle\product\11.2.0\client_1\network\admin\sqlnet.ora
已使用 EZCONNECT 适配器来解析别名
尝试连接 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOS
=192.168.24.128)(PORT=1521)))
OK (20 毫秒)
--------------------------------------------
>sqlplus yong/yong@yongyy.com:1521
ERROR:
ORA-12504: TNS: 监听程序在 CONNECT_DATA 中未获得 SERVICE_NAME
在服务器上:
如果我把: listener.ora
HOST=yongyy.com 改成 192.168.24.128 或者 localhost
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.24.128)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
$ping yongyy.com
64 bytes from yongyy.com (192.168.24.128): icmp_seq=1 ttl=64 time=0.371 ms
为什么客户端的监听无法监听到服务器的实例?
[解决办法]#------------------------------------------
tnsnames.ora
YONGDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = yongyy.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = YONGDB.yongyy.com)
)
)
#-------------------------------
这个应该在客户端配置 HOST改为你服务器的IP
[解决办法]将tnsname.ora中的host改成ip地址，SERVER写到是服务器的实例名，使用netmgr可以手动创建一个
