Prerequisites for EM CLI Database Migration

Before you can begin a database migration with the EMCLI verb migrate_db you will need to review, install and configure the following:

Migration Workbench migrations using EM CLI migrate_db verb, use a JSON payload file exclusively.

Validate if Prerequistes are Met

emcli migrate_db 
-file="/home/migrations/prereqs.json"

The JSON file prereqs.json contains the following payload:

{
    "action": "VALIDATE_PREREQS",
    "type": "DATAPUMP", 
    "platform": "linux32|linux_64|windows64|solaris_sparc64|solaris_x64|aix_ppc64" 
}

Upload Migration Tools Using EM CLI

emcli migrate_db 
      -file="/home/migrations/prereqsupload.json"

The JSON file prereqsupload.json contains the following payload:

{
    "action": "UPLOAD_PREREQS",
    "type": "DATAPUMP",      
    "hostTarget": "<host-target>",      
    "hostTargetCred": "<hostCredName>:<hostCredOwner>",      
    "tools": {    
             "instantClient": {
         "version": "<DB Version e.g.: 18.5.0.0.0>",
               "platform": "linux32|linux_64|windows64|solaris_sparc64|solaris_x64|aix_ppc64",
               "files": [
                    "/u01/db/insClients/instantclient-basic-<Operating System>-<DB Version>dbru.zip",
                    "/u01/db/insClients/instantclient-sqlplus-<Operating System>-<DB Version>dbru.zip",
                    "/u01/db/insClients/instantclient-tools-<Operating System>-<DB Version>dbru.zip"               
          ]           
        },          
        "schemaAdvisor":{                
            "files":[                     
                    "/u01/db/tools/install_adb_advisor.sql"         
            ]           
        }     
    }
}