Shulou(Shulou.com)06/01 Report--

1 background

According to the request of xx head office, transform the existing DMZ network of xx branch. All IP addresses in this segment need to be changed to new IP address, which involves database oracle 11g rac. The following is the detailed test environment operation procedure for reference!

Operating system:

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 GNU/Linux

2 system environment check

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 stop the oracle cluster service

3.1 stop the database service

Grid@sles02:~ > srvctl stop database-d tfrapp-o immediate / / double check both nodes

3.2 stop the asm volume group service on each node

Volume groups listed by 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 stop the asm service of each node

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

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

3.4 stop node application services (virtual IP, GSD, TNS listeners and ONS)

Grid@sles01:~ > srvctl stop nodeapps-n sles01 / / after many experiments, I think this step is ignored.

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 / / ditto

3.5 stop the crs service of each node

In order to generate unnecessary errors, it is enforced to stop the service.

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

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

4 modify the IP address information of two hosts

Node one

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

Restart network services

Sles01:~ # sed-I's Universe 192.168.99 Universe 192.168.88 / etc/sysconfig/network/ifcfg-bond0

Sles01:~ # service network restart

Node two

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

Restart network services

Sles02:~ # sed-I's Universe 192.168.99 Universe 192.168.88 / etc/sysconfig/network/ifcfg-bond0

Sles02:~ # service network restart

5 configure cluster information

5.1 start the crs service with two nodes

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

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

5.2Node sles01 modifies vip network segment of group rack

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.3Node sles02 modifies the group rack vip network segment

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 adjust the connection to the private network. If the internal address remains the same, you do not need to adjust it. You can ignore this step.

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 configure the vip address of each node

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

-n 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 / / because a node is specified, commands can be executed on a machine

At this point, you can restart the crs service on both nodes

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: 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: 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: 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: 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: 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 modify scanip address

Found that the scanip address was not refreshed.

6.1 turn off scan services and listen

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 configure scan ip addr

Read the new address from the DNS parsing, refresh the IP address, because you are using the hosts list, so it may not be successful, and you need to configure it manually.

Sles01:/u01/grid/11.2.0/bin #. / srvctl modify scan- n scanip / / scanip refers to the name (tfrapp-scan) of the corresponding scan-ip in the host. This is a refresh operation. If the IP address can be refreshed, you do not need to specify it manually.

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 / / manually specify the IP address

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 start scan service and intercept

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

Grid@sles01:~ > srvctl start scan

Grid@sles01:~ > srvctl start scan_listener

7 Verification service

Node one

Grid@sles01:~ > ip a

1: lo: 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: 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: 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: 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: 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

^ C

-192.168.88.12 ping statistics-

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

Rtt min/avg/max/mdev = 0.218 ms 3.045 ms 12.462 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

^ C

-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

^ C

-192.168.88.13 ping statistics-

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

Rtt min/avg/max/mdev = 0.025max 0.034 ms 0.051 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

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 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

/ / at this time, because the instance on the node is not started, listening is only ASM and there is no db information.

Start each node instance

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

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 > 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

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 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

Node two verification

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

eight

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

eight

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

eight

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

forty-five

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

fifty-eight

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

Root 5400 10 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 10 11:24? 00:01:56 / u01/grid/11.2.0/bin/oraagent.bin

Oracle 10476 10 11:24? 00:00:07 ora_pmon_tfrapp2

Oracle 10482 10 11:24? 00:00:04 ora_psp0_tfrapp2

Oracle 10487 10 11:24? 00:04:00 ora_vktm_tfrapp2

Oracle 10494 10 11:24? 00:00:00 ora_gen0_tfrapp2

Oracle 10499 10 11:24? 00:00:26 ora_diag_tfrapp2

Oracle 10504 10 11:24? 00:00:02 ora_dbrm_tfrapp2

Oracle 10509 10 11:24? 00:00:03 ora_ping_tfrapp2

Oracle 10514 10 11:24? 00:00:00 ora_acms_tfrapp2

Oracle 10519 10 11:24? 00:01:44 ora_dia0_tfrapp2

Oracle 10524 10 11:24? 00:01:01 ora_lmon_tfrapp2

Oracle 10529 10 11:24? 00:00:46 ora_lmd0_tfrapp2

Oracle 10534 10 11:24? 00:01:43 ora_lms0_tfrapp2

Oracle 10541 10 11:24? 00:00:00 ora_rms0_tfrapp2

Oracle 10546 10 11:24? 00:00:02 ora_lmhb_tfrapp2

Oracle 10551 10 11:24? 00:00:01 ora_mman_tfrapp2

Oracle 10556 10 11:24? 00:00:02 ora_dbw0_tfrapp2

Oracle 10561 10 11:24? 00:00:01 ora_lgwr_tfrapp2

Oracle 10566 10 11:24? 00:00:10 ora_ckpt_tfrapp2

Oracle 10571 10 11:24? 00:00:02 ora_smon_tfrapp2

Oracle 10576 10 11:24? 00:00:00 ora_reco_tfrapp2

Oracle 10581 10 11:24? 00:00:00 ora_rbal_tfrapp2

Oracle 10587 10 11:24? 00:00:00 ora_asmb_tfrapp2

Oracle 10594 10 11:24? 00:00:15 ora_mmon_tfrapp2

Oracle 10599 10 11:24? 00:00:19 ora_mmnl_tfrapp2

Grid 10606 10 11:24? 00:00:01 oracle+ASM2_asmb_tfrapp2 (DESCRIPTION= (LOCAL=YES) (ADDRESS= (PROTOCOL=beq))

Oracle 10607 10 11:24? 00:00:00 ora_d000_tfrapp2

Oracle 10612 10 11:24? 00:00:00 ora_s000_tfrapp2

Oracle 10621 10 11:24? 00:00:01 ora_mark_tfrapp2

Oracle 10689 10 11:24? 00:00:22 ora_lck0_tfrapp2

Oracle 10694 10 11:25? 00:00:01 ora_rsmn_tfrapp2

Oracle 10789 10 11:25? 00:00:00 ora_arc0_tfrapp2

Oracle 10795 10 11:25? 00:00:01 ora_arc1_tfrapp2

Oracle 10800 10 11:25? 00:00:01 ora_arc2_tfrapp2

Oracle 10805 10 11:25? 00:00:00 ora_arc3_tfrapp2

Oracle 10810 10 11:25? 00:00:00 ora_gtx0_tfrapp2

Oracle 10815 10 11:25? 00:00:01 ora_rcbg_tfrapp2

Oracle 10820 10 11:25? 00:00:01 ora_qmnc_tfrapp2

Oracle 10842 10 11:26? 00:00:00 ora_q000_tfrapp2

Oracle 10851 10 11:26? 00:00:00 ora_q001_tfrapp2

Oracle 10890 10 11:26? 00:00:00 oracletfrapp2 (DESCRIPTION= (LOCAL=YES) (ADDRESS= (PROTOCOL=beq))

Oracle 10943 10 11:26? 00:00:08 ora_cjq0_tfrapp2

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

Grid 13949 10 07:21? 00:00:44 / u01/grid/11.2.0/jdk/bin/java-server-Xcheck:jni-Xms128M-Xmx384M-Djava.awt.headless=true-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 hash GridBank 11.2.0 GridHare 11.2.0 UK OC4J BWLM _ _ 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

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 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.