Scribd Logo
Upload

Welcome to Scribd!

  • 79 views

    Administration Activities 2: - Relocating Services

    Uploaded by

    naresh
    The document summarizes administration activities on an Oracle Real Application Clusters (RAC) database: - It relocates a service to a different instance, brings the cluster down by stopping processes, and then restarts the cluster processes. - It deletes a service, modifies the configuration of a service, and adds instances to the preferred list of a service.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Administration Activities 2: - Relocating Services

    Uploaded by

    naresh
    79 views6 pages
    The document summarizes administration activities on an Oracle Real Application Clusters (RAC) database: - It relocates a service to a different instance, brings the cluster down by stopping processes, and then restarts the cluster processes. - It deletes a service, modifies the configuration of a service, and adds instances to the preferred list of a service.

    Original Description:

    ok

    Original Title

    oracle_rac_commadns

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document summarizes administration activities on an Oracle Real Application Clusters (RAC) database: - It relocates a service to a different instance, brings the cluster down by stopping processes, and then restarts the cluster processes. - It deletes a service, modifies the configuration of a service, and adds instances to the preferred list of a service.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    79 views6 pages

    Administration Activities 2: - Relocating Services

    Uploaded by

    naresh
    The document summarizes administration activities on an Oracle Real Application Clusters (RAC) database: - It relocates a service to a different instance, brings the cluster down by stopping processes, and then restarts the cluster processes. - It deletes a service, modifies the configuration of a service, and adds instances to the preferred list of a service.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 6

    6.

    Administration Activities 2

    - Relocating services

    [oracle@RAC1 ~]$ srvctl relocate service -d RACDB -s SERVICE2 -i RACDB1 -t RACDB2


    [oracle@RAC1 ~]$ srvctl status service -d RACDB -s SERVICE2
    Service SERVICE2 is running on instance(s) RACDB2

    - Bringing cluster down

    [root@RAC1 oracle]# crsctl stop cluster -all

    CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'

    CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'

    CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'rac1'

    CRS-2673: Attempting to stop 'ora.cvu' on 'rac1'

    CRS-2673: Attempting to stop 'ora.oc4j' on 'rac1'

    CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'rac1'

    CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'

    CRS-2673: Attempting to stop 'ora.racdb.all.svc' on 'rac1'

    [root@RAC1 oracle]# ps -ef | grep grid

    root 2449 1 0 08:19 ? 00:00:13 /grid/home/11.2.0/grid/bin/ohasd.bin reboot

    oracle 2879 1 0 08:19 ? 00:00:05 /grid/home/11.2.0/grid/bin/oraagent.bin

    oracle 2891 1 0 08:19 ? 00:00:00 /grid/home/11.2.0/grid/bin/mdnsd.bin

    oracle 2901 1 0 08:19 ? 00:00:01 /grid/home/11.2.0/grid/bin/gpnpd.bin

    oracle 2912 1 0 08:19 ? 00:00:05 /grid/home/11.2.0/grid/bin/gipcd.bin

    root 2914 1 0 08:19 ? 00:00:12 /grid/home/11.2.0/grid/bin/orarootagent.bin

    root 2929 1 1 08:19 ? 00:00:29 /grid/home/11.2.0/grid/bin/osysmond.bin

    root 3079 1 0 08:20 ? 00:00:11 /grid/home/11.2.0/grid/bin/ologgerd -M -d


    /grid/home/11.2.0/grid/crf/db/rac1

    root 4686 4513 0 08:47 pts/0 00:00:00 grep grid

    [root@RAC1 oracle]# crsctl stop crs


    Oracle 11gR2 Real Application Clusters(RAC)
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'

    CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'

    CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'

    CRS-2673: Attempting to stop 'ora.oc4j' on 'rac1'

    [root@RAC1 oracle]# ps -ef | grep grid

    root 5829 4513 0 08:53 pts/0 00:00:00 grep grid

    [root@RAC1 oracle]# ps -ef | grep oracle

    root 4316 2285 0 08:38 ? 00:00:00 sshd: oracle [priv]

    oracle 4318 4316 0 08:38 ? 00:00:00 sshd: oracle@pts/0

    oracle 4319 4318 0 08:38 pts/0 00:00:00 -bash

    root 5834 4513 0 08:53 pts/0 00:00:00 grep oracle

    - Starting cluster

    [root@RAC1 oracle]# crsctl start cluster -all

    CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'

    CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac2'

    CRS-2676: Start of 'ora.cssdmonitor' on 'rac2' succeeded

    CRS-2672: Attempting to start 'ora.cssd' on 'rac2'

    CRS-2672: Attempting to start 'ora.diskmon' on 'rac2'

    CRS-2676: Start of 'ora.diskmon' on 'rac2' succeeded

    CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded

    CRS-2672: Attempting to start 'ora.cssd' on 'rac1'

    CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'

    CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded

    [root@RAC1 oracle]# crsctl start crs

    CRS-4123: Oracle High Availability Services has been started.


    Oracle 11gR2 Real Application Clusters(RAC)

    - deleting services

    $ srvctl status service -d RACDB -s SERVICE2


    Service SERVICE2 is running on instance(s) RACDB2
    $ srvctl stop service -d RACDB -s SERVICE2
    $ srvctl config service -d RACDB -s SERVICE2
    Service name: SERVICE2
    Service is enabled
    Server pool: RACDB_SERVICE2
    Cardinality: 1
    Disconnect: false
    Service role: PRIMARY
    Management policy: AUTOMATIC
    DTP transaction: false
    AQ HA notifications: false
    Failover type: SESSION
    Failover method: BASIC
    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: RACDB2
    Available instances: RACDB1
    $ srvctl remove service -d RACDB -s SERVICE2
    $srvctl status service -d RACDB -s SERVICE2
    PRCR-1001 : Resource ora.racdb.service2.svc does not exist

    - Modifying services

    $ srvctl config service -d RACDB -s SERVICE2


    Service name: SERVICE2
    Service is enabled
    Server pool: RACDB_SERVICE2
    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
    Oracle 11gR2 Real Application Clusters(RAC)
    TAF failover delay: 0
    Connection Load
    Balancing Goal:
    LONG Runtime
    Load Balancing
    Goal: NONE TAF
    policy specification:
    NONE
    Edition:
    Preferred
    instances
    : RACDB2
    Available
    instances
    : RACDB1
    $srvctl modify service -d RACDB -s SERVICE2 -P BASIC -m basic -e session

    $ srvctlconfig service -d
    RACDB -s
    SERVICE2
    Service name:
    SERVICE2
    Service is enabled
    Server
    pool:
    RACDB_SE
    RVICE2
    Cardinality
    :1
    Dis
    co
    nn
    ect
    :
    fal
    se
    Se
    rvi
    ce
    rol
    e:
    PR
    IM
    AR
    Y
    Management
    policy:
    AUTOMATIC
    DTP
    transaction:
    false
    AQ
    HA
    notific
    ations
    : false
    Failov
    er
    type:
    SESSI
    ON
    Failov
    er
    meth
    od:
    BASIC
    TAF
    failov
    er
    retrie
    s: 0
    TAF
    failov
    er
    delay:
    0
    Connection Load
    Balancing Goal:
    LONG Runtime
    Load Balancing
    Goal: NONE TAF
    policy specification:
    BASIC
    Edition:
    Preferred
    instances
    : RACDB2
    Available
    instances
    : RACDB1
    [oracle@RAC1 ~]$ srvctl modify service -d RACDB -s ALL -i
    RACDB1 -a RACDB2 -n [oracle@RAC1 ~]$
    [oracle@RAC1 ~]$ srvctl config
    service -d RACDB -s ALL Service
    name: ALL
    Servi
    ce is
    enab
    led
    Serv
    er
    pool:
    RAC
    DB_
    ALL
    Card
    inalit
    y: 1
    Disc
    onne
    ct:
    false
    Servi
    ce
    role:
    PRI
    MAR
    Y
    Management
    policy:
    AUTOMATIC
    DTP
    transaction:
    false
    AQ HA notifications: false Failover type: NONE Failover method: NONE TAF failover retries: 0

    You might also like