8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » Misc » Here


Miscellaneous Articles

DBA

ALTER TABLE ... SHRINK SPACE Command : Online Segment Shrink for Tables, LOBs and IOTs - The ALTER TABLE ... SHRINK SPACE command is used to perform online segment shrinks for tables, LOBs and IOT overflow segments.

Autonomous Health Framework (AHF) - Autonomous Health Framework (AHF) provides a number of diagnostic tools in a single bundle, making it easy to gather diagnostic information about the Oracle database and clusterware.

AutoNumber And Identity Functionality - Implement AutoNumber or Identity column behaviour in Oracle.

Basic Enterprise Manager Troubleshooting - The first things to check out when the web-based Enterprise Manager console stops working.

Basic Security Measures for Oracle - This article presents some basic steps to increase the security of your Oracle database servers.

Clean-Up the '.patch_storage' Directory - This article demonstrates how to clean up wasted storage associated with old database patches.

Clearing Down Old Database Sessions - This article explains how you might manage large numbers of old or inactive database sessions.

Configuration of TCP/IP with SSL and TLS for Database Connections - This article describes the server and client configuration needed to use TCP/IP with SSL and TLS for database connections.

Cost Based Optimizer (CBO) And Database Statistics - Lists the available mechanisms for gathering database statistics that are used by the cost based optimizer.

Database Configuration Assistant (DBCA) : Creating Databases in Silent Mode - This article demonstrates how to create a new database using the Database Configuration Assistant (DBCA) in silent mode.

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.

DBMS_SQLHASH Package - The DBMS_SQLHASH package allows us to generate a hash based on the result set returned by a query.

Deadlocks - This article shows the steps necessary to identify the offending application code when a deadlock is detected.

Detect And Repair Corruption in an Oracle Database - Learn the different methods of detecting and repairing table block corruption.

Direct and Asynchronous I/O - Take advantage of the performance advantages associated with Direct and Asynchronous I/O.

Dbvisit Replicate Installation on Oracle Linux 5 and 6 - This article describes the installation and configuration of Dbvisit Replicate with Oracle Database 11g Release 2 on Oracle Linux 5 and 6.

Dbvisit Reporting Installation on Oracle Linux 5 and 6 - This article describes the installation and configuration of Dbvisit Reporting with Oracle Database 11g Release 2 on Oracle Linux 5 and 6.

Dbvisit Standby Installation on Oracle Linux 5 and 6 - This article briefly describes the installation and usage of Dbvisit Standby with Oracle Database 11g Release 2 on Oracle Linux 5 and 6.

Dbvisit Standby 9 Installation on Oracle Linux 7 - This article describes the installation and usage of Dbvisit Standby 9 on Oracle Linux 7 with Oracle Database 19c.

Granular Control of Optimizer Features (OPTIMIZER_FEATURES_ENABLE, _FIX_CONTROL, V$SYSTEM_FIX_CONTROL and V$SESSION_FIX_CONTROL) - Enable and disable specific optimizer features and bug fixes in Oracle 10.2.0.2 and above.

hcheck.sql : A Quick Check for Known Data Dictionary Problems - The hckeck.sql script checks for known data dictionary problems in the Oracle database, so it can be used as a quick health check of a database when trying to diagnose problems.

Heterogeneous Services (Generic Connectivity) : Oracle to Non-Oracle Database Links Using ODBC - Query non-Oracle databases using database links over ODBC.

Identifying Host Names and IP Addresses - This article presents a mixed bag of Oracle functionality relating to the identification of host names and IP addresses for Oracle clients and servers.

Incrementally Updated Backups : Rolling Forward Image Copies Using RMAN - Speed up backup and recovery time by rolling your image copy backups forward using incremental backups.

Install Sample Schemas - A quick note as a reminder of how to install the sample schemas into an existing database.

Killing Oracle Sessions (ALTER SYSTEM KILL / DISCONNECT SESSION) - Kill Oracle sessions from SQL, NT and UNIX.

Learning to be an Oracle Database Administrator (DBA) - My thoughts on the most efficient way to learn to be an Oracle Database Administrator (DBA).

Manually Cloning an Existing Oracle Database Installation on Linux - This article describes the steps necessary to manually clone an existing Oracle database installation to a new Linux server.

Manual Oracle Uninstall - Having trouble removing all Oracle software using the OUI? Try these methods.

Materialized Views in Oracle - Use materialized views (snapshots) to replicate data to a remote database.

Measuring Storage Performance For Oracle Systems - This article outlines two easy ways to test the performance of your storage systems using utilities provided by Oracle.

Native Network Encryption for Database Connections - Native network encryption gives you the ability to encrypt database connections, without the configuration overhead of TCP/IP and SSL/TLS and without the need to open and listen on different ports.

ORA-00600 ORA-07445 ORA-00700 : How to Diagnose and Fix Them - A quick note to explain how to deal with these errors, so I don't have to keep answering the same questions.

Oracle Certification : Frequently Asked Questions (OCA, OCP, OCE, OCM) - My personal opinions when answering questions about Oracle Certification.

Oracle Databases and CI/CD Pipelines - This article contains a general discussion about how Oracle Databases can fit into Continuous Integration/Continuous Delivery (CI/CD) pipelines.

Oracle Database Consolidation Comparison - An overview of the available options for consolidation of Oracle databases.

Naming Conventions - Some of the typical naming conventions used for objects in Designer and the database.

Oracle Instant Client Installation - Quickly enable Oracle access without the need for a full-blown Oracle Client installation.

Oracle Network Configuration (listener.ora , tnsnames.ora , sqlnet.ora) - This article gives an example of each configuration file (listener.ora , tnsnames.ora , sqlnet.ora) as a starting point for simple network configuration.

Oracle Shell Scripting - This article presents some some basic techniques for creating Windows batch files and UNIX/Linux shell scripts that connect to SQL*Plus and RMAN.

Oracle Universal Installations (OUI) Silent Installations - Use the Oracle Universal Installations (OUI) to create and use response files to automate the installation of Oracle products.

OS Authentication - A guide to configuring OS authentication on UNIX/Linux and Windows servers.

OS Backup Commands - A summary of the operating system backup commands you might encounter whilst backing up Oracle databases.

Partitioning an Existing Table using EXCHANGE PARTITION - This article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax.

Partitioning an Existing Table using DBMS_REDEFINITION - This article presents a simple method for partitioning an existing table using the DBMS_REDEFINITION package.

Purge the Shared Pool (DBMS_SHARED_POOL and ALTER SYSTEM FLUSH SHARED_POOL) - This article describes how to use the the DBMS_SHARED_POOL package and the ALTER SYSTEM FLUSH SHARED_POOL statement to remove one or more objects from the shared pool.

Proxy User Authentication and Connect Through in Oracle Databases - Connect to other database users without knowing their passwords.

Oracle and RAID - A summary of the most common RAID levels and their usage with Oracle files.

Reclaiming Unused Space in Datafiles - This article shows several methods for reclaiming unused space from datafiles.

Recompiling Invalid Schema Objects - This article presents several methods for recompiling invalid schema objects.

Renaming or Moving Oracle Files - An explanation of how assorted Oracle files can be renamed or moved to a new location.

Reverse Key Indexes - Reverse key indexes literally reverse the bytes of the key value in the index to reduce block contention on sequence generated primary keys.

Schema Owners and Application Users - Protect your schema objects by defining application users with the necessary privileges on those objects, rather than allowing direct connections to the schema owner.

Setting Database Time Zones in Oracle - This article contains several methods for setting the time zone in an Oracle database.

Stored Outlines and Plan Stability - Use stored outlines to maintain consistent execution plans regardless of changes in the system environment or associated statistics.

SYSRESV Utility and "ORA-01041: internal error. hostdef extension doesn't exist" - This article provides an example of using the SYSRESV utility to identify the shared memory segments associated with an Oracle instance.

SQL Developer 3.1 Data Pump Wizards (expdp, impdp) - This article gives an overview of the Data Pump Wizards included in SQL Developer 3.1.

SQL Developer 3.1 Scheduler (DBMS_SCHEDULER) Support - A brief overview of the DBMS_SCHEDULER support in SQL Developer 3.1.

Tablespace Thresholds and Alerts (DBMS_SERVER_ALERT) - Set tablespace thresholds as an early warning mechanism for space issues.

Oracle Trace File Analyzer (TFA) - Oracle Trace File Analyzer (TFA) provides a number of diagnostic tools in a single bundle, making it easy gather diagnostic information about the Oracle database and clusterware.

Running Commands in Different Schemas and Pluggable Databases - This article explains how to run commands in a different schema using the DBMS_SCHEDULER and DBMS_SQL packages.

Tracking Database Feature Usage (DBA_FEATURE_USAGE_STATISTICS) - Identify which database options you are using to see if you comply with your Oracle licensing.

Transportable Tablespaces - Copy tablespaces to new instances in the time it takes to copy the datafiles.

UNIX Commands For DBAs - A selection of UNIX commands including those for monitoring performance.

Unregister a Database From an RMAN Recovery Catalog - A step-by-step guide to unregistering unwanted databases from the RMAN catalog.

Upgrade the Database Time Zone File Using the DBMS_DST Package - The DBMS_DST package was introduced to simplify the process of upgrading the database time zone file, as well as the time zone data based on new time zone file.

Virtual Indexes - Use virtual indexes to test alternate indexing strategies with no impact on the rest of your system.

Development

ALL, ANY and SOME Comparison Conditions in SQL - A quick look at some comparison conditions you may not be used to seeing in SQL against an Oracle database.

Analytic Functions - An introduction to analytic functions in Oracle.

ANYDATA Type - This article presents an overview of the ANYDATA type.

APEX_DATA_PARSER : Convert simple CSV, JSON, XML and XLSX data as rows and columns. - The APEX_DATA_PARSER package allows you to easily convert simple CSV, JSON, XML and XLSX formatted data into rows and columns from SQL.

APEX_WEB_SERVICE : Consuming SOAP and REST Web Services - Use the APEX_WEB_SERVICE package to simplify consuming SOAP and REST web services from PL/SQL.

