Minimalistic Oracle

Minimalistic Oracle contains a collection of practical examples from my encounters with Oracle technologies. When relevant, I also write about other technologies, like Linux or PostgreSQL. Many of the posts starts with "how to" since they derive directly from my own personal experience. My goal is to provide simple examples, so that they can be easily adapted to other situations.

Monday, December 12, 2022

Some useful ADRCI commands

›
The ADR (Automatic Diagnostic Repository) and its command-line tool adrci was introduced in Oracle11g and is still available. I still find...
Friday, December 9, 2022

What does the UR = A in tnsnames.ora mean?

›
I recently had to connect remotely as sysdba to remote instances when I created Physical Standby Databases using RMAN. There were some som...

How to solve "Can't locate TXK/ARGS.pm in @INC (you may need to install the TXK::ARGS module)" when running txkChkPDBCompatability.pl

›
Background: As a part of converting your non-CDB Oracle database to a pluggable database, you are supposed to run the perl script txkChkP...
Tuesday, December 6, 2022

SWITCHOVER VERIFY WARNING: switchover target has no standby database defined in LOG_ARCHIVE_DEST_n parameter.

›
When performing a switchover verificaton from your primary database, in your Data Guard setup, you may see the following: sqlplus / as sys...

What is an Oracle snapshot standby database?

›
A snapshot standby database is a fully updatable standby database. Redo data is still received from the primary database, but it is not ap...
Monday, December 5, 2022

How to avoid redo logs and standby redo logs being created as OMF files during a DUPLICATE ... FOR STANDBY operation

›
Recently I had to create a Data Guard physical standby database, and I used RMAN active database duplication ( "duplicate target datab...
Friday, December 2, 2022

How to alter a column to use a sequence generated number

›
In my example, mytable contains a columnn called id, which is of datatype bigint. If you want to use a sequence to automatically popluate...
‹
›
Home
View web version

About Me

My photo
Name: Vegard Kåsa
My career as an Oracle DBA startet in 2001, when I acceptet a request to take on the responsibility as my current employer's DBA. From that point and onwards, managing Oracle databases has kept me busy and engaged. I enjoy my work, and particulary appreciate the constant learning and devlopment that comes with the job. From 2014, I am self-employed through my company Oric Consulting AS (Norway), and from 2024 Oric Consulting AB (Sweden) I currently live in Göteborg, Sweden, with my family.
View my complete profile
Powered by Blogger.