Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
Blog | Oracle DBA – Tips and Techniques | Knowledge Is Power – Share IT ….
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Oracle Cloud Marketplace GoldenGate Classic Environment

  • Posted by Gavin Soorma
  • On April 19, 2020
  • 0 Comments
To launch Goldengate via GGSCI we need to enter “ggsci” followed by the “version” -bash-4.2$ which ggsci /usr/local/bin/ggsci -bash-4.2$ ggsci Usage:   /usr/local/bin/ggsci <oracle-version> Example: /usr/local/bin/ggsci oracle18 Goldengate 19c version is 19.1.0.0.4 -bash-4.2$-bash-4.2$ ggsci oracle19 Oracle GoldenGate Command Interpreter for Oracle Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO Linux, x64, 64bit (optimized), Oracle 19c on Oct 17 2019 21:16:29 Operating […]
Read More
 

Oracle GoldenGate on Oracle Cloud Marketplace (Part 3)

  • Posted by Gavin Soorma
  • On April 19, 2020
  • 0 Comments
In this example, we will perform replication from an Oracle 12c Release 1 database hosted on GEN 1 OCI Classic environment to an Oracle 19c Autonomous (ATP) database using Oracle GoldenGate on Cloud Marketplace. In the earlier parts of this post (Part 1 and Part 2) , we have discussed how to configure Oracle GoldenGate […]
Read More
 

Oracle GoldenGate on Oracle Cloud Marketplace (Part 2)

  • Posted by Gavin Soorma
  • On April 19, 2020
  • 0 Comments
Connect to the GoldenGate Cloud Marketplace Node Identify the Public IP Address of the GoldenGate Cloud Marketplace compute node and connect via PuTTY using the saved PPK  private key. (note we had to provide the SSH Public Key details when we deployed Oracle GoldenGate Cloud Marketplace)   Note the directory structure of the GoldenGate Cloud […]
Read More
 

Data migration to Autonomous Database using MV2ADB

  • Posted by Gavin Soorma
  • On April 19, 2020
  • 1 Comments
Move to Autonomous Database (MV2ADB) is a tool developed by Oracle (thanks Ruggero Citton, great work!) to fully  automate the process of migrating data both from on-premise as well as OCI Classic Gen 1 to Autonomous Database Cloud on OCI. Data migration and loading to an Autonomous Database can now be performed using a single […]
Read More
 

Migrate data in real-time from OCI Classic to OCI using MV2ADB and Oracle Cloud Marketplace GoldenGate

  • Posted by Gavin Soorma
  • On April 19, 2020
  • 1 Comments
In example we will use a combination of Oracle Cloud Marketplace GoldenGate and the MV2ADB tool to migrate data in real-time from an Oracle 12c database hosted on Gen 1 OCI Classic infrastructure to an OCI Oracle 18c Autonomous database. Oracle GoldenGate Extract and Replicat processes run on Cloud Marketplace which has network connectiviy to […]
Read More
 

Oracle GoldenGate on Oracle Cloud Marketplace (Part 1)

  • Posted by Gavin Soorma
  • On March 29, 2020
  • 0 Comments
