In this blog post I will show how to identify and fix the root cause of a failed Grid Infrastructure upgrade to 23ai and how to complete the upgrade to get the VM Cluster back to the AVAILABLE state.
Continue readingTag: Oracle
ExaCC: Upgrade Grid Infrastructure to 23ai using OCI CLI
In May 2024 Oracle announced the general availability of Oracle 23ai on ExaCC. In this blog post, I will upgrade an existing VM Cluster to 23ai using the OCI CLI.
Continue readingDrop database link in different schema
In this blog post, I will show different ways to drop a private database link of a different schema without connecting to this schema.
Continue readingExaCC: Database Service Events
In April 2022, Oracle released a new feature called Database Service Events for the ExaCC platform. This feature collects telemetry data of VM cluster nodes and sends a notification when a health issue is detected.
Continue readingExaCC: DSI creation fails because of default patches
Since April 2021, ExaCC supports the creation of Database Software Images (DSI). This feature allows the creation of Golden Images of the Oracle Database software, which can then be provisioned to VM clusters. In this blog post, I will explain one reason why the creation of a new DSI can fail.
Continue readingExaCC: Create VM Cluster Network using OCI CLI
This is the first part of a blog series where I will demonstrate how to create a new VM Cluster in an Exadata Cloud@Clustomer environment using the OCI command-line interface. In the first part, I will create the required VM Cluster Network.
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 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