Preparing to import data

Before you import data to SnapCenter, you must perform certain tasks to complete the import operation successfully.

Steps

  1. Identify the database that you want to import.
  2. Using SnapCenter, add the database host and install SnapCenter Plug-ins Package for Linux.
  3. Using SnapCenter, set up the connections for the storage virtual machines (SVMs) used by the databases on the host.
  4. In the left navigation pane, click Resources, and then select the appropriate plug-in from the list.
  5. On the Resources page, ensure that the database to be imported is discovered and displayed.
    When you want to run the import tool, the database must be accessible or else the resource group creation fails.

    If the database has credentials configured, you must create a corresponding Run As credential in SnapCenter, assign the Run As credential to the database, and then re-run discovery of the database. If the database is residing on Automatic Storage Management (ASM), you must create Run As credentials for the ASM instance, and assign the Run As credential to the database.

  6. Ensure that the user running the import tool has sufficient privileges to run SnapManager for Oracle or SnapManager for SAP CLI commands (such as the command to suspend schedules) from SnapManager for Oracle or SnapManager for SAP host.
  7. Run the following commands on the SnapManager for Oracle or SnapManager for SAP host to suspend the schedules:
    If you want to... Then run the following commands...
    Suspend the schedules on the SnapManager for Oracle host
    • smo credential set -repository -dbname repository_database_name -host host_name -port port_number -login -username user_name_for_repository_database
    • smo profile sync -repository -dbname repository_database_name -host host_name -port port_number -login -username host_user_name_for_repository_database
    • smo credential set -profile -name profile_name

      You must run the smo credential set command for each profile on the host.

    Suspend the schedules on the SnapManager for SAP host
    • smsap credential set -repository -dbname repository_database_name -host host_name -port port_number -login -username user_name_for_repository_database
    • smsap profile sync -repository -dbname repository_database_name -host host_name -port port_number -login -username host_user_name_for_repository_database
    • smsap credential set -profile -name profile_name

      You must run the smsap credential set command for each profile on the host.

  8. Ensure that fully qualified domain name (FQDN) of the database host is displayed when you run hostname -f.
    If FQDN is not displayed, you must modify /etc/hosts to specify the FQDN of the host.