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

最新推荐文章于 2021-04-12 20:40:10 发布
最新推荐文章于 2021-04-12 20:40:10 发布
阅读量506 收藏
点赞数
文章标签： oracle rac 通信端口

目的：修改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/，如需转载，请注明出处，否则将追究法律责任。

weixin_39740272
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle Database 11.2.0.4 服务端和客户端
04-02
经典版本11.2.0.4，包含Windows和Linux系统内32位和64位服务端、客户端、RAC、图形化卸载等工具。
oracle v-11.2.0.4.0 Oracle 11.2.0.4 For Windows 64bit+32bit 数据库
08-04
3为grid infrastructure，用来升级RAC。如果要使用Clusterware、ASM、ACFS、ASM动态卷等功能时都需要先安装此包 4表示客户端（Client）； 5为Gateway software，gateways是指透明网关，如果要从oracle访问其它数据库...
Oracle rac 监听状态异常远程连接问题解决（TNS-12541 TNS-12560 TNS-00511 Linux Error：111 ORA-12502）...
weixin_34041003的博客
04-02 1475
问题1现象 数据导出脚本执行失败，报错如下 ORA-12537 到服务器上查看，报错： [oracle@test ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 02-APR-2019 11:17:10 Copyright (c) 1991, 2013, Oracle...
rac 配置oracle互信,Oracle19C RAC 用户互信问题处理
weixin_31526891的博客
04-12 1584
亲爱滴伙伴们,我们又见面了。今天我们继续讲讲Linux7平台Oracle19C RAC安装那些事儿。事情是这样的，一“入坑”不久的哥们在安装GI的时候，到了互信配置这一步死活过不去。当时第一反应是怀疑这哥们是不是哪里姿势错了。接手后发现不管是使用界面配置互信，还是手动配置，显示成功后，点击next报错，错误信息显示两个节点互信配置失败。注意：这里说的互信配置成功指的是手动输入命令验证确认成功的。到...
oracle rac 通信端口,Oracle RAC 下非缺省端口监听配置(listener.ora tnsnames.ora)
weixin_36118049的博客
04-04 232
oracle@bo2dbp:~>ps-ef|greplsnroracle210971017:40?00:00:00/u01/oracle/db/bin/tnslsnrLISTENER_BO2DBP-inheritoracle262281017:58?00:00:00/u01/oracle/db/bin/tnslsnrLISTENER_NEW_BO2DBP-inheritor...
RAC 安装完成后 节点间通信不依赖于SSH
bantaoti1130的博客
12-23 209
RAC 安装完成后，想修改ssh 的端口。google了一下。原文https://community.oracle.com/thread/2444594?tstart=0 原文说的是11g,10g也好使。 修改ssh 端口， cat /etc/ssh/sshd_config Port 2222 service sshd restart; 当然先前建立的...
常见数据库常用端口
fzhqcjc的博客
01-09 650
Oracle 端口范围 1521~1621 Mssql 端口范围 1433~1533 Mysql 端口范围 3306~3406 Sybase 端口范围 4100-5000 -------------------------------oracle-------------------------------- 驱动：oracle.jdbc.dr...
tcp.validnode_checking踩过的坑
Data & Analysis
02-20 1705
对Oracle 检查ip合法性,就必须在服务器端的sqlnet.ora文件中设置如下参数 01 02 TCP.INVITED_NODES=(10.0.0.36,10.0.0.1,10.0.0.35) TCP.EXCLUDED_NODES=(10.0.0.2) 启动监听出现如下错误 01 02 03 ...
RAC环境TNS-12541报错处理
weixin_34262482的博客
08-26 230
按照前文所述搭建好RAC环境后，发现在rac2上面无法查看到listener的状态，如下：[oracle@rac2 ~]$ lsnrctl statusLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-FEB-2011 20:35:41Copyright (c) 1991, 2005, Oracle.  All rights rese...
查找oracle11g的端口,oracle11g rac 非缺省端口在Oracle用户下无法查看状态
weixin_31861055的博客
04-03 193
今天在Oracle11gr2 rac 中修改了端口号，将1521修改为11521，修改完成后访问正常， 但发现在oracle用户下通过命令lsnrctl stat无法查看了[oracle@rac01 ~]$ lsnrctl statLSNRCTL for Linux: Version 11.2.0.4.0 - Production on 05-AUG-2015 17:33:43Copyright ...
oracle11.2.0.4_linux-x86-64位全套安装包
08-01
包含oracle11.2.0.4_x86-64位linux版本全套安装包： p13390677_112040_Linux-x86-64_1of7.zip p13390677_112040_Linux-x86-64_2of7.zip p13390677_112040_Linux-x86-64_3of7.zip p13390677_112040_Linux-x86-64_4of7...
rhel6.3安装ORACLE 11.2.0.4 RAC图文教程
02-14
非常详细的oracle rac教程 目录 1、安装环境 2 2、安装前系统配置 2 2.1存储规划 2 2.2 ip地址规划 2 2.3创建用户、组(所有节点) 3 2.4配置各节点环境变量 3 2.5关闭所有节点防火墙 4 2.6配置NTP服务(所有...
oracle11.2.0.4数据库安装包百度网盘下载.txt
07-26
oracle11g最终版本11.2.0.4的全套资源，包括RAC集群和管理工具共7个文件 资源说明（按需下载）： p102025301120——Linux-x86-64_1of7.zip database安装介质 p102025301120——Linux-x86-64_2of7.zip database安装...
oracle12541无监听没有服务,ORA-12541:TNS:无监听程序问题
weixin_34377037的博客
04-03 979
装好oracle后，在linux服务器上面可以连接oracle数据库，但是在我的电脑window上面连接不上，提示ORA-12541:TNS:无监听1、切换成oracle用户，执行：lsnrctl status看到一下信息：看到了以下赤裸裸的信息TNS-12541: TNS:no listenerTNS-12560: TNS:protocol adapter errorTNS-00511: No ...
oracle6i xp无法安装,11g installation on win xp sp3, on oracle 10g
weixin_34431256的博客
04-05 302
Content of the Listener.ora file... and I have checked the services... their is a listener file for 9i and 10g but no listener file for 11g...are your sure there is no listener file in 11g home?# list...
oracle数据库监听频道异常,数据库监听不定期出现异常故障处理
weixin_39785286的博客
04-06 460
故障现象：数据库监听不定期出现异常,从应用tnsping数据库，时间花费很长甚至连不上故障分析处理过程：从应用主机tnsping如下：racdb1_scenemon$tnsping racdb_newTNS Ping Utility for Solaris: Version11.2.0.3.0 - Production on 19-2月-2014 15:46:23Copyright (c) 199...
手动更改oracle监听,【Oracle】修改oracle监听端口
weixin_39820244的博客
04-02 277
修改oracle 监听端口号，过程相对比较简单：1 修改 listener.ora ,tnsnames.ora 文件中的端口号2 重启监听 lsnrctl stop ，lsnrctl start上面的过程是对于 监听名为默认的LISTENER 而言的，如果listener.oar文件中的监听名不是默认的，就重启时必须指定监听名。比如将端口号由1521改为1523oracle@rac3:/opt/o...
【Oracle】ORACLE RAC修改监听端口
Tinko123的博客
01-17 1512
ORACLE RAC修改监听端口/修改端口 从1521修改成1526 1、停应用 2、检查当前健康状态 su - grid crsctl status res -t 3、查看端口 su - grid srvctl config listener srvctl config scan_listener 4、修改端口 su - grid srvctl modify listener -l LISTEN...
(2024)跳槽涨薪必备精选面试题.pdf
最新发布
06-29
(2024)跳槽涨薪必备精选面试题.pdf (2024)跳槽涨薪必备精选面试题.pdf (2024)跳槽涨薪必备精选面试题.pdf (2024)跳槽涨薪必备精选面试题.pdf (2024)跳槽涨薪必备精选面试题.pdf
Oracle Linux6.1 +Oracle11.2.0.1RAC+RAW安装文档
09-07
"Oracle Linux6.1 +Oracle11.2.0.1RAC+RAW安装文档" 在本文档中，我们将深入探讨如何在Oracle Linux 6.1环境下安装Oracle 11.2.0.1 Real Application Clusters (RAC)以及使用RAW设备作为存储。RAC是一种高可用性...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值