cancel
Showing results for 
Search instead for 
Did you mean: 

DB Server Migration

Experimenter
Experimenter
Hi TCS Experts,

Currently our customer is thinking about changing the current DB server(Unix) to a standalone Unix server.

Any advice on how to approach it and inputs on best practices?

Anyone done it before?

Your reply is appreciated.

TC Version is 8.3
DB server os is AIX

Thanks
1 REPLY

Re: DB Server Migration

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom

Assuming that the flavor of Unix is staying the same (AIX?) then the operation is fairly simple. Naturally, the Teamcenter envirnment must be taken down before making any changes to the underlaying architecture.

 

A rough outline:

  1. Take down the Teamcenter environment and lock it.
  2. Export the database from the original DB server.
  3. Import the database to the new DB server.
  4. Modify TC_DATA.
  5. Test the DB connection and regen the POM_SCHEMA.
  6. Unlock Teamcenter and start it back up.

 

Modifying TC_DATA is the "secret sauce" that tells Teamcenter how to connect to the database.

  • Rename the POM_schema file.
  • Rename the log directory.
  • Modify tc_profilevars.bat.
  • Modify tnsnames.ora.

 

Best,

/Randy


Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11.0.1.mp01 | SW 2016 | TcUA 11.2.3
Evaluating:AW 3.2