Syed Jaffar

• According to Commvault, over 80% of companies are using the multi-cloud today. Commvault Cloud Backup solution provides support backup and recovery for  over 40% clouds. This can ease backup and recovery operations between clouds.

• Vertitas's Netbackup 7.7.x supports backup and recovery operations on Oracle Cloud as well as supports multi-cloud data protection solutions. With NetBackup multi-cloud data protection, you can achieve seamless deduplication between data centers and multi-clouds.  

• Using Cyberduck version 6.4.0 or higher, you can connect to OCI object storage

• With dbm cloud systems, you can easy move data and VMs from Classic to OCI, migrate & replicate data from on-premise to OCI and move data stored from any cloud vendor into OCI.

• VictorOps with OCI integration can greatly assist in cloud infrastructure and application monitoring, as well as real-time incident response will improve significantly. 
• ZeroDown software provides HA option for Oracle cloud infrastructure. 

• Coriolis is the simplest way to migrate your windows or Linux VMs alongside their underlying storage and networking configuration across cloud platforms.

SELECT * 
FROM  user_load_operations
WHERE type = 'COPY';

SELECT table_name, owner_name, type, status, logfile_table,

  badfile_table

FROM user_load_operations WHERE type = 'COPY';

SELECT * FROM copy$1_log;
SELECT * FROM copy$1_bad;

• an ADB is created and running
• You have downloaded the database connection credentials (as shown in the below screenshots)
• You have an excel sheet to load the data

• HTTP connectivity between on-premise and Oracle object storage.  Required to move dump files
• Download ADB credentials file
• Download and install latest Oracle client to have new version of expdp/impdp and other essential tools
• Perl >=5.10
• Perl-data-dumper
• Set java in execution path
• Also download and configure OCI CLI from the below link:

• Auto Operations
• ExpDP Operations
• ImpDP Operation
• OCI Object Storage/Bucket Operations
• Database Schema Operations
• Encrypt Password Operations

• Migration summary report with object count
• List objects that can't be migrated to ADB due to restrictions and limitations
• Also, objects list that can be migrated with modifications automatically during import process 
• And Best practices and guidance are listed under Information section

• The target databases (non-ADB) should be configured to use TCP/IP with SSL (TCPS) authentication
• The allowed DB port range is 1521-1525 to ensure the security. You can define the port while creating the DB link
• ADB DB link support databases that are only accessible through a public IP or public hostname
• One directory restricted to one wallet file. Create multiple directories to keep multiple wallet files of multiple databases
• Supported target database versions are 11.2.0.2, 12.1.0.2, 12.2.0.1, 18c and 19c.

• Copy your target database wallet file (cwallet.sso) which contains target database certification to an object store
• Using DBMS_CLOUD.CREATE_CREDENTIAL procedure, create access credentials to the object store where the target wallet file is stored.
• Upload the target database wallet file from Object store to database directory using the DBMS_CLOUD.GET_OBJECT procedure. Refer example below:

• Create credentials on ADB, refer below example:

• Now we are ready to create database link from Autonomous database. Use the example below to create:

BEGIN
     DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK(
          db_link_name => 'ADB_TO_CRDB', 
          hostname => 'adb.eu-frankfurt-1.oraclecloud.com', 
          port => '1525',
          service_name => 'example_medium.adwc.example.oraclecloud.com',
          ssl_server_cert_dn => 'CN=adwc.example.oraclecloud.com,OU=Oracle BMCS FRANKFURT,O=Oracle Corporation,L=Redwood City,ST=California,C=US',
          credential_name => 'DBL_CRDB',
          directory_name => 'DATA_PUMP_DIR');
END;
/

BEGIN
     DBMS_CLOUD_ADMIN.DROP_DATABASE_LINK(
          db_link_name => 'ADB_TO_CRDB' );
END;
/

• Download the client connect credentials
• Unzip the downloaded file to a secure location your computer
• Turn of GLOBAL_NAMES parameter using 'ALTER SYSTEM SET GLOBAL_NAMES=FALSE';
• Using below example, create a db LINK ADB:

CREATE DATABASE LINK DBL_TO_ADB 
   CONNECT TO SYEDJ IDENTIFIED BY welcome1 
   USING
'(description=(retry_count=20)(retry_delay=3)
     (address=(protocol=tcps)(port=1522)(host=example1.oraclecloud.com))     
     (connect_data=(service_name=example2_high.adwc.oraclecloud.com))     
     (security=(my_wallet_directory=/u01/targetwallet)
        (ssl_server_dn_match=true)
        (ssl_server_cert_dn="CN=example2.oraclecloud.com,OU=Oracle
          BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))';

