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.

Wednesday, January 25, 2023

clone.pl is deprecated, substituted by runInstaller - how to use

›
1. create a "Golden Image" of the Oracle software home you want to clone oracle@testserver1.oric.no:[testdb01]# /sw/oracle/prod...
Tuesday, January 24, 2023

How to avoid error Perl lib version (5.28.1) doesn't match executable version (5.36.0)

›
When trying to use clone.pl to clone the latest version of the Oracle 19c database, the following error stopped me from proceeding: /sw/or...
Thursday, January 19, 2023

What is the ifile directive sometimes used in tnsnames.ora?

›
My customer is using Oracle E-Business Suite, and during a so-called "autoconfig", some files in the Oracle RDBMS home on the dat...
Wednesday, January 11, 2023

More on setting redo routes property when adding a terminal standby database to your data guard broker configuration

›
As described in an earlier post , it is possible to set up a "terminal standby database" which fetches its redo information from ...
Friday, January 6, 2023

How to solve script error $'\r': command not found syntax error: unexpected end of file

›
when trying to execute a script from root, like the following: su - oracle -c "/tmp/set_params.sh" You may see errors like the...
Wednesday, January 4, 2023

Check if your CDB is set up for local undo

›
col PROPERTY_NAME format a20 col PROPERTY_VALUE format a20 col DESCRIPTION format a40 col LOCAL_UNDO_ENABLED format a20 select * from data...
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...
‹
›
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.