首页 > 资讯 > 数据库 >oracle11g rac 修改主机IP地址

433

分享到

oracle11g rac 修改主机IP地址

2024-04-02 19:04:59 433人浏览泡泡鱼

摘要

1 背景应xx总行要求，对xx分行现有DMZ网络进行改造，此网段所有IP地址都要变更新的IP地址，涉及数据库oracle 11g rac，以下是详细测试环境操作步骤参考！操作系统：sles01:

1 背景

应xx总行要求，对xx分行现有DMZ网络进行改造，此网段所有IP地址都要变更新的IP地址，涉及数据库oracle 11g rac，以下是详细测试环境操作步骤参考！

操作系统：

sles01:/u01/grid/11.2.0/bin # cat /etc/issue

Welcome to SUSE linux Enterprise Server 11 SP4 (x86_64) - Kernel \r (\l).

sles01:/u01/grid/11.2.0/bin # uname -a

Linux sles01 3.0.101-63-default #1 SMP Tue Jun 23 16:02:31 UTC 2015 (4b89d0c) x86_64 x86_64 x86_64 GNU/Linux

2 系统环境检查

sles01:~ # cat /etc/hosts

#public

192.168.99.1 sles01

192.168.99.2 sles02

#private

10.0.0.1 sles01-priv

10.0.0.2 sles02-priv

#virtual

192.168.99.11 sles01-vip

192.168.99.12 sles02-vip

#scan

192.168.99.13 tfrapp-scan

3 停止oracle集群服务

3.1 停止数据库服务

grid@sles02:~> srvctl stop database -d tfrapp -o immediate //两个节点反复检查一下

3.2 停止各节点asm卷组服务

crsctl stat res -t 列出的卷组

grid@sles02:~> crsctl stat res -t

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

NAME TARGET STATE SERVER STATE_DETaiLS

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

Local Resources

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

ora.DATAVG01.dg

OFFLINE OFFLINE sles01

OFFLINE OFFLINE sles02

ora.DATAVG02.dg

OFFLINE OFFLINE sles01

OFFLINE OFFLINE sles02

ora.LISTENER.lsnr

ONLINE ONLINE sles01

ONLINE ONLINE sles02

ora.asm

ONLINE ONLINE sles01 Started

ONLINE ONLINE sles02 Started

ora.gsd

OFFLINE OFFLINE sles01

OFFLINE OFFLINE sles02

ora.net1.network

ONLINE ONLINE sles01

ONLINE ONLINE sles02

ora.ons

ONLINE ONLINE sles01

ONLINE ONLINE sles02

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE sles01

ora.cvu

1 ONLINE ONLINE sles01

ora.oc4j

1 ONLINE ONLINE sles02

ora.scan1.vip

1 ONLINE ONLINE sles01

ora.sles01.vip

1 ONLINE ONLINE sles01

ora.sles02.vip

1 ONLINE ONLINE sles02

ora.tfrapp.db

1 OFFLINE OFFLINE Instance Shutdown

2 OFFLINE OFFLINE Instance Shutdown

grid@sles02:~> crs_stop ora.DATAVG01.dg

Attempting to stop `ora.DATAVG01.dg` on member `sles01`

Attempting to stop `ora.DATAVG01.dg` on member `sles02`

Stop of `ora.DATAVG01.dg` on member `sles01` succeeded.

Stop of `ora.DATAVG01.dg` on member `sles02` succeeded.

grid@sles02:~> crs_stop ora.DATAVG02.dg

Attempting to stop `ora.DATAVG02.dg` on member `sles01`

Attempting to stop `ora.DATAVG02.dg` on member `sles02`

Stop of `ora.DATAVG02.dg` on member `sles01` succeeded.

Stop of `ora.DATAVG02.dg` on member `sles02` succeeded.

3.3 停止各节点asm服务

grid@sles01:~> srvctl stop asm -n sles01

grid@sles02:~> srvctl stop asm -n sles02

3.4 停止各节点应用服务（虚拟IP、GSD、TNS 监听器和 ONS）

grid@sles01:~> srvctl stop nodeapps -n sles01 //多次实验后，本人觉得这个步骤是忽略的

PRCR-1014 : Failed to stop resource ora.ons

