Hi, new to Primavera so be kind...
Currently we have a Primavera P6 6.2.1 installation on a server running Oracle 10g 10.2.0. In a bid to upgrade the infrastructure, we have a new 2008R2 server with Oracle 11g 11.2.0 ready to host a new Primavera instance. I have installed the P6 R83 Database without loading sample data as I didn't want it to interfere with our data when I finally manage to migrate it.
This brings me to my question; how do I migrate our PMDB db from old to new? I have read about using the migrate.bat but I can't find the 6.2.1 installer to run the equivalent migrate.bat file - I read it was bad juju to try running a newer version of the bat on an older db. I have tried running it from the new server but I keep getting the following error:
ORA-12505, TNS:Listener does not currently know of SID given in connect descriptor.
I have amended the tnsnames file to include the connect descriptor of the old server, but no luck, same error code.
I was thinking of manually copying the .DBF files from the old to the new server and simply overwriting them. Then I could update them manually somehow?!
Any help on this is gratefully received and will be rewarded with magical OTN points.
EDIT** Exciting development in the 8 and a half minutes since I posted! My boss pointed out the error in my connection details within the migrate tool! Now I am a little further ahead, but not all the way yet...
I am at the stage 'Configure Oracle Tablespaces'. If I try and except the defaults I get the following error: NullPointerException: null (null). I think this is thrown because the value for Temporary tablespace is empty and there is nothing to be selected from the drop down menu. What do?!
Message was edited by: 9e54ea23-380c-459a-80be-9ad73531b394
Hi, thanks for the reply. I tried to upload a screenshot to show what I am stuck on but I don't have permissions.
When I try running the migrate.bat file from V37500-01\P6_R83_Database I get to the configure oracle tablespaces screen but then am presented with the following error when trying to proceed with defaults:
NullPointerException: null (null)
I think this is because there is no value in the temporary tablespace dropdown, but there is no available value to select. What should I do at this point? Do I need to create a temp tablespace first and then come back into the migrate tool?
This is because you are trying to use the migration tool for version 8.3 against a database in version 6.2.1 instead of 8.3. You cannot migrate a db from 6.2.1 to 8.3.... since the migration tool is an application that should only be used to migrate databases from one source to another (ex: from Oracle to SQL Server) at its current version only. This utility was not designed to use to upgrade from one version to another.
If you need to go from 6.2.1 to 8.3, then you need to follow the upgrade process and not use the migration tool.
hope this helps.