MIGRATION FROM WINDOWS TO LINUX(12.1.0.1 TO 19.0.0)
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 MIGRATION
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 MIGRATED
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
Posted by:Sakthi sethu perumal S