PRCR-1065 : Failed to stop resource ora.ons

Cannot communicate with crsd

PRCR-1035 : Failed to look up CRS resource node01 for ora.cluster_vip.type

PRCR-1068 : Failed to query resources

Cannot communicate with crsd

PRCR-1070 : Failed to check if resource ora.net1.network is reGIStered

Cannot communicate with crsd

grid@sles02:~> srvctl stop nodeapps -n sles02 //同上

3.5 停止各节点crs服务

为了不必要的错误产生，这里是强制执行停止服务

sles01:/u01/grid/11.2.0/bin #./crsctl stop crs -f

sles02:/u01/grid/11.2.0/bin #./crsctl stop crs -f

4 修改两台主机IP地址信息

节点一

sles01:~ # cat /etc/hosts

#public

192.168.88.1 sles01

192.168.88.2 sles02

#private

10.0.0.1 sles01-priv

10.0.0.2 sles02-priv

#virtual

192.168.88.11 sles01-vip

192.168.88.12 sles02-vip

#scan

192.168.88.13 tfrapp-scan

重启网络服务

sles01:~ # sed -i 's/192.168.99/192.168.88/g' /etc/sysconfig/network/ifcfg-bond0

sles01:~ # service network restart

节点二

sles02:~ # cat /etc/hosts

#public

192.168.88.1 sles01

192.168.88.2 sles02

#private

10.0.0.1 sles01-priv

10.0.0.2 sles02-priv

#virtual

192.168.88.11 sles01-vip

192.168.88.12 sles02-vip

#scan

192.168.88.13 tfrapp-scan

重启网络服务

sles02:~ # sed -i 's/192.168.99/192.168.88/g' /etc/sysconfig/network/ifcfg-bond0

sles02:~ # service network restart

5 配置集群信息

5.1 启动两个节点的crs服务

sles01:/u01/grid/11.2.0/bin #./crsctl start crs

sles02:/u01/grid/11.2.0/bin #./crsctl start crs

5.2 节点sles01 修改群架vip网段

sles01:/u01/grid/11.2.0/bin # ./oifcfg getif

* 10.0.0.0 global cluster_interconnect

bond0 192.168.99.0 global public

Only in OCR: eth3 10.0.0.0 global cluster_interconnect

PRIF-29: Warning: wildcard in network parameters can cause mismatch among GPnP profile, OCR, and system

sles01:/u01/grid/11.2.0/bin # ./oifcfg delif -global bond0

sles01:/u01/grid/11.2.0/bin # ./oifcfg setif -global bond0/192.168.88.0:public

5.3 节点sles02 修改群架vip网段

sles02:/u01/grid/11.2.0/bin # ./oifcfg getif

* 10.0.0.0 global cluster_interconnect

bond0 192.168.99.0 global public

Only in OCR: eth3 10.0.0.0 global cluster_interconnect

PRIF-29: Warning: wildcard in network parameters can cause mismatch among GPnP profile, OCR, and system

sles02:/u01/grid/11.2.0/bin # ./oifcfg delif -global bond0

sles02:/u01/grid/11.2.0/bin # ./oifcfg setif -global bond0/192.168.88.0:public

5.4 调整私网连接，如果内部地址不变可以不用调整的，可以忽略此步骤操作

sles01:/u01/grid/11.2.0/bin # ./oifcfg delif -global eth3

sles01:/u01/grid/11.2.0/bin # ./oifcfg setif -global eth3/10.0.0.0:cluster_interconnect

sles02:/u01/grid/11.2.0/bin # ./oifcfg delif -global eth4

sles02:/u01/grid/11.2.0/bin # ./oifcfg setif -global eth4/10.0.0.0:cluster_interconnect

5.5 配置各个节点的vip地址

grid@sles01:~> srvctl config nodeapps -n sles01 -a

-n <node_name> option has been deprecated.

Network exists: 1/192.168.99.0/255.255.255.0/bond0, type static

VIP exists: /sles01-vip/192.168.88.11/192.168.99.0/255.255.255.0/bond0, hosting node sles01

grid@sles01:~> exit

sles01:~ # cd /u01/grid/11.2.0/bin/

