DB schema change

server administration XI Server Discussion
1

Hi

we are using Bo 3.1 sp3 on linux. We are changing our schema in oralce to new schema.

could anyone please tell What are the steps or changes we need to follow to make sure our Bo connects and work with new schema.

Thanks

rajx72 (BOB member since 2006-08-02)

2

Will this schema is going to be copied on an another Oracle server ?

Take the backup first of your CMS DB.

If not then do this:

– Copy the current schema(all tables) to new schema on same server
– Stop SIA.
– Change the SIA configuration in CCM to point to new schema with correct userid and password. (i.e., only update the database settings)
– Start SIA.

Note : Do not select RECREATE or COPY option while configuring SIA Agent.!!

That’s it. :wink:

BO_Chief :us: (BOB member since 2004-06-06)

3

HI

thanks. for the information…

Sorry I got the wrong info… I have 2 dbs… One is BO db and one is Data db… Our data db is moving to new IP address not our BO db…

where do i go and make the change so that my Bo works fine…

whats steps do i need to follow…

thanks

rajx72 (BOB member since 2006-08-02)

4

For ODBC

For 3 tier login:
Just change the Universe Connection if WebI reports and export to repository.

For 2 tier login:
– All the System DSN’s on the Developer’s Desktops for WebI Rich Client & Crystal Reports

On BI Server:
All the System DSN’s that you need to point to Data Source DB.

It will be different for OLEDB and JDBC. !!

BO_Chief :us: (BOB member since 2004-06-06)

5

Hi

Do we create the ODBC connection on the Bo Server… or changing the Host entry in TNSnames file will work…

Sorry i don’t remember if we ever created a odbc connection on the Bo linux server…

thanks

rajx72 (BOB member since 2006-08-02)

6

For Oracle Net Client… TNS host name entry change will do on BI Server.

BO_Chief :us: (BOB member since 2004-06-06)

7

Hi

Thanks…

Just to recap…

Change the host name in tnsnames.ora file… that will do the trick… also do the same on you local machine tnsnames.ora file…

No need to change any thing else… With this change the Bo will talk to the new reporting database.

am i correct… I hope i did not missed any step…

thanks

rajx72 (BOB member since 2006-08-02)

8

Exactly… but for your machine only.

If there are other developers… the TNS file has to be changed for them too.

BO_Chief :us: (BOB member since 2004-06-06)