Oracle Cloud & Third party tools
Jaffar Oracle blog
by
4y ago
There have been several buzz words and offerings since the invention of Cloud concepts. We have been hearing of Private Cloud, Public Cloud, Hybrid cloud and more recently multi-clouds concepts and offering from many leading cloud market players.  All most all leading market players are offering several tools and solutions to support seamless administration, maintenance and operations tasks. Despite many OCI offerings, still we sometimes might need third-party tools or solutions to achieve some of the goals to move or manage the cloud platforms. So, I gonna walk through some of the third ..read more
Visit website
Oracle database migration to cloud with Zero Downtime Migration (ZDM)
Jaffar Oracle blog
by
4y ago
I wrote this article on my LN page, visit the link below to read it. https://www.linkedin.com/pulse/on-premise-oracle-db-migration-cloud-zero-downtime-zdm-hussain/?published=t ..read more
Visit website
Migration methods to Autonomous Database (ADB) - Part IV (DBMS_CLOUD.COPY_DATA)
Jaffar Oracle blog
by
4y ago
In this part of Migration methods to Autonomous Database (ADB) article series, we will see how to load data into ADB database using the DBMS_CLOUD package. Assuming you have an ADB database up & running and you wanna load data from the file stored in any of the supported object storage. The image below from Oracle presentation depicts explains what type of object storage is supported to store the files, and settings required part of DBMS_CLOUD package to load the data. Below image depicts the important procedures and table details to monitor the loading jobs: You may review my earlie ..read more
Visit website
Migration methods to Autonomous Database (ADB) - Part III (SQL Developer)
Jaffar Oracle blog
by
4y ago
In part III article series of Migration methods to Autonomous Database we will see how to migrate or load data into ADB using SQL Developer. Below slide from Oracle presentation depicts SQL Developer different use cases to migrate or load data into ADB: Following screenshots walk through data loading scenario from an excel sheet into an existing table using SQL Developer. To walk though this demonstration, ensure the following is in-place: 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 ..read more
Visit website
Migration methods to Autonomous Database (ADB) - Part II (MV2ADB)
Jaffar Oracle blog
by
4y ago
In part II of migration methods to ADB blog series, we will look into MV2ADB tool details and usage. If you haven't read the Part I, I would encourage you to read it to get basic knowledge on various solutions offered by Oracle and some of the prerequisites for on-premise database migration to ADB. Move to Autonomous Database (aka MV2ADB) tool new tool introduced by Oracle to easily migrate on-premise Oracle database over Autonomous Database levering Oracle data pump capabilities. The tool automates data loading into Oracle Object storage and migrating the data into ADB by one-click option ..read more
Visit website
Migration methods to Autonomous Database (ADB) - Part I (Data Pump)
Jaffar Oracle blog
by
4y ago
In this part of on-premise Oracle database migration to ADB series, we will focus on set of tools to migrate your on-prime database to Autonomies database (ADB). We will briefly discuss about various migration solutions offered by Oracle and walk through data pumps migration pre-requisites and procedure. Database cloud migration requires a good amount of knowledge about various methods offered by Oracle and the best solution that suits your business need. The best place to start with understanding various database cloud migration solutions is to visit the below interactive Cloud Migration Adv ..read more
Visit website
DB Links and ADB - Dos and Don'ts
Jaffar Oracle blog
by
4y ago
DB Link simplifies data sharing across oracle databases. And DB link is created using the CREATE DATABASE LINK SQL command, a very simple and straight forward method. DB link creation has a different procedure on an Autonomous database in contract to typical Oracle databases. In this post, we will highlight the rules, limitations and the use of new DBMS_CLOUD_ADMIN package. Let's get into the action. Rules and Limitations Note some of below rules and limitations of creating DB link from ADB: The target databases (non-ADB) should be configured to use TCP/IP with SSL (TCPS) authentication ..read more
Visit website
Connecting to an Autonomous Database using JDBC Thin client
Jaffar Oracle blog
by
4y ago
I have discussed in my earlier posts about establishing SQL * Plus and using the SQLcl tool details. Today's blog post will take you through JDBC Thin client configuration details to be able to successfully connect with an autonomous database service. Will primarily focus on mandatory JDK, JDBC versions and client connect credentials requirement details. Let's get started. To begin with, any Java application that uses JDBC Thin driver requires an Oracle wallet or JavaKeyStore(JKS). Luckily, these files are readily available on OCI console for download. Refer my earlier blog post to learn abou ..read more
Visit website
Autonomous Database (ADB) connectivity with Oracle SQLcl
Jaffar Oracle blog
by
4y ago
This blog post takes you through Oracle SQL Developer command line interface connectivity to an autonomous database (ADB). SQLcl is a free command line interface for Oracle database. It will allow interactive or batch execution of SQL and PL/SQL commands with in-line editing, statement completion, and command recall for a feature-rich experience capabilities. Download the tool from the below url:     https://www.oracle.com/database/technologies/appdev/sqlcl.html With SQLcl 4.2 or higher you can also connect  to ADB database, either using Oracle Call Interface or JDBC thin connection. Wha ..read more
Visit website
SQL * Plus connectivity to Autonomous Database (ADB) procedure
Jaffar Oracle blog
by
4y ago
Keeping myself occupied learning all about Autonomous Database (ADB) concepts. Thanks to Oracle for the free offer to course and a certification chance. So planned to write a few important topics along the way while learning. This post will focus on autonomous database (ADB) connectivity options, downloading connection credentials and procedure to connect a ADB database using the SQL * Plus tool. Autonomous Database (ADB) can be connected through SQL * Net, JDBC thick/thin or ODBC. All connections to the database must use SSL for encryption and under any circumstances, unsecured connection ar ..read more
Visit website

Follow Jaffar Oracle blog on FeedSpot

Continue with Google
Continue with Apple
OR