sles01:/u01/grid/11.2.0/bin # ./srvctl modify nodeapps -n sles01 -A 192.168.88.11/255.255.255.0/bond0

sles01:/u01/grid/11.2.0/bin # ./srvctl modify nodeapps -n sles02 -A 192.168.88.12/255.255.255.0/bond0 //因为指定了节点，所以可以在一台机器上执行命令

到这时，就可以重启两个节点crs服务

sles01:/u01/grid/11.2.0/bin # ./crsctl stop crs -f

sles02:/u01/grid/11.2.0/bin # ./crsctl stop crs -f

sles01:/u01/grid/11.2.0/bin # ./crsctl start crs

sles02:/u01/grid/11.2.0/bin #./crsctl start crs

sles01:/u01/grid/11.2.0/bin # su - grid

grid@sles01:~> crs_stat -t -v

Name Type R/RA F/FT Target State Host

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

ora....VG01.dg ora....up.type 0/5 0/ ONLINE ONLINE sles01

ora....VG02.dg ora....up.type 0/5 0/ ONLINE ONLINE sles01

ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE sles01

ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE sles01

ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE sles01

ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE sles02

ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE

ora....network ora....rk.type 0/5 0/ ONLINE ONLINE sles01

ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE sles02

ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE sles01

ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE sles01

ora....SM1.asm application 0/5 0/0 ONLINE ONLINE sles01

ora....01.lsnr application 0/5 0/0 ONLINE ONLINE sles01

ora.sles01.gsd application 0/5 0/0 OFFLINE OFFLINE

ora.sles01.ons application 0/3 0/0 ONLINE ONLINE sles01

ora.sles01.vip ora....t1.type 0/0 0/0 ONLINE ONLINE sles01

ora....SM2.asm application 0/5 0/0 ONLINE ONLINE sles02

ora....02.lsnr application 0/5 0/0 ONLINE ONLINE sles02

ora.sles02.gsd application 0/5 0/0 OFFLINE OFFLINE

ora.sles02.ons application 0/3 0/0 ONLINE ONLINE sles02

ora.sles02.vip ora....t1.type 0/0 0/0 ONLINE ONLINE sles02

ora.tfrapp.db ora....se.type 0/2 0/1 OFFLINE OFFLINE

grid@sles01:~> ip a

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN

link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00

inet 127.0.0.1/8 brd 127.255.255.255 scope host lo

inet 127.0.0.2/8 brd 127.255.255.255 scope host secondary lo

2: eth0: <BROADCAST,MULTICAST,SLAVE,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000

link/ether 08:00:27:14:be:ff brd ff:ff:ff:ff:ff:ff

3: eth2: <BROADCAST,MULTICAST,SLAVE,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000

link/ether 08:00:27:14:be:ff brd ff:ff:ff:ff:ff:ff

4: eth3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000

link/ether 08:00:27:21:ca:79 brd ff:ff:ff:ff:ff:ff

inet 10.0.0.1/24 brd 10.0.0.255 scope global eth3

inet 169.254.40.214/16 brd 169.254.255.255 scope global eth3:1

6: bond0: <BROADCAST,MULTICAST,MASTER,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP

link/ether 08:00:27:14:be:ff brd ff:ff:ff:ff:ff:ff

inet 192.168.88.1/24 brd 192.168.88.255 scope global bond0

inet 192.168.99.13/24 brd 192.168.99.255 scope global bond0:1

inet 192.168.88.11/24 brd 192.168.88.255 scope global secondary bond0:3

6 修改scanip地址

发现scanip地址没有刷新过来

6.1 关闭scan服务及侦听

grid@sles01:~> srvctl stop scan_listener

grid@sles01:~> srvctl stop scan

sles01:/u01/grid/11.2.0/bin # ./srvctl config scan

SCAN name: tfrapp-scan, Network: 1/192.168.88.0/255.255.255.0/bond0

SCAN VIP name: scan1, IP: /tfrapp-scan/192.168.99.13

6.2 配置scan ip地址

从DNS解析中读取新地址，刷新IP地址，因为使用的是hosts列表，所以不一定能够成功，还需要手动配置。

sles01:/u01/grid/11.2.0/bin # ./srvctl modify scan -n scanip //scanip 指的是host里面对应scan-ip的名称（ tfrapp-scan）这个是刷新操作，如果可以刷新IP地址就不需要手动指定

