Question Re: BO Repository Migration in Technology Q&A

BO Repository Migration

Former Member — Tue, 19 Aug 2008 05:05:53 GMT

We are currently trying to move our Business Objectu2019s repository databases from one Oracle database server to new Oracle RAC database server. So far we have tried to shutdown the BO apps, export/import the databases into the new Oracle environment and re-point the source in BO, but this has been unsuccessful. We are fairly new to BO and we were wondering how we could migrate these database(s). Is there a BO document to do this??? So far we have had trouble searching the web site for such a document. If you could guide us through this process that would be much appreciated.

Cheers,

Julien

Re: BO Repository Migration

amrsalem1983 — Tue, 19 Aug 2008 05:33:32 GMT

Julien , you dont need to do that

Business objects system can do that for you, there a shortcut to "Repository Migration Wizard"

find it with your business objects installation,

refer to the source, and to the destination and it will migrate it for you.

find this

http://help.sap.com/businessobject/product_guides/boexir2/en/datasourcemigration.pdf

good luck

Amr

Re: BO Repository Migration

Former Member — Tue, 19 Aug 2008 05:49:57 GMT

Julien.

Are you referring to moving the cms and audit databases? If so, then your initial procedure should have worked. What error did you get after repointing the cms data source to the new Oracle database? Is the XI server Windows or Unix, and what patch level? The tool you use to repoint the cms datasource also has the ability to migrate your existing database to a new database. The exact instructions are slightly different based on whether your XI server is Windows or Unix based, however both are fairly straight forward. On windows you would run the CCM (Cental Configuration Manager). On unix you would run the cmsdbsetup.sh script.

--Jack

Re: BO Repository Migration

Former Member — Tue, 19 Aug 2008 06:16:31 GMT

Hi Amr,

Thanks for your reply.

I've read through this thread named "CMC database " which posted on 7 Aug with similar question and you have feedback saying using the "Repository Migration Wizard" to migrate the CMS database. However Srinivas replied saying "the "Repository Migration Wizard" has actually nothing to do with migrating repositories. This tool is used to update repository objects if you have CE 9 or Crystal Reports 9."

I'm confused.

Anyway, i'll have a read through at the document you sent through.

Thanks,

Julien

Re: BO Repository Migration

amrsalem1983 — Tue, 19 Aug 2008 06:19:33 GMT

so why they made it

please read the document.

good luck

Re: BO Repository Migration

Former Member — Tue, 19 Aug 2008 06:34:52 GMT

Hi Julian,

The methos you are describing is the correct approach.

What you are saying is that you BO system must stay in tact, all you want to do is move the the CMS database (repository) to another Oracle machine/database?

The process would be to copy the existing CMS and retore it on the target Oracle machine... then all that is needed is changing the connection to point to the new locacation and start the services again.

the moveing of the database should be easy task for your DBA to do.

If you could share what exactly the "unsuccessful" bits are maybe someone would spot the issue.

Regards

Jacques

Re: BO Repository Migration

Former Member — Tue, 19 Aug 2008 06:36:30 GMT

I think we are all confusing the term repository. I believe Julien is not using the term properly. I believe in Classic BO repository was referred to as the system database, however in XI it is not. Repository in XI is a database location of special report objects and I believe that is what the document Amr sent is talking about. I think Julien is only concerned with migrating his system (cms) database. In this case you would using the cms copy tool built in to the CCM on windows or cmsdbsetup.sh on Unix.

--Jack

Re: BO Repository Migration

Former Member — Tue, 19 Aug 2008 06:39:12 GMT

Jacques is correct. Your original method should have worked. That is why I also asked for the error you received when starting you cms after repointing to the new cms data source. You can also use the method I described and let the XI tools do all the copying of the content from the source database server to the destination database server.

--Jack

Re: BO Repository Migration

Former Member — Tue, 19 Aug 2008 06:52:00 GMT

Hi Jacques,

You are right. All i want is to move the CMS database from our current database to Oracle RAC.

I have received the following errors

Oracle database error: ORA-28759: failure to open file

Oracle database error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Which i reckon could be something to do with the database connection setup in TNS.

Regards,

Julien

Re: BO Repository Migration

Former Member — Tue, 19 Aug 2008 06:54:10 GMT

Hi Jack,

Thanks for your comment.

I'm using Windows and my BO version is XIR2 SP1. Going to upgrade it tomorrow to at least SP2.

I'm going to re-try in 20 minutes time after office hour using the copying tool you mentioned.

Will update the result of my testing

Cheers,

Julien

Re: BO Repository Migration

Former Member — Tue, 19 Aug 2008 06:57:52 GMT

Julien,

You are right. The error indicates that the tns name you entered when configuring the data source for the cms has not been configured in your tnsnames.ora file and your oracle client cannot find the connection information.

Once you have updated the tnsnames.ora file with the new db connection info, you should be able to use the oracle tnsping command to ping the db using the tnsname or you can try to connect via the sqlconnect tool provided by Oracle client tools. Once you are successful with the ORacle connection tools, then run the data source tool again in the CCM with the correct tnsname, user, and password.