dbname_high= (description=
      (address=(protocol=tcps)(port=1522)(host=adw.example.oraclecloud.com))(connect_data=(service_name=adw_jdbctest_high.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adw.oraclecloud.com,OU=Oracle
      US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))

DB_URL="jdbc:oracle:thin:@dbname_high?TNS_ADMIN=/Users/test/wallet_dbname"

DB_URL="jdbc:oracle:thin:@dbname_high?TNS_ADMIN=/Users/test/wallet_dbname"

# Properties for using Java KeyStore (JKS)
oracle.net.ssl_server_dn_match=true
javax.net.ssl.trustStore==${TNS_ADMIN}/truststore.jks
javax.net.ssl.trustStorePassword=password
javax.net.ssl.keyStore==${TNS_ADMIN}/keystore.jks
javax.net.ssl.keyStorePassword=password

java –classpath ./lib/ojdbc8.jar:./lib/ucp.jar UCPSample

ADWC1_high =
       (description=
             (address=
                   (https_proxy=proxyhostname)(https_proxy_port=80)(protocol=tcps)(port=1522)(host=adw.example.oraclecloud.com)
             )
             (connect_data=(service_name=adwc1_high.adw.oraclecloud.com)
             )
             (security=(ssl_server_cert_dn="adw.example.oraclecloud.com,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")
             )
       )

• Navigate to ADB details page  and click on DB Connection button
• Based on the connectivity requirement, choose either Instance or Regional wallet type and click on the Download button 
• The credentials file is protected with a password. So, you will have to input a password before downloading the file. The password must be 8 characters long, with at least 1 letter and either 1 numeric character or 1 special character
• Once the password is entered and confirmed, download button will be activated to download the connectivity zip file
• Default name for the file is Wallet_databaename.zip, and the zip files contains following files:
• tnsnames.ora & sqlnet.ora
• cwallet.sso & ewallet.p12
• keystore.jks & tuststore.jks
• ojdbc.properties & 

WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="/home/adw_credentials")))
SSL_SERVER_DN_MATCH=yes

• sqlnet.ora should have this entry: SQLNET.USE_HTTPS_PROXY=on
• And the tnsnames.ora entry should contains the following:

ADWC1_high =
       (description=
             (address=
                   (https_proxy=proxyhostname)(https_proxy_port=80)(protocol=tcps)(port=1522)(host=adwc.example.oraclecloud.com)
             )
             (connect_data=(service_name=adwc1_high.adwc.oraclecloud.com)
             )
             (security=(ssl_server_cert_dn="adwc.example.oraclecloud.com,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")
             )
       )

sqlplus sales_dwh@adwc1_low  

SQL*Plus: Release 18.0.0.0.0 - Production on Wed Apr 3 15:09:53 2019
Version 18.5.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Enter password:
Last Successful login time: Wed Apr 03 2019 14:50:39 -07:00

Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

SQL>

• ASM Upgrade Feasible Check: The database is using ASM as storage. Before you upgrade database, you need to upgrade ASM using Automatic Storage Management Configuration Assistant (ASMCA) from grid infrastructure home. ASM should be running from grid infrastructure home. Upgrade Storage Check :  Disk space usage summary Location +DATA_DG does not exist.

• Up to 912 CPU cores and 28.5 TB memory per rack for database processing
• Up to 576 CPU cores per rack dedicated to SQL processing in storage
• From 2 to 19 database servers per rack
• From 3 to 18 storage servers per rack
• Up to 920 TB of flash capacity (raw) per rack
• Up to 3.0 PB of disk capacity (raw) per rack
• Hybrid Columnar Compression often delivers 10X-15X compression ratios
• 40 Gb/second (QDR) InfiniBand Network
• Complete redundancy for high availability

• Hardware and Software
• Control panel software
• The Oracle Advanced Support Gateway (OASW)
• The Oracle Cloud Service

• Oracle Cloud accounts
• VMs instances on IaaS or PaaS
• DB that are provisioned within the PaaS subscription
• Applications (Oracle or any third-party)

• The hardware required to run Cloud at customer
• Control panel software
• The Oracle Advanced Support Gateway
• Oracle Cloud services

• VCN and Subnet CIDR Prefixes
• DNS Names 

1. Create one or more VCNs.
2. Create an Internet gateway and/or NAT gateway. An Internet gateway is a virtual router that allows resources in a public subnet direct access the public Internet. A NAT gateway allows resources that don't have a public IP addresses to access the Internet, without exposing those resources to incoming traffic from the Internet.
3. Configure a service gateway, if required. A service gateway provides a path for private network traffic between your VCN and a public Oracle service such as Oracle Cloud Infrastructure Object Storage.
4. Create one or more subnets in each VCN.
5. Configure local peering gateways between VCNs, if required.
6. Configure security lists, security rules, and route tables for each subnet.