Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Converting from Oracle 10 -> Oracle 11

CLM 4.0.6
WAS 8.5
Oracle 10

We have installed Oracle 11 on a new machine. We need to migrate from 10 to Oracle 11 before moving to 5.x/6.x. What steps need to happen to migrate to the new DB server?

I'm thinking:
  1. Backup/Restore DB on new machine
  2. Shutdown server
  3. Edit the text files in JAZZHOME/server/conf to point to the new DB
  4. Start server
Am I missing something?

0 votes



2 answers

Permanent link
Hi Mahari,

Please find the below links and details and also verify it.

1) Preparation :
CLM 4.0.6 supports Oracle 11 from the below system requirements.

https://jazz.net/wiki/bin/view/Deployment/CLMSystemRequirements405406#A6_Databases

2) Backup Source : Find the Backup related CLM.

https://jazz.net/wiki/bin/view/Deployment/BackupCLM

3. CLM Migration considerations.

https://jazz.net/wiki/bin/view/Deployment/MigratingCLMToANewEnvironment

4. Shutdown the server.

5. Edit the database related configuration wrt applications.

eg: edit the teamserver.properties file for all applications in ( JAZZHOME/server/conf ) to point to the new DB.

6. Start the server.

Regards,
Arun.

0 votes

Comments

Arun - the question is how to upgrade database, not how to migrate CLM solution to a new environment.


Permanent link
Hi Mahari,
Here is the procedure:
  1. Stop CLM server.

  2. Upgrade your database. If you have any issues with this step, then refer to your DBA admin or to your DBA vendor support.

  3. If you have changed database server or port, modify <your-server-installation>/server/teamserver.properties to point to the new database.

  4. Start your CLM server.
Let us know if that helped you.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,490
× 6,119
× 82
× 42

Question asked: Aug 07 '15, 6:47 a.m.

Question was seen: 4,317 times

Last updated: Nov 10 '15, 3:34 a.m.

Confirmation Cancel Confirm