APPEND Hint - Use the APPEND hint to improve the performance of load operations.

Autonomous Transactions - A brief overview of autonomous transactions.

Change Your Own Password in an Oracle Database - This article describes how to change the password for your own user in an Oracle database.

Check the Contents of Ref Cursors - This article demonstrates a few simple ways to display the contents of ref cursors.

Database Triggers Overview - An introduction to database triggers in Oracle.

DBMS_PIPE : For Inter-Session Communication - This article presents a brief description of the DBMS_PIPE package, explaining how it can be used for non-secure inter-session mesaging.

DBMS_RANDOM : Generating Random Data (Numbers, Strings and Dates) in Oracle - A description of how to generate random numbers, string and dates in Oracle.

DBMS_SESSION : Managing Sessions From a Connection Pool in Oracle Databases - A guide to using the DBMS_SESSION package to manage sessions that form part of a connection pool.

Decoupling to Improve Performance - Learn how to decouple processing to give the impression of improved performance.

Download Files Using PL/SQL and a Gateway (ORDS, mod_plsql, EPG) - This article gives some examples of the PL/SQL needed to download files using a PL/SQL gateway, such as ORDS, mod_plsql or the embedded PL/SQL gateway (EPG).

Dynamic IN-Lists - This article presents a number of methods for parameterizing the IN-list of a query.

Efficient Function Calls From SQL - This article presents a number of solutions for making calls to PL/SQL functions from SQL more efficient.

Efficient SQL Statements - A brief non-version specific guide to writing efficient SQL statements.

Email From Oracle PL/SQL (UTL_SMTP) - Email from PL/SQL using UTL_SMTP rather than using external procedures or Java.

FIRST_VALUE and LAST_VALUE Analytic Functions - Simple examples of how to use these analytic functions.

FTP From PL/SQL - A description of two methods for triggering FTP jobs directly from PL/SQL.

Hierarchical Queries in Oracle - Easily query hierarchical data in Oracle databases using SQL.

How do I learn to tune SQL? - A brief overview of the topic of SQL tuning for beginners.

HTML with Embedded Images from PL/SQL - Use PL/SQL to create HTML with embedded images.

Implicit vs. Explicit Cursors in Oracle PL/SQL - A comparison of the relative performance of implicit and explicit cursors in Oracle PL/SQL.

Instrumenting Your PL/SQL Code - No matter who you are or how cool you think you are at programming, you can never know exactly what is going on in your code unless you instrument it.

Introduction to PL/SQL - A brief overview of some of the important points you should consider when first trying to learn PL/SQL.

Join Elimination - This article describes how join elimination can improve performance of queries by removing tables from the plan.

LAG and LEAD Analytic Functions - Simple examples of how to use these analytic functions.

List Files in a Directory From PL/SQL and SQL : Comparison of Methods - This article compares the methods available to list files in a directory on the database server.

List Files in a Directory From PL/SQL and SQL : External Table - This article shows how to list files in a directory on the database server using an external table.

List Files in a Directory From PL/SQL and SQL : Java - This article shows how to list files in a directory on the database server using a Java in the database.

List Files in a Directory From PL/SQL and SQL : DBMS_BACKUP_RESTORE - This article shows how to list files in a directory on the database server using the DBMS_BACKUP_RESTORE package.

List Files in a Directory From PL/SQL and SQL : DBMS_SCHEDULER - This article shows how to list files in a directory on the database server using the DBMS_SCHEDULER package.

Literals, Substitution Variables and Bind Variables - The article compares the affect of using literals, substitution variables and bind variables on memory and CPU usage.

Logic/Branch Ordering in PL/SQL - This article demonstrates the affect of branch ordering on the performance of CASE and ELSIF statements.

Managing Database Links - Some quick guidelines to help you manage database links.

NOCOPY Hint to Improve Performance of OUT and IN OUT Parameters in PL/SQL Code - This article discusses the benefits of using the NOCOPY hint for passing large or complex OUT and IN OUT parameters in PL/SQL.

NULL-Related Functions (NVL, DECODE, NVL2, COALESCE, NULLIF, LNNVL, NANVL, SYS_OP_MAP_NONNULL) - A summary of the functions available for handling NULL values.

Object Views and Nested Tables - Use object views to present relational data as an object-relational model.

One True Lookup Table (OTLT) - A description of a common design anti-pattern, where lookup tables are combined into a single table.

Oracle Certification : Frequently Asked Questions (OCA, OCP, OCE, OCM) - My personal opinions when answering questions about Oracle Certification.

Oracle Dates, Timestamps and Intervals - An overview of the usage of dates, timestamps and intervals in Oracle databases.

Oracle Sequences - This article demonstrates the common ways sequences can be used to generate synthetic or surrogate keys.

Overlapping Date Ranges - This article presents simple methods to test for overlapping date ranges.

Performance of Numeric Data Types in PL/SQL - This article demonstrates the relative performance of the numeric data types in PL/SQL.

PL/SQL : Stop Making the Same Performance Mistakes - This article describes the common PL/SQL performance mistakes I see people making time and time again.

PL/SQL Vs. Oracle JVM: Speed Comparison for Mathematical Operations - This article does a side-by-side speed comparison of PL/SQL and the Oracle JVM for some basic mathematical operations.

Populating Master-Detail Foreign Key Values Using Sequences - This article presents some safe methods for populating master-detail foreign key columns when using sequences.

RANK, DENSE_RANK, FIRST and LAST Analytic Functions - Simple examples of how to use these analytic functions.

Regular Expression Support in Oracle (REGEXP_COUNT, REGEXP_INSTR, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_LIKE) - Using regular expressions to solve some questions I've been asked over the years.

Retrieving HTML and Binaries into Tables Over HTTP - This article gives two brief examples of how HTML pages and Binaries, such as images or documents, can be downloaded over HTTP and placed directly into tables.

ROLLUP, CUBE, GROUPING Functions and GROUPING SETS - An overview of some functionality available for aggregation in data warehouses.

ROWIDs for PL/SQL Performance - This article demonstrates how using ROWIDs in transactions can improve performance.

Short-Circuit Evaluation in PL/SQL - This article describes how short-circuit evaluation can be used to improve the performance of some boolean expressions.

SQL for Beginners (Part 1) : The SELECT List - In this article we take a look at the type of things you are likely to see in the SELECT list of queries.

SQL for Beginners (Part 2) : The FROM Clause - In this article we take a look at the type of things you are likely to see in the FROM clause of queries.

SQL for Beginners (Part 3) : The WHERE Clause - In this article we take a look at the type of things you are likely to see in the WHERE clause of queries.

SQL for Beginners (Part 4) : The ORDER BY Clause - In this article we take a look at how you can influence the order of the data that is returned by queries.

SQL for Beginners (Part 5) : Joins - In this article we take a look at some of the common joins, both ANSI and non-ANSI, available in SQL.

SQL for Beginners (Part 6) : Set Operators - In this article we take a look at the SQL set operators available in Oracle.

SQL for Beginners (Part 7) : The GROUP BY Clause and HAVING Clause - In this article we take a look at the GROUP BY clause and HAVING clause in SQL.

SQL for Beginners (Part 8) : The INSERT Statement - In this article we take a look at some of the variations on the INSERT statement.

SQL for Beginners (Part 9) : The UPDATE Statement - In this article we take a look at some of the variations on the UPDATE statement.

SQL for Beginners (Part 10) : The DELETE and TRUNCATE TABLE Statements - In this article we take a look at the DELETE and TRUNCATE TABLE statements.

SQL/XML (SQLX) : Generating XML using SQL - Oracle9i Release 2 includes functionality to support the emerging SQL/XML standard to simplify XML generation from SQL queries.

String Aggregation Techniques - Several methods of combining multiple rows of data into a single row using aggregate functions.

Top-N Queries - Top-N queries provide a method for limiting the number of rows returned from ordered sets of data.

Updates Based on Queries - This article describes how a table can be updated using data from another table.

Using Ref Cursors To Return Recordsets - Return recordsets from Oracle stored procedures.

UTL_HTTP and SSL (HTTPS) using Oracle Wallets - This article describes how to use the UTL_HTTP package to interact with resources secured by SSL (HTTPS).

utPLSQL Installation and Upgrade - This article demonstrates the installation and upgrade of the utPLSQL unit test framework for PL/SQL.

Web Services and the Oracle Database - An overview of the functionality available in the Oracle database for consuming and publishing web services.

Web Scripting for Oracle (PHP, Perl, JSP, ASP and ASP.NET) - This article presents the basic syntax for several popular web scripting languages that connect to Oracle databases.

WITH Clause : Subquery Factoring in Oracle - Use the WITH clause in Oracle to reduce repetition and simplify complex SQL statements.

XML-Over-HTTP (REST Web Services) From PL/SQL - XML-over-HTTP was the precursor to web services allowing easy access to XML via HTTP GETs and POSTs.

XMLTABLE : Convert XML Data into Rows and Columns using SQL - Use the XMLTABLE operator to project columns on to XML data, allowing you to query it directly from SQL.

Middleware

Oracle 9iAS Articles - Installation and configuration articles for Oracle 9iAS.

Oracle AS10g Articles - Installation and configuration articles for Oracle AS10g.

Oracle WebLogic 11g Articles - Installation and configuration articles for Oracle WebLogic 11g.

Oracle WebLogic 12c Articles - Installation and configuration articles for Oracle WebLogic 12c.

An Oracle DBA's Guide to WebLogic Server - An overview of WebLogic Server for beginners, especially DBA's, who are new to middle tier administration.

Linux HTTP Server Configuration - Install and configure an Apache HTTP server on Linux.

Apache Tomcat 6 Installation on Linux (RHEL and clones) - A guide to installation of Apache Tomcat on RHEL and its clones.

Apache Tomcat 7 Installation on Linux (RHEL and clones) - A guide to installation of Apache Tomcat 7 on RHEL and its clones.

Apache Tomcat 8 Installation on Linux (RHEL and clones) - A guide to installation of Apache Tomcat 8 on RHEL and its clones.

