Dear all, after reading a lot of post in here, I still am confused what is right and wrong:
We have to move both application database to new datacenter.
BO is installed on application Server together with our JAVA-web application.
This Server will be cloned to the new Destination and will receive new IP but will Keep server's alias and Domain-Name. The database will be cloned with Oracle rman and restored to new Server having different IP and different Server alias and different domain-Name. We had done this with our QA-Environment with a lot of Problems and now I am very afraid doing the production. Therefore please let me know if my points are correc:
1. before move: Taking backup of universes and reports before the move
2. Stopping all Services (allplication, BO-Tomcat, SIA)
3. after move: edit tnsname to new Destination db, check connectivity (sqlplus), create new SIA with new Destination ("copy database...")
testing connectivity, testing new reporting in application
4. delete "old" sia.
or is it better to Change Settings to new database in "old" existing SIA also with "copy database" ???
Is this really all I have to do?
Thanks and Kind regards