求cluster3.2 下oracle自动启动配置

bosshoss_cn

看了半天的sun文档，没看懂，请各位大佬们指点

bosshoss_cn

clresourcegroup create -n csdb1,csdb2 -p failback=true \
-p rg_description="Logical hostname csdb1 RG" cs_rac1_sh_rg

clresourcegroup create -n csdb2,csdb1 -p failback=true \
-p rg_description="Logical hostname csdb2 RG" cs_rac2_sh_rg

clreslogicalhostname create -h cs_rac1_sh -g cs_rac1_sh_rg cs_rac1_sh
clreslogicalhostname create -h cs_rac2_sh -g cs_rac2_sh_rg cs_rac2_sh


clresourcegroup create -S -p rg_affinities=++cs_rac_rg \
-p rg_description="RAC 9i server and listener RG" cs_rac_db_rg

clresourcetype register SUNW.scalable_rac_listener

clresource create -g cs_rac_db_rg -t SUNW.scalable_rac_listener \
-p listener_name\{csdb1\}=csdb1 -p listener_name\{csdb2\}=csdb2 \
-p oracle_home=/oracle/app/oracle/product/9.2.0 scalable_rac_listener_rs

clresourcetype register SUNW.scalable_rac_server




这一条走不下去了
clresource create -g cs_rac_db_rg -t SUNW.scalable_rac_server \
-p resource_dependencies=rac-framework-rs,rac-svm-rs \
-p resource_dependencies_weak=scalable_rac_listener_rs \
-p oracle_home=/oracle/app/oracle/product/9.2.0 \
-p connect_string=oracle/hehehe \
-p oracle_sid\{csdb1\}=csdb1 \
-p oracle_sid\{csdb2\}=csdb2 \
-p alert_log_file\{csdb1\}=/oracle/app/oracle/product/9.2.0/rdbms/log/alert_csdb1.log \
-p alert_log_file\{csdb2\}=/oracle/app/oracle/product/9.2.0/rdbms/log/alert_csdb2.log \
scalable_rac_server-rs

[ 本帖最后由 bosshoss_cn 于 2008-12-2 19:13 编辑 ]

bosshoss_cn

scstat 状态：
# scstat
------------------------------------------------------------------

-- 群集节点 --

                    节点名称            状态
                    --------            ----
群集节点：          csdb1               联机
群集节点：          csdb2               联机

------------------------------------------------------------------

-- 群集传输路径 --

                    端点                   端点                   状态
                    ----                   ----                   ----
传输路径：          csdb1:ce1              csdb2:ce1              Path online
传输路径：          csdb1:ce0              csdb2:ce0              Path online

------------------------------------------------------------------

-- 法定摘要 --

可能的法定选票：              3
所需的法定选票：              2
现有的法定选票：              3


-- 按节点计算的法定选票 --

                    节点名称            现有的  可能的   状态
                    --------            ------  ------   ----
节点选票：          csdb1               1        1       联机
节点选票：          csdb2               1        1       联机


-- 按设备计算的法定选票 --

                    设备名称            现有的  可能的   状态
                    --------            ------  ------   ----
设备选票：          /dev/did/rdsk/d6s2  1        1       联机

------------------------------------------------------------------

-- 设备组服务器 --

                         设备组              主                  辅助
                         ------              --                  ----


-- 设备组状态 --

                              设备组              状态               
                              ------              ----               


-- 多所有者设备组 --

                              设备组              联机状态
                              ------              --------
  多所有者设备组：            csracdg             csdb1,csdb2

------------------------------------------------------------------

-- 资源组和资源 --

            组名称         资源
            ------         ----
资源：      cs_rac_rg      rac-framework-rs rac-udlm-rs rac-svm-rs
资源：      cs_rac1_sh_rg  -
资源：      cs_rac2_sh_rg  -
资源：      cs_rac_db_rg   scalable_rac_listener_rs


-- 资源组 --

            组名称         节点名称                 状况           已暂停
            ------         --------                 ----           ------
组：        cs_rac_rg      csdb1                    联机           否
组：        cs_rac_rg      csdb2                    联机           否

组：        cs_rac1_sh_rg  csdb1                    未被管理       否
组：        cs_rac1_sh_rg  csdb2                    未被管理       否

组：        cs_rac2_sh_rg  csdb2                    未被管理       否
组：        cs_rac2_sh_rg  csdb1                    未被管理       否

组：        cs_rac_db_rg   csdb1                    未被管理       否
组：        cs_rac_db_rg   csdb2                    未被管理       否


-- 资源 --

            资源名称       节点名称                 状况           状态消息
            --------       --------                 ----           --------