Apache Tomcat 7 Installation on Windows - A guide to installation of Apache Tomcat 7 on Windows.

Apache : Reverse Proxy Configuration - Learn how to configure Apache as a reverse proxy server.

Apache Monitoring using mod_status (server-status) - Monitor the performance of Apache servers using the mod_status Apache module.

NGINX : Reverse Proxy Configuration - Learn how to configure NGINX as a reverse proxy server.

Database Callouts : Simplifying Certificate Management and TLS Version Support by Using a Reverse Proxy - This article describes how using a reverse proxy can simplify the certificate management required for database callouts. It also explains how this can be used to overcome TLS support issues encountered by older systems.

Signing JAR Files - This article describes the method for creating a keystore and signing JAR files.

Apache and PHP Installation on Windows - The steps necessary to get Apache 1.3 and PHP 4.4.0 configured on Windows to connect to Oracle.

Configuration of PHP with IIS on Windows 2003 - This article contains instructions for setting up PHP with IIS on Windows 2003.

Zend Core for Oracle v2 - Get a fully configured Apache + PHP server with full Oracle connectivity from a single installation.

Create Self-Signed SSL Certificates - Notes on how to create self-signed SSL certificates using a variety of methods.

Monitoring Java Garbage Collection Using jstat - This article provides a very brief introduction to diagnosing Java performance problems relating to garbage collection.

Application Express (APEX)

Oracle Application Express (APEX) Installation - A brief overview of the installation process for Application Express (APEX) for releases from 5.x onward.

Oracle Application Express (APEX) Post Upgrade - Clean Up Old Installations - This article demonstrates how to remove old installations after an APEX upgrade.

Oracle Application Express (APEX) Patches - This article describes how to patch minor version numbers of APEX.

Oracle Application Express (APEX) LDAP Authentication - Use DBMS_LDAP to perform LDAP authentication from Oracle Application Express (APEX).

Azure AD Authentication for Oracle APEX Applications : Social Sign In - This article describes the setup of social sign in to enable Azure AD authentication of APEX applications.

Oracle Application Express (APEX) 4.2 Basic Themes and Cascading Style Sheets (CSS) - This article covers some really basic information about APEX themes and CSS. It is meant as a quick pointer to help you start customizing your APEX look and feel.

APEX_DATA_PARSER : Convert simple CSV, JSON, XML and XLSX data to rows and columns. - The APEX_DATA_PARSER package allows you to easily convert simple CSV, JSON, XML and XLSX formatted data into rows and columns from SQL.

APEX_JSON Package: Generate and Parse JSON Documents in Oracle - This article gives a brief overview of using the APEX_JSON package to generate and parse JSON documents in Oracle.

APEX_MAIL : Send Emails from PL/SQL - The APEX_MAIL package provides an API for sending emails from PL/SQL.

APEX_WEB_SERVICE : Consuming SOAP and REST Web Services - Use the APEX_WEB_SERVICE package to simplify consuming SOAP and REST web services from PL/SQL.

APEX_ZIP : Manage Zip Files From PL/SQL - The APEX_ZIP package provides an API to manage zip files from PL/SQL.

Multitenant : Remove APEX Installations from the CDB in Oracle Database 12c Release 1 (12.1) - This article describes how to remove APEX from the CDB so you can install it directly in a PDB.

Oracle REST Data Services (ORDS) : Installation on Tomcat - Install Oracle REST Data Services (ORDS) on Tomcat.

Oracle Application Express (APEX) : Change the Admin Password - This article describes the two methods of changing the admin password for APEX.

SQLcl and APEXExport : Export APEX Applications and Workspaces From the Command Line - This article describes how to use SQLcl and the APEXExport utility to export applications and workspaces.

Oracle Application Express (APEX) Production Environment Topology - This article gives an example of the topology necessary to deploy an APEX application safely in a production environment.

Liquibase : Deploying Oracle Application Express (APEX) Applications - This article demonstrates how to deploy Oracle Application Express (APEX) applications using Liquibase.

SQLcl : Deploying Oracle Application Express (APEX) Applications using the SQLcl implementation of Liquibase - This article demonstrates how to deploy Oracle Application Express (APEX) applications using the SQLcl implementation of Liquibase.

Oracle Cloud : APEX Application Development Service (APX) - Create Service - This article provides a run through of creating a new APEX Application Development (APX) service on the Oracle Cloud.

Oracle Cloud : APEX Application Development Service (APX) - Import Data - This article describes how to import data into the APEX Application Development (APX) service on the Oracle Cloud.

APEX Tips : Some basic notes as reminders about how to use specific features of APEX.

Oracle REST Data Services (ORDS)

See the Introduction to JSON Support in the Oracle Database article for an introduction to REST and JSON.

Oracle REST Data Services (ORDS) : YouTube Playlist

Oracle REST Data Services (ORDS) : Installation on Tomcat (ORDS Version 22.1 Onward) - Install Oracle REST Data Services (ORDS) version 22.1 onward on Tomcat.

Oracle REST Data Services (ORDS) : Installation on Tomcat (ORDS Versions 3.0 to 21.4) - Install Oracle REST Data Services (ORDS) on Tomcat.

Oracle REST Data Services (ORDS) : Installation on Tomcat (Windows) - Install Oracle REST Data Services (ORDS) version 22.1 onward on Tomcat running on Windows.

Oracle REST Data Services (ORDS) : Upgrade ORDS (ORDS Versions 3.0 to 21.4) - This article describes the process of upgrading an existing installation of Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : Standalone Mode (ORDS Version 22.1 Onward) - This article provides an overview of using Oracle REST Data Services (ORDS) version 22.1 onward in standalone mode.

Oracle REST Data Services (ORDS) : Standalone Mode (ORDS Versions 3.0 to 21.4) - This article provides an overview of using Oracle REST Data Services (ORDS) in standalone mode.

Oracle REST Data Services (ORDS) : Configure Multiple Databases (ORDS Version 22.1 Onward) - This article describes how to create new database connections so ORDS can service APEX, PL/SQL application and ORDS RESTful services.

Oracle REST Data Services (ORDS) : Configure Multiple Databases (ORDS Versions 3.0 to 21.4) - This article describes how to create new database connections so ORDS can service APEX, PL/SQL application and ORDS RESTful services.

Oracle REST Data Services (ORDS) : Create Basic RESTful Web Services Using PL/SQL - This article gives an overview of using Oracle REST Data Services to developing RESTful web services using the PL/SQL API provided by the ORDS package.

Oracle REST Data Services (ORDS) : RESTful Web Services Handling Complex JSON Payloads - This article describes how to create RESTful web services that can process complex JSON payloads representing complete transactions.

Oracle REST Data Services (ORDS) : RESTful Web Services Handling Media (Documents and Images) - This article demonstrates how to create RESTful web services that handle media, such as documents and images, using Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : Allowed Origins - This article gives an example of controlling the allowed origins for a web service created with Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : AutoREST - This article gives an overview of the AutoREST functionality of Oracle REST Data Services (ORDS), which allows you to automatically expose tables and views as RESTful web services.

Oracle REST Data Services (ORDS) : AutoREST of JSON-Relational Duality Views - This article gives an overview of the AutoREST functionality of Oracle REST Data Services (ORDS) against JSON-relational duality views in Oracle 23c.

Oracle REST Data Services (ORDS) : Auto PL/SQL - This article gives an overview of the Auto PL/SQL functionality of Oracle REST Data Services (ORDS), which allows you to easily expose PL/SQL code as RPC over HTTP(S).

Oracle REST Data Services (ORDS) : Remote Procedure Call (RPC) and Output Parameters - This article demonstrates how to handle output parameters from procedures when using Oracle REST Data Services (ORDS) for remote procedure calls (RPC).

Oracle REST Data Services (ORDS) : Using SQL Developer - This article gives an overview of using SQL Developer to interact with Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : Authentication - This article gives a quick run through the authentication options available with Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : Database Authentication - Use database authentication to provide basic authentication for your calls to PL/SQL from Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : Basic and Digest Authentication on Tomcat using JDBCRealm - This article demonstrates the use of the Tomcat JDBCRealm to control authentication to Oracle REST Data Services (ORDS) web services.

Oracle REST Data Services (ORDS) : Basic and Digest Authentication on Tomcat using DataSourceRealm - This article demonstrates the use of the Tomcat DataSourceRealm to control authentication to Oracle REST Data Services (ORDS) web services.

Oracle REST Data Services (ORDS) : Custom Authentication Schemes - This article gives an example of how you could develop your own custom authentication scheme for Oracle REST Data Services (ORDS).

Oracle REST Data Services (ORDS) : Presenting PL/SQL Web Toolkit Applications - PL/SQL Web Toolkit applications can be presented using Oracle REST Data Services (ORDS) rather than mod_plsql.

Oracle REST Data Services (ORDS) : File Upload and Download (mod_plsql Style) - Upload and download files directly from the database using Oracle REST Data Services to replace the mod_plsql style upload/download functionality.

Oracle REST Data Services (ORDS) : Simple Oracle Document Access (SODA) for REST - This article gives an overview of the Simple Oracle Document Access (SODA) for REST functionality of Oracle REST Data Services (ORDS), which allows you to use Oracle as a JSON document store.

Oracle REST Data Services (ORDS) : REST Enabled SQL - REST Enabled SQL allows REST client to send DML, DDL and scripts to any REST enabled schema without additional web service configuration.

Oracle REST Data Services (ORDS) : Open API 2.0 (Swagger) Support - From version 17.4 onward, Oracle REST Data Services (ORDS) exposes the metadata of web services in Open API 2.0 format, making it easy to document and generate calling code for REST APIs using Swagger.

Oracle REST Data Services (ORDS) : HTTP Headers (OWA_UTIL) and ORDS-Specific Bind Variables - This article describes how to get information from the HTTP header of a request to ORDS using the OWA_UTIL package, as well as how to reference ORDS-specific bind variables.

Oracle REST Data Services (ORDS) : Including Hyperlinks in JSON Output - This article demonstrates how column aliases are used to instruct Oracle REST Data Services (ORDS) to display values as hyperlinks in the JSON output.

