3 Replies Latest reply: Dec 4, 2012 8:35 AM by Victor Armbrust RSS

    Modify instance number

    Alecsel
      Hi all,

      I have a 11.2 cluster with two nodes and i recently created a new serverpool and added the two nodes.
      After this the status command identifies the first instance as being on the second node.
      Is there a way to change this?

      $crsctl status resource ora.bula.db -t

      --------------------------------------------------------------------------------
      NAME TARGET STATE SERVER STATE_DETAILS
      --------------------------------------------------------------------------------
      Cluster Resources
      --------------------------------------------------------------------------------
      ora.bula.db
      *1* ONLINE ONLINE rac21 Open
      2 ONLINE ONLINE rac11 Open


      $ crsctl status serverpool ora.sp1 -f
      NAME=ora.sp1
      IMPORTANCE=1
      MIN_SIZE=0
      MAX_SIZE=10
      SERVER_NAMES=
      PARENT_POOLS=
      EXCLUSIVE_POOLS=
      ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
      ACTIVE_SERVERS=rac11 rac21
        • 1. Re: Modify instance number
          879560
          With 11.2, RAC Database has 2 type : Admin-Manage and Policy manage. You can configure policy manage database to run in a server pool. You can set the amount of db instance will run in this server pool (Resource atribute candiality) . You can manual re allocate instance from one server to another server in server pool.
          • 2. Re: Modify instance number
            Alecsel
            It's strange, because the following select statement returns the correct instance number for the first server.

            select * from v$active_instances;
            INST_NUMBER INST_NAME
            ---------------------- ------------------------------------------------------------
            1 rac11:bula1
            2 rac21:bula2

            It seems that $crsctl status resource ora.bula.db -t returns wrong instance number, or maybe that number is not the instance number (can't find anything in the documentation about it).
            • 3. Re: Modify instance number
              Victor Armbrust
              You can change your configuration using srvctl command and make a "restart" of your database instance:

              eg:
              srvctl modify instance bula1 -n rac11
              srvctl modify instance bula2 -n rac21

              srvctl stop database -d bula
              srvctl start database -d bula

              You can also use options like "-o" on your modify instance command, if you want to.

              Victor