How to Migrate SYSMAN user from one grid control server Db to another one
Hello,
We have HA Grid Control DB sever of 11gr1 version. We are planning to upgrade to 12c. This is how we are planning to achieve.
1. Migrate the SYSMAN user from production GC db to another GC DB of same version. Intention is to migrate all the jobs
2. Fresh Install/upgrade 12c on production.
4. point the agents to new 11gr1 GC db.
3. Meanwhile the 11gr1 GC will be used on another server. All the db job should be running from this new box.
The question is how to achieve step 1? We tried transport tablespace but the source and target dbs have different character sets not sure if that will work or not?
We have HA Grid Control DB sever of 11gr1 version. We are planning to upgrade to 12c. This is how we are planning to achieve.
1. Migrate the SYSMAN user from production GC db to another GC DB of same version. Intention is to migrate all the jobs
2. Fresh Install/upgrade 12c on production.
4. point the agents to new 11gr1 GC db.
3. Meanwhile the 11gr1 GC will be used on another server. All the db job should be running from this new box.
The question is how to achieve step 1? We tried transport tablespace but the source and target dbs have different character sets not sure if that will work or not?
0