windows命令连接linux oracle网络原理及配置教程(27)

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener2.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redhat4)(PORT=1522)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "jiagulun" has 1 instance(s).

Instance "jiagulun", status READY, has 1 handler(s) for this service...

Service "jiagulun2" has 1 instance(s).

Instance "jiagulun2", status UNKNOWN, has 1 handler(s) for this service...

Service "jiagulunXDB" has 1 instance(s).

Instance "jiagulun", status READY, has 1 handler(s) for this service...

Service "jiagulun_XPT" has 1 instance(s).

Instance "jiagulun", status READY, has 1 handler(s) for this service...

The command completed successfully

如果这时再把1522端口的从listener.ora文件中去掉

就是listener.ora文件中也没有了1522端口的定义

而local_listener参数指定在1522端口

sqlplus hr/hr@192.168.3.47:1521/jiagulun

连不通

但可以ping通

[oracle@redhat4 ~]$ tnsping 192.168.3.47:1521/jiagulun

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 28-JAN-2018 09:03:32

Used parameter files:

Used HOSTNAME adapter to resolve the alias

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=jiagulun))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.47)(PORT=1521)))

OK (0 msec)

并且有状态

[oracle@redhat4 ~]$ lsnrctl status listener

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/ruanjian/article-71958-27.html