Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE SCALE OUT: with out admin will secondary server runs and takes over the control if primary ser

Sai Manoj VApr 29 2019

DOC followed to perform Scale out:

Configuring High Availability for Oracle Business Intelligence Applications Version 11.1.1.8.1 (Doc ID 1679319.1)

we are successful in creating  new server for BI_SERVER as a failover (scale out).

i'm seeing BI_SERVER2 and instance2 folders created in my backup server, but not Admin server folder (also where we can store boot.properties file to start the weblogic from nohup command ).

this made think about what happens if my primary server is completely down and admin server would not be running on my secondary server. please let me know if any insights can be given to understand how a secondary server comes into picture when primary server is partially/fully down.

Regards,

Sai Manoj V

Comments

Dude!

There's no problem to have copies of the same control files in different directories and ideally on different media and independent storage controllers. It's called control file multiplexing and very common.

Yes, you can use the alter system command according to  your needs. There are many examples on the web, For instance: https://oracle-base.com/articles/misc/renaming-or-moving-oracle-files#controlfiles

EdStevens

Sorry, in my quick-scan first read I saw your opening statement:

We have created a new 11gR2 instance on Windows 2012 R2. By mistake

As

We have created a new 11gR2 instance on Windows 2012 R2 by mistake

And thought to myself, "yes, creating it on a Windows machine is certainly a mistake!"

Seriously,though, many would consider installing a new 11g to be a mistake regardless of platform.  It is effectively at end of life, going into sustaining support by the end of this year.

As for your actual question, Oracle doesn't care if the individual file names are the same.  It is using the fully-qualified name (complete directory path) to identify all files.  But from a human management perspective, it seems to make more sense to name them as you want (control01, control02, etc.).  And your procedure is essentially correct.  I say 'essentially' because it is one of several minor variations on the theme, all of which will get you there in the end.  The common theme being 'alter database' to change the entry in the spfile', stop the database, move/rename the file at the OS level, start the database.

EdStevens
Joerg.Sobottka

Yes, it works as you have described it, if you run with spfile. If you run with the old init.ora you need to specify the right names in there, shutdown immediate the database, rename/copy your controlfiles to the right names/places and startup the database again.

That's easy. You could also use rman to mirror the controlfiles, but stay at the easy path...

1 - 4