INTRODUCTION
Migration of a windows database 12.1.0.1 to linux database of version 19.0.0, below are the steps to perform the migration.
INSTALLED A DATABASE IN WINDOWS AND CHECKED THE PLATFORM NAME AND ENDIAN FORMAT
CHECK THE PLATFORM AND ENDIAN FORMAT
INSTALLED A DATABASE IN WINDOWS AND CHECKED THE PLATFORM NAME AND ENDIAN FORMAT
CREATED A USER AND CREATED A TABLE IN THE USER TO VERIFY AFTER MIGARATION
TO CHECK WHETHER EXTERNAL TABLES ARE AVAILABLE WE ARE DBMS_TDB.CHECK_EXTERNAL IF AVAILABLE WE NEED TO CREATE IT MANUALLY
SHUT THE DATABASE AND OPEN THE DATABASE IN READ ONLY MODE
RUN DBMS_TDB.CHECK_DB TO VERIFY WHETHER IT CAN BE MIGARATED
CREATE A FILE TO STORE THE TRANSPORT SCRIPT
IN RMAN CONVERT THE DATABASE AND GENERATED THE TRANSPORT SCRIPT AND ALSO INCLUDED DB_FILE_NAME_CONVERT FOR THE DATAFILES
CREATED A PFILE
CREATED THE REQUIRD DIRECTORY IN THE LINUX SERVER
MOVED THE GENERATED FILES TO THE CORRESPONDING DIRECTORIES
EDIT THE TRANSPORT SCRIPT WITH THE RESPECTIVE DIRECTORIES
EDIT THE PFILE WITH THE RESPECTIVE DIRECTORIES
RUN THE TRANSPORT SCRIPT
CHECKED THE TABLE WHETHER IT IS AVAILABLE OR NOT
THE DATABASE HAS BEEN MIGRATED FROM LINUX TO WINDOWS.
