oracle rac 通信端口,ORACLE 修改11.2.0.4 RAC 默认监听端口号1521为1621

目的:修改ORACLE 11.2.0.4 RAC 默认监听端口号1521为1621

操作系统:

节点1:

[root@rac1 ~]# uname -a

Linux rac1 2.6.32-642.el6.x86_64 #1 SMP Wed Apr 13 00:51:26 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux

[root@rac1 ~]# cat /etc/redhat-release

Red Hat Enterprise Linux Server release 6.8 (Santiago)

节点2:

[root@rac2 ~]# uname -a

Linux rac2 2.6.32-642.el6.x86_64 #1 SMP Wed Apr 13 00:51:26 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux

[root@rac2 ~]# cat /etc/redhat-release

Red Hat Enterprise Linux Server release 6.8 (Santiago)

数据库:

[root@rac1 ~]# su - oracle

[oracle@rac1 ~]$ sqlplus -v

SQL*Plus: Release 11.2.0.4.0 Production

[oracle@rac1 ~]$

操作前检查:

[grid@rac1 ~]$ crs_stat -t

Name           Type           Target    State     Host

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

ora.ARCHDG.dg  ora....up.type ONLINE    ONLINE    rac1

ora.CRSDG.dg   ora....up.type ONLINE    ONLINE    rac1

ora.DATADG.dg  ora....up.type ONLINE    ONLINE    rac1

ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1

ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac2

ora....N2.lsnr ora....er.type ONLINE    ONLINE    rac2

ora.asm        ora.asm.type   ONLINE    ONLINE    rac1

ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac2

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE

ora....network ora....rk.type ONLINE    ONLINE    rac1

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac1

ora.ons        ora.ons.type   ONLINE    ONLINE    rac1

ora.orcl.db    ora....se.type ONLINE    ONLINE    rac1

ora....SM1.asm application    ONLINE    ONLINE    rac1

ora....C1.lsnr application    ONLINE    ONLINE    rac1

ora.rac1.gsd   application    OFFLINE   OFFLINE

ora.rac1.ons   application    ONLINE    ONLINE    rac1

ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1

ora....SM2.asm application    ONLINE    ONLINE    rac2

ora....C2.lsnr application    ONLINE    ONLINE    rac2

ora.rac2.gsd   application    OFFLINE   OFFLINE

ora.rac2.ons   application    ONLINE    ONLINE    rac2

ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2

ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac2

ora.scan2.vip  ora....ip.type ONLINE    ONLINE    rac2

[grid@rac1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2016 10:59:29

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                14-SEP-2016 10:53:26

Uptime                    0 days 0 hr. 6 min. 3 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/oracle/app/grid/home/network/admin/listener.ora

Listener Log File         /u01/oracle/app/grid/base/diag/tnslsnr/rac1/listener/alert/log.xml

Listening Endpoints Summary...

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

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

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

Services Summary...

Service "+ASM" has 1 instance(s).

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

Service "orcl" has 1 instance(s).

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

Service "orclXDB" has 1 instance(s).

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

The command completed successfully

[grid@rac1 ~]$

[root@rac1 ~]# su - oracle

[oracle@rac1 ~]$ sqlplus zhul/zhul@orcl

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 14 11:00:25 2016

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, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL>

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

1、修改listener、scan_listener的ip端口号

[grid@rac1 ~]$ lsnrctl status LISTENER

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2016 11:04:47

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                14-SEP-2016 10:53:26

Uptime                    0 days 0 hr. 11 min. 20 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/oracle/app/grid/home/network/admin/listener.ora

Listener Log File         /u01/oracle/app/grid/base/diag/tnslsnr/rac1/listener/alert/log.xml

Listening Endpoints Summary...

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

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

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

Services Summary...

Service "+ASM" has 1 instance(s).

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

Service "orcl" has 1 instance(s).

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

Service "orclXDB" has 1 instance(s).

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

The command completed successfully

停止scan监听

[grid@rac1 ~]$ srvctl stop LISTENER

[grid@rac1 ~]$ lsnrctl status LISTENER

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2016 11:06:16

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 2: No such file or directory

[grid@rac1 ~]$

修改scan监听的端口号1521为1621,修改后需要oracle用户修改集群数据库的远程和本地监听端口号注册服务

[grid@rac1 ~]$ srvctl modify listener -p 1621

[grid@rac1 ~]$ srvctl modify scan_listener -p 1621

[grid@rac1 ~]$ srvctl start listener

[grid@rac1 ~]$ lsnrctl status LISTENER

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2016 11:09:43

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                14-SEP-2016 11:09:37

Uptime                    0 days 0 hr. 0 min. 6 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/oracle/app/grid/home/network/admin/listener.ora

Listener Log File         /u01/oracle/app/grid/base/diag/tnslsnr/rac1/listener/alert/log.xml

Listening Endpoints Summary...

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=20.20.20.24)(PORT=1621)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=20.20.20.25)(PORT=1621)))

