Oracle 11g RAC手動新增service
11.2.0.4 RAC
dbname:XXXXXXDB
新增服務:
ordXX:ordXX
orXX:orXX
dsXX:dsXX
[oracle@jdordXX2 ~]$ srvctl add service -h
Adds a service configuration to the Oracle Clusterware.
Usage: srvctl add service -d <db_unique_name> -s <service_name> {-r "<preferred_list>" [-a "<available_list>"] [-P {BASIC | NONE | PRECONNECT}] | -g <pool_name> [-c {UNIFORM | SINGLETON}] } [-k <net_num>] [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}] [-q {TRUE|FALSE}] [-x {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z <failover_retries>] [-w <failover_delay>] [-t <edition>] [-f]
-d <db_unique_name> Unique name for the database
-s <service> Service name
-r "<preferred_list>" Comma separated list of preferred instances
-a "<available_list>" Comma separated list of available instances
-g <pool_name> Server pool name
-c {UNIFORM | SINGLETON} Service runs on every active server in the server pool hosting this service (UNIFORM) or just one server (SINGLETON)
-k <net_num> network number (default number is 1)
-P {NONE | BASIC | PRECONNECT} TAF policy specification
-l <role> Role of the service (primary, physical_standby, logical_standby, snapshot_standby)
-y <policy> Management policy for the service (AUTOMATIC or MANUAL)
-e <Failover type> Failover type (NONE, SESSION, or SELECT)
-m <Failover method> Failover method (NONE or BASIC)
-w <integer> Failover delay
-z <integer> Failover retries
-t <edition> Edition (or "" for empty edition value)
-j <clb_goal> Connection Load Balancing Goal (SHORT or LONG). Default is LONG.
-B <Runtime Load Balancing Goal> Runtime Load Balancing Goal (SERVICE_TIME, THROUGHPUT, or NONE)
-x <Distributed Transaction Processing> Distributed Transaction Processing (TRUE or FALSE)
-q <AQ HA notifications> AQ HA notifications (TRUE or FALSE)
Usage: srvctl add service -d <db_unique_name> -s <service_name> -u {-r "<new_pref_inst>" | -a "<new_avail_inst>"} [-f]
-d <db_unique_name> Unique name for the database
-s <service> Service name
-u Add a new instance to service configuration
-r <new_pref_inst> Name of new preferred instance
-a <new_avail_inst> Name of new available instance
-f Force the add operation even though a listener is not configured for a network
-h Print usage
[oracle@jdordXX2 ~]$ srvctl add service -d XXXXXXDB -s ordXX -r XXXXXXDB1 -a XXXXXXDB2 -P basic -e select -m basic -z 180 -w 5
[oracle@jdordXX2 ~]$ srvctl add service -d XXXXXXDB -s dsXX -r XXXXXXDB1 -a XXXXXXDB2 -P basic -e select -m basic -z 180 -w 5
[oracle@jdordXX2 ~]$ srvctl start service -d XXXXXXDB -s ordXX
[oracle@jdordXX2 ~]$ srvctl start service -d XXXXXXDB -s dsXX
[oracle@jdordXX2 ~]$ srvctl add service -d XXXXXXDB -s orXX -r XXXXXXDB1 -a XXXXXXDB2 -P basic -e select -m basic -z 180 -w 5
[oracle@jdordXX2 ~]$ srvctl start service -d XXXXXXDB -s orXX
[oracle@jdordXX1 ~]$ srvctl relocate service -d XXXXXXDB -s Gaoyc -i XXXXXXDB1 -t XXXXXXDB2
[oracle@jdordXX2 ~]$ srvctl add service -d XXXXXXDB -s Gaoyc -r XXXXXXDB1,XXXXXXDB2 -P basic -e select -m basic -z 180 -w 5
[oracle@jdordXX1 ~]$ srvctl add service -d XXXXXXDB -s Gaoyc -r "XXXXXXDB1,XXXXXXDB2" -a "XXXXXXDB2,XXXXXXDB1" -P basic -e select -m basic -z 180 -w 5
PRKO-2102 : Failed to create server pool XXXXXXDB_Gaoyc: PRCS-1009 : Failed to create server pool ora.XXXXXXDB_Gaoyc
PRCR-1071 : Failed to register or update server pool ora.XXXXXXDB_Gaoyc
CRS-2714: 'jdordXX2' is specified multiple times in 'SERVER_NAMES' of 'ora.XXXXXXDB_Gaoyc'
##-r引數和-a引數不允許重複
[oracle@jdordXX1 ~]$ srvctl add service -d XXXXXXDB -s Gaoyc -r "XXXXXXDB1,XXXXXXDB2" -P basic -e select -m basic -z 180 -w 5
[oracle@jdordXX1 ~]$ srvctl remove service -d XXXXXXDB -s Gaoyc
[oracle@jdordXX1 ~]$
[oracle@jdordXX1 ~]$ srvctl relocate service -h
Temporarily relocates service from one node of the cluster to another.
Usage: srvctl relocate service -d <db_unique_name> -s <service_name> {-i <old_inst_name> -t <new_inst_name> | -c <current_node> -n <target_node>} [-f]
-d <db_unique_name> Unique name for the database
-s <service> Service name
-i <old_inst> Old instance name
-t <new_inst> New instance name
-c <current_node> Node name to relocate service from
-n <target_node> Node name to relocate service to
-f Disconnect all sessions during stop or relocate service operations
-h Print usages
[grid@jdordXX1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
ora.LISTENER.lsnr
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
ora.asm
ONLINE ONLINE jdordXX1 Started
ONLINE ONLINE jdordXX2 Started
ora.gsd
OFFLINE OFFLINE jdordXX1
OFFLINE OFFLINE jdordXX2
ora.net1.network
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
ora.ons
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jdordXX1
ora.cvu
1 ONLINE ONLINE jdordXX1
ora.jdordXX1.vip
1 ONLINE ONLINE jdordXX1
ora.jdordXX2.vip
1 ONLINE ONLINE jdordXX2
ora.oc4j
1 ONLINE ONLINE jdordXX1
ora.XXXXXXDB.db
1 ONLINE ONLINE jdordXX1 Open
2 ONLINE ONLINE jdordXX2 Open
ora.XXXXXXDB.dsXX.svc
1 ONLINE ONLINE jdordXX1
ora.XXXXXXDB.ordXX.svc
1 ONLINE ONLINE jdordXX1
ora.scan1.vip
1 ONLINE ONLINE jdordXX1
[grid@jdordXX1 ~]$
[grid@jdordXX1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
ora.LISTENER.lsnr
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
ora.asm
ONLINE ONLINE jdordXX1 Started
ONLINE ONLINE jdordXX2 Started
ora.gsd
OFFLINE OFFLINE jdordXX1
OFFLINE OFFLINE jdordXX2
ora.net1.network
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
ora.ons
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jdordXX1
ora.cvu
1 ONLINE ONLINE jdordXX1
ora.jdordXX1.vip
1 ONLINE ONLINE jdordXX1
ora.jdordXX2.vip
1 ONLINE ONLINE jdordXX2
ora.oc4j
1 ONLINE ONLINE jdordXX1
ora.XXXXXXDB.db
1 ONLINE ONLINE jdordXX1 Open
2 ONLINE ONLINE jdordXX2 Open
ora.XXXXXXDB.funtune.svc
1 ONLINE ONLINE jdordXX1
2 ONLINE ONLINE jdordXX2
ora.scan1.vip
1 ONLINE ONLINE jdordXX1
[oracle@jdordXX2 ~]$ srvctl remove service -d XXXXXXDB -s funtune
PRCR-1025 : Resource ora.XXXXXXDB.funtune.svc is still running
[oracle@jdordXX2 ~]$ srvctl stop service -d XXXXXXDB -s funtune;
[oracle@jdordXX2 ~]$ srvctl remove service -d XXXXXXDB -s funtune
[oracle@jdordXX2 ~]$ srvctl config service -d XXXXXXDB -s ordXX
Service name: ordXX
Service is enabled
Server pool: XXXXXXDB_ordXX
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Preferred instances: XXXXXXDB1
Available instances: XXXXXXDB2
[oracle@jdordXX2 ~]$ srvctl remove service -d XXXXXXDB -s ordXX
[oracle@jdordXX2 ~]$ srvctl add service -d XXXXXXDB -s ordXX -r XXXXXXDB1 -a XXXXXXDB2 -P basic -e select -m basic -z 180 -w 5
[oracle@jdordXX2 ~]$ srvctl config service -d XXXXXXDB -s ordXX
Service name: ordXX
Service is enabled
Server pool: XXXXXXDB_ordXX
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 180
TAF failover delay: 5
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Preferred instances: XXXXXXDB1
Available instances: XXXXXXDB2
好記性不如爛筆頭,方便後期檢視。
dbname:XXXXXXDB
新增服務:
ordXX:ordXX
orXX:orXX
dsXX:dsXX
[oracle@jdordXX2 ~]$ srvctl add service -h
Adds a service configuration to the Oracle Clusterware.
Usage: srvctl add service -d <db_unique_name> -s <service_name> {-r "<preferred_list>" [-a "<available_list>"] [-P {BASIC | NONE | PRECONNECT}] | -g <pool_name> [-c {UNIFORM | SINGLETON}] } [-k <net_num>] [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}] [-q {TRUE|FALSE}] [-x {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z <failover_retries>] [-w <failover_delay>] [-t <edition>] [-f]
-d <db_unique_name> Unique name for the database
-s <service> Service name
-r "<preferred_list>" Comma separated list of preferred instances
-a "<available_list>" Comma separated list of available instances
-g <pool_name> Server pool name
-c {UNIFORM | SINGLETON} Service runs on every active server in the server pool hosting this service (UNIFORM) or just one server (SINGLETON)
-k <net_num> network number (default number is 1)
-P {NONE | BASIC | PRECONNECT} TAF policy specification
-l <role> Role of the service (primary, physical_standby, logical_standby, snapshot_standby)
-y <policy> Management policy for the service (AUTOMATIC or MANUAL)
-e <Failover type> Failover type (NONE, SESSION, or SELECT)
-m <Failover method> Failover method (NONE or BASIC)
-w <integer> Failover delay
-z <integer> Failover retries
-t <edition> Edition (or "" for empty edition value)
-j <clb_goal> Connection Load Balancing Goal (SHORT or LONG). Default is LONG.
-B <Runtime Load Balancing Goal> Runtime Load Balancing Goal (SERVICE_TIME, THROUGHPUT, or NONE)
-x <Distributed Transaction Processing> Distributed Transaction Processing (TRUE or FALSE)
-q <AQ HA notifications> AQ HA notifications (TRUE or FALSE)
Usage: srvctl add service -d <db_unique_name> -s <service_name> -u {-r "<new_pref_inst>" | -a "<new_avail_inst>"} [-f]
-d <db_unique_name> Unique name for the database
-s <service> Service name
-u Add a new instance to service configuration
-r <new_pref_inst> Name of new preferred instance
-a <new_avail_inst> Name of new available instance
-f Force the add operation even though a listener is not configured for a network
-h Print usage
[oracle@jdordXX2 ~]$ srvctl add service -d XXXXXXDB -s ordXX -r XXXXXXDB1 -a XXXXXXDB2 -P basic -e select -m basic -z 180 -w 5
[oracle@jdordXX2 ~]$ srvctl add service -d XXXXXXDB -s dsXX -r XXXXXXDB1 -a XXXXXXDB2 -P basic -e select -m basic -z 180 -w 5
[oracle@jdordXX2 ~]$ srvctl start service -d XXXXXXDB -s ordXX
[oracle@jdordXX2 ~]$ srvctl start service -d XXXXXXDB -s dsXX
[oracle@jdordXX2 ~]$ srvctl add service -d XXXXXXDB -s orXX -r XXXXXXDB1 -a XXXXXXDB2 -P basic -e select -m basic -z 180 -w 5
[oracle@jdordXX2 ~]$ srvctl start service -d XXXXXXDB -s orXX
[oracle@jdordXX1 ~]$ srvctl relocate service -d XXXXXXDB -s Gaoyc -i XXXXXXDB1 -t XXXXXXDB2
[oracle@jdordXX2 ~]$ srvctl add service -d XXXXXXDB -s Gaoyc -r XXXXXXDB1,XXXXXXDB2 -P basic -e select -m basic -z 180 -w 5
[oracle@jdordXX1 ~]$ srvctl add service -d XXXXXXDB -s Gaoyc -r "XXXXXXDB1,XXXXXXDB2" -a "XXXXXXDB2,XXXXXXDB1" -P basic -e select -m basic -z 180 -w 5
PRKO-2102 : Failed to create server pool XXXXXXDB_Gaoyc: PRCS-1009 : Failed to create server pool ora.XXXXXXDB_Gaoyc
PRCR-1071 : Failed to register or update server pool ora.XXXXXXDB_Gaoyc
CRS-2714: 'jdordXX2' is specified multiple times in 'SERVER_NAMES' of 'ora.XXXXXXDB_Gaoyc'
##-r引數和-a引數不允許重複
[oracle@jdordXX1 ~]$ srvctl add service -d XXXXXXDB -s Gaoyc -r "XXXXXXDB1,XXXXXXDB2" -P basic -e select -m basic -z 180 -w 5
[oracle@jdordXX1 ~]$ srvctl remove service -d XXXXXXDB -s Gaoyc
[oracle@jdordXX1 ~]$
[oracle@jdordXX1 ~]$ srvctl relocate service -h
Temporarily relocates service from one node of the cluster to another.
Usage: srvctl relocate service -d <db_unique_name> -s <service_name> {-i <old_inst_name> -t <new_inst_name> | -c <current_node> -n <target_node>} [-f]
-d <db_unique_name> Unique name for the database
-s <service> Service name
-i <old_inst> Old instance name
-t <new_inst> New instance name
-c <current_node> Node name to relocate service from
-n <target_node> Node name to relocate service to
-f Disconnect all sessions during stop or relocate service operations
-h Print usages
[grid@jdordXX1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
ora.LISTENER.lsnr
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
ora.asm
ONLINE ONLINE jdordXX1 Started
ONLINE ONLINE jdordXX2 Started
ora.gsd
OFFLINE OFFLINE jdordXX1
OFFLINE OFFLINE jdordXX2
ora.net1.network
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
ora.ons
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jdordXX1
ora.cvu
1 ONLINE ONLINE jdordXX1
ora.jdordXX1.vip
1 ONLINE ONLINE jdordXX1
ora.jdordXX2.vip
1 ONLINE ONLINE jdordXX2
ora.oc4j
1 ONLINE ONLINE jdordXX1
ora.XXXXXXDB.db
1 ONLINE ONLINE jdordXX1 Open
2 ONLINE ONLINE jdordXX2 Open
ora.XXXXXXDB.dsXX.svc
1 ONLINE ONLINE jdordXX1
ora.XXXXXXDB.ordXX.svc
1 ONLINE ONLINE jdordXX1
ora.scan1.vip
1 ONLINE ONLINE jdordXX1
[grid@jdordXX1 ~]$
[grid@jdordXX1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
ora.LISTENER.lsnr
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
ora.asm
ONLINE ONLINE jdordXX1 Started
ONLINE ONLINE jdordXX2 Started
ora.gsd
OFFLINE OFFLINE jdordXX1
OFFLINE OFFLINE jdordXX2
ora.net1.network
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
ora.ons
ONLINE ONLINE jdordXX1
ONLINE ONLINE jdordXX2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jdordXX1
ora.cvu
1 ONLINE ONLINE jdordXX1
ora.jdordXX1.vip
1 ONLINE ONLINE jdordXX1
ora.jdordXX2.vip
1 ONLINE ONLINE jdordXX2
ora.oc4j
1 ONLINE ONLINE jdordXX1
ora.XXXXXXDB.db
1 ONLINE ONLINE jdordXX1 Open
2 ONLINE ONLINE jdordXX2 Open
ora.XXXXXXDB.funtune.svc
1 ONLINE ONLINE jdordXX1
2 ONLINE ONLINE jdordXX2
ora.scan1.vip
1 ONLINE ONLINE jdordXX1
[oracle@jdordXX2 ~]$ srvctl remove service -d XXXXXXDB -s funtune
PRCR-1025 : Resource ora.XXXXXXDB.funtune.svc is still running
[oracle@jdordXX2 ~]$ srvctl stop service -d XXXXXXDB -s funtune;
[oracle@jdordXX2 ~]$ srvctl remove service -d XXXXXXDB -s funtune
[oracle@jdordXX2 ~]$ srvctl config service -d XXXXXXDB -s ordXX
Service name: ordXX
Service is enabled
Server pool: XXXXXXDB_ordXX
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Preferred instances: XXXXXXDB1
Available instances: XXXXXXDB2
[oracle@jdordXX2 ~]$ srvctl remove service -d XXXXXXDB -s ordXX
[oracle@jdordXX2 ~]$ srvctl add service -d XXXXXXDB -s ordXX -r XXXXXXDB1 -a XXXXXXDB2 -P basic -e select -m basic -z 180 -w 5
[oracle@jdordXX2 ~]$ srvctl config service -d XXXXXXDB -s ordXX
Service name: ordXX
Service is enabled
Server pool: XXXXXXDB_ordXX
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 180
TAF failover delay: 5
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Preferred instances: XXXXXXDB1
Available instances: XXXXXXDB2
好記性不如爛筆頭,方便後期檢視。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24585765/viewspace-2151772/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 11G Rac service管理Oracle
- ORACLE 11g RAC EM手動配置Oracle
- Oracle 11g RAC重新新增節點Oracle
- [zt]Oracle rac 11g線上新增ocr,votediskOracle
- Oracle RAC的自定義service自啟動Oracle
- oracle 11g RAC手動解除安裝grid,no deinstallOracle
- ORACLE RAC 手動建庫Oracle
- oracle RAC手動配置互信Oracle
- oracle 11g rac 新增重做日誌檔案Oracle
- Oracle RAC DG手動切換Oracle
- oracle 11g rac新增節點前之清除節點資訊Oracle
- Oracle RAC 手動升級 11.2.0.3.4Oracle
- 資料庫Oracle 11g RAC手動打GI PSU補丁(11.2.0.4.8)資料庫Oracle
- Oracle RAC新增節點Oracle
- Oracle RAC 新增節點Oracle
- 安裝Oracle RAC 11gOracle
- oracle 11g rac 程式理解Oracle
- Oracle 11g RAC自動打GI PSU補丁Oracle
- Oracle 11g rac 的 active dataguard的啟動步驟Oracle
- [網摘] Oracle RAC新增節點Oracle
- Oracle 11g R2手動配置EMOracle
- RAC 11g下管理Service資源並測試FailoverAI
- Oracle 11G RAC CTSS服務Oracle
- Oracle 11g修改RAC SCAN IPOracle
- Oracle 11g Rac清理指令碼Oracle指令碼
- Oracle 11g rac add nodeOracle
- Oracle 11g RAC檔案目錄Oracle
- Oracle 11g r2 racOracle
- 手動清除Oracle 10g RAC CRS的方法Oracle 10g
- 手動進行oracle rac vip 漂移的步驟 。Oracle
- 自動啟動ORACLE Script ServiceOracle
- 11G R2 RAC新增刪除節點
- 11gR2 RAC手動新增節點資料庫例項資料庫
- oracle 11g 新增控制檔案Oracle
- oracle11g RAC新增節點Oracle
- Oracle 11g RAC自動打GI PSU補丁(11.2.0.4.8)Oracle
- Oracle 11g RAC 監聽日常管理Oracle
- Oracle 11g RAC Silent Install For NFSOracleNFS