--Jack

Re: BO Repository Migration

Former Member — Tue, 19 Aug 2008 07:01:54 GMT

Julien,

The XI data source copy tool will not work unless your Oracle client is configured correctly to connect to the new destination database server. So you need to be certain you tnsnames.ora file has been updated correctly and then use the Oracle provide command line connection tools to verify your Oracle client can connect to the new database. Once you have confirmed the client is configure correctly, rerun the data source wizard in the CCM and try to start the CMS and hopefully it will start without error. If is still gives an error, let us know what it says.

--Jack

Re: BO Repository Migration

Former Member — Tue, 19 Aug 2008 07:50:44 GMT

Hi Jack,

I don't think i could report on the status today. I'm having difficulty pinging to the new server. Have to confirm with system engineer if he has done any changes to the setting.

Will definitely keep everyone posted once i got any clue.

Regards,

Julien

Re: BO Repository Migration

Former Member — Tue, 19 Aug 2008 11:55:15 GMT

Hi Julien,

I think if you have sorted out the Oracle connection issue, you will be sailing. This is definitely where your problem is stemming from.

Regards

Jacques

Re: BO Repository Migration

Former Member — Thu, 21 Aug 2008 01:52:50 GMT

Thanks Jack and Jacques once again for your kind responses Appreciated.

Anyway, i gave it another go last night but still haven't got any luck pointing my CMS to the new database.

I've tested my new connection to RAC database using ODBC and tnsping. They are responding and working fine.

After the test, i went into CCM and change the connection in CMS by clicking on the 'Specify' button in the Configuration tab.

Here is the error message i received.

assert failure: (\backend\cms\include\DatabaseSubsystem.h:166). (0 : Oracle database error: ORA-12545: Connect failed because target host or object does not exist

The database is definitely there and i could ping the host! Some forum suggested to change the host to numeric ip adress and i did test both scenario but again, no luck

Julien

Re: BO Repository Migration

Former Member — Thu, 21 Aug 2008 02:36:38 GMT

Julien, In your last post you mention Oracle ODBC, I hope this is just a typo. You should be using the native oracle client for the cms database. I do not think we even support an Oracle ODBC connection for the cms, only for your reporting database. The error message indicates that the oracle client cannot find the specified db server, however tnsping should fail as well.

Can you try to just go to a Windows command prompt window. Do not set any environment variables or run any environmnet scripts. Run the follwing commands and past the output in this forum thread. Replace "tnsname" with the actual tnsname you are using when running the data source connection in the CCM.

C:\tnsping tnsname

C:\sqlplus username/password@tnsname

Re: BO Repository Migration

BasicTek — Thu, 21 Aug 2008 02:42:25 GMT

ok then try this.

Create a blank CMS DB in the new oracle location.

Then connect the CMS and oracle middleware to the new connection. It should start up fine in few seconds. (It will actually create the tables but we will overwrite them)

Once you verified that you can hit the new instance use the CCM to copy the data source

to do this stop the cms, double click the CMS (or right click properties), click configuration tab, then specify, finally selecting copy data from another data source.

Backup the original DB just in case and make sure you don't get the DB's backwards, I've seen that happen(If you get them backwards you will in effect delete your source DB).

So the source is the original DB the destination is the new one.

When it's done you should be able to start your CMS with the new Oracle DB.

Regards,

Tim

Re: BO Repository Migration

Former Member — Thu, 21 Aug 2008 02:58:51 GMT

Hi Jack,

Yes i'm using native oracle client for the cms database. Reason why i create ODBC connection is to test whether my connection to the new db is working fine.

Anyway, here is the result of my testing as suggested

C:\Documents and Settings\Administrator>tnsping boxi

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-AUG-2

008 12:49:54

Used parameter files:

C:\oracle\10.2.0\client_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)

(HOST = 10.200.xx.xx)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.xx

.xx)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = boxi)))

OK (10 msec)

C:\Documents and Settings\Administrator>sqlplus bo_owner/xxx@boxi

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 21 12:50:55 2008

ERROR:

ORA-12545: Connect failed because target host or object does not exist

Enter user-name: bo_owner

Enter password:

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name: bo_owner

Enter password:

ERROR:

ORA-12560: TNS:protocol adapter error

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

Regards,

Julien

Re: BO Repository Migration

Former Member — Thu, 21 Aug 2008 03:08:05 GMT

Hi Tim,

Thanks for your information.

My DBA has changed some setting on the actual Oracle Parameter. He has updated local_listener to point to the new RAC server and the following test suceeded.

C:\Documents and Settings\Administrator>sqlplus bo_owner/xxx@boxi

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 21 13:01:19 2008

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

SQL>

It seems very positive for me to change the datasource of CMS to the new server now. If the change is not successful, then i will test using your suggested approach.

Julien

Re: BO Repository Migration

BasicTek — Thu, 21 Aug 2008 03:10:28 GMT

since your on the same machine it should work either way. Just thought we could try the CCM DB copy to see what was going wrong.

good luck