Hello we would like to migrate a "complex" database with 50 different users to the up to date oracle 10r2 version (+ fixpack + CPU)
The source platform is debian woody and target would be either debian sarge or SLES 9/10
With exp/imp I was able to dump and reimport the complete database onto another computer with SLES 9 (test machine) with the same oracle 188.8.131.52 version.
I was already able to solve some ora-xxxx's but the main problem persists: Is is wise to replace the system tables from the target database or is there a better way to migrate all these user accounts. (Since we don't know each single account's password at once it would be cool if we could extract somehow the password for each account, even a hash would do the trick that could be entered into the target database.)
Later I'd like to use "dbua" from oracle 10r2 to upgrade, but until that I'd prefer to have a rather 1-to-1 copy on the test machine to get valid results from the upgrade.
1.) Export from: productive environment: Debian woody + oracle 184.108.40.206 -> test machine: SLES 9 + oracle 220.127.116.11
2.) Upgrade with dbua: on test machine (SLES 9 +oracle 18.104.22.168) -> test machine: (SLES 9 + oracle 10r2)
3.) If successful: Export of database to new productive machine with SLES 9/10 or debian sarge + oracle 10r2