So you want to replicate your production data into your test environment. You understand all the reasons you shouldn’t do this, but your client wants it done anyway. Soooo, here’s a generic outline of the steps you’ll need to do. After this is done, don’t forget that you need to “refresh” all your resources (AD, OID, etc), so that all the accounts match up.

Refreshing OIM from existing environment

MUST DO THIS BEFORE YOU ERASE CURRENT ENVIRONMENT

- Stop all WebLogic Application Servers, Nodes, and Manager
- Copy the soon-to-be-refreshed environment details to an Excel sheet
- Copy all IT Resource information and details
- Copy current XELSYSADM email address
- Copy the details of the scheduled tasks that have environment specific data – Copy the details of environment specific lookup definitions

Refresh Steps

- Log into each node on environment to be refreshed and sudo into root and run the following – cd /opt/oracle/oim91/xellerate/config
- cp .xldatabasekey .xldatabasekey-STAGE
- cp /software/oracle/OIM/productionDBKey/.xldatabasekey .

- Answer ‘y’ to overwrite the old file

- Have someone rest the XELSYSADM password in OID to what the current environments password should be (OID is the repo for OAM in this instance)

- Have the DBA team change the oimuser (OIM data owner) password to what it should be for this environment

- Make sure the oimuser account is unlocked

- If any WebLogic services are up, they need to be stopped and restarted. You will have to kill them at the process level (kill -9)

- Start WebLogic

- open dev design console
- login as xelsysadm with production password – Wipe out all addresses for every IT resource

- If an application server doesn’t start, you will have to do it manually (example):

- Either have someone else change the password in OID for XELSYSADM to the production password or change it yourself if possible

- Open the OIM Web Console
- Login as XELSYSADM with the production password
- (If you login through OAM, but not into OIM, you need to disable SSO for OIM) – Click on My Account on the top left and then click Change Password
- Change the password to what the current environments password should be

Note: if the password you’re changing to doesn’t fit the password policy, you’ll have to delete the policy in the Design Console ( Resource Management > Resource Objects > Name = Xellerate User) Make sure to re-add it when done. Blue columns need to be double-clicked and selected. Not typed in. (Default | base password policy | 1)

- On the left, click Account Profile under My Account
- Modify the email address to match what it should be in the new environment

- Open the OIM Design Console and modify the IT Resources – Click on Resource Management on the left

- Click on Manage IT Resource – Click Search
- Click on OID Server
- Click the Edit button

- Fill in the correct information for this environment (See corresponding Excel document IT Resources) – Click Save
- Click on Users > Manage
- Select User ID from the first dropdown and XELSYSADM for the value

- Click on Search User button
- From the drop-down, select Resource Profile
- For OID User, click on Edit
- Change the password to the new password and click Save
- Log out of the Web console and re-login with the new password to verify that it’s working

- Open the OIM Design Console – Expand Resource Management – Open IT Resources
- Click the New icon

- Name: Test Mail Server
- Double-Click the Type field and select Mail Server
- Click the Save icon
- Double-click new test mail server to configure it
- Fill in the correct information for this environment (See corresponding Excel document IT Resources) – Click the Save icon
- Expand Administration
- Double-click System Configuration
- Click the Search icon
- Select the System Configuration Table tab at the bottom
- Double-click the number next to Email Server to configure it
- Change the value to ‘Test Mail Server’ (no quotes)
- Click the Save icon
- Open Task Scheduler on the left
- Click the Search button and then select the Task Scheduler Table tab at the bottom
- Edit all scheduled tasks that have environment specific variables from saved data

- Update the attributes for the new environment (server names) – Click Save

- Using the IT Resource information stored in the Excel doc before everything was wiped out, update the IT Resources

- Open a SQL DB Editor and login to the Database
- Run this SQL command:
- update USR SET USR_EMAIL=‘test@domain.com’; – Commit changes and then quit
- commit;

- Verify that the /etc/hosts file on each server has all the necessary host names and IP translations for this environment

- Truncate the AUD_JMS table (sql command: truncate table AUD_JMS). Restart all application servers.