Oracle 监听的默认端口是1521，这个端口我们可以进行修改。http://www.cndba.cn/dave/article/2744http://www.cndba.cn/dave/article/2744

Oracle 监听的配置文件是：listener.ora

[dave@Dave admin]$ pwd
/u02/app/oracle/product/11.2.0/db_1/network/admin
[dave@Dave admin]$ ls
listener.ora  samples  shrept.lst  sqlnet.ora  tnsnames.ora
[dave@Dave admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u02/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.2)(PORT = 1522))
    )
  )

ADR_BASE_LISTENER = /u02/app/oracle

但如果我们只修改这个配置文件，那么监听后的监听无法正常使用，连接时会报如下错误:http://www.cndba.cn/dave/article/2744

C:/Users/Dave>sqlplus system/oracle@dave_562

SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 22 11:52:03 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

所以要想修改默认的监听端口，除了修改监听的配置文件外，还需要需改LOCAL_LISTENER 参数。

因为 Oracle实例动态注册动作是在1521端口的监听程序上进行的，其他端口不会自动进行动态注册，需要通过修改LOCAL_LISTENER参数来实现非默认端口的动态注册。默认情况下，该参数为空。

将listener.ora中监听配置的内容复制一份到tnsnames.ora文件：

[dave@Dave admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u02/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.2)(PORT = 1522))
    )
  )

ADR_BASE_LISTENER = /u02/app/oracle

[dave@Dave admin]$ cat tnsnames.ora 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.2)(PORT = 1522))
    )
  )
[dave@Dave admin]$

修改参数：

SQL> alter system set local_listener=listener;
System altered.
SQL> set lines 120
SQL> show parameter local_listener

NAME                     TYPE            VALUE
------------------------------------ ---------------------- ------------------------------
local_listener                 string            LISTENER
SQL>

配置后在客户端就可以使用非默认端口进行连接了：http://www.cndba.cn/dave/article/2744

C:/Users/Dave>sqlplus system/oracle@dave_562

SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 22 12:06:09 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

版权声明：本文为博主原创文章，未经博主允许不得转载。