This discussion is archived
3 Replies Latest reply: Dec 4, 2012 6:35 AM by Victor Armbrust RSS

Modify instance number

Alecsel Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points