PRCS-1016 : Failed to resolve Single Client Access Name scanip

sles01:/u01/grid/11.2.0/bin # ./srvctl config scan

SCAN name: tfrapp-scan, Network: 1/192.168.88.0/255.255.255.0/bond0

SCAN VIP name: scan1, IP: /tfrapp-scan/192.168.99.13

sles01:/u01/grid/11.2.0/bin # ./srvctl modify scan -n 192.168.88.13 //手动指定IP地址

sles01:/u01/grid/11.2.0/bin # ./srvctl config scan

SCAN name: 192.168.88.13, Network: 1/192.168.88.0/255.255.255.0/bond0

SCAN VIP name: scan1, IP: /192.168.88.13/192.168.88.13

6.3 启动scan服务及侦听

sles01:/u01/grid/11.2.0/bin # su - grid

grid@sles01:~> srvctl start scan

grid@sles01:~> srvctl start scan_listener

7 验证服务

节点一

grid@sles01:~> ip a

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN

link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00

inet 127.0.0.1/8 brd 127.255.255.255 scope host lo

inet 127.0.0.2/8 brd 127.255.255.255 scope host secondary lo

2: eth0: <BROADCAST,MULTICAST,SLAVE,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000

link/ether 08:00:27:14:be:ff brd ff:ff:ff:ff:ff:ff

3: eth2: <BROADCAST,MULTICAST,SLAVE,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast master bond0 state UP qlen 1000

link/ether 08:00:27:14:be:ff brd ff:ff:ff:ff:ff:ff

4: eth3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000

link/ether 08:00:27:21:ca:79 brd ff:ff:ff:ff:ff:ff

inet 10.0.0.1/24 brd 10.0.0.255 scope global eth3

inet 169.254.40.214/16 brd 169.254.255.255 scope global eth3:1

6: bond0: <BROADCAST,MULTICAST,MASTER,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP

link/ether 08:00:27:14:be:ff brd ff:ff:ff:ff:ff:ff

inet 192.168.88.1/24 brd 192.168.88.255 scope global bond0

inet 192.168.88.11/24 brd 192.168.88.255 scope global secondary bond0:3

inet 192.168.88.13/24 brd 192.168.88.255 scope global secondary bond0:1

grid@sles01:~> ping 192.168.88.12

PING 192.168.88.12 (192.168.88.12) 56(84) bytes of data.

64 bytes from 192.168.88.12: icmp_seq=1 ttl=64 time=12.4 ms

64 bytes from 192.168.88.12: icmp_seq=2 ttl=64 time=0.218 ms

64 bytes from 192.168.88.12: icmp_seq=3 ttl=64 time=0.695 ms

64 bytes from 192.168.88.12: icmp_seq=4 ttl=64 time=1.19 ms

64 bytes from 192.168.88.12: icmp_seq=5 ttl=64 time=0.658 ms

--- 192.168.88.12 ping statistics ---

5 packets transmitted, 5 received, 0% packet loss, time 4002ms

rtt min/avg/max/mdev = 0.218/3.045/12.462/4.718 ms

grid@sles01:~> ping 192.168.88.11

PING 192.168.88.11 (192.168.88.11) 56(84) bytes of data.

64 bytes from 192.168.88.11: icmp_seq=1 ttl=64 time=0.052 ms

64 bytes from 192.168.88.11: icmp_seq=2 ttl=64 time=0.023 ms

64 bytes from 192.168.88.11: icmp_seq=3 ttl=64 time=0.030 ms

64 bytes from 192.168.88.11: icmp_seq=4 ttl=64 time=0.067 ms

64 bytes from 192.168.88.11: icmp_seq=5 ttl=64 time=0.048 ms

--- 192.168.88.11 ping statistics ---

5 packets transmitted, 5 received, 0% packet loss, time 4001ms

rtt min/avg/max/mdev = 0.023/0.044/0.067/0.015 ms

grid@sles01:~> ping 192.168.88.13

PING 192.168.88.13 (192.168.88.13) 56(84) bytes of data.

64 bytes from 192.168.88.13: icmp_seq=1 ttl=64 time=0.025 ms

