Oracle11gRAC如何手動(dòng)添加service

這篇文章給大家介紹Oracle 11g RAC如何手動(dòng)添加service，內(nèi)容非常詳細(xì)，感興趣的小伙伴們可以參考借鑒，希望對(duì)大家能有所幫助。

成都創(chuàng)新互聯(lián)公司專注于上思企業(yè)網(wǎng)站建設(shè),響應(yīng)式網(wǎng)站設(shè)計(jì),電子商務(wù)商城網(wǎng)站建設(shè)。上思網(wǎng)站建設(shè)公司,為上思等地區(qū)提供建站服務(wù)。全流程按需定制設(shè)計(jì)，專業(yè)設(shè)計(jì)，全程項(xiàng)目跟蹤，成都創(chuàng)新互聯(lián)公司專業(yè)和態(tài)度為您提供的服務(wù)

11.2.0.4 RAC

dbname:XXXXXXDB

添加服務(wù)：
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參數(shù)和-a參數(shù)不允許重復(fù)
[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

關(guān)于Oracle 11g RAC如何手動(dòng)添加service就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，可以學(xué)到更多知識(shí)。如果覺得文章不錯(cuò)，可以把它分享出去讓更多的人看到。

網(wǎng)頁標(biāo)題：Oracle11gRAC如何手動(dòng)添加service
分享URL：http://muchs.cn/article46/pdgehg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供建站公司、微信小程序、網(wǎng)站排名、電子商務(wù)、靜態(tài)網(wǎng)站、軟件開發(fā)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)