DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: identifying instance from shared spfile in RAC

  1. #1
    Join Date
    Jan 2001
    Posts
    2,828

    identifying instance from shared spfile in RAC

    In a single instance database when i issue the startup command the oracle software will read a
    instance specific init.ora file and bring up a instance

    what happens when there is shared spfile file with entries like this in case of RAC

    rac1.instance_number=1
    rac2.instance_number=2

    and when i say

    srvctl start instance -i rac1 how will oracle know which instance is rac1 as the instance specific spfile is no longer there

    regards
    Hrishy

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I dont really understand what do you mean, may be yoou want to do crs_stat -p and your instance resource

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    it reads the rac1 entries from shared spfile

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    I am sorry if my post is not clear.

    What i meant in the shared spfile it has entries like

    rac1.instance_number=1
    rac2.instance_number=2

    but the rac1 might be hosted on a server called madonna and rac2 might be hosted on a server called Ritchie

    when i issue a command like

    srvctl start instance -i rac1

    How does it know that the instance rac1 has to be started on the server madonna ? Where is this information stored ?

    regards
    Hrishy

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    have you tried crs_stat -p as I mentioned?

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Pando

    I dont have a RAC instance with me.

    This doubt came up when i was reading something on shared spfile storage

    regards
    Hrishy

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    because when you create the services you tell it which node rac1 belongs to

  8. #8
    Join Date
    Nov 2001
    Posts
    335
    Each node can have local init.ora initdb1.ora or initdb2.ora file in $ORACLE_HOME/dbs as always . This files will point to the shared file system where spfile is stored:
    spfile='/u01/oradata/db/spfiledb.ora

    When you issue your startup command from your ORACLE_SID will link you to the proper init.ora file and will lead to the spfile
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Code:
    $ORA_CRS_HOME/bin/crs_stat -p ora.bsp.bsp1.inst
    NAME=ora.bsp.bsp1.inst
    TYPE=application
    ACTION_SCRIPT=/u01/app/oracle/product/10.2.0/db/bin/racgwrap
    ACTIVE_PLACEMENT=0
    AUTO_START=1
    CHECK_INTERVAL=600
    DESCRIPTION=CRS application for Instance
    FAILOVER_DELAY=0
    FAILURE_INTERVAL=0
    FAILURE_THRESHOLD=0
    HOSTING_MEMBERS=oex1
    OPTIONAL_RESOURCES=
    PLACEMENT=restricted
    REQUIRED_RESOURCES=ora.oex1.ASM1.asm
    RESTART_ATTEMPTS=5
    SCRIPT_TIMEOUT=600
    START_TIMEOUT=0
    STOP_TIMEOUT=0
    UPTIME_THRESHOLD=7d
    USR_ORA_ALERT_NAME=
    USR_ORA_CHECK_TIMEOUT=0
    USR_ORA_CONNECT_STR=/ as sysdba
    USR_ORA_DEBUG=0
    USR_ORA_DISCONNECT=false
    USR_ORA_FLAGS=
    USR_ORA_IF=
    USR_ORA_INST_NOT_SHUTDOWN=
    USR_ORA_LANG=
    USR_ORA_NETMASK=
    USR_ORA_OPEN_MODE=
    USR_ORA_OPI=false
    USR_ORA_PFILE=
    USR_ORA_PRECONNECT=none
    USR_ORA_SRV=
    USR_ORA_START_TIMEOUT=0
    USR_ORA_STOP_MODE=immediate
    USR_ORA_STOP_TIMEOUT=0
    USR_ORA_VIP=
    look hosting_member

  10. #10
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Pando,Davey,BV1963

    Thank you for the explanation and taking your precious time out to look into this problem.

    I missed this in the documentation.

    regards
    Hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width