64 bytes from 192.168.88.13: icmp_seq=2 ttl=64 time=0.051 ms

64 bytes from 192.168.88.13: icmp_seq=3 ttl=64 time=0.026 ms

--- 192.168.88.13 ping statistics ---

3 packets transmitted, 3 received, 0% packet loss, time 1998ms

rtt min/avg/max/mdev = 0.025/0.034/0.051/0.012 ms

grid@sles01:~> crs_stat -t -v

Name Type R/RA F/FT Target State Host

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

ora....VG01.dg ora....up.type 0/5 0/ ONLINE ONLINE sles01

ora....VG02.dg ora....up.type 0/5 0/ ONLINE ONLINE sles01

ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE sles01

ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE sles01

ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE sles01

ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE sles02

ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE

ora....network ora....rk.type 0/5 0/ ONLINE ONLINE sles01

ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE sles02

ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE sles01

ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE sles01

ora....SM1.asm application 0/5 0/0 ONLINE ONLINE sles01

ora....01.lsnr application 0/5 0/0 ONLINE ONLINE sles01

ora.sles01.gsd application 0/5 0/0 OFFLINE OFFLINE

ora.sles01.ons application 0/3 0/0 ONLINE ONLINE sles01

ora.sles01.vip ora....t1.type 0/0 0/0 ONLINE ONLINE sles01

ora....SM2.asm application 0/5 0/0 ONLINE ONLINE sles02

ora....02.lsnr application 0/5 0/0 ONLINE ONLINE sles02

ora.sles02.gsd application 0/5 0/0 OFFLINE OFFLINE

ora.sles02.ons application 0/3 0/0 ONLINE ONLINE sles02

ora.sles02.vip ora....t1.type 0/0 0/0 ONLINE ONLINE sles02

ora.tfrapp.db ora....se.type 0/2 0/1 OFFLINE OFFLINE

grid@sles01:~> lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 30-AUG-2017 11:19:02

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 30-AUG-2017 11:04:04

Uptime 0 days 0 hr. 14 min. 57 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/grid/11.2.0/network/admin/listener.ora

Listener Log File /u01/app/diag/tnslsnr/sles01/listener/alert/log.xml

Listening Endpoints Summary...

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

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

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

Services Summary...

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

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

The command completed successfully

//这个时候是因为节点上的实例没有启动，所以侦听只是ASM，没有db信息。

启动各个节点实例

grid@sles01:~> srvctl start instance -d tfrapp -n sles01

grid@sles01:~> srvctl start instance -d tfrapp -n sles02

sles01:/u01/grid/11.2.0/bin # su - oracle

oracle@sles01:~/bin> sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 30 11:28:42 2017

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> select name from v$database;

NAME

---------

TFRAPP

sles01:/u01/grid/11.2.0/bin # su - grid

crsgrid@sles01:~> crs_stat -t -v

Name Type R/RA F/FT Target State Host

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

ora....VG01.dg ora....up.type 0/5 0/ ONLINE ONLINE sles01

ora....VG02.dg ora....up.type 0/5 0/ ONLINE ONLINE sles01

ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE sles01

ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE sles01

ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE sles01

ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE sles02

ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE

ora....network ora....rk.type 0/5 0/ ONLINE ONLINE sles01

ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE sles02

ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE sles01

ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE sles01

ora....SM1.asm application 0/5 0/0 ONLINE ONLINE sles01

ora....01.lsnr application 0/5 0/0 ONLINE ONLINE sles01

ora.sles01.gsd application 0/5 0/0 OFFLINE OFFLINE

ora.sles01.ons application 0/3 0/0 ONLINE ONLINE sles01

ora.sles01.vip ora....t1.type 0/0 0/0 ONLINE ONLINE sles01

ora....SM2.asm application 0/5 0/0 ONLINE ONLINE sles02

ora....02.lsnr application 0/5 0/0 ONLINE ONLINE sles02

ora.sles02.gsd application 0/5 0/0 OFFLINE OFFLINE

ora.sles02.ons application 0/3 0/0 ONLINE ONLINE sles02

ora.sles02.vip ora....t1.type 0/0 0/0 ONLINE ONLINE sles02

ora.tfrapp.db ora....se.type 0/2 0/1 ONLINE ONLINE sles01

