Oracle 11g 修改监听端口

最新推荐文章于 2023-05-20 19:27:24 发布

weixin_30787531

最新推荐文章于 2023-05-20 19:27:24 发布

阅读量155

点赞数

文章标签：数据库网络

原文链接：http://www.cnblogs.com/staryea/p/8919073.html

版权

修改LOCAL_LISTENER参数
SQL> show parameter listen

NAME                     TYPE            VALUE
------------------------------------ ---------------------- ------------------------------
listener_networks             string
local_listener                 string            (ADDRESS=(PROTOCOL=TCP)(HOST=l
                                ocalhost)(PORT=1521))
remote_listener              string

SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT= 1522))';

System altered.

SQL> show parameter local_l

NAME                     TYPE            VALUE
------------------------------------ ---------------------- ------------------------------
local_listener                 string            (ADDRESS=(PROTOCOL=TCP)(HOST=l
                                ocalhost)(PORT=1522))

修改监听文件中的端口
[oracle@localhost admin]$ lsnrctl stop
[oracle@localhost admin]$ vi listener.ora
LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
)

ADR_BASE_LISTENER = /u01/app/oracle
[oracle@localhost admin]$ lsnrctl start

转载于:https://www.cnblogs.com/staryea/p/8919073.html