-
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
-
I dont really understand what do you mean, may be yoou want to do crs_stat -p and your instance resource
-
it reads the rac1 entries from shared spfile
-
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
-
have you tried crs_stat -p as I mentioned?
-
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
-
because when you create the services you tell it which node rac1 belongs to
-
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!
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|