The listener supports no services

The command completed successfully

[grid@rac1 ~]$

oracle用户修改集群数据库的远程和本地监听端口号

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 14 11:11:20 2016

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, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> show parameter remote_listener

NAME     TYPE VALUE

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

remote_listener     string racscan:1521

SQL> alter system set remote_listener='racscan:1621';

System altered.

SQL> show parameter remote_listener

NAME     TYPE VALUE

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

remote_listener     string racscan:1621

SQL>

SQL> show parameter local_listener

NAME     TYPE VALUE

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

local_listener     string  (ADDRESS=(PROTOCOL=TCP)(HOST=

20.20.20.25)(PORT=1521))

SQL> alter  system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=20.20.20.25)(PORT=1621))))' sid='orcl1';

SQL> show parameter local_listener

NAME     TYPE VALUE

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

local_listener     string (DESCRIPTION=(ADDRESS_LIST=(AD

DRESS=(PROTOCOL=TCP)(HOST=20.2

0.20.25)(PORT=1621))))

修改节点2本地监听端口

SQL> show parameter local_listener

NAME     TYPE VALUE

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

local_listener     string  (ADDRESS=(PROTOCOL=TCP)(HOST= 20.20.20.28)(PORT=1521))

SQL> alter  system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=20.20.20.28)(PORT=1621))))' sid='orcl2';

System altered.

SQL> show parameter local_listener

NAME     TYPE VALUE

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

local_listener     string (DESCRIPTION=(ADDRESS_LIST=(AD

DRESS=(PROTOCOL=TCP)(HOST=20.2

0.20.28)(PORT=1621))))

修改2个节点的tnsnames.ora

节点1

[oracle@rac1 admin]$ ls

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = racscan)(PORT = 1621))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

节点2

[oracle@rac2 admin]$ cat tnsnames.ora

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = racscan)(PORT = 1621))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

2个节点使用root关闭集群,否则使用grid检查监听时会看不到ASM服务状态

[grid@rac1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2016 12:40:07

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                14-SEP-2016 12:26:27

Uptime                    0 days 0 hr. 13 min. 40 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/oracle/app/grid/home/network/admin/listener.ora

Listener Log File         /u01/oracle/app/grid/base/diag/tnslsnr/rac1/listener/alert/log.xml

Listening Endpoints Summary...

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=20.20.20.24)(PORT=1621)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=20.20.20.25)(PORT=1621)))

Services Summary...

Service "orcl" has 1 instance(s).

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

Service "orclXDB" has 1 instance(s).

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

The command completed successfully

root用户关闭2个节点的集群

节点1

[root@rac1 bin]# pwd

/u01/oracle/app/grid/home/bin

[root@rac1 bin]# ./crsctl stop crs

节点2

[root@rac2 bin]# pwd

/u01/oracle/app/grid/home/bin

[root@rac2 bin]# ./crsctl stop crs

2个节点重启服务器

root执行reboot

重启完成后检查端口号修改结果及测试TNS

