程序博客网 > 网络聊天

Oracle 11g R2 RAC：使用 srvctl 工具管理 service 资源

来源：互联网 发布：网络聊天 编辑：程序博客网 时间：2024/04/30 05:12
1、使用 srvctl 工具创建 service 资源
srvctl add service -d db_unique_name -s service_name {-r "preferred_list"   [-a "available_list"] [-P {BASIC | NONE | PRECONNECT}] | -g server_pool   [-c {UNIFORM | SINGLETON]} [-k network_number]   [-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]
Table A-17 srvctl add service Options
OptionDescription
-d db_unique_name
Unique name for the database.
-s service_name
The service_name.service_domain should be unique within the cluster unless you want to spread connections across multiple databases that offer the same service. If you do specify the service domain as part of the service name (such as sales.foo.com), then the DB_DOMAIN database attribute is appended to the service name.
-r preferred_list
A list of preferred instances on which the service runs when the database is administrator managed.
The list of preferred instances must be mutually exclusive with the list of available instances.
Note: This option is available only with Oracle RAC and only for administrator-managed databases.
-a available_list
A list of available instances to which the service fails over when the database is administrator managed.
The list of available instances must be mutually exclusive with the list of preferred instances.
Note: This option is available only with Oracle RAC and only for administrator-managed databases.
-P {BASIC | NONE | PRECONNECT}
TAF policy specification (for administrator-managed databases only).
Notes:
  • You can only use PRECONNECT when you specify the -r and -a options.
  • For administrator-managed databases, you cannot set the client-side TAF policy to PRECONNECT.
-g server_pool
The name of a server pool used when the database is policy managed.
Note: This option is available only with Oracle RAC and only for policy-managed databases.
-c {UNIFORM | SINGLETON}
The cardinality of the service, either UNIFORM (offered on all instances in the server pool) or SINGLETON (runs on only one instance at a time).
Notes:
  • This option is available only with Oracle RAC and only for policy-managed databases.
  • For policy-managed Oracle RAC One Node databases, all services must be SINGLETON.
-k network_number
Use this option to determine on which network this service is offered. The service is configured to depend on VIPs from the specified network.
Note: This option is available only with Oracle RAC and Oracle RAC One Node database configurations.
-l {[PRIMARY] |[PHYSICAL_STANDBY] |[LOGICAL_STANDBY] |[SNAPSHOT_STANDBY]}
The service role.
You use this option to indicate that the service should only be automatically started when the Oracle Data Guard database role matches one of the specified service roles.
See Also: Oracle Data Guard Concepts and Administration for more information about database roles
-y {AUTOMATIC | MANUAL}
Service management policy.
If AUTOMATIC (the default), then the service is automatically started upon restart of the database, either by a planned restart (with SRVCTL) or after a failure. Automatic restart is also subject to the service role, however (the -l option).
If MANUAL, then the service is never automatically restarted upon planned restart of the database (with SRVCTL). A MANUAL setting does not prevent Oracle Clusterware from monitoring the service when it is running and restarting it if a failure occurs.
Note: Using CRSCTL to stop and start the Oracle Clusterware restarts the service in the same way that a failure does.
-x {TRUE | FALSE}
Indicates whether or not Distributed Transaction Processing should be enabled for this service. This service will either be a singleton service in a policy-managed database or a preferred service on a single node in an administrator-managed database.
Note: This option is available only with Oracle RAC.
-j {SHORT | LONG}
Assign a connection load balancing goal to the service: SHORT if using an integrated connection pool, LONG for long running connections that you want balanced by the number of sessions per node for the service
-B {NONE | SERVICE_TIME | THROUGHPUT}
Goal for the Load Balancing Advisory.
-e {NONE | SESSION | SELECT}
Failover type.
-m {NONE | BASIC}
Failover method.
If the failover type (-e) is set to a value other than NONE, then you should choose BASIC for this option.
Note: This option is available only with Oracle RAC.
-z failover_retries
The number of failover retry attempts.
-w failover_delay
The time delay between failover attempts.
-u
Add a new preferred or available instance to an existing service configuration.
-f
Force the add operation even though a listener is not configured for the network.
示例：
[oracle@rac1 ~]$ srvctl add service -d rac -s ractest1 -r rac1 -a rac2 -P BASIC -y automatic -e SELECT -z 5 -w 180[oracle@rac1 ~]$ srvctl add service -d rac -s ractest2 -r rac2 -a rac1 -P BASIC -y automatic -e SELECT -z 5 -w 180
[oracle@rac1 ~]$ crs_stat -t -vName           Type           R/RA   F/FT   Target    State     Host        ----------------------------------------------------------------------ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora.FRA.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    rac1        ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac1        ora....N2.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac2        ora....N3.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac2        ora....VOTE.dg ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    rac1        ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    rac2        ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    rac1        ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    rac2        ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    rac1        ora.rac.db     ora....se.type 0/2    0/1    ONLINE    ONLINE    rac1        ora....st1.svc ora....ce.type 0/0    0/0    OFFLINE   OFFLINE               ora....st2.svc ora....ce.type 0/0    0/0    OFFLINE   OFFLINE               ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1        ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1        ora.rac1.gsd   application    0/5    0/0    OFFLINE   OFFLINE               ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1        ora.rac1.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac1        ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2        ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2        ora.rac2.gsd   application    0/5    0/0    OFFLINE   OFFLINE               ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2        ora.rac2.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac2        ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    rac1        ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac1        ora.scan2.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac2        ora.scan3.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac2     

2、使用 srvctl 工具启动和停止 service 资源
语法：
srvctl start service -d db_unique_name             [-s "service_name_list" [-n node_name | -i instance_name]] 
                        [-o start_options]   
Table A-121 srvctl start service Options
OptionDescription
-d db_unique_name
Unique name for the database
-s "service_name_list"
Comma-delimited list of service names.
If you do not include this option, then SRVCTL starts all of the services for the specified database.
-n node_name
The name of the node where the service should be started. Use this option for policy-managed databases.
Note: This option is available only with Oracle Clusterware.
-i instance_name
The name of the instance for which the service should be started. Use this option for administrator-managed databases.
Note: This option is available only with Oracle Clusterware.
-o start_options
Options to startup command, such as OPEN, MOUNT, or NOMOUNT
Note: For multi-word startup options, such as read only and read write, separate the words with a space and enclose in single quotation marks (''). For example, 'read only'.
See Also: SQL*Plus User's Guide and Reference for more information about startup options
示例：
[oracle@rac1 ~]$ srvctl start service -d rac -s ractest1,ractest2 -o open[oracle@rac1 ~]$ crs_stat -t -vName           Type           R/RA   F/FT   Target    State     Host        ----------------------------------------------------------------------ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora.FRA.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    rac1        ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac1        ora....N2.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac2        ora....N3.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac2        ora....VOTE.dg ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    rac1        ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    rac2        ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    rac1        ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    rac2        ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    rac1        ora.rac.db     ora....se.type 0/2    0/1    ONLINE    ONLINE    rac1        ora....st1.svc ora....ce.type 0/0    0/0    ONLINE    ONLINE    rac2        ora....st2.svc ora....ce.type 0/0    0/0    ONLINE    ONLINE    rac2        ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1        ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1        ora.rac1.gsd   application    0/5    0/0    OFFLINE   OFFLINE               ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1        ora.rac1.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac1        ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2        ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2        ora.rac2.gsd   application    0/5    0/0    OFFLINE   OFFLINE               ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2        ora.rac2.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac2        ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    rac1        ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac1        ora.scan2.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac2        ora.scan3.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac2        

srvctl stop service -d db_unique_name [-s "service_name_list"     [-n node_name | -i instance_name] [-f]
Table A-153 srvctl stop service Options
OptionDescription
-d db_unique_name
Unique name for the database
-s service_name_list
Comma-delimited list of service names enclosed in double quotation marks ("").
If you do not provide a service name list, then SRVCTL stops all services on the database.
-n node_name
The name of the node on which the services should be stopped. Use this option for policy-managed databases.
Note: This option is available only with Oracle Clusterware.
-i instance_name
The name of the instance for which the services should be stopped. Use this option for administrator-managed databases.
Note: This option is available only with Oracle Clusterware.
-f
Force SRVCTL to stop the service; this causes SRVCTL to disconnect all of the sessions transactionally, requiring the sessions using the service to reconnect and then connect to another instance.
Note: If you do not specify the -f option, then sessions already connected to this service stay connected, but new sessions cannot be established to the service.
[oracle@rac1 ~]$ srvctl stop service -d rac -s ractest1[oracle@rac1 ~]$ crs_stat -t -vName           Type           R/RA   F/FT   Target    State     Host        ----------------------------------------------------------------------ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora.FRA.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    rac1        ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac1        ora....N2.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac2        ora....N3.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac2        ora....VOTE.dg ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    rac1        ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    rac2        ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    rac1        ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    rac2        ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    rac1        ora.rac.db     ora....se.type 0/2    0/1    ONLINE    ONLINE    rac1        ora....st1.svc ora....ce.type 0/0    0/0    OFFLINE   OFFLINE               ora....st2.svc ora....ce.type 0/0    0/0    ONLINE    ONLINE    rac2        ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1        ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1        ora.rac1.gsd   application    0/5    0/0    OFFLINE   OFFLINE               ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1        ora.rac1.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac1        ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2        ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2        ora.rac2.gsd   application    0/5    0/0    OFFLINE   OFFLINE               ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2        ora.rac2.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac2        ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    rac1        ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac1        ora.scan2.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac2        ora.scan3.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac2  
[oracle@rac1 trace]$ srvctl stop service -d rac -s ractest1,ractest2[oracle@rac1 trace]$ srvctl status service -d racService ractest1 is not running.Service ractest2 is not running.
[oracle@rac1 trace]$ srvctl start service -d rac -s ractest2 -i rac1[oracle@rac1 trace]$ srvctl status service -d racService ractest1 is not running.Service ractest2 is running on instance(s) rac1
      
3、使用 srvctl 工具启用和禁用 service 资源
If you disable a service, then Oracle Clusterware does not consider the service for automatic startup, failover, or restart. You might disable a service when performing application maintenance, to ensure the service is not accidentally restarted by Oracle Clusterware until your maintenance operations are complete. To make the service available for normal operation again, you enable the service.
srvctl enable service -d db_unique_name -s "service_name_list"     [-i instance_name | -n node_name]
Table A-55 srvctl enable service Options
OptionDescription
-d db_unique_name
Unique name for the database
-s service_name_list
Comma-delimited list of service names
-i instance_name
Name of the database instance where you want the service to run
Use this option for administrator-managed databases
Note: This option is available only with Oracle Clusterware and Oracle RAC.
-n node_name
Name of the node where you want the service to run
Use this option for policy-managed databases
Note: This option is available only with Oracle Clusterware and Oracle RAC.
srvctl disable service -d db_unique_name      -s "service_name_list" [-i instance_name | -n node_name]
Table A-41 srvctl disable service Options
OptionDescription
-d db_unique_name
Unique name for the database
-s "service_name_list"
Comma-delimited list of service names, or a single service name
-i instance_name
The name of the instance that you want to disable the service for.
Note: Use this option with administrator-managed databases
Note: This option is available only with Oracle Clusterware and Oracle RAC.
-n node_name
The name of the node on which to disable the service
Note: Use this option with policy-managed databases
Note: This option is available only with Oracle Clusterware and Oracle RAC.
4、使用 srvctl 工具查看 service 资源的状态
srvctl status service -d db_unique_name [-s "service_name_list"] [-f] [-v]
Table A-137 srvctl status service Options
OptionDescription
-d db_unique_name
Unique name for the database
-s "service_name_list"
Comma-delimited list of service names.
If you do not specify this option, then the utility lists the status of all the services for the specified database.
-f
Include disabled applications
-v
Displays INTERNAL_STATE, which indicates actions in progress by Oracle Clusterware, such as starting, stopping, or cleaning. If the internal state is STABLE, then the -v option displays nothing because this is the normal state. Additionally, the -v option displays STATE_DETAILS, which may indicate additional information provided by the resource about why it is in its current state.
[oracle@rac1 ~]$ srvctl status service -d rac -s ractest1Service ractest1 is running on instance(s) rac2[oracle@rac1 ~]$ srvctl status service -d rac -s ractest1 -vService ractest1 is running on instance(s) rac2[oracle@rac1 ~]$ srvctl status service -d rac -vService ractest1 is running on instance(s) rac2Service ractest2 is running on instance(s) rac2
5、使用 srvctl 工具 relocate service 资源
语法：
srvctl relocate service -d db_unique_name -s service_name    {-c source_node -n target_node | -i old_instance_name -t new_instance_name}    [-f]
Table A-89 srvctl relocate service Options
OptionDescription
-d db_unique_name
Unique name for the database
-s service_name
Service name
-c source_node
Name of the node where the service is currently running
-n target_node
Name of node where the service should be relocated
-i old_instance_name
Old instance name
-t new_instance_name
New instance name
-f
Disconnect all sessions during stop or relocate service operations
[oracle@rac1 ~]$ srvctl status service -d rac -vService ractest1 is running on instance(s) rac2Service ractest2 is running on instance(s) rac2
[oracle@rac1 trace]$ srvctl relocate service -d rac -s ractest1 -i rac2 -t rac1
[oracle@rac1 trace]$ srvctl status service -d racService ractest1 is running on instance(s) rac1Service ractest2 is running on instance(s) rac2
6、使用 srvctl 工具删除 service 资源
语法：
srvctl remove service -d db_unique_name -s service_name [-i instance_name] [-f]
Table A-100 srvctl remove service Options
OptionsDescription
-d db_unique_name
Unique name for the database
-s service_name
Service name
-i instance_name
Instance name
Note: This option is available only for Oracle Clusterware.
-f
Removes the service resource even though the service is running
示例：
[oracle@rac1 trace]$ srvctl status service -d racService ractest1 is not running.Service ractest2 is running on instance(s) rac1
[oracle@rac1 trace]$ srvctl remove service -d rac -s ractest1
[oracle@rac1 trace]$ srvctl status service -d racService ractest2 is running on instance(s) rac1
在 service 正在 running 时强制删除 service
[oracle@rac1 trace]$ crs_stat -t -vName           Type           R/RA   F/FT   Target    State     Host        ----------------------------------------------------------------------ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora.FRA.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    rac1        ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac1        ora....N2.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac2        ora....N3.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac2        ora....VOTE.dg ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    rac1        ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    rac2        ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    rac1        ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    rac2        ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    rac1        ora.rac.db     ora....se.type 0/2    0/1    ONLINE    ONLINE    rac1        ora....st2.svc ora....ce.type 0/0    0/0    ONLINE    ONLINE    rac1        ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1        ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1        ora.rac1.gsd   application    0/5    0/0    OFFLINE   OFFLINE               ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1        ora.rac1.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac1        ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2        ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2        ora.rac2.gsd   application    0/5    0/0    OFFLINE   OFFLINE               ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2        ora.rac2.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac2        ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    rac1        ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac1        ora.scan2.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac2        ora.scan3.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac2        [oracle@rac1 trace]$ srvctl status service -d racService ractest2 is running on instance(s) rac1[oracle@rac1 trace]$ srvctl remove service -d rac -s ractest2 -f
[oracle@rac1 trace]$ srvctl remove service -d rac -s ractest2 -f[oracle@rac1 trace]$ crs_stat -t -vName           Type           R/RA   F/FT   Target    State     Host        ----------------------------------------------------------------------ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora.FRA.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    rac1        ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac1        ora....N2.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac2        ora....N3.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac2        ora....VOTE.dg ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    rac1        ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    rac2        ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    rac1        ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    rac2        ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    rac1        ora.rac.db     ora....se.type 0/2    0/1    ONLINE    ONLINE    rac1        ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1        ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1        ora.rac1.gsd   application    0/5    0/0    OFFLINE   OFFLINE               ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1        ora.rac1.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac1        ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2        ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2        ora.rac2.gsd   application    0/5    0/0    OFFLINE   OFFLINE               ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2        ora.rac2.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac2        ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    rac1        ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac1        ora.scan2.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac2        ora.scan3.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac2        
7、使用 srvctl 工具查看 service 资源的配置信息
语法：
srvctl config service -d db_unique_name [-s service_name]
Table A-27 srvctl config service Options
OptionDescription
-d db_unique_name
Unique name for the database
-s service_name
Service name.
If this option is not specified, then the configuration information for all services configured for the database are displayed.
[oracle@rac1 trace]$ srvctl config service -d rac -s ractest1Service name: ractest1Service is enabledServer pool: rac_ractest1Cardinality: 1Disconnect: falseService role: PRIMARYManagement policy: AUTOMATICDTP transaction: falseAQ HA notifications: falseFailover type: SELECTFailover method: NONETAF failover retries: 5TAF failover delay: 180Connection Load Balancing Goal: LONGRuntime Load Balancing Goal: NONETAF policy specification: BASICEdition: Preferred instances: rac1Available instances: rac2
转载请注明作者出处及原文链接，否则将追究法律责任：
作者：xiangsir
原文链接：http://blog.csdn.net/xiangsir/article/details/9972975
QQ：444367417
MSN：xiangsir@hotmail.com
	
				
		









 网络聊天
    		网络聊天



原创粉丝点击



		

热门IT博客


淘宝怎么发布定制宝贝淘宝怎么发布定制宝贝




林冲和关胜谁厉害 知乎林冲和关胜谁厉害 知乎




淘宝客服用什么软件




一千零一夜 淘宝 出品




域名更换 搜索引擎




图解网络硬件下载




arm linux ar




中山大学端口聚合实验




sai绘图软件下载mac




编程和软件开发




淘宝洗车器




淘宝店铺教程




保定进销存软件




阀门保温计算软件




win7部分软件无法安装




java标识符的命名测试




mysql主键自增insert




人工智能 研究报告




宁夏膏药猜一网络用语




世界上第三位程序员



		

热门问题
    老师的惩罚
    人脸识别
    我在镇武司摸鱼那些年
    重生之率土为王
    我在大康的咸鱼生活
    盘龙之生命进化
    天生仙种
    凡人之先天五行
    春回大明朝
    姑娘不必设防，我是瞎子
    pe膜收缩包装机械
    收缩包装膜厂家
    血管收缩剂滴鼻液
    血块收缩时间
    可以收缩的床
    肌肉收缩过程
    高收缩涤纶纤维
    hgm高强无收缩灌浆料
    收缩包装机厂家
    怎么收缩骨盆
    肌肉收缩的过程
    心尖部收缩期杂音
    收缩包装加工
    收毛孔面膜
    缩毛孔的护肤品
    缩毛孔的产品
    细致毛孔护肤品排行
    缩小毛孔方法
    收敛毛孔的产品
    怎么可以缩小毛孔
    股四头肌等长收缩
    萝莉肉核花瓣粉嫩收缩
    怎样有助于阴道收缩
    一侧胸锁乳突肌收缩
    收售银行卡群
    收腰羽绒服
    收腰蓬蓬裙
    收腰纽扣
    收腰
    收腰连衣裙
    怎么收腰
    裤子收腰针法
    如何减腰
    怎样廋腰
    怎么锻炼瘦腰
    怎样快速瘦腰
    瘦腰软件
    瘦腰瘦肚子的方法
    减肥瘦身腰带有用吗
    怎么快速瘦腰
    瘦腰两侧


	










程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里