Latest Articles
Oracle Cloud Infrastructure (OCI) : Create a Database VM
This article shows how to create a database virtual machine under Oracle Cloud Infrastructure (OCI).
Oracle Cloud Infrastructure (OCI) : Create a Virtual Cloud Network (VCN)
Oracle Cloud Infrastructure (OCI) allows you to define your own data center network topology inside the Oracle Cloud using a Virtual Cloud Network (VCN).
Database Security Assessment Tool (DBSAT)
The Database Security Assessment Tool (DBSAT) is provided by Oracle as a utility to help you check for common database security issues, as well as helping to identify sensitive data stored in the database.
Scalable Sequences in Oracle Database 18c
Scalable sequences are designed to reduce problems with hot index blocks during large scale data loads into tables with sequence generated primary keys on single instance and RAC databases.
Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 18c
This article contains an example of setting up a physical standby database for Oracle 18c using the Data Guard Broker.
Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 12c Release 2
This article contains an example of setting up a physical standby database for Oracle 12c Release 2 using the Data Guard Broker.
Oracle Cloud : Autonomous Transaction Processing (ATP) - Create Service
This article provides a run through of creating a new Autonomous Transaction Processing (ATP) service on the Oracle Cloud.
Oracle Database 18c RAC On Oracle Linux 7 Using VirtualBox and Vagrant
This article describes the hands-off installation of Oracle Database 18c RAC on Oracle Linux 7 using VirtualBox and Vagrant with no additional shared disk devices.
Read-Only Oracle Homes in Oracle Database 18c
Oracle 18c introduced the concept of a read-only Oracle home, where all configuration and log files can be kept separate from the Oracle binaries.
Oracle Database 18c Installation On Fedora 28 (F28)
This article describes the installation of Oracle Database 18c 64-bit on Fedora 28 (F28).
Oracle Database 18c Installation On Oracle Linux 6 (OL6) and 7 (OL7)
This article describes the installation of Oracle Database 18c 64-bit on Oracle Linux 6 (OL6) and 7 (OL7) 64-bit.
Oracle Cloud : Autonomous Data Warehouse (ADW) - Import Data from an Object Store (impdp)
This article demonstrates how to import data into the Autonomous Data Warehouse (ADW) service on the Oracle Cloud using the impdp utility.
Oracle Cloud : Autonomous Data Warehouse (ADW) - Load Data from an Object Store (DBMS_CLOUD)
This article demonstrates how to load data into the Autonomous Data Warehouse (ADW) service on the Oracle Cloud using the DBMS_CLOUD package.
Oracle Cloud : Autonomous Data Warehouse (ADW) - Create Service
This article provides a run through of creating a new Autonomous Data Warehouse (ADW) service on the Oracle Cloud.
Upgrade Oracle Enterprise Manager Cloud Control 13c Release 2 (13cR2) to 13c Release 3 (13cR3)
This article describes a simple upgrade of Enterprise Manager Cloud Control 13c Release 2 (13cR2) to 13c Release 3 (13cR3).
Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0) Installation on Oracle Linux 6 and 7
This article describes the installation of Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0) on Oracle Linux 6 and 7.
Latest Videos
Check out my YouTube channel here.
- Table Point In Time Recovery (PITR) in 12c
- Oracle Data Guard Broker
- CASE Expressions and CASE Statements
- Indexing JSON Data in Oracle Database 12c
- JSON Support in Oracle Database 12c
Quick Links
- SQL for Beginners
- Multitenant Articles
- ORDS Articles
- JSON Articles
- Docker Articles
- Writing Tips
- Public Speaking Tips
- Learning New Things
- What Employers Want
You can follow me on these networks:
You can get an oracle-base.com t-shirt here.
Oracle Documentation
8iR3,
9iR1,
9iR2
10gR1,
10gR2,
11gR1,
11gR2
12cR1,
12cR2,
18c
ORDS 3.0,
ORDS 17,
ORDS 18
EM 10g,
EM 11g,
EM 12c,
EM 13c
ADW
AS10g R2,
AS10g R3,
FMW 11gR1,
FMW 12cR1,
FMW 12cR2
Oracle VM,
VirtualBox
Oracle Resources
Oracle Developer Community, Technology Network, Oracle Support, Oracle Certification, Oracle Magazine, Ask Tom, Products, Downloads, Documentation, Forums, VirtualBox, VirtualBox Developer VMs, CPUs/PSUs/BPs/RUs/RURs