Oracle REST Data Services (ORDS) : Use SQLcl to Display ORDS Web Service Definitions - SQLcl is a lightweight Java-based replacement for SQL*Plus, which amongst other things allows you to display ORDS web service definitions using the REST command.

Oracle REST Data Services (ORDS) : SQL Developer Web - SQL Developer Web allows Oracle REST Data Services (ORDS) to present a web-based version of SQL Developer and SQL Developer Data Modeler.

SODA for PL/SQL in Oracle Database 18c - This article gives an overview of the Simple Oracle Document Access (SODA) for PL/SQL functionality in Oracle Database 18c.

Docker : Oracle REST Data Services (ORDS) on Docker - This article describes a simple build for running Oracle REST Data Services (ORDS) on Docker.

Oracle REST Data Services (ORDS) : Database API - PDB Lifecyle Management - The Oracle REST Data Services (ORDS) database API allows us to manage the lifecycle of PDBs via REST web service calls.

Oracle REST Data Services (ORDS) : Database API - Setup - The Oracle REST Data Services (ORDS) database API allows us to perform some database administration via REST web service calls. This article covers the basic setup.

Oracle REST Data Services (ORDS) : Database API - Data Pump - The Oracle REST Data Services (ORDS) database API allows us to create Data Pump export and import jobs via REST web service calls.

JSON

See the Oracle REST Data Services (ORDS) articles.

An Introduction to JSON Support in the Oracle Database - This article provides an overview of the JSON functionality available when using an Oracle database, along with links to relevant articles.

JSON Support in Oracle Database 12c Release 1 (12.1.0.2) - This article describes the server side support for JSON in the database.

JSON Support Enhancements in Oracle Database 12c Release 2 (12.2) - Oracle 12c Release 2 (12.2) includes several enhancements to the JSON functionality in the database. This article details some of them, as well as linking to separate articles on some of them.

JSON Support Enhancements in Oracle Database 18c - Oracle 18c includes several enhancements to the JSON functionality in the database. This article details some of them, as well as linking to separate articles on others.

JSON Support Enhancements in Oracle Database 19c - Oracle 19c includes several enhancements to the JSON functionality in the database. This post acts as a links page to separate articles on each feature.

JSON Support Enhancements in Oracle Database 21c - Oracle 21c includes several enhancements to the JSON functionality in the database. This post acts as a links page to separate articles on each feature.

APEX_JSON Package: Generate and Parse JSON Documents in Oracle - This article gives a brief overview of using the APEX_JSON package to generate and parse JSON documents in Oracle.

APEX_WEB_SERVICE : Consuming SOAP and REST Web Services - Use the APEX_WEB_SERVICE package to simplify consuming SOAP and REST web services from PL/SQL.

GeoJSON Data Support in Oracle Database 19c - In this article we demonstrate the support for GeoJSON data in Oracle Database 19c. Specifically the mapping between GeoJSON data and the Oracle Spatial SDO_GEOMETRY object type.

Indexing JSON Data in Oracle Database 12c Release 1 (12.1.0.2) - This article provides an overview of how to index JSON data in Oracle Database 12c Release 1 (12.1.0.2).

JSON Data Guide in Oracle Database 12c Release 2 (12.2) - Simplify the interaction with JSON data stored in the database using the JSON Data Guide functionality introduced in Oracle Database 12c Release 2 (12.2).

JSON Data Guide Enhancements in Oracle Database 18c - This article covers the enhancements to the JSON Data Guide functionality in Oracle Database 18c.

JSON_EQUAL Condition in Oracle Database 18c - The JSON_EQUAL condition was introduced in 18c to allow JSON documents to be compared regardless of member order or document formatting.

JSON_MERGEPATCH in Oracle Database 19c - The JSON_MERGEPATCH function is used to modify parts of a JSON document in select and update operations.

JSON_OBJECT Enhancements in Oracle Database 19c - The SQL/JSON function JSON_OBJECT got a whole lot easier to use in Oracle 19c.

JSON_SERIALIZE in Oracle Database 19c - The JSON_SERIALIZE function converts a JSON document from any supported data type to text.

JSON_TABLE Enhancements in Oracle Database 18c - This article covers the enhancements to the JSON_TABLE function in Oracle Database 18c.

Mapping of JSON Data To and From SQL Object Types in Oracle Database 19c - Oracle database 19c allows JSON data to instantiate user-defined object type instances, and user defined object-type instances can be converted to JSON data.

Materialized View Support for Queries Containing JSON_TABLE in Oracle Database 19c - Oracle 19c can perform query rewrites of statements using some SQL/JSON functions (JSON_VALUE, JSON_EXISTS) to use a materialized view containing and appropriate JSON_TABLE call.

PL/SQL Object Types for JSON in Oracle Database 12c Release 2 (12.2) - Oracle 12c Release 2 (12.2) includes several enhancements to the JSON functionality in the database including native support for JSON parsing and generation in PL/SQL.

Simple Oracle Document Access (SODA) for PL/SQL in Oracle Database 18c - This article gives an overview of the Simple Oracle Document Access (SODA) for PL/SQL functionality in Oracle Database 18c.

SQL/JSON Functions in Oracle Database 12c Release 2 (12.2) - This article gives basic examples of the SQL/JSON functions introduced in Oracle Database 12c Release 2 (12.2).

SQL NESTED Clause Instead of JSON_TABLE in Oracle Database 19c - The SQL NESTED clause allows us to write the equivalent of the LEFT OUTER JOIN JSON_TABLE using a simplified syntax.

TO_UTC_TIMESTAMP_TZ Function in Oracle Database 18c - Oracle 18c introduced the new TO_UTC_TIMESTAMP_TZ function to help deal with ISO 8601 date strings.

TREAT(... AS JSON) in Oracle Database 18c - In Oracle 18c the TREAT function can be used in SQL to change the declared type of an expression to JSON, where the expression is an object containing JSON data.

JSON Data Type in Oracle 21c - The JSON data type was introduced in the Oracle 20c preview release to provide native JSON support and improve the performance of JSON processing. It has become generally available in Oracle 21c.

JSON_SCALAR in Oracle Database 21c - The JSON_SCALAR function creates an instance of a JSON type from a SQL scalar value.

JSON_TRANSFORM in Oracle Database 21c - The JSON_TRANSFORM function was introduced in Oracle database 21c to simplify the modification of JSON data.

Multivalue Function-Based Indexes for JSON_EXISTS in Oracle Database 21c - Multivalue function-based indexes allow us to index multiple scalar values in JSON documents stored in the JSON data type.

JSON_ARRAY Using Subqueries in Oracle Database 23c - From Oracle database 23c onward the JSON_ARRAY function can accept a subquery as input, which brings it in line with the current SQL/JSON standard.

JSON Data Type Constructor Enhancements in Oracle Database 23c - The JSON data type constructor can now accept collections, object types and record types as input.

JSON-Relational Duality Views in Oracle Database 23c - JSON-relational duality views expose our relational data as JSON documents, allowing both query and DML operations to be performed using conventional SQL or directly using JSON.

JSON_SERIALIZE : ORDERED Keyword in Oracle Database 23c - In Oracle 23c the ORDERED keyword has been added to the JSON_SERIALIZE function. When present, the members are serialized in ascending alphabetical order by field name.

JSON_VALUE Function Enhancements in Oracle Database 23c - In Oracle database 23c the RETURNING clause of the JSON_VALUE function has been enhanced allowing it to convert JSON data to user-defined types.

Loading SODA Collections with SQL*Loader in Oracle Database 23c - In Oracle 23c we can use SQL*Loader to load JSON data into a Simple Oracle Document Access (SODA) collection.

Migrating Text-Based JSON to JSON Data Type : Pre-Migration Check in Oracle Database 23c - In Oracle 23c the JSON_TYPE_CONVERTIBLE_CHECK procedure has been added to the DBMS_JSON package to allow pre-migration checks to be performed on text-based JSON columns.

JSON Schema in Oracle 23c - In Oracle 23c a JSON Schema can validate the structure and contents of JSON documents in your database.

JSON_TRANSFORM Enhancements in Oracle Database 23c - In Oracle 23c the JSON_TRANSFORM function has lots of new operations, conditional control and richer path support.

Precheck Constraints using JSON Schema in Oracle Database 23c - In Oracle database 23c we can use the PRECHECK keyword to mark check constraints as being validated externally by an application.

Predicates for JSON_QUERY and JSON_VALUE in Oracle Database 23c - In Oracle database 23c the JSON_QUERY and JSON_VALUE functions can include multiple predicates in a single JSON path expression, and use the PASSING clause to support variables.

XML, JSON and Oracle Text Search Index Enhancements in Oracle Database 23c - In Oracle 23c the CREATE SEARCH INDEX statement allows us to create search indexes on XML, JSON and text data, making the syntax consistent between them.

IS JSON JSON_EXISTS JSON_VALUE JSON_QUERY JSON_TABLE
JSON_TEXTCONTAINS JSON_EQUAL JSON_OBJECT JSON_OBJECTAGG JSON_ARRAY
JSON_ARRAYAGG JSON Data Guide JSON_MERGEPATCH JSON_SERIALIZE GeoJSON
JSON Data Type JSON_SCALAR JSON_TRANSFORM JSON-Relational Duality Views  

SODA

Oracle REST Data Services (ORDS) : Simple Oracle Document Access (SODA) for REST - This article gives an overview of the Simple Oracle Document Access (SODA) for REST functionality of Oracle REST Data Services (ORDS), which allows you to use Oracle as a JSON document store.

Simple Oracle Document Access (SODA) for PL/SQL in Oracle Database 18c - This article gives an overview of the Simple Oracle Document Access (SODA) for PL/SQL functionality in Oracle Database 18c.

Simple Oracle Document Access (SODA) for SQLcl - This article gives an overview of the integration of Simple Oracle Document Access (SODA) in SQLcl.

XML

SQL/XML (SQLX) : Generating XML using SQL - Oracle9i Release 2 includes functionality to support the emerging SQL/XML standard to simplify XML generation from SQL queries.

