Skip to content

DBA Blog

  • Home
  • Oracle
    • Administration
    • Application Server
    • Backup & Recovery
    • High Availability
    • Engineered Systems
    • Migration
    • References
    • Security
    • Troubleshooting
  • MySQL
    • High Availability
    • Installation
  • Cloud
    • Oracle Cloud Infrastructure
  • Linux / Unix
    • Administration
    • Installation
  • Virtualization
    • VirtualBox
  • About Me
  • Appearences
  • Imprint
DBA Blog

Tag: Oracle

11. October 2022 Christian Gohmann

ExaCC: 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 reading
16. April 2022 Christian Gohmann

ExaCC: 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 reading
25. March 2022 Christian Gohmann

ExaCC: 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 reading
21. January 2021 Christian Gohmann

Oracle 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 reading
20. January 2021 Christian Gohmann

Installation 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 reading
25. September 2020 Christian Gohmann

Analyze 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 reading
17. September 2020 Christian Gohmann

Cleanup of TEMPORARY segments

In this short blog post, I will explain how to get rid of TEMPORARY segments in a permanent tablespace.

Continue reading
30. March 2020 Christian Gohmann

Generate DBMS_DATAPUMP script using Data Pump trace

Starting with Oracle 10g, Data Pump can be used to export and import database objects using command-line tools expdp and impdp. Calls of these tools are mapped to the Data Pump API within the database. This blog post will demonstrate how to generate DBMS_DATAPUMP calls based on an expdp/impdp execution.

Continue reading
27. February 2020 Christian Gohmann

Different ways to get the current database version

In this blog post I will show you how to get the current version of the connected database using either SQL queries or PL/SQL code. To show you some enhancements in this area, I will use versions 12.1.0.2 and 19c for a comparison.

Continue reading
28. January 2020 Christian Gohmann

ALERT: opatch util cleanup deletes OS files in 12.2.0.1.19

With the release of the January patches, Oracle released version 12.2.0.1.19 of OPatch. In this specific release, the execution of opatch util cleanup deletes OS files outside the Oracle home directory structure. Thanks to my colleague Miguel for pointing this out.

Continue reading

Posts navigation

1 2 Next Posts»

Next Appearances

Recent Posts

  • ExaCC: Database Service Events
  • ExaCC: Single instance databases
  • ExaCC: Oracle Home deployment fails with DBAAS-60018
  • ExaCC: DSI creation fails because of default patches
  • ExaCC: Create VM Cluster Network using OCI CLI

Archives

  • October 2022
  • August 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • November 2021
  • August 2021
  • July 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • October 2020
  • September 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • November 2019
  • July 2019
  • May 2019
  • December 2018
  • October 2018
  • August 2018
  • July 2018
  • February 2018
  • January 2018
  • December 2017
  • October 2017
  • September 2017
  • July 2017
  • May 2017
  • April 2017
  • June 2016
  • November 2015
  • April 2015
  • July 2014
  • January 2014
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • April 2013
  • February 2013
  • January 2013
  • October 2012
  • June 2012
  • May 2012
  • March 2012
  • February 2012
  • January 2012
  • November 2011
  • August 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010

Tags

12cR1 12cR2 18c 19c 20 21c Alert audit vault server cloud co configuration databaes Database Data Guard DataPump Data Pump dbms_space_admin DBSAT exacc expdp firewall Grid Infrastructure hr impdp installation iscsi ix Linux Listener New Features oci opatch Oracle patching patchmgr rman sample schemas scott Security segments srvctl storage tracing Troubleshooting VirtualBox
WordPress Theme: Wellington by ThemeZee.
Opt-Out Click here to opt-out.