BusinessObjects Board

Switching BO to new database server

building semantic layer
#1

We recently switched over to a new Oracle 10g database server. We initially only modified our tnsnames.ora file to have the old server name pointing now to our new IP address. However we ran into issues when attempting to connect to Infoview.

To circumvent this, we modified our universe connections to point to our new server name then exported them. This seems to be working.

The issue is, when we try to generate a new bomain.key we no longer can see the new connection associated with the universe. It currently still points back to the old connection. While digging deeper we noticed when logging into Supervisor and going to Tools --> Repository the connection info there also points to the old connection. We thought of simply updating the available repository domains to point to our new connection but the Security domain is currently unable to be changed.

Does anyone have any insight into what all needs to be updated/changed when switching over to a new database server? Our fear is that once we “officially” switch and shut down the old server we’re going to open up a big can of worms!

ctanner94 (BOB member since 2002-12-11)

#2

Sounds like you may have cross-linked repositories.

Did you move the database that contains your repository or your datamarts? If it’s the repository, then you’d need to do a safe recovery to create the new bomain.key, then change all of the universe and document domains (from Supervisor) similarly. You don’t need to touch universe connections, unless the data sources for the connections are on the same database.

If you just updated bomain.key without changing the universe and document domains, then you could potentially corrupt both repositories.

Joe

joepeters :us: (BOB member since 2002-08-29)

#3

It does sound like you could have cross-linked repositories. If you’ve made ANY changes in your “new” repository – you might have made inadvertent changes in your “old” repostory instead. If so, can you do a restore of the production repository from a backup from just before your move, and complete the move correctly?

Please check the Supervisor FAQ: “How do I move my repository?” to see the step(s) that you probably missed.

Anita Craig :us: (BOB member since 2002-06-17)