grid@sles01:~> lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 30-AUG-2017 22:30:47

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 30-AUG-2017 11:04:04

Uptime 0 days 11 hr. 26 min. 43 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/grid/11.2.0/network/admin/listener.ora

Listener Log File /u01/app/diag/tnslsnr/sles01/listener/alert/log.xml

Listening Endpoints Summary...

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

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

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

Services Summary...

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

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

Service "tfrapp" has 1 instance(s).

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

Service "tfrappXDB" has 1 instance(s).

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

The command completed successfully

节点二验证

grid@sles02:~> ps -ef|grep oracle |wc -l

grid@sles02:~> ps -ef|grep oracle |grep -v grep

root 5400 1 0 06:09 ? 00:01:31 /u01/grid/11.2.0/jdk/jre/bin/java -Xms64m -Xmx256m -classpath /u01/grid/11.2.0/tfa/sles02/tfa_home/jar/RATFA.jar:/u01/grid/11.2.0/tfa/sles02/tfa_home/jar/je-4.0.103.jar:/u01/grid/11.2.0/tfa/sles02/tfa_home/jar/ojdbc6.jar oracle.rat.tfa.TFAMain /u01/grid/11.2.0/tfa/sles02/tfa_home

grid 7843 1 0 11:02 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

grid 7862 1 0 11:02 ? 00:00:00 oracle+ASM2_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

grid 7872 1 0 11:02 ? 00:00:01 oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

grid 8038 1 0 11:02 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

grid 8075 1 0 11:02 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 10419 1 0 11:24 ? 00:01:56 /u01/grid/11.2.0/bin/oraagent.bin

oracle 10476 1 0 11:24 ? 00:00:07 ora_pmon_tfrapp2

oracle 10482 1 0 11:24 ? 00:00:04 ora_psp0_tfrapp2

oracle 10487 1 0 11:24 ? 00:04:00 ora_vktm_tfrapp2

oracle 10494 1 0 11:24 ? 00:00:00 ora_gen0_tfrapp2

oracle 10499 1 0 11:24 ? 00:00:26 ora_diag_tfrapp2

oracle 10504 1 0 11:24 ? 00:00:02 ora_dbrm_tfrapp2

oracle 10509 1 0 11:24 ? 00:00:03 ora_ping_tfrapp2

oracle 10514 1 0 11:24 ? 00:00:00 ora_acms_tfrapp2

oracle 10519 1 0 11:24 ? 00:01:44 ora_dia0_tfrapp2

oracle 10524 1 0 11:24 ? 00:01:01 ora_lmon_tfrapp2

oracle 10529 1 0 11:24 ? 00:00:46 ora_lmd0_tfrapp2

oracle 10534 1 0 11:24 ? 00:01:43 ora_lms0_tfrapp2

oracle 10541 1 0 11:24 ? 00:00:00 ora_rms0_tfrapp2

oracle 10546 1 0 11:24 ? 00:00:02 ora_lmhb_tfrapp2

oracle 10551 1 0 11:24 ? 00:00:01 ora_mman_tfrapp2

oracle 10556 1 0 11:24 ? 00:00:02 ora_dbw0_tfrapp2

oracle 10561 1 0 11:24 ? 00:00:01 ora_lgwr_tfrapp2

oracle 10566 1 0 11:24 ? 00:00:10 ora_ckpt_tfrapp2

oracle 10571 1 0 11:24 ? 00:00:02 ora_smon_tfrapp2

oracle 10576 1 0 11:24 ? 00:00:00 ora_reco_tfrapp2

oracle 10581 1 0 11:24 ? 00:00:00 ora_rbal_tfrapp2

oracle 10587 1 0 11:24 ? 00:00:00 ora_asmb_tfrapp2

oracle 10594 1 0 11:24 ? 00:00:15 ora_mmon_tfrapp2

oracle 10599 1 0 11:24 ? 00:00:19 ora_mmnl_tfrapp2

grid 10606 1 0 11:24 ? 00:00:01 oracle+ASM2_asmb_tfrapp2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 10607 1 0 11:24 ? 00:00:00 ora_d000_tfrapp2

oracle 10612 1 0 11:24 ? 00:00:00 ora_s000_tfrapp2

