Installation Oracle11gR2 RAC One Node ---测试一
节点1
grid@node1:~> srvctl config database -d ORACLE
Database unique name: ORACLE
Database name: ORACLE
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/ORACLE/spfileORACLE.ora
Domain:
Start options: open
Stop options: immediate
Database role:PRIMARY
Management policy: AUTOMATIC
Server pools: ORACLE
Database instances:
Disk Groups: DATA,FRA
Mount point paths:
Services: ORACLESER
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: ORACLE
Candidate servers:node1,node2
Database is administrator managed
grid@node1:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATESERVERSTATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.FRA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.LISTENER.lsnr
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.OCR_VOTE.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.asm
ONLINE ONLINEnode1Started
ONLINE ONLINEnode2Started
ora.gsd
OFFLINEOFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.ons
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.registry.acfs
ONLINE ONLINEnode1
ONLINE ONLINEnode2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE node2
ora.cvu
1 ONLINEONLINE node2
ora.node1.vip
1 ONLINEONLINE node1
ora.node2.vip
1 ONLINEONLINE node2
ora.oc4j
1 ONLINEONLINE node2
ora.oracle.db
1 ONLINEONLINE node1 Open
ora.oracle.oracleser.svc
1 ONLINEONLINE node1
ora.scan1.vip
1 ONLINEONLINE node2
grid@node1:~> srvctl status database -d ORACLE
Instance ORACLE_1 is running on node node1
Online relocation: INACTIVE
grid@node1:~>
oracle@node1:~> sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Mon May 25 18:01:492015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> show parameter cluster_database;
NAME TYPE VALUE
------------------------------------ -----------------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ -----------------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string ORACLE
db_unique_namestring ORACLE
global_names boolean FALSE
instance_name string ORACLE_1
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string ORACLESER
SQL>
节点2
grid@node2:~> srvctl config database -d ORACLE
Database unique name: ORACLE
Database name: ORACLE
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/ORACLE/spfileORACLE.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ORACLE
Database instances:
Disk Groups: DATA,FRA
Mount point paths:
Services: ORACLESER
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: ORACLE
Candidate servers:node1,node2
Database is administrator managed
grid@node2:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATESERVERSTATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.FRA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.LISTENER.lsnr
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.OCR_VOTE.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.asm
ONLINE ONLINEnode1 Started
ONLINE ONLINEnode2Started
ora.gsd
OFFLINEOFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINEnode2
ora.registry.acfs
ONLINE ONLINEnode1
ONLINE ONLINEnode2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE node2
ora.cvu
1 ONLINEONLINE node2
ora.node1.vip
1 ONLINEONLINE node1
ora.node2.vip
1 ONLINEONLINE node2
ora.oc4j
1 ONLINEONLINE node2
ora.oracle.db
1ONLINE ONLINE node1 Open
ora.oracle.oracleser.svc
1 ONLINEONLINE node1
ora.scan1.vip
1 ONLINEONLINE node2
grid@node2:~> srvctl status database -d ORACLE
Instance ORACLE_1 is running on node node1
Online relocation: INACTIVE
grid@node2:~>
此时，实例ORACLE_1运行于节点1上。
6.2 Kill Pmon在节点1杀死pmon进程，查看数据库状态。
node1:~ # ps -ef|grep pmon
grid 4452 10 17:56 ? 00:00:00asm_pmon_+ASM1
oracle 5282 10 17:57 ? 00:00:00ora_pmon_ORACLE_1
root 6741 42590 18:03 pts/0 00:00:00 greppmon
node1:~ # kill -9 5282
node1:~ # su - grid
grid@node1:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATESERVERSTATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.FRA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.LISTENER.lsnr
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.OCR_VOTE.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.asm
ONLINE ONLINEnode1Started
ONLINE ONLINEnode2Started
ora.gsd
OFFLINEOFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.ons
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.registry.acfs
ONLINE ONLINEnode1
ONLINE ONLINEnode2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE node2
ora.cvu
1 ONLINEONLINE node2
ora.node1.vip
1 ONLINEONLINE node1
ora.node2.vip
1 ONLINEONLINE node2
ora.oc4j
1ONLINE ONLINE node2
ora.oracle.db
1 ONLINEOFFLINEAbnormal Terminatio
n,CLEANING
ora.oracle.oracleser.svc
1 ONLINEOFFLINE
ora.scan1.vip
1 ONLINEONLINE node2
grid@node1:~>
等待一分钟再次查看
grid@node1:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATESERVERSTATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.FRA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.LISTENER.lsnr
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.OCR_VOTE.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.asm
ONLINE ONLINEnode1Started
ONLINE ONLINEnode2Started
ora.gsd
OFFLINEOFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.ons
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.registry.acfs
ONLINE ONLINEnode1
ONLINE ONLINEnode2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE node2
ora.cvu
1 ONLINEONLINE node2
ora.node1.vip
1 ONLINEONLINE node1
ora.node2.vip
1 ONLINEONLINE node2
ora.oc4j
1ONLINE ONLINE node2
ora.oracle.db
1 ONLINEONLINE node1 Open
ora.oracle.oracleser.svc
1 ONLINEONLINE node1
ora.scan1.vip
1 ONLINEONLINE node2
grid@node1:~>
杀死PMON进程后，不发生切换，将会在本机重启进程。
6.3 Relocate数据库node1:/u01/app/11.2.0/grid/bin # ./srvctl relocate database -dORACLE -n node2
grid@node1:~> srvctl statusdatabase -d oracle
Instance ORACLE_1is running on node node1
Online relocation:ACTIVE
Source instance:ORACLE_1 on node1
Destinationinstance: ORACLE_2 on node2
grid@node1:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATESERVERSTATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.FRA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.LISTENER.lsnr
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.OCR_VOTE.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.asm
ONLINE ONLINEnode1Started
ONLINE ONLINEnode2Started
ora.gsd
OFFLINE OFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.ons
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.registry.acfs
ONLINE ONLINEnode1
ONLINE ONLINEnode2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE node2
ora.cvu
1 ONLINEONLINE node2
ora.node1.vip
1 ONLINEONLINE node1
ora.node2.vip
1 ONLINEONLINE node2
ora.oc4j
1 ONLINEONLINE node2
ora.oracle.db
1 ONLINEONLINE node1 Open
2 ONLINEOFFLINESTARTING
ora.oracle.oracleser.svc
1 ONLINEONLINE node1
ora.scan1.vip
1 ONLINEONLINE node2
再次查看
grid@node1:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATESERVERSTATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.FRA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.LISTENER.lsnr
ONLINE ONLINEnode1
ONLINEONLINE node2
ora.OCR_VOTE.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.asm
ONLINE ONLINEnode1Started
ONLINE ONLINEnode2Started
ora.gsd
OFFLINEOFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.ons
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.registry.acfs
ONLINE ONLINEnode1
ONLINE ONLINEnode2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE node2
ora.cvu
1 ONLINEONLINE node2
ora.node1.vip
1 ONLINEONLINE node1
ora.node2.vip
1 ONLINEONLINE node2
ora.oc4j
1 ONLINEONLINE node2
ora.oracle.db
1 ONLINEONLINE node1 Open
2 ONLINEOFFLINESTARTING
ora.oracle.oracleser.svc
1 ONLINEONLINE node1
ora.scan1.vip
1 ONLINEONLINE node2
再次查看
grid@node1:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATESERVERSTATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.FRA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.LISTENER.lsnr
ONLINE ONLINEnode1
ONLINEONLINE node2
ora.OCR_VOTE.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.asm
ONLINE ONLINEnode1Started
ONLINE ONLINEnode2Started
ora.gsd
OFFLINEOFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.ons
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.registry.acfs
ONLINE ONLINEnode1
ONLINE ONLINEnode2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE node2
ora.cvu
1 ONLINEONLINE node2
ora.node1.vip
1 ONLINEONLINE node1
ora.node2.vip
1 ONLINEONLINE node2
ora.oc4j
1 ONLINEONLINE node2
ora.oracle.db
1 OFFLINE ONLINE node1 Open,STOPPING
2 ONLINEONLINE node2 Open
ora.oracle.oracleser.svc
1 ONLINEONLINE node2
ora.scan1.vip
1 ONLINEONLINE node2
再次查看
grid@node1:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATESERVERSTATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.FRA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.LISTENER.lsnr
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.OCR_VOTE.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.asm
ONLINE ONLINEnode1Started
ONLINE ONLINEnode2Started
ora.gsd
OFFLINEOFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.ons
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.registry.acfs
ONLINE ONLINEnode1
ONLINE ONLINEnode2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE node2
ora.cvu
1 ONLINEONLINE node2
ora.node1.vip
1 ONLINEONLINE node1
ora.node2.vip
1 ONLINEONLINE node2
ora.oc4j
1 ONLINEONLINE node2
ora.oracle.db
2 ONLINEONLINE node2 Open
ora.oracle.oracleser.svc
1 ONLINEONLINE node2
ora.scan1.vip
1 ONLINEONLINE node2
grid@node1:~>
此时在节点2进行查看
grid@node2:~> srvctl config database -d ORACLE
HDatabase unique name: ORACLE
Database name: ORACLE
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/ORACLE/spfileORACLE.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ORACLE
Database instances:
Disk Groups: DATA,FRA
Mount point paths:
Services: ORACLESER
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: ORACLE
Candidate servers: node1,node2
Database is administrator managed
grid@node2:~> srvctl status database -d ORACLE
Instance ORACLE_2is running on node node2
Online relocation:INACTIVE
grid@node2:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATESERVERSTATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.FRA.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.LISTENER.lsnr
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.OCR_VOTE.dg
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.asm
ONLINE ONLINEnode1Started
ONLINE ONLINEnode2Started
ora.gsd
OFFLINE OFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.ons
ONLINE ONLINEnode1
ONLINE ONLINEnode2
ora.registry.acfs
ONLINE ONLINEnode1
ONLINE ONLINEnode2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE node2
ora.cvu
1 ONLINEONLINE node2
ora.node1.vip
1 ONLINEONLINE node1
ora.node2.vip
1 ONLINEONLINE node2
ora.oc4j
1 ONLINEONLINE node2
ora.oracle.db
2 ONLINEONLINE node2 Open
ora.oracle.oracleser.svc
1 ONLINEONLINE node2
ora.scan1.vip
1 ONLINEONLINE node2
grid@node2:~>
发生切换后实例ORACLE_1变为ORACLE_2运行于节点2上运行。
声明：本站所有文章资源内容，如无特殊说明或标注，均为采集网络资源。如若本站内容侵犯了原著者的合法权益，可联系本站删除。