Oracle Cloud Marketplace (https://cloudmarketplace.oracle.com) is an online store selling a wide variety of business applications and services which can complement an existing Oracle Cloud implementation. All these applications and services available on the Cloud marketplace are offered by Oracle approved and registered partners and developers. Oracle GoldenGate is one of the many applications available on […]
Read More
 

Oracle 19c New Feature Compare Execution Plans with DBMS_XPLAN.COMPARE_PLANS

  • Posted by Gavin Soorma
  • On August 12, 2019
  • 0 Comments
In Oracle 19c, a new sub-program called COMPARE_PLANS has been added to DBMS_XPLAN. With this new functionality, we can take a reference plan and compare it with some other execution plan – it could belong to a SQL statement already executed where we obtain the plan from the Cursor Cache or from the AWR history […]
Read More
 

Oracle 19c New Feature Hybrid Partitioned Tables

  • Posted by Gavin Soorma
  • On July 30, 2019
  • 0 Comments
In Oracle 12c Release 2, one of the new features was the ability to create partitions on External tables. New in Oracle 19c is the feature where we can create a Hybrid Partitioned table – so some partitions exist in the database and some partitions are hosted external to the database – maybe on a […]
Read More
 1

Oracle 18c New Feature – Online Partitioning Strategy Modification

  • Posted by Gavin Soorma
  • On July 28, 2019
  • 0 Comments
In Oracle 12c Release 2, a new feature was added whereby we could convert a non-partitioned table to a partitioned table with a MODIFY clause added to the ALTER TABLE SQL statement. In addition, the operation could be performed online enabling concurrent DML operations while the conversion was being performed. This was a very good […]
Read More
 1

Applying the July 2019 Database Release Update Patch

  • Posted by Gavin Soorma
  • On July 24, 2019
  • 0 Comments
This note describes the steps used to apply the latest July 2019 Database Release Update Patch for Oracle 12c Release 2. The environment is single instance Multitenant database. Notes 1)Review MOS note Master Note for Database Proactive Patch Program (Doc ID 756671.1) 2)Download patch p29699168_122010_Linux-x86-64.zip – COMBO OF OJVM RU COMPONENT 12.2.0.1.190716 + 12.2.0.1.190716 DBJUL2019RU […]
Read More
 2

Oracle 19c New Feature Automatic Indexing

  • Posted by Gavin Soorma
  • On July 9, 2019
  • 0 Comments
Automatic Indexing is a new feature in Oracle 19c which automatically creates, rebuilds, and drops indexes in a database based on the application workload. The index management task is now dynamically performed by the database itself via a task which executes in the background every 15 minutes. Automatic indexing task analyzes the current workload and […]
Read More
 3

Oracle 19c New Feature Automatic Flashback of Standby Database

  • Posted by Gavin Soorma
  • On July 2, 2019
  • 0 Comments
One of the new features in Oracle 19c is that either when a flashback or point-in-time recovery is performed on the primary database in an Oracle Data Guard configuration, the same operation is also performed on the standby database as well. Following a flashback or PITR operation, the primary database is then opened with the […]
Read More
 

Oracle 18c New Feature Private Temporary Tables

  • Posted by Gavin Soorma
  • On June 28, 2019
  • 0 Comments
Active Data Guard databases are now no longer just ‘read-only’ databases – they have now become ‘read-mostly’ databases which is primarily used for reporting purposes but also allows to some extent DML activity as well. One of the new features in Oracle 18c is Private Temporary Tables. Private temporary tables differ from Global Temporary tables […]
Read More
 

SQLcl – SQL Command Line Interface Top Features

  • Posted by Gavin Soorma
  • On June 26, 2019
  • 1 Comments
SQLcl or also known as SQL Command Interface was earlier available as a stand alone utility which we could download – it is now bundled in the Oracle 18c and Oracle 19c software (as well as 12c Release 2). Think of SQLcl as a feature-rich combination of SQL*Plus and SQL Developer – all the helpful […]
Read More
 

SQL*Plus New Features in Oracle 12c Release 2 and 18c

  • Posted by Gavin Soorma
  • On June 25, 2019
  • 0 Comments
A number of new features were added in Oracle 12c Release 2 and Oracle 18c related to SQL*Plus. Let us have a quick look at some of these new features and how they can be used.   Oracle 18c SET FEEDBACK ON SQL_ID: Display the sql_id for the currently executed SQL statement SET ROWLIMIT n: […]
Read More
 5

DBCA New Features Oracle 19c

  • Posted by Gavin Soorma
  • On June 24, 2019
  • 1 Comments
In Oracle 19c a number of new features have been added to DBCA in silent mode. In Oracle 18c, we could clone a PDB both via the GUI DBCA as well as using the dbca -silent -createPluggableDatabase command. New in Oracle 19c is the ability to create a remote clone of a PDB as well […]
Read More