XML-Over-HTTP (REST Web Services) From PL/SQL - XML-over-HTTP was the precursor to web services allowing easy access to XML via HTTP GETs and POSTs.

Parse XML Documents - Explode unstructured XML documents into relational tables using the new integrated XDB packages.

XMLTABLE : Convert XML Data into Rows and Columns using SQL - Use the XMLTABLE operator to project columns on to XML data, allowing you to query it directly from SQL.

XMLSERIALIZE - The XMLSERIALIZE function was introduced in Oracle 10.1 to create a string or LOB based on the XML passed to it.

XMLSEQUENCE - Use this operator to split multi-value results from XMLTYPE queries into multiple rows.

Native Oracle XML DB Web Services in Oracle 11g Release 1 - Present your exisitng PL/SQL procedures and functions as web services using XML DB in Oracle 11g.

APEX_WEB_SERVICE : Consuming SOAP and REST Web Services - Use the APEX_WEB_SERVICE package to simplify consuming SOAP and REST web services from PL/SQL.

XMLType Datatype - Store XML documents in tables and query them using SQL.

Load XMLTYPE From File - A simple method to load XMLTYPE data from a file.

Load XMLTYPE From URL - A simple method to load XMLTYPE data from a URL.

XML DB - Store and retrieve XML documents from the Oracle XML DB repository using HTTP, FTP and WebDAV in seconds.

XML Generation In Oracle9i Using DBMS_XMLQuery, DBMS_XMLGen, Sys_XMLGen And Sys_XMLAgg - Generate XML and perform XSL transformations with ease using the new XML features of Oracle9i.

XSQL Servlet and XSQL Pages - Publish dynamic XML documents through HTTP using the XSQL Servlet utility.

Validate an XML Document Against an XML Schema (XSD) in an Oracle Database - This article gives some simple examples of validating XML documents against a XML Schema (XSD) in an Oracle database.

XML, JSON and Oracle Text Search Index Enhancements in Oracle Database 23c - In Oracle 23c the CREATE SEARCH INDEX statement allows us to create search indexes on XML, JSON and text data, making the syntax consistent between them.

Cloud

Oracle Databases in the Cloud - This article presents an overview of options for deploying Oracle databases in the cloud.

Oracle Cloud : Free Tier Account Sign-Up - This article demonstrates how to sign up for an Oracle Cloud Free Tier account, giving you access to a number of free tier services.

Oracle Cloud Infrastructure (OCI) : Create a Compartment - This article shows how to create a compartment, a container for a group of related resources, 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 centre network topology inside the Oracle Cloud using a Virtual Cloud Network (VCN).

Oracle Cloud Infrastructure (OCI) : Create a Compute VM - This article shows how to create a compute virtual machine under Oracle Cloud Infrastructure (OCI).

Oracle Cloud Infrastructure (OCI) : Amend Firewall Rules - his article shows how to amend the firewall rules for a virtual machine under Oracle Cloud Infrastructure (OCI).

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.

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 Cloud : Autonomous JSON Database (ADJ) - Create Service - This article provides a run through of creating a new Autonomous JSON Database (ADJ) service on the Oracle Cloud.

Oracle Cloud : APEX Application Development Service (APX) - Create Service - This article provides a run through of creating a new APEX Application Development (APX) service on the Oracle Cloud.

Oracle Cloud : APEX Application Development Service (APX) - Import Data - This article describes how to import data into the APEX Application Development (APX) service on the Oracle Cloud.

Oracle Cloud : Autonomous Database (ADW or ATP) - Load Data from an Object Store (DBMS_CLOUD) - This article demonstrates how to load data into an Autonomous Data Warehouse (ADW) or Autonomous Transaction Processing (ATP) service on the Oracle Cloud using the DBMS_CLOUD package.

Oracle Cloud : Autonomous Database (ADW or ATP) - Import Data from an Object Store (impdp) - This article demonstrates how to import data into an Autonomous Data Warehouse (ADW) or Autonomous Transaction Processing (ATP) service on the Oracle Cloud using the impdp utility.

Oracle Cloud : Autonomous Database (ADW or ATP) - Export Data to an Object Store (expdp) - This article demonstrates how to export data from an Autonomous Data Warehouse (ADW) or Autonomous Transaction Processing (ATP) service on the Oracle Cloud using the expdp utility.

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 Vault and Key - This article shows how to create a vault and key under Oracle Cloud Infrastructure (OCI).

Oracle Cloud Infrastructure (OCI) : Create an Object Storage Bucket This article shows how to create an object storage bucket under Oracle Cloud Infrastructure (OCI).

Oracle Cloud Infrastructure (OCI) : Create a Bastion - This article shows how to create a bastion under Oracle Cloud Infrastructure (OCI).

Oracle Cloud : Database as a Service (DBaaS) - Create Service - This article provides a run through of creating a new DBaaS service on the Oracle Cloud.

Oracle Cloud : Database as a Service (DBaaS) - Patch Service - This article provides a run through of patching a DBaaS service on the Oracle Cloud.

Oracle Cloud : Schema as a Service - This article gives and overview of Oracle's schema as a service DBaaS offering.

Oracle Cloud : MySQL Cloud Service - Create Service - The Oracle MySQL Cloud Service allows you to quickly deploy MySQL databases on the Oracle Public Cloud.

Amazon Web Services (AWS) : Installation of Oracle on EC2 - This article gives an overview of creating an Oracle database in an Amazon Web Services (AWS) Elastic Compute Cloud (EC2) virtual machine.

Amazon Web Services (AWS) : Relational Database Services (RDS) for Oracle - This article describes the creation of a database using Amazon Web Services (AWS) Relational Database Services (RDS) for Oracle.

Amazon Web Services (AWS) : Relational Database Services (RDS) for MySQL - This article describes the creation of a database using Amazon Web Services (AWS) Relational Database Services (RDS) for MySQL.

Amazon Web Services (AWS) : Relational Database Services (RDS) for SQL Server - This article describes the creation of a database using Amazon Web Services (AWS) Relational Database Services (RDS) for SQL Server.

Azure : Installation of an Oracle Database on Azure - This article gives an overview of creating an Oracle database in a Microsoft Azure virtual machine.

Azure : SQL Server Databases on Azure - This article gives an overview of creating an Oracle database in a Microsoft Azure virtual machine.

DBMS_CLOUD : Installation on 19c and 21c On-Prem Databases - This article describes how to install the DBMS_CLOUD package in on-prem 19c and 21c databases.

DBMS_CLOUD Package - This article describes the basic usage of the DBMS_CLOUD package.

Silent Installation and Configuration

Oracle Universal Installations (OUI) Silent Installations - Use the Oracle Universal Installations (OUI) to create and use response files to automate the installation of Oracle products.

Database Configuration Assistant (DBCA) : Creating Databases in Silent Mode - This article demonstrates how to create a new database using the Database Configuration Assistant (DBCA) in silent mode.

WebLogic 11g Silent Installation - This article demonstrates how to perform a silent installation of WebLogic Server 11g on Oracle Linux.

Oracle Forms and Reports 11gR2 Silent Installation on Oracle Linux 6 - An overview of the silent installation of Oracle Forms and Reports 11gR2 on Oracle Linux 6.

ADF 11g Silent Installation - This article demonstrates how to perform a silent installation of ADF 11g on Oracle Linux.

WebLogic 12c Silent Installation - This article demonstrates how to perform a silent installation of WebLogic Server 12c on Oracle Linux.

Oracle Forms and Reports 12c (12.2.1) Silent Installation on Oracle Linux 6 and 7- An overview of the silent installation of Oracle Forms and Reports 12c on Oracle Linux 6 and 7.

WebLogic Server 12cR2 (12.2.1) : ADF Application Development Runtime - Repository Configuration Utility (RCU) in Silent Mode - This article provides a brief example of using the Repository Configuration Utility (RCU) from the ADF Application Development Runtime in silent mode.

Oracle Business Intelligence 12c (12.2.1.2.0) Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Business Intelligence 12c (12.2.1.2.0) on Oracle Linux (OL6 or OL7) using Oracle Database 12cR1 (12.1) for the repository created by the Repository Creation Utility (RCU).

Oracle Business Intelligence 12c (12.2.1.3.0) Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Business Intelligence 12c (12.2.1.3.0) on Oracle Linux (OL6 or OL7) using Oracle Database 12cR1 (12.1) for the repository created by the Repository Creation Utility (RCU).

Oracle Data Integrator (ODI) 12c (12.2.1.2.6) Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Data Integrator (ODI) 12c (12.2.1.2.6) on Oracle Linux (OL6 or OL7) using Oracle Database 12cR2 (12.2) for the repository created by the Repository Creation Utility (RCU).

Oracle Data Integrator (ODI) 12c (12.2.1.3.0) Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Data Integrator (ODI) 12c (12.2.1.3.0) on Oracle Linux (OL6 or OL7) using Oracle Database 12cR2 (12.2) for the repository created by the Repository Creation Utility (RCU).

Oracle Business Intelligence 11g Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Business Intelligence 11g on Oracle Linux (OL6 or OL7) using Oracle Database 12cR1 (12.1) for the repository created by the Repository Creation Utility (RCU).

Oracle Data Integrator (ODI) 11g Silent Installation on Oracle Linux 6 and 7 (OL6 and OL7) - This article demonstrates how to perform a silent installation of Oracle Data Integrator (ODI) 11g on Oracle Linux (OL6 or OL7) using Oracle Database 12cR2 (12.2) for the repository created by the Repository Creation Utility (RCU).

WebLogic Scripting Tool (WLST) Examples

Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0) Silent Installation on Oracle Linux 7 - This article describes the silent installation of Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0) on Oracle Linux 7.

Silent Upgrade of Oracle Enterprise Manager Cloud Control to 13c Release 3 (13cR3) - This article describes a silent upgrade of Enterprise Manager Cloud Control to 13c Release 3 (13cR3).

Oracle Enterprise Manager Cloud Control 13c Release 4 (13.4) Silent Installation on Oracle Linux 7 - This article describes the silent installation of Oracle Enterprise Manager Cloud Control 13c Release 4 (13.4) on Oracle Linux 7.

