This content has been marked as final. Show 4 replies
Is this possible when using dbca to create the rac database and instances?I don't know if the instance name is set when using dbca as I have always used the manual method but the database name is set at that time and I think instance name is as well using your naming convention. The instance name can always be changed afterwards. You set this when you export the ORACLE_SID and start the database. The instance name can be anything you want and does not need to relate to your database.
Also, is it a good idea to have the instance names different from the database name.Your naming convention is typically what is used as there is no confusion. All my database and instance names follow the same convention. ie [database_name][instance_number]
Why does your manager want different database and instance names. The database name of prod makes it pretty obvious it's a prod database, but instance name of "mock" doesn't make it obvious it's a prod database. In fact I would have assumed it's a mock database and not prod with that name.
Personally I think it's confusing having desperate instance and database names.
I think when you create the database using DBCA it ask you to specify global database name and database sid, database sid should be used as a Instance Prefix.
I have not been able to find anything in documentation regarding this topic...
Thats what I have always done which is just use the instance sid which is derived from the database name. I have never tried chamging it and not sure if this will cause problems down the road so I am not sure if I should travel that road?