The default output format of the OCI commandline interface is JSON. Every available piece of information is included in the response. Especially when you use it in Shell scripts or applications, it can be difficult to extract the desired information. This blog post demonstrate the build-in filtering capabilities and the available output formats.
Continue readingConfigure Oracle Cloud Infrastructure (OCI) CLI
The Oracle Cloud can be accessed with its web console or on the command-line using the OCI CLI. In this blog post, I will show the required steps to install it and to link it with your Oracle Cloud tenant.
Continue readingOracle 21c: Separate Oracle Home for GIMR
In Oracle 21c the Grid Infrastructure Management Repository (GIMR) is still an optional component of an Oracle Cluster setup. But with this release, it is not supported anymore to use the Grid Infrastructure installation as Oracle Home for it. Instead, an Oracle RAC Database Home has to be used.
Continue readingOracle 21c: Simultaneous use of INCLUDE and EXCLUDE in Data Pump
Sometimes the small enhancements in a new Oracle release save a lot of effort needed in previous versions to reach the same goal. For me, this applies also to the Data Pump enhancement I am going to blog about, which allows the usage of INCLUDE and EXCLUDE in the same operation.
Continue readingInstallation of sample schemas in Oracle 12c and higher
To demonstrate the features of the database, Oracle provides a list of sample schemas, which can be installed in the database. This blog post provides an overview of the existing sample schemas and summarizes the necessary steps to install them.
Continue readingOracle 21c: Dedicated Grid Infrastructure resource for a PDB
Starting with Oracle 21c, a PDB is registered as dedicated resource in the Grid Infrastructure.
Continue readingInstallation of Database Firewall 20.1
This is the second part of my blog series about the Oracle Audit Vault and Database Firewall 20.1 (AVDF). I will demonstrate how to install and configure the Database Firewall 20.1.
Continue readingInstallation of Oracle Audit Vault Server 20.1
With this blog post, I am trying something new for me. I will install Oracle Audit Vault Server 20.1 as a virtual machine using Oracle VirtualBox. This blog post will be the first of a multipart series of posts around the topic of the Oracle Audit Vault and Database Firewall 20.1 (AVDF)
Continue readingAnalyze raw trace files with SQL Developer
Since version 1.5 the Oracle SQL Developer has the capability to view and analyze raw trace files in an interactive way. In this blog post, I will demonstrate how to use this very unknown feature.
Continue readingCleanup of TEMPORARY segments
In this short blog post, I will explain how to get rid of TEMPORARY segments in a permanent tablespace.
Continue reading