cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
466
Views
0
Helpful
2
Replies

Move CPO server/keep database schemas

jlouvet
Beginner
Beginner

Hi,

We have moved our database hosting the CPO schemas to a different datacenter. The application server however has not moved.

I have a new server on that same datacenter to use for CPO.

Will installing CPO on the new server using the same oracle schemas affect the table and data that are already there?

Would you have a document on how to do such move?

Thanks,

JB

1 Accepted Solution

Accepted Solutions

Von Jones
Enthusiast
Enthusiast

There is a key on the server which hosts TEO which is used to encrypt data such as runtime users.  Without moving this, you will lose all of the encrypted data in the DB.  You will need to go through the TEO Server relocation procedures covered in the Resiliency Strategy document to ensure the key is present on the PO server you are moving.

You may want to take this in 2 steps.  First go through the database server change using the tool for this purpose.  Once that's working, go through the server move process.

Working with TAC through this process would probably be a good idea.

Also, this may be a good way to explore the mechanics of the hot stanby strategy should you want to use it for HA until such time as PO 3.0 arrives.

View solution in original post

2 Replies 2

Von Jones
Enthusiast
Enthusiast

There is a key on the server which hosts TEO which is used to encrypt data such as runtime users.  Without moving this, you will lose all of the encrypted data in the DB.  You will need to go through the TEO Server relocation procedures covered in the Resiliency Strategy document to ensure the key is present on the PO server you are moving.

You may want to take this in 2 steps.  First go through the database server change using the tool for this purpose.  Once that's working, go through the server move process.

Working with TAC through this process would probably be a good idea.

Also, this may be a good way to explore the mechanics of the hot stanby strategy should you want to use it for HA until such time as PO 3.0 arrives.

Shaun Roberts
Cisco Employee
Cisco Employee

I did a video on moving DBs. It is with SQL, but the premise is still correct:

https://supportforums.cisco.com/videos/2815

--Shaun Roberts
Principal Engineer, CX
shaurobe@cisco.com
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers