建站
咨詢
售后
建站咨詢
新聞中心
1 背景
創(chuàng)新互聯(lián)專注于舒蘭企業(yè)網(wǎng)站建設,自適應網(wǎng)站建設,商城網(wǎng)站建設。舒蘭網(wǎng)站建設公司,為舒蘭等地區(qū)提供建站服務。全流程按需求定制設計，專業(yè)設計，全程項目跟蹤，創(chuàng)新互聯(lián)專業(yè)和態(tài)度為您提供的服務
應xx總行要求，對xx分行現(xiàn)有DMZ網(wǎng)絡進行改造，此網(wǎng)段所有IP地址都要變更新的IP地址，涉及數(shù)據(jù)庫oracle 11g rac，以下是詳細測試環(huán)境操作步驟參考！
操作系統(tǒng)：
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 系統(tǒng)環(huán)境檢查
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 停止數(shù)據(jù)庫服務
grid@sles02:~> srvctl stop database -d tfrapp -o immediate //兩個節(jié)點反復檢查一下
3.2 停止各節(jié)點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 停止各節(jié)點asm服務
grid@sles01:~> srvctl stop asm -n sles01
grid@sles02:~> srvctl stop asm -n sles02
3.4 停止各節(jié)點應用服務（虛擬IP、GSD、TNS 監(jiān)聽器和 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 停止各節(jié)點crs服務
為了不必要的錯誤產(chǎn)生，這里是強制執(zhí)行停止服務
sles01:/u01/grid/11.2.0/bin #./crsctl stop crs -f
sles02:/u01/grid/11.2.0/bin #./crsctl stop crs -f
4 修改兩臺主機IP地址信息
節(jié)點一
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
重啟網(wǎng)絡服務
sles01:~ # sed -i 's/192.168.99/192.168.88/g' /etc/sysconfig/network/ifcfg-bond0
sles01:~ # service network restart
節(jié)點二
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
重啟網(wǎng)絡服務
sles02:~ # sed -i 's/192.168.99/192.168.88/g' /etc/sysconfig/network/ifcfg-bond0
sles02:~ # service network restart
5 配置集群信息
5.1 啟動兩個節(jié)點的crs服務
sles01:/u01/grid/11.2.0/bin #./crsctl start crs
sles02:/u01/grid/11.2.0/bin #./crsctl start crs
5.2 節(jié)點sles01 修改群架vip網(wǎng)段
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 節(jié)點sles02 修改群架vip網(wǎng)段
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 調整私網(wǎng)連接，如果內(nèi)部地址不變可以不用調整的，可以忽略此步驟操作
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 配置各個節(jié)點的vip地址
grid@sles01:~> srvctl config nodeapps -n sles01 -a
-n
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 //因為指定了節(jié)點，所以可以在一臺機器上執(zhí)行命令
到這時，就可以重啟兩個節(jié)點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:
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:
link/ether 08:00:27:14:be:ff brd ff:ff:ff:ff:ff:ff
3: eth2:
link/ether 08:00:27:14:be:ff brd ff:ff:ff:ff:ff:ff
4: eth3:
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:
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地址
發(fā)現(xiàn)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 驗證服務
節(jié)點一
grid@sles01:~> ip a
1: lo:
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:
link/ether 08:00:27:14:be:ff brd ff:ff:ff:ff:ff:ff
3: eth2:
link/ether 08:00:27:14:be:ff brd ff:ff:ff:ff:ff:ff
4: eth3:
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:
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/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
^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.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
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
//這個時候是因為節(jié)點上的實例沒有啟動，所以偵聽只是ASM，沒有db信息。
啟動各個節(jié)點實例
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
節(jié)點二驗證
grid@sles02:~> ps -ef|grep oracle |wc -l
8
grid@sles02:~> ps -ef|grep oracle |wc -l
8
grid@sles02:~> ps -ef|grep oracle |wc -l
8
grid@sles02:~> ps -ef|grep oracle |wc -l
45
grid@sles02:~> ps -ef|grep oracle |wc -l
58
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
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
本文題目：oracle11grac修改主機IP地址
網(wǎng)頁路徑：http://www.ef60e0e.cn/article/pghjpo.html