oracle 10621 1 0 11:24 ? 00:00:01 ora_mark_tfrapp2

oracle 10689 1 0 11:24 ? 00:00:22 ora_lck0_tfrapp2

oracle 10694 1 0 11:25 ? 00:00:01 ora_rsmn_tfrapp2

oracle 10789 1 0 11:25 ? 00:00:00 ora_arc0_tfrapp2

oracle 10795 1 0 11:25 ? 00:00:01 ora_arc1_tfrapp2

oracle 10800 1 0 11:25 ? 00:00:01 ora_arc2_tfrapp2

oracle 10805 1 0 11:25 ? 00:00:00 ora_arc3_tfrapp2

oracle 10810 1 0 11:25 ? 00:00:00 ora_gtx0_tfrapp2

oracle 10815 1 0 11:25 ? 00:00:01 ora_rcbg_tfrapp2

oracle 10820 1 0 11:25 ? 00:00:01 ora_qmnc_tfrapp2

oracle 10842 1 0 11:26 ? 00:00:00 ora_q000_tfrapp2

oracle 10851 1 0 11:26 ? 00:00:00 ora_q001_tfrapp2

oracle 10890 1 0 11:26 ? 00:00:00 oracletfrapp2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 10943 1 0 11:26 ? 00:00:08 ora_cjq0_tfrapp2

oracle 11408 1 0 11:30 ? 00:00:00 ora_smco_tfrapp2

grid 13949 1 0 07:21 ? 00:00:44 /u01/grid/11.2.0/jdk/bin/java -server -Xcheck:jni -Xms128M -Xmx384M -Djava.awt.headless=true -Ddisable.checkForUpdate=true -Dstdstream.filesize=100 -Dstdstream.filenumber=10 -DTRACING.ENABLED=false -Doracle.wlm.dbwlmlogger.logging.level=INFO -Dport.rmi=23792 -jar /u01/grid/11.2.0/oc4j/j2ee/home/oc4j.jar -config /u01/grid/11.2.0/oc4j/j2ee/home/OC4J_DBWLM_config/server.xml -out /u01/grid/11.2.0/oc4j/j2ee/home/log/oc4j.out -err /u01/grid/11.2.0/oc4j/j2ee/home/log/oc4j.err

oracle 15124 1 0 21:59 ? 00:00:01 ora_vkrm_tfrapp2

oracle 17535 1 0 22:21 ? 00:00:00 ora_pz99_tfrapp2

oracle 17558 1 0 22:22 ? 00:00:00 ora_w000_tfrapp2

grid@sles02:~> lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 30-AUG-2017 22:29:29

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 30-AUG-2017 11:03:13

Uptime 0 days 11 hr. 26 min. 17 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/grid/11.2.0/network/admin/listener.ora

Listener Log File /u01/app/diag/tnslsnr/sles02/listener/alert/log.xml

Listening Endpoints Summary...

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

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

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

Services Summary...

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

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

Service "tfrapp" has 1 instance(s).

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

Service "tfrappXDB" has 1 instance(s).

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

The command completed successfully

您可能感兴趣的文档:

点击免费下载>>软考高级考试备考技巧/历年真题/备考精华资料

--结束END--

本文标题: oracle11g rac 修改主机IP地址

本文链接: https://www.lsjlt.com/news/39995.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑，方便收藏和打印～

下载Word文档

去做题

猜你喜欢

rac如何修改ip地址

小编给大家分享一下rac如何修改ip地址，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！oracle release 11.2.0...

99+

2024-04-02
oracle11g RAC如何修改PUBLIC-IP、VIP、PRIV-IP、SCAN-IP

小编给大家分享一下oracle11g RAC如何修改PUBLIC-IP、VIP、PRIV-IP、SCAN-IP，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，...

99+

2024-04-02
怎么修改linux中rac上IP地址

本篇内容主要讲解“怎么修改linux中rac上IP地址”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“怎么修改linux中rac上IP地址”吧!修改前IP：###...

99+

2024-04-02
Solaris 10如何修改主机名和IP地址

这篇文章主要介绍Solaris 10如何修改主机名和IP地址，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！Solaris 10修改主机名和IP地址步骤修改主机名：hostname newnamevi /etc/hos...