Silent Upgrade of Oracle Enterprise Manager Cloud Control to 13c Release 4 (13.4) - This article describes a silent upgrade of Enterprise Manager Cloud Control to 13c Release 4 (13.4).

Resource Manager

Resource Manager in Oracle 8i - Prevent batch processes interfering with your OLTP transactions by using this simple PL/SQL API to assign a priority to each type of session.

Resource Manager Enhancements In Oracle 9i - Manage system resources more precisely using the Resource Manager enhancements in Oracle 9i.

Resource Manager Enhancements in Oracle Database 10g - In Oracle 10g resource manager is more flexible and even easier to configure than before. Check out the enhancements here.

Resource Manager Enhancements in Oracle Database 11g Release 1 - An overview of the resource manager enhancements in Oracle Database 11g Release 1.

Instance Caging to Manage CPU Usage in Oracle Database 11g Release 2 - Control CPU usage when consolidating multiple databases on to a single server.

Resource Manager Enhancements in Oracle Database 12c Release 1 (12.1) - This article describes the enhancements to automatic consumer group switching in Oracle 12c Release 1 (12.1).

Multitenant : Disk I/O (IOPS, MBPS) Resource Management for PDBs in Oracle Database 12c Release 2 (12.2) - Control the amount of disk I/O used by a PDB, making consolidation more reliable in Oracle Database 12c Release 2 (12.2).

Multitenant : Dynamic CPU Scaling - Resource Manager Control of CPU using CPU_COUNT and CPU_MIN_COUNT - Resource Manager can control CPU usage in PDBs using the CPU_COUNT and CPU_MIN_COUNT parameters. Oracle call this Dynamic CPU Scaling. The genesis of this functionality began in Oracle 12.2, but Oracle 19.4 saw the introduction of the CPU_MIN_COUNT parameters.

Multitenant : Resource Manager with Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) - Control resource allocation between pluggable databases and within an individual pluggable database.

Multitenant : Memory Resource Management for PDBs in Oracle Database 12c Release 2 (12.2) - Control the amount of memory used by a PDB, making consolidation more reliable in Oracle Database 12c Release 2 (12.2).

Multitenant : Resource Manager PDB Performance Profiles in Oracle Database 12c Release 2 (12.2) - PDB performance profiles define the resource management for groups of PDBs in Oracle Database 12c Release 2 (12.2)

Resource Manager Enhancements in Oracle Database 12c Release 2 (12.2) - This page brings together all the articles related to Resource Manager enhancements in Oracle Database 12c Release 2 (12.2).

Resource Manager : Per-Process PGA Limits in Oracle Database 12c Release 2 (12.2) - Resource Manager can limit the amount of PGA used by a session in Oracle Database 12c Release 2 (12.2).

Recovery Manager (RMAN)

Recovery Manager (RMAN) in Oracle Database 8i - Explanation of RMANs basic backup, recovery and reporting functionality.

Recovery Manager (RMAN) Enhancements in Oracle Database 9i - Use the latest RMAN features which make backup and recovery quicker and more reliable.

Recovery Manager (RMAN) in Oracle Database 9i - Explanation of RMANs basic backup, recovery and reporting functionality.

RMAN Enhancements in Oracle Database 10g - Check out the large number of enhancements in the Oracle 10g version of RMAN. If you are not currently using this tool you're running out of excusses.

RMAN Enhancements in Oracle Database 11g Release 1 - An overview of all the RMAN enhancements in Oracle Database 11g Release 1.

Duplicate a Database Using RMAN in Oracle Database 11g Release 2 - This article summarizes the process of duplicating a database using the RMAN DUPLICATE command.

Recovery Manager (RMAN) Enhancements in Oracle Database 12c Release 1 (12.1) - This article described the new features and enhancements made to Recovery Manager (RMAN) in Oracle Database 12c Release 1 (12.1).

Recovery Manager (RMAN) Database Duplication Enhancements in Oracle Database 12c Release 1 (12.1) - This article describes the enhancements made to Recovery Manager (RMAN) for database duplication in Oracle Database 12c Release 1 (12.1).

Recovery Manager (RMAN) Table Point In Time Recovery (PITR) in Oracle Database 12c Release 1 and 2 (12.1 and 12.2) - Oracle Database 12c makes Point In Time Recovery (PITR) of individual tables as easy as a single Recovery Manager (RMAN) command.

Multitenant : Duplicate a Pluggable Database (PDB) to an existing Container Database (CDB) in Oracle Database 18c - Oracle 18c allows you to duplicate a pluggable database (PDB) from one container database (CDB) instance to another existing CDB instance using RMAN.

Multitenant : Backup and Recovery of a Container Database (CDB) and a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) - Learn how backup and recovery is affected by the multitenant option in Oracle Database 12c Release 1 (12.1).

Unregister a Database From an RMAN Recovery Catalog - A step-by-step guide to unregistering unwanted databases from the RMAN catalog.

Incrementally Updated Backups : Rolling Forward Image Copies Using RMAN - Speed up backup and recovery time by rolling your image copy backups forward using incremental backups.

Scheduler (DBMS_SCHEDULER)

Scheduler (DBMS_SCHEDULER) in Oracle Database 10g Onward - Oracle Database 10g includes a flexible scheduler to replace the DBMS_JOB package.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle 10g Database Release 2 - This article provides simple examples of how to use the scheduler enhancements (DBMS_SCHEDULER) in Oracle 10g Database Release 2, including event-based jobs and job chains.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 11g Release 1 - Oracle 11g adds more functionality to the Oracle scheduler.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 11g Release 2 - Oracle 11gR2 adds more functionality to the Oracle scheduler.

Remote Scheduler Agent Installation for Oracle 11g Release 2 - An overview of the installation of the Remote Scheduler Agent for Oracle 11g Release 2.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12c Release 1 (12.1) - Oracle Database 12c Release 1 adds more functionality to the Oracle scheduler.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 continues to extend the functionality of the Oracle scheduler with in-memory jobs, job incompatibility definitions and scheduler resource queues.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 18c, 19c and 21c - This post summarises the enhancements to the scheduler in Oracle Database 18c, 19c and 21c.

SQL Developer 3.1 Scheduler (DBMS_SCHEDULER) Support - A brief overview of the DBMS_SCHEDULER support in SQL Developer 3.1.

DBMS_CREDENTIAL : Persist Database and OS Credentials in Oracle Database 12c Release 1 (12.1) - In Oracle 12c the credential related sub-programs of the DBMS_SCHEDULER package have been deprecated and replaced by the new DBMS_CREDENTIAL package. From a usage perspective it feels similar.

DBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c - The DBMS_JOB package has been deprecated since 12cR2. Oracle 19c takes the demise of the DBMS_JOB package a step further by converting any DBMS_JOB jobs to DBMS_SCHEDULER jobs.

Feature List:

Data Pump (expdp, impdp)

Data Pump (expdp, impdp) in Oracle Database 10g - Test drive the Oracle 10g replacement for the EXP and IMP utilities.

Data Pump (expdp, impdp) Enhancements in Oracle Database 11g Release 1 - This article provides an overview of the main Data Pump enhancements in Oracle Database 11g Release 1.

Data Pump (expdp, impdp) Enhancements in Oracle Database 12c Release 1 - This article provides an overview of the main Data Pump enhancements in Oracle Database 12c Release 1.

Data Pump (expdp, impdp) Enhancements in Oracle Database 12c Release 2 (12.2) - This article provides an overview of the main Data Pump enhancements in Oracle Database 12c Release 2 (12.2).

Data Pump (expdp, impdp) Enhancements in Oracle Database 18c - This article gives an overview of the Data Pump enhancements in Oracle Database 18c.

Data Pump (expdp, impdp) Enhancements in Oracle Database 19c - This article gives an overview of the Data Pump enhancements in Oracle Database 19c.

Data Pump (expdp, impdp) Enhancements in Oracle Database 21c - This article gives an overview of the Data Pump enhancements in Oracle Database 21c.

Data Pump API for PL/SQL (DBMS_DATAPUMP) - The DBMS_DATAPUMP package provides a PL/SQL API, allowing us to define Data Pump operations programmatically. This article provides a few examples to get you started.

Data Pump (expdp, impdp) Interactive Command Mode - This article shows how to use the interactive command mode of the expdp and impdp Data Pump utilities.

SQL Developer 3.1 Data Pump Wizards (expdp, impdp) - This article gives an overview of the Data Pump Wizards included in SQL Developer 3.1 onward.

Oracle REST Data Services (ORDS) : Database API - Data Pump - The Oracle REST Data Services (ORDS) database API allows us to create Data Pump export and import jobs via REST web service calls.

Upgrading to Oracle Database 12c - Transportable Database

SQLcl : Data Pump - In this article we demonstrate the Data Pump functionality in SQLcl.

Videos

Partitioning

Partitioned Tables And Indexes - Reduce tables and indexes to a more manageable size and simultaneously improve performance.

Partitioning Enhancements In Oracle 9i - Check out the additions and enhancements to partitioning in Oracle 9i.

Partitioning Enhancements in Oracle Database 11g Release 1 - An introduction to the partitioning enhancements in Oracle 11g Release 1.

Partitioning Enhancements in Oracle Database 12c Release 1 (12.1) - This article brings together all the articles related to partitioning enhancements in Oracle Database 12c Release 1.

Partitioning Enhancements in Oracle Database 12c Release 2 (12.2) - This article brings together all the articles related to partitioning enhancements in Oracle Database 12c Release 2.

Automatic List Partitioning in Oracle Database 12c Release 2 (12.2) - Automatic list partitioning was introduced in Oracle Database 12c Release 2 (12.2) to solve the problem of how to handle new distinct values of the list partitioning key.

Asynchronous (Delayed) Global Index Maintenance for DROP and TRUNCATE Partition in Oracle Database 12c Release 1 - Oracle 12c can optimize the performance of some DROP PARTITION and TRUNCATE PARTITION commands by deferring the associated index maintenance, while leaving the global indexes in a valid state.

