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

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-JAN-2018 09:04:41

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. 22 min. 44 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

而在1522端口

[oracle@redhat4 ~]$ sqlplus hr/hr@192.168.3.47:1522/jiagulun

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jan 28 09:02:50 2018

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL>

是可以连通的

说明

这时local_listener指定在了1522端口

而且listener.ora文件中没有1521和1522端口的定义

这时oracle

仍会自动建立一个1521的默认但这时不接受动态注册

而且还会在1522端口自动建一个并用来接受动态注册

5)local_listener参数的修改

实例中的local_listener参数用来指定实例把它的信息动态注册到哪个中

在修改local_listener参数时有两种方法

一种直接把字符串给它

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

另一种方法

先在tnsname.ora文件中设置了一个网络服务名

如：

listener_in =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.47)(PORT = 1522))

)

(CONNECT_DATA =

(SERVICE_NAME = jiagulun)

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