资源:       rac-framework-rs csdb1                    联机           联机
资源:       rac-framework-rs csdb2                    联机           联机

资源:       rac-udlm-rs    csdb1                    联机           联机
资源:       rac-udlm-rs    csdb2                    联机           联机

资源:       rac-svm-rs     csdb1                    联机           联机
资源:       rac-svm-rs     csdb2                    联机           联机

资源:       scalable_rac_listener_rs csdb1                    脱机           脱机
资源:       scalable_rac_listener_rs csdb2                    脱机           脱机

------------------------------------------------------------------

-- IPMP 组 --

              节点名称            组      状态           适配器    状态
              --------            --      ----           ------    ----
IPMP 组：     csdb1               sc_ipmp0 联机           ge0       联机
IPMP 组：     csdb1               sc_ipmp0 联机           eri0      联机

IPMP 组：     csdb2               sc_ipmp0 联机           ge0       脱机
IPMP 组：     csdb2               sc_ipmp0 联机           eri0      联机

bosshoss_cn

找到资料了
做好了
呵呵
How to Automate the Startup and Shutdown of Oracle 9i RAC Database Instances
Before You Begin

Ensure that the following prerequisites are met:

    *

      The RAC framework resource group is created and is online.
    *

      Storage resources for Oracle files are configured.
    *

      The Oracle RAC software is installed.
    *

      Node-specific files and directories for a shared file system are created.
    *

      The installation of the Oracle RAC software is verified.
    *

      The Oracle database is created.

