How to move database used by TIBCO Administration domain when Admin is running in SF environment
Article ID: KB0083869
Updated On:
| Products | Versions |
|---|---|
| TIBCO Silver Fabric Enabler for TIBCO Administrator Enterprise Edition | - |
Description
Issue/Introduction
Environment
Resolution
1. Setup TibcoAdmin component with DB1 configuration with FT mode checked.
2. Setup BW component with same db driver as in Tibco Admin.
3. Do data migration from DB1 to DB2. (I used expdp/impdp oracle db utilities for export/import of schema).
4. Create user in DB2 with same name as used for DB1 connection. (This is because the schema is created with same name as user name in db).
5. Run DomainUtility GUI on machine where Tibco Administrator server installed for DB changes.
6. DomainUtility will not work on machine where BW is installed due to changes in folder structure. Instead modify the AdministrationDomain & AuthorizationDomain properties manually on BW component machine to point to new DB.
7. Stop both BW and Tibco Admin components/stacks in SF.
8. Edit Tibco Admin component with new db details and publish the changes.
9. Edit BW component if there is any change in the driver and publish the changes.
10. Start Tibco Admin and BW components.
Additional Information
case 737809
Feedback
