oracle11g rac 修改主机IP地址
|
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: eth2 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 #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 eth2 sles01:/u01/grid/11.2.0/bin # ./oifcfg setif -global eth2/10.0.0.0:cluster_interconnect sles02:/u01/grid/11.2.0/bin # ./oifcfg delif -global eth3 sles02:/u01/grid/11.2.0/bin # ./oifcfg setif -global eth3/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 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,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: eth1: <BROADCAST,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: eth2: <BROADCAST,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 eth2 inet 169.254.40.214/16 brd 169.254.255.255 scope global eth2:1 6: bond0: <BROADCAST,MASTER,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 # 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,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,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 ^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,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,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 //这个时候是因为节点上的实例没有启动，所以侦听只是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 Copyright (c) 1982,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,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",has 1 handler(s) for this service... Service "tfrapp" has 1 instance(s). Instance "tfrapp1",has 1 handler(s) for this service... Service "tfrappXDB" has 1 instance(s). Instance "tfrapp1",has 1 handler(s) for this service... The command completed successfully 节点二验证 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,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",has 1 handler(s) for this service... Service "tfrapp" has 1 instance(s). Instance "tfrapp2",has 1 handler(s) for this service... Service "tfrappXDB" has 1 instance(s). Instance "tfrapp2",has 1 handler(s) for this service... The command completed successfully （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |