Move Grid Control repository db to a different server.

Is it possible to & if so, what steps if any are needed after restore?

Shutdown the grid repository db
Stop all processes
Run a full server backup
Restore to another server (can possibly be same hostname)
Startup db
Start all processes
Do you have to do a new install, export/import from existing grid repository db?

dedean01Technical Support Engineer Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark GeerlingsDatabase AdministratorCommented:
If you want to restore to another server that will have the same name (and IP address) as the original server, your steps should work just fine.
dedean01Technical Support Engineer Author Commented:
The IP address will be different, will that present a problem?
dedean01Technical Support Engineer Author Commented:
We are moving from hp-ux servers to titanium servers.

Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Mark GeerlingsDatabase AdministratorCommented:
I expect that will be a problem.  I've moved other Oracle databases from server to server and I knew that i just needed to changes the tnsnames.ora files on the clients or applciation servers to the new server.  For the OEM Grid Control repository however, I think it may use configuration values that are stored in other places than the tnsnames.ora file, but I don't where these might be, or if Oracle supports modifying them.
Mark GeerlingsDatabase AdministratorCommented:
When I said "that will be a problem" I meant the different IP address.  I don't know if a different O/S will be a problem, or not.
Mark GeerlingsDatabase AdministratorCommented:
But if the O/S is different, there is no way that you can do a backup and restore from the old server to the new server, right?
dedean01Technical Support Engineer Author Commented:
Yeah, that's right. I was trying to research metalink but the only note that I could fine was "Note 388090.1"  Title: Cross Platform EM Grid Control Repository/OMS Migration.  Which I'm not sure is still supported.  The Note states that it is Distributed to customers with guidance from an Oracle Support because of the complex process.  I couldn't fine the note on matalink anymore but I was able to google it with the subject "Moving db repository to another existing database without losing the data"

Any thoughts
Mark GeerlingsDatabase AdministratorCommented:
I would try a full export from the old server and a full import on the new server.  Take a backup of the new server after you install the Oracle software, and create a starter database but before you import the data from the old server.  That way, if OEM is happy and can use the imported data, you are all set.  If that doesn't work, just restore the backup, then create a new repository, and you can go forward, but you won't have the old data.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dedean01Technical Support Engineer Author Commented:
That was one of my concerns, keeping the old data.  If all possible we need the old data.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Unix OS

From novice to tech pro — start learning today.