Skip to content

DBA Blog

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

Tag: Oracle

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
13. January 2020 Christian Gohmann

Shrink virtual disk (VDI) of a VirtualBox VM (Linux)

A lot of people are using VirtualBox to build their test or demo environments. In this blog post, I will demonstrate how to shrink an existing virtual disk of a Linux VM (Oracle Linux 7).

Continue reading
11. November 2019 Christian Gohmann

Rotation for plain-text listener log in 19c

In this short blog post, I will write about a new feature introduced with Oracle 19c. Starting with this release the plain-text listener log located in the diagnostic directory are rotated.

Continue reading
19. July 2019 Christian Gohmann

Insufficient SRLs reported by DGMGRL

This is a short blog post about a small issue with the reporting of Standby Redo Logs in DGMGRL during the validation of a database.

Continue reading

Posts navigation

1 2 Next Posts»

Next Appearances

Recent Posts

  • Oracle 21c: Simultaneous use of INCLUDE and EXCLUDE in Data Pump
  • Installation of sample schemas in Oracle 12c and higher
  • Oracle 21c: Dedicated Grid Infrastructure resource for a PDB
  • Installation of Database Firewall 20.1
  • Installation of Oracle Audit Vault Server 20.1

Archives

  • 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 ASM Change cheat sheet Compression CSV Database DataPump Data Pump DBMS_METADATA DBMS_TNS DBSAT expdp Formatting Grid Infrastructure impdp Java Kernel Linux Listener New Features opatch Oracle orapwd Package PL/SQL rman Security Silent SQL*Plus srvctl Stack Clash tracing Troubleshooting UEK unix Utilities vi VirtualBox
WordPress Theme: Wellington by ThemeZee.
Opt-Out Click here to opt-out.