[grid@rac1 ~]$ crs_stat -t

Name           Type           Target    State     Host

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

ora.ARCHDG.dg  ora....up.type ONLINE    ONLINE    rac1

ora.CRSDG.dg   ora....up.type ONLINE    ONLINE    rac1

ora.DATADG.dg  ora....up.type ONLINE    ONLINE    rac1

ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1

ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac2

ora....N2.lsnr ora....er.type ONLINE    ONLINE    rac2

ora.asm        ora.asm.type   ONLINE    ONLINE    rac1

ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac1

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE

ora....network ora....rk.type ONLINE    ONLINE    rac1

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac1

ora.ons        ora.ons.type   ONLINE    ONLINE    rac1

ora.orcl.db    ora....se.type ONLINE    ONLINE    rac1

ora....SM1.asm application    ONLINE    ONLINE    rac1

ora....C1.lsnr application    ONLINE    ONLINE    rac1

ora.rac1.gsd   application    OFFLINE   OFFLINE

ora.rac1.ons   application    ONLINE    ONLINE    rac1

ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1

ora....SM2.asm application    ONLINE    ONLINE    rac2

ora....C2.lsnr application    ONLINE    ONLINE    rac2

ora.rac2.gsd   application    OFFLINE   OFFLINE

ora.rac2.ons   application    ONLINE    ONLINE    rac2

ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2

ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac2

ora.scan2.vip  ora....ip.type ONLINE    ONLINE    rac2

[grid@rac1 ~]$

[grid@rac1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2016 12:41:43

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                14-SEP-2016 12:26:27

Uptime                    0 days 0 hr. 15 min. 15 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/oracle/app/grid/home/network/admin/listener.ora

Listener Log File         /u01/oracle/app/grid/base/diag/tnslsnr/rac1/listener/alert/log.xml

Listening Endpoints Summary...

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=20.20.20.24)(PORT=1621)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=20.20.20.25)(PORT=1621)))

Services Summary...

Service "+ASM" has 1 instance(s).

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

Service "orcl" has 1 instance(s).

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

Service "orclXDB" has 1 instance(s).

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

The command completed successfully

[grid@rac1 ~]$

[root@rac1 ~]# su - oracle

[oracle@rac1 ~]$ tnsping orcl

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2016 12:42:45

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

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = racscan)(PORT = 1621)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))

OK (10 msec)

[oracle@rac1 ~]$ sqlplus zhul/zhul@orcl

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 14 12:42:09 2016

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, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

[oracle@rac1 ~]$

oracle用户下检查监听不能使用默认方式lsnrctl status,只能使用lsnrctl status orcl(global_dbname)

[oracle@rac1 ~]$ lsnrctl status orcl

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2016 12:52:13

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=racscan)(PORT=1621))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))

STATUS of the LISTENER

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

Alias                     LISTENER_SCAN1

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                14-SEP-2016 12:49:39

Uptime                    0 days 0 hr. 2 min. 33 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/oracle/app/grid/home/network/admin/listener.ora

Listener Log File         /u01/oracle/app/grid/home/log/diag/tnslsnr/rac1/listener_scan1/alert/log.xml

Listening Endpoints Summary...

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=20.20.20.26)(PORT=1621)))

Services Summary...

Service "orcl" has 2 instance(s).

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

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

Service "orclXDB" has 2 instance(s).

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

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

The command completed successfully

[oracle@rac1 ~]$

如果在oracle用户下使用默认监听查看方式lsnrctl status,会遇到如下报错!

[oracle@rac2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2016 12:14:59

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

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

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

如果集群没有重启(我重启了集群和服务器),可能会遇到如下异常,虽然监听相关所有的端口号都已更改,但是oracle下原来的tns不能使用了

[oracle@rac2 admin]$ sqlplus zhul/zhul@orcl

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 14 12:17:28 2016

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

ERROR:

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

descriptor

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29357786/viewspace-2125582/,如需转载,请注明出处,否则将追究法律责任。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值