How to migrate oracle from physical server to virtual server (VM) using expdp/impdp

You can migrate from server to other server too using this tutorial.

1. create TNS on the new server, locate in dir $ORACLE_HOME/network/admin

2. open firewall host

3. create DBCA, locate in dir $ORACLE_HOME/assistants/dbca/ with name dbcaICNPRODB.rsp.

part where you have to put new credential

4. create tablespace

warning you have to put this command = autoextend on

5. export database, make sure you have directories oracle for location export file

and then follow this command

expdp username/password@your_database reuse_dumpfiles=y schemas=your_schema dumpfile=expdp_yourchema.dmp directory=EXPDP_BKP_ICNPRODB logfile=expdp_your_schema.log

you will see the export progress

then transfer export file to destination server with this command

scp expdp_your_schema.dmp oracle@your_ip_destination:/home/oracle

6. import database *login into destination server

import database with this command

impdp user/pass directory=DATA_PUMP_DIR dumpfile=expdp_your_schema.dmp logfile=expdp_log_5102019.log

the import progress is running, wait until success