99+

2023-06-28
如何更改rac scanIP IP的地址

这篇文章主要为大家展示了“如何更改rac scanIP IP的地址”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下“如何更改rac scanIP IP的地址”这篇文...

99+

2024-04-02
怎么修改linux中rac集群各种ip地址

这篇文章主要介绍“怎么修改linux中rac集群各种ip地址”，在日常操作中，相信很多人在怎么修改linux中rac集群各种ip地址问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解...

99+

2024-04-02
手机如何修改ip地址

这篇文章将为大家详细讲解有关手机如何修改ip地址，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。在实际的网络应用中，我们经常需要更换本地的IP地址。有许多方法可以更换IP。这里有几种方法可以根据实际情况选择...

99+

2023-06-20
Ubuntu修改IP地址

安装的核心版ubuntu，不带桌面图形界面，需要修改IP地址，如下操作：找到网卡配置文件 sudo cp /etc/netplan/你的网卡文件.yaml /etc/netplan/你的网卡文件.yaml.bak 修改如下配置，注意对齐...

99+

2023-10-23

ubuntu 服务器 linux
如何修改手机上ip地址

这篇文章将为大家详细讲解有关如何修改手机上ip地址，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。手机的版本不同，自身手机为准选择手机VPN点击添加VPN地址添加名称-选择类型-服务器地址-保存保存进行连接...

99+

2023-06-15
linux下怎么修改ip地址,主机名等信息

本篇内容主要讲解“linux下怎么修改ip地址,主机名等信息”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“linux下怎么修改ip地址,主机名等信息”吧!修改ip地址即时生效:# ifconfi...

99+

2023-06-13
hadoop虚拟机怎么修改ip地址

要修改Hadoop虚拟机的IP地址，您可以按照以下步骤操作：打开虚拟机管理软件（如VirtualBox、VMware等）。 ...

99+

2024-04-09

hadoop
云主机如何修改mac地址

在云主机中修改mac地址的方法：1.远程登录云主机；2.控制面板点击“网络和Internet”；3.点击“网络和共享中心”选项；4.点击左侧"更改适配器设置"选项；5.右键“本地连接”，选择属性；6.选择“Microso...

99+

2024-04-02
centos怎么修改ip地址

要在CentOS上修改IP地址，您可以按照以下步骤进行操作：1. 打开终端并以root用户身份登录。2. 使用以下命令查看当前网络连...

99+

2023-08-17

centos
gitlab怎么修改IP地址

如果你使用的是GitLab，你可能会面临需要在网络配置更改时修改GitLab IP地址的情况。在这篇文章中，我们将告诉你如何将GitLab IP地址更改为新的IP地址。首先，确保你已经获得了新的IP地址。在更改GitLab的IP地址之前，确...

99+

2023-10-22
win11如何修改ip地址

本篇内容主要讲解“win11如何修改ip地址”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“win11如何修改ip地址”吧!win11修改ip地址的方法：第一步，右键右下角网络图标，打开“网络和i...

99+

2023-06-30
Ubuntu如何修改ip地址

本篇内容主要讲解“Ubuntu如何修改ip地址”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“Ubuntu如何修改ip地址”吧!0x00使用ifconfig命令查看网卡ifconfig0...

99+

2023-07-04
OpenStack如何修改ip地址

本篇内容介绍了“OpenStack如何修改ip地址”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！OpenStack 是当今最具影响力的云计算...

99+

2023-06-27
linux如何修改ip地址

linux中修改ip地址的方法：1.打开终端；2.输入“ifconfig”命令查看网卡信息；3.打开/etc/sysconfig/network-scripts/ifcfg-eth0配置文件；4.修改文件中对应的ip地址配置；5.输入“se...

99+

2024-04-02
linux怎么修改ip地址

要在Linux系统中修改IP地址，需要使用命令行工具。具体步骤如下：1. 打开终端，以root用户或具有sudo权限的用户身份登录。...

99+

2023-08-25

linux
ubuntu系统 IP地址修改

1）系统当前IP地址 192.168.123.88，打算修改为 192.168.123.80。2）打开网卡配置文件 vim /etc/network/interfaces3）将address地址修改为 192.168.1...

99+

2023-06-06