Cascade Functionality for TRUNCATE PARTITION and EXCHANGE PARTITION in Oracle Database 12c Release 1 - The TRUNCATE [SUB]PARTITION and EXCHANGE [SUB]PARTITION commands can now include a CASCADE clause, allowing the actions to cascade down the hierarchy of reference partitioned tables.

Create Table for Exchange With a Partitioned Table in Oracle Database 12c Release 2 (12.2) - Make sure a table is compatible for an EXCHANGE PARTITION operation by using CREATE TABLE ... FOR EXCHANGE WITH TABLE in Oracle Database 12c Release 2 (12.2).

Filtered Partition Maintenance Operations - Oracle Database 12c Release 2 (12.2) allows you to add a filter condition when you move, split or merge a partition, move a table or convert a non-partitioned table to a partitioned table.

Hybrid Partitioned Tables in Oracle Database 19c - This article shows how to combine internal and external partitions into a single Hybrid Partitioned Table in Oracle Database 19c.

Interval-Reference Partitioning in Oracle Database 12c Release 1 - Oracle 12c allows you to use an interval partitioned table as the parent for a reference partitioned table.

Multi-Column List Partitioning in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 (12.2) introduced the ability to define a list partitioned table based on multiple columns.

Online Conversion of a Non-Partitioned Table to a Partitioned Table in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 makes it easier than ever to convert a non-partitioned table to a partitioned table, requiring only a single command and no downtime.

Online MERGE PARTITION and MERGE SUBPARTITION in Oracle Database 18c - In Oracle Database 18c the MERGE PARTITION and MERGE SUBPARTITION operations on heap tables can be performed online so they don't block DML.

Online Move of Partitions and Sub-Partitions in Oracle 12c Release 1 - In Oracle 12c it is now possible to move table partitions and sub-partitions as online operations.

Online SPLIT PARTITION and SPLIT SUBPARTITION in Oracle Database 12c Release 2 (12.2) - In Oracle Database 12c Release 2 (12.2) the SPLIT PARTITION and SPLIT SUBPARTITION operations on heap tables can be performed online so they don't block DML.

Partial Indexes for Partitioned Tables in Oracle Database 12c Release 1 - Oracle 12c allows the creation of global and local indexes on a subset of the partitions of a partitioned table.

Partition Maintenance Operations on Multiple Partitions in Oracle Database 12c Release 1 - In Oracle 12c some maintenance operations can now be performed on multiple partitions in a single ALTER TABLE statement.

Partitioned External Tables in Oracle Database 12c Release 2 (12.2) - Partitioned external tables were introduced in Oracle Database 12c Release 2 (12.2), allowing external tables to benefit from partition pruning and partition-wise joins.

Partitioning an Existing Table using EXCHANGE PARTITION - This article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax.

Partitioning an Existing Table using DBMS_REDEFINITION - This article presents a simple method for partitioning an existing table using the DBMS_REDEFINITION package.

Read-Only Partitions and Subpartitions in Oracle Database 12c Release 2 (12.2) - From Oracle Database 12c Release 2 (12.2) onward you can mark partitions and subpartitions as read-only to protect their data from accidental change.

Partitioning From a Design Perspective (A Practical Guide) - By Lothar Flatz - This is a guest post by Lothar Flatz. It is an English translation of an article first published in German.

Enhanced Partitioning Metadata in Oracle Database 23c - Oracle database 23c makes it easier to display the high value of partitions using two new columns in the ALL_TAB_PARTITIONS view.

Hybrid Partitioned Table Enhancements in Oracle Database 23c - This article demonstrates hybrid partitioned tables with interval and auto-list partitioning in Oracle Database 23c.

External Tables

External Tables : Querying Data From Flat Files in Oracle - Query the contents of flat files as if they were regular tables by using external tables.

External Table Enhancements in Oracle Database 12c Release 1 (12.1) - An overview of the enhancements to external tables in Oracle Database 12c Release 1 (12.1).

External Tables and XMLTAG to Load XML Documents in Oracle Database 12c Release 2 (12.2) - This article describes how to use the XMLTAG clause of an external table to load XML fragments from XML documents in Oracle Database 12c Release 2 (12.2).

External Tables Containing LOB Data - This articles shows how external tables are used to read CLOB and BLOB data, enabling parallel load operations of large quantities of data.

Hybrid Partitioned Tables in Oracle Database 19c - This article shows how to combine internal and external partitions into a single Hybrid Partitioned Table in Oracle Database 19c.

Inline External Tables in Oracle Database 18c - Oracle Database 18c allows you to access data in flat files using an inline external table defined in a SELECT statement.

Partitioned External Tables in Oracle Database 12c Release 2 (12.2) - Partitioned external tables were introduced in Oracle Database 12c Release 2 (12.2), allowing external tables to benefit from partition pruning and partition-wise joins.

Override External Table Parameters From a Query in Oracle Database 12c Release 2 (12.2) - Oracle Database 12c Release 2 (12.2) allows a query to modify of some external table parameters using the EXTERNAL MODIFY clause of the SELECT statement.

External Tables (Unloading/Loading Data Using External Tables) - Oracle have incorporated support for data pump technology into external tables. The ORACLE_DATAPUMP access driver can be used to unload data to data pump export files and subsequently reload it. The unload of data occurs when the external table is created using the "AS" clause.

Data Guard

Standby Database in Oracle Database 8i - Keep an up-to-date copy of the production database ready for failover in the event of a disaster.

Data Guard in Oracle Database 9i - Oracle 9i Data Guard is the new name for Oracle 8i Standby Database incorporating a large number of new features. This article discusses those relevant to the Oracle 9i Database: New Features For Administrators OCP exam.

Data Guard Physical Standby Setup in Oracle Database 11g Release 2 - This article contains an example of setting up a physical standby database for Oracle 11gR2.

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 11g Release 2 - This article contains an example of setting up a physical standby database for Oracle 11gR2 using the Data Guard Broker.

Oracle Database 11g Release 2 Data Guard Setup using Oracle Grid Control - This article describes the creation of a standby database using Oracle Database 11g Release 2 and the Oracle Grid Control.

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 12c Release 1 - This article contains an example of setting up a physical standby database for Oracle 12c Release 1 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.

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 19c - This article contains an example of setting up a physical standby database for Oracle 19c using the Data Guard Broker.

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 21c - This article contains an example of setting up a physical standby database for Oracle 21c using the Data Guard Broker.

Data Guard : The PREPARE DATABASE FOR DATA GUARD Command in Oracle Database 21c - The PREPARE DATABASE FOR DATA GUARD command simplifies the setup of the primary database when configuring Data Guard in Oracle database 21c.

DG PDB : Oracle Data Guard per Pluggable Database in Oracle Database 21c (21.7 Onward) - DG PDB is a new feature introduced in Oracle database 21c (21.7) which allows PDB-level Data Guard protection. This article describes a basic setup of DG PDB.

Multitenant : Controlling PDB Replication in Data Guard Environments : STANDBYS Clause (12.1.0.2) - This article describes two methods for controlling the replication of PDBs in standby databases when using Data Guard.

Multitenant : Controlling PDB Replication in Data Guard Environments : ENABLED_PDBS_ON_STANDBY Parameter (12.2) - This article describes two methods for controlling the replication of PDBs in standby databases when using Data Guard.

Multitenant : Copying a PDB in a Data Guard Environment in Oracle Database 18c - The STANDBY_PDB_SOURCE_FILE_DBLINK and STANDBY_PDB_SOURCE_FILE_DIRECTORY initialisation parameters make remote clones and plugin operations much simpler in Oracle 18c.

Upgrades

Oracle Database Upgrades : One Size Does Not Fit All - A list of some of the factors you should consider before starting an upgrade.

Upgrading to Oracle Database 10g - This article provides a brief overview of the areas involved in upgrading existing databases to Oracle 10g.

Upgrading to Oracle Database 11g - This article provides a brief overview of the areas involved in upgrading existing databases to Oracle 11g.

Multitenant : Upgrade a PDB using Unplug/Plugin - This article describes the method for upgrading a PDB using the unplug/plugin method.

Upgrading to Oracle Database 12c - This article provides an overview of some of the options for upgrading existing databases to Oracle 12c Release 1.

Multitenant : PDB Upgrades Using Priority Lists, Inclusion Lists and Exclusion Lists in Oracle Database 12c Release 2 (12.2) - From Oracle 12.2 onward it's possible adjust the priority in which PDBs are upgraded when running the 'catupgrd.sql' script with the parallel upgrade utility (catctl).

Multitenant : Upgrading to Oracle Database 18c - This article provides an overview of upgrading an existing multitenant database to Oracle 18c.

Upgrading to Oracle Database 18c (Non-CDB) - This article provides an overview of upgrading an existing non-CDB database to Oracle 18c.

Multitenant : Upgrading to Oracle Database 19c - This article provides an overview of upgrading an existing multitenant database to Oracle 19c.

Upgrading to Oracle Database 19c (Non-CDB) - This article provides an overview of upgrading an existing non-CDB database to Oracle 19c.

Auditing

Auditing in Oracle 8i - Basic setup instructions to allow the auditing of user actions.

Auditing in Oracle 10g Database Release 2 - This article presents an overview of auditing in Oracle 10g Release 2.

Auditing Enhancements (DBMS_AUDIT_MGMT) in Oracle Database 11g Release 2 - Oracle 11g Release 1 turned on auditing by default for the first time. Oracle 11g Release 2 now allows better management of the audit trail using the DBMS_AUDIT_MGMT package.

Auditing Enhancements (Audit Policies and Unified Audit Trail) in Oracle Database 12c Release 1 (12.1) - The introduction of audit policies and the unified audit trail simplifies the configuration of database auditing in Oracle 12c.

Auditing Enhancements in Oracle Database 19c - This article gives an overview of the auditing enhancements in Oracle database 19c.

Auditing Enhancements in Oracle Database 21c - This article gives an overview of the auditing enhancements in Oracle database 21c.

Auditing Enhancements in Oracle Database 23c - This post describes some of the auditing enhancements in Oracle database 23c.

