BMC TrueSight Operations Management Review
BPPM - Movement of Oracle Database from a RAC to a Standalone.


Hi Everyone,

I would like to share one of my experience in a Project where we have a Scenario of moving our BPPM Oracle RAC Database Instance to a Oracle Standalone Database Instance. We just have backup of our RAC Database kept with all data in it.

We have restored the DB Backup from RAC to Standalone Oracle DB instance.

Further to this we have made changes in pronet.conf file over BPPM Application Server.

We need to replace the enteries of Oracle RAC with Oracle Standalone Instance. While doing these changes keep BPPM Application Server completely down.

RAC Instance Enteries which needs to be removed.

pronet.api.database.oracle.rac=true
pronet.api.database.oracle.rac.count=1
pronet.api.database.oracle.rac.host.1=abc.xxx.com
pronet.api.database.oracle.rac.port.1=1655
pronet.api.database.sid=ABC

Standalone Enteries which needs to be placed.

pronet.api.database.hostname=abc.xyz.com
pronet.api.database.oracle.rac=false
pronet.api.database.portnum=1655
pronet.api.database.sid=ABC

Once this is done. Turn on BPPM Application.

Your BPPM will be up and running over Oracle Standalone Database.

./Anuparn Padalia

Disclosure: I am a real user, and this review is based on my own experience and opinions.

Add a Comment

Guest
Why do you like it?

Sign Up with Email