Ensure that you have the following information:

    *

      The full path to the Oracle home directory
    *

      The Oracle system identifier (SID) for each instance of the database for which you are configuring resources
    *

      The names of all Sun Cluster storage resources for Oracle files that you are using
    *

      The logical hostnames, or the names of the logical hostname resources, that you are using for Oracle listeners

   1.

      On one node of the cluster, become superuser.
   2.

      Start the clsetup utility.

      # clsetup

      The clsetup main menu is displayed.
   3.

      Type the number that corresponds to the option for data services and press Return.

      The Data Services menu is displayed.
   4.

      Type the number that corresponds to the option for configuring Sun Cluster Support for Oracle RAC and press Return.

      The clsetup utility displays information about Sun Cluster Support for Oracle RAC.
   5.

      Press Return to continue.

      The clsetup utility prompts you to select whether you are performing the initial configuration of Sun Cluster Support for Oracle RAC or administering an existing configuration.
   6.

      Type the number that corresponds to the option for performing the initial configuration of Sun Cluster Support for Oracle RAC and press Return.

      The clsetup utility displays a list of components of Oracle RAC to configure.
   7.

      Type the number that corresponds to the option for resources for Oracle RAC database instances and press Return.

      The clsetup utility displays the list of prerequisites for performing this task.
   8.

      Verify that the prerequisites are met, and press Return.

      The clsetup utility displays a list of versions of Oracle that you can configure by using this utility.
   9.

      Type the number that corresponds to the option for Oracle 9i and press Return.
  10.

      Type the number that corresponds to the option to configure both the listener and the server.

      The clsetup utility displays a list of Oracle home directories that exist on the cluster.
  11.

      Specify the Oracle home directory for your installation of the Oracle RAC software.
          *

            If the directory is listed, type the number that corresponds to the directory that you are selecting and press Return.

            The clsetup utility displays a list of Oracle system identifiers that are configured on the cluster. The utility also prompts you to specify the system identifier for the first node in the list of nodes where Oracle RAC is to run.
          *

            If the directory is not listed, specify the directory explicitly:
               1.

                  Type e and press Return.

                  The clsetup utility prompts you for the Oracle home directory.
               2.

                  Type the full path to the Oracle home directory and press Return.

                  The clsetup utility displays a list of Oracle system identifiers that are configured on the cluster. The utility also prompts you to specify the system identifier for the first node in the list of nodes where Oracle RAC is to run.
  12.

      Specify the Oracle SID of the Oracle RAC database instance for the node that you are configuring.

      The wizard prompts you to perform this step for each node in the list of nodes where Oracle RAC is to run.
      Note –

      You must specify a unique Oracle SID for each node. If you specify a duplicate SID, the clsetup utility warns you that the SID is a duplicate and prompts you to specify the SID again.
          *

            If the SID is listed, type the number that corresponds to the SID that you are selecting and press Return.

            The clsetup utility displays the values of properties for the node of the Sun Cluster resources that the utility will create.
          *

            If the SID is not listed, specify the SID explicitly.
               1.

                  Type e and press Return.

                  The clsetup utility prompts you for the SID.
               2.

                  Type the SID and press Return.

                  The clsetup utility displays the values of properties for the node of the Sun Cluster resources that the utility will create.
  13.

      If you require a different value for any Sun Cluster resource properties, change each property as follows.

      The wizard prompts you to perform this step for each node in the list of nodes where Oracle RAC is to run.
         1.

            Type the number that corresponds to the property that you are changing and press Return.

            The clsetup utility displays a screen where you can specify the new value.
         2.

            At the New Value prompt, type the new value and press Return.

            The clsetup utility returns you to the values of properties for the node.
         3.

            To confirm your selection of Sun Cluster resource properties, press Return.

            The response of the clsetup utility depends on whether you have specified the Sun Cluster resource properties for all nodes where Oracle RAC is to run.
                *

                  If you have not specified Sun Cluster resource properties for all nodes, the clsetup utility prompts you to specify the system identifier for the next node in the list of nodes.
                *

                  If you have specified the Sun Cluster resource properties for all nodes, the clsetup utility displays a list of logical hostname resources that are configured.
  14.

      Configure a logical hostname resource for each node where Oracle RAC is to run.

      The Oracle listener uses the logical hostname resource for a node to connect to the Oracle RAC database instance on the node.

      The wizard prompts you to perform this step for each node in the list of nodes where Oracle RAC is to run.
          *

            If the logical hostname resource is listed, type the number that corresponds to the resource that you are selecting and press Return.

            The response of the clsetup utility depends on whether you have configured a logical hostname resource for all nodes where Oracle RAC is to run.
                o

                  If you have not configured a resource for all nodes, the clsetup utility prompts you to configure a resource for the next node.
                o

                  If you have configured a resource for all nodes, the clsetup utility displays a list of Sun Cluster storage resources for Oracle files that are configured. For information about these resources, see Registering and Configuring Storage Resources for Oracle Files.
          *

            If the logical hostname resource is not listed, create the resource as follows:
               1.

                  Type c and press Return.

                  The clsetup utility prompts you for the logical hostname that the resource is to make available.
          *

            Type the logical hostname and press Return.

            The clsetup utility returns you to the list of logical hostname resources. An entry for the logical hostname resource that the wizard will create is added to the list.
          *

            Type the number that corresponds to the resource that you are creating and press Return.

            The response of the clsetup utility depends on whether you have configured a logical hostname resource for all nodes where Oracle RAC is to run.
                o

                  If you have not configured a resource for all nodes, the clsetup utility prompts you to configure a resource for the next node.
                o

                  If you have configured a resource for all nodes, the clsetup utility displays a list of Sun Cluster storage resources for Oracle files that are configured. For information about these resources, see Registering and Configuring Storage Resources for Oracle Files.
  15.

      Type a comma-separated or space-separated list of the numbers that correspond to the storage resources that you are using, and press Return.

      The clsetup utility displays the names of the Sun Cluster objects that the utility will create.
  16.

      If you require a different name for any Sun Cluster objects, change each name as follows.
         1.

            Type the number that corresponds to the name that you are changing and press Return.

            The clsetup utility displays a screen where you can specify the new name.
         2.

            At the New Value prompt, type the new name and press Return.

      The clsetup utility returns you to the list of the names of the Sun Cluster objects that the utility will create.
  17.

      To confirm your selection of Sun Cluster object names, press Return.

      The clsetup utility displays information about the Sun Cluster configuration that the utility will create.
  18.

      To create the configuration, type c and Press Return.

      The clsetup utility displays a progress message to indicate that the utility is running commands to create the configuration. When configuration is complete, the clsetup utility displays the commands that the utility ran to create the configuration.
  19.

      Press Return to continue.

      The clsetup utility returns you to the list of options for configuring Sun Cluster Support for Oracle RAC.
  20.

      (Optional) Type q and press Return repeatedly until you quit the clsetup utility.

Resource Configuration

bosshoss_cn

>>> Review Sun Cluster Resource Properties <<<

    The Oracle properties must uniquely identify the database instance on each
    node. Therefore, you must specify the values for the oracle properties on
    each node individually.

    The wizard will assign values to the following properties of the Sun
    Cluster resources that the wizard will create. The following values will be
    used for node "csdb1".

    Select the property that you are changing:

          Property Name             Current Setting
          =============             ===============
        1) Alert_log_file           /oracle/app/oracle/product/9.2.0/rdbms/lo...
        2) Connect_string           .
        3) Parameter_file           /oracle/app/oracle/product/9.2.0/dbs/init...
        4) Custom_action_file
        5) Server:User_env
        6) Serverebug_level       1
        7) Listener_name            LISTENER
         Listener:User_env

        d) Done
        ?) Help

    Option:  2