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

With the Partitioning, OLAP and Data Mining options

SQL>

证明1521端口的是存在的

就是在1521端口默认自动建立的总是存在并接受动态注册信息

b)当local_listener指定了值时

如指定了1522端口

SQL> alter system set LOCAL_LISTENER=(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.47)(PORT = 1522));

System altered.

为了试验

先设置这时在listener.ora文件中没有1521端口的定义

并先设置名为listener2的使用1522端口

执行命令

[oracle@redhat4 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-JAN-2018 08:56:03

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 25-JAN-2018 10:41:57

Uptime 2 days 22 hr. 14 min. 5 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /etc/listener.ora

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

Listening Endpoints Summary...

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

The listener supports no services

The command completed successfully

发现端口号为1521的默认仍然是已经建立了

只是这时它没有接受动态注册信息

而接受动态注册信息的是listener2

[oracle@redhat4 ~]$ lsnrctl status listener2

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-JAN-2018 08:57:36

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=redhat4)(PORT=1522)))

STATUS of the LISTENER

------------------------

Alias listener2

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 23-JAN-2018 10:42:44

Uptime 4 days 22 hr. 14 min. 52 sec

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