Hello everybody,
I'm trying to convert a database for testing purposes from an old AIX system (AIX-Based Systems (64-bit), BigEndian) to a Windows system (Microsoft Windows x86 64-bit, LittleEndian). I follow a mix of instructions that I figured out of several official guides like "CONVERT DATABASE. Converting Datafiles on the Destination Host" (RMAN Cross-Platform Transportable Databases and Tablespaces), but I stuck at running the modified scripts (convertscript.rman and transportscript.sql).
There seems to be a missing part in the guides where the configuration of the destination system is explained.
RMAN tells me I have to be connected to a database to run commands like "STARTUP NOMOUNT PFILE=..." (with the exported PFile) or "CONVERT DATAFILE..." -but surely there is no local database I can be connected to.
So I hope there is probably a simple solution for my problem to run the needed commands provided by the scripts. I'd be much obliged if you could help me!
Here is what I've done in headlines:
1. Set source system to read only, ran "CONVERT DATABASE ON TARGET PLATFORM..." command and copied all needed files over to my windows machine (server 2012 R2 x64 Hyper-V)
2. Installed database software on the destination system without creation of a database
3. Modified the scripts that where generated through running the CONVERT DATABASE command so that they meet the rights paths in my dest system (C:\app\...\dbname\...)
4. Prepared the destination system for running the scripts <--- seems to be the part I've missed in all the guides
5. Ran the scripts (damn it! missing step 4. )
6. Crack open a beer...
I searched for a related topic, but didn't find one. @Mods: If this is the wrong section feel free in moving it to the right one, thanks.