Database Patching

Database Patching : It’s a difficult subject - An overview of the current state of database patching.

Patching : Find the Required Patches for Oracle Products - This post describes how to identify the required patches for your Oracle products.

Patching : Apply a Database Release Update (RU) to an Existing ORACLE_HOME - This article gives an example of applying a database Release Update (RU) to an existing ORACLE_HOME for a simple single-instance Oracle database. The process is similar for previous versions.

Patching : Apply a Database Release Update (RU) to a New ORACLE_HOME - This article gives an example of applying a database Release Update (RU) to a new ORACLE_HOME for an simple single-instance Oracle database.

Patching : Apply a Grid Infrastructure (GI) Release Update (RU) to Existing ORACLE_HOMEs - This article gives an example of applying a Grid Infrastructure (GI) Release Update (RU) to existing ORACLE_HOMEs for a Real Application Clusters (RAC) installation.

Patching : Apply a Grid Infrastructure (GI) Release Update (RU) to New ORACLE_HOMEs (Out-Of-Place Patching) - This article gives an example of applying a Grid Infrastructure (GI) Release Update (RU) to new ORACLE_HOMEs for a Real Application Clusters (RAC) installation. This is know as out-of-place patching.

Patching : Apply a Database Release Update (RU) to Existing Data Guard ORACLE_HOMEs - This article gives an example of applying a database Release Update (RU) to existing Data Guard ORACLE_HOMEs.

Automation Patterns for Typical DBA Tasks - This post describes some common automation patterns I use when automating typical DBA tasks.

SQLcl

SQLcl : Installation - This short post describes the simple process to install SQLcl.

SQLcl : Format Query Results with the SET SQLFORMAT Command - SQLcl makes it simple to format query results using the SET SQLFORMAT command and a variety of built-in formats.

Oracle REST Data Services (ORDS) : Use SQLcl to Display ORDS Web Service Definitions - SQLcl is a lightweight Java-based replacement for SQL*Plus, which amongst other things allows you to display ORDS web service definitions using the REST command.

SQLcl : Automating Your SQL and PL/SQL Deployments using the SQLcl implementation of Liquibase - This article gives a quick overview of applying changes to the database using the Liquibase implementation in SQLcl.

SQLcl : Deploying Oracle Application Express (APEX) Applications using the SQLcl implementation of Liquibase - This article demonstrates how to deploy Oracle Application Express (APEX) applications using the SQLcl implementation of Liquibase.

SQLcl : Simple Oracle Document Access (SODA) for SQLcl - This article gives an overview of the integration of Simple Oracle Document Access (SODA) in SQLcl.

SQLcl : Unload and Load Table Data - Use SQLcl to unload table data to a formatted file, and load data from a formatted file into a table.

SQLcl : Data Pump - In this article we demonstrate the Data Pump functionality in SQLcl.

ARGUMENT Command in SQL*Plus 23c and SQLcl 22.4 - The ARGUMENT command in SQL*Plus 23c and SQLcl 22.4 allows us to manage arguments passed to a script. This includes the prompt or default value if an argument is missing, and whether the user input from a prompt should he echoed to the screen.

Liquibase

Liquibase : Automating Your SQL and PL/SQL Deployments - This article gives a quick overview of applying changes to the database using Liquibase.

Liquibase : Deploying Oracle Application Express (APEX) Applications - This article demonstrates how to deploy Oracle Application Express (APEX) applications using Liquibase.

SQLcl : Automating Your SQL and PL/SQL Deployments using the SQLcl implementation of Liquibase - This article gives a quick overview of applying changes to the database using the Liquibase implementation in SQLcl.

SQLcl : Deploying Oracle Application Express (APEX) Applications using the SQLcl implementation of Liquibase - This article demonstrates how to deploy Oracle Application Express (APEX) applications using the SQLcl implementation of Liquibase.

Liquibase and Source Control : Changes to Scripts Over Time - A discussion of how to manage changes to scripts over time with Liquibase.

Operating System Installations

These articles provide a pictorial guide for performing an installation of Oracle linux.

These articles provide a pictorial guide for performing an installation of RHEL.

These articles provide a pictorial guide for performing an installation of Fedora.

Here are some miscellaneous installation articles.

Oracle VM

A Cure for Virtual Insanity - A vendor-neutral introduction to virtualization without the hype.

Oracle VM (2.2) Installation - This article gives a brief overview of the installation of Oracle VM Server and Oracle VM Manager version 2.2 (64-bit).

Oracle VM (3.0.1) Installation - This article gives a brief overview of the installation of Oracle VM Server and Oracle VM Manager version 3.0.1 (64-bit).

VirtualBox : Creating a New Virtual Machine (VM) - An overview of creating a new virtual machine using VirtualBox (4.2).

VirtualBox : Extend Virtual Disk and File System - This article describes how to extend VirtualBox virtual disks.

Vagrant : A Beginner's Guide - This article gives a very brief introduction to Vagrant.

Create a Vagrant Base Box (VirtualBox) - In this article we demonstrate the creation of a new Vagrant base box using a Fedora distribution and VirtualBox.

EMCLI : Enterprise Manager Command Line Interface

EMCLI : Installing Enteprise Manager Command Line Interface for Cloud Control 12c and 13c - Learn how to install EMCLI for Enterprise Manager Cloud Control 12c and 13c on Windows and Linux.

EMCLI : Manage Credentials using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage credentials in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

EMCLI : Manage Agents using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage agents in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

EMCLI : Manage Listeners using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage listeners in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

EMCLI : Manage Databases using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage databases in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

EMCLI : Manage WebLogic Domains using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage WebLogic domains in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

EMCLI : Manage Jobs using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage jobs in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

EMCLI : Manage Tablespace Thresholds using Enterprise Manager Command Line Interface (Cloud Control) - This article describes how to manage tablespace thresholds in Enterprise Manager Cloud Control using EMCLI, rather than using the web interface.

Ansible

Ansible : First Steps - This article presents the first steps to get you up and running with Ansible.

Ansible : Playbooks - First Steps - This article presents some examples of basic Ansible Playbooks, to give you a feel for how Ansible Playbooks work.

Ansible : Roles - First Steps - Roles allow us to split Ansible playbooks into more manageable chunks, rather than having one monolithic playbook. They also aid in code reusability.

Ansible : Vault - Ansible Vault provides a simple way to encrypt secrets, so you don't expose sensitive data in your playbooks.

Ansible : Ad Hoc Commands - This article demonstrates how to run ad hoc commands using Ansible.

Ansible YouTube Playlist - A collection of all my Ansible videos on YouTube.

Ansible vs Terraform - This article compares Ansible and Terraform, explaining what roles they play in infrastructure as code.

Terraform

Terraform : Installation - This article explains how to install Terrafrom and perform the basic setup required before using it.

Terraform : A Beginner's Guide - This article presents what I think is the minimum information needed to start using Terraform.

Terraform : Variables - A Beginner's Guide - This article gives an overview of how to manage state snapshots remotely in Terraform using backends.

Terraform : Backends - Manage State Snapshots Remotely - This article gives an overview of input variables in Terraform.

Terraform : Oracle Cloud Infrastructure (OCI) Provider - This article describes how to configure an Oracle Cloud Infrastructure (OCI) provider for Terraform.

Terraform : Oracle Cloud Infrastructure (OCI) Compartment - This article describes how to create a compartment on Oracle Cloud Infrastructure (OCI) using Terraform.

Terraform : Oracle Cloud Infrastructure (OCI) Virtual Cloud Network (VCN) - This article describes how to create a virtual cloud network (VCN) on Oracle Cloud Infrastructure (OCI) using Terraform.

Terraform : Oracle Cloud Infrastructure (OCI) Autonomous Database (ADW, ATP, AJD, APX) - This article describes how to create an autonomous database (ADW, ATP, AJD, APX) on Oracle Cloud Infrastructure (OCI) using Terraform.

Terraform : Oracle Cloud Infrastructure (OCI) Object Storage Bucket - This article describes how to create an object storage bucket on Oracle Cloud Infrastructure (OCI) using Terraform.

Terraform : Oracle Cloud Infrastructure (OCI) Database VM - This article describes how to create a database virtual machine on Oracle Cloud Infrastructure (OCI) using Terraform.

Terraform : Oracle Cloud Infrastructure (OCI) Compute Instance - This article describes how to create a compute instance on Oracle Cloud Infrastructure (OCI) using Terraform.

Terraform : Oracle Cloud Infrastructure (OCI) Bastion - This article describes how to create a bation on Oracle Cloud Infrastructure (OCI) using Terraform.

Terraform : Oracle Cloud Infrastructure (OCI) General Information - This article describes how to display some commonly used information from Oracle Cloud Infrastructure (OCI), needed when using Terraform.

Terraform : Linking Oracle Cloud Interface (OCI) Terraform Modules Together - This article demonstrates how to link Oracle Cloud Interface (OCI) Terraform modules together to deploy infrastructure.

Ansible vs Terraform - This article compares Ansible and Terraform, explaining what roles they play in infrastructure as code.

Others

PowerShell : Useful Commands - A collection of commands and scripts I've found useful when working with Windows PowerShell.

Adding/Removing Windows Features using PowerShell - This article describes how to list, add and remove Windows features using PowerShell.

SQL Server : Connections in SQL Developer - Use SQL Developer to connect to SQL Server databases.

Dnsmasq : For Simple DNS Configurations on Mac OS X - Learn how to use Dnsmasq simple DNS configurations on Mac OS X.

Miscellaneous Frequently Asked Questions - Some frequently asked questions about general items.

Cool New Features for Developers in 18c and 12c - A links page to all the articles referenced by the conference presentation of the same name.

Patching : Find the Required Patches for Oracle Products - This post describes how to identify the required patches for your Oracle products.

Configuring the Alcatel SpeedTouch USB modem on RedHat 7.3 - 9.0 - A guide to configuring an ADSL connection on RedHat Linux using the Alcatel SpeedTouch USB modem.

Automation Patterns for Typical DBA Tasks - This post describes some common automation patterns I use when automating typical DBA tasks.