We are moving our Oracle DB to new hardware. I am looking for information on how to point our Business Objects to the new IP. Can anyone help me out or point me in the right direction?
snturner 
(BOB member since 2012-01-17)
Assuming everything else in the database is remaining as it was, it sounds like you need to update your network’s DNS server, to reflect the new server IP for the host name. Actually though I would think the Oracle & network people would already be planning to do that, so ask them about it.
If that is not possible (due to the old server remaining active), you’ll need to change the tnsnames entries to that server to point to the new host, in the tnsnames.ora file on all of your BusObj servers.
Remember to stop the Business Objects services before taking a backup, copying the database over, and repointing.
b_demann (BOB member since 2003-03-20)
Hi
I have a similar situation… My data DB is moving to a new place(Linux)… rest everything is same… only the IP address is changing…
What steps do i need to follow… and under which directory I will find TNSnames.ora file… also do i need to do any change on the client machine also…
What I understood…
Just change the IP address in Tnsnames.ora on Bo server and rest will work fine… I mean the BO db will talk to the new data db…
Am i correct…do we make a ODBC connection on BO server…
Thanks
rajx72 (BOB member since 2006-08-02)
It depends on how you are connecting to Oracle.
Typically you will have to modify/update the TNSnames.ora entry on ALL machines using Oracle Client to connect directly to Oracle.
That will be the SAP BI BusObjects Server as well all develeoper machines using the SAP BI BusObjects Client Tools (such as Webi Rich Client, IDT, UDT, etc.) or any other SQL Plus/TOAD etc.
Andreas 
(BOB member since 2002-06-20)