|
Home > Archive > Oracle Server > August 2005 > Instance name in 9i RAC
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Instance name in 9i RAC
|
|
|
| Hi Everyone,
If i create a DB in RAC using DBCA then we just give the name of the DB
in DBCA, then how does the DBCA gets the instance_name from.
For eg if my db name is racdb then what will be the isntance name on
the nodes, does it depends upon the oracle_sid varialbe set in the
profile in unix??? or is it something else from where a instance name
is picked up.
Regards,
Amar.
| |
| hpuxrac 2005-08-22, 7:24 am |
|
Amar wrote:
> Hi Everyone,
> If i create a DB in RAC using DBCA then we just give the name of the DB
> in DBCA, then how does the DBCA gets the instance_name from.
> For eg if my db name is racdb then what will be the isntance name on
> the nodes, does it depends upon the oracle_sid varialbe set in the
> profile in unix??? or is it something else from where a instance name
> is picked up.
>
> Regards,
> Amar.
Amar take a look at below this is what I suggest checking on and
setting up your instance similar to.
*. cluster_database_ins
tances=2
*. cluster_database=FAL
SE
*.db_name='racdb'
*. db_domain='whatever'
racdb1. cluster_database=TRU
E
racdb2. cluster_database=TRU
E
racdb2. instance_name='racdb
2'
racdb1. instance_name='racdb
1'
racdb2.instance_number=2
racdb1.instance_number=1
racdb1.thread=1
racdb2.thread=2
Yes the ORACLE_SID environment comes into play if you start up the
instances individually like via sqlplus etc.
Most of the time though you will want to use the srvctl utility to
startup/shutdown instances or the whole rac database so you also have
to configure srvctl.
Having the cluster_database=FAL
SE except for the real rac instance is
handy when you want to take the database into and out of archive log
mode and under other fairly unusual situations.
| |
|
| Hi There,
I specificly mentioned that i am creating a DB with DBCA and not manual
installation. and when i am using DBCA then i dont need to modify the
init.ora file and without touching init.ora also in dbca i am getting
the names of my instances. Yes what u have specified above holds true
if i am creating a Db manually and there i need to create init.ora ,
but not in case of DBCA. please clearify. Thanks for your response.
Amar.
| |
| hpuxrac 2005-08-23, 1:23 pm |
| Amar wrote:
> Hi There,
> I specificly mentioned that i am creating a DB with DBCA and not manual
> installation. and when i am using DBCA then i dont need to modify the
> init.ora file and without touching init.ora also in dbca i am getting
> the names of my instances. Yes what u have specified above holds true
> if i am creating a Db manually and there i need to create init.ora ,
> but not in case of DBCA. please clearify. Thanks for your response.
>
> Amar.
Sorry I am not a big fan of DBCA and especially for RAC but I believe
that oracle just starts with 1, 2, 3, etc concatenating that onto the
name you select.
I forget exactly what the problem is but recommendation is to stick to
5 characters or less for base name for RAC db.
|
|
|
|
|