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.

Friday, February 24, 2023

Getting ORA-01722 when running adstats.sql after an EBS database upgrade to 19c

›
An old error from 2015 surfaced today , when we were trying to upgrade a 12.1 EBS database to 19c. The problem occured during the running...
1 comment:
Sunday, February 19, 2023

How to identified active files/executables when using opatch to deinstall software

›
During a opatch rollback operation, we saw the following error message in the opatch logfile: [Feb 19, 2023 2:29:51 PM] [INFO] Prerequi...
Saturday, February 18, 2023

How to prevent sed to destroy your symlinks

›
Because of EBS, we have a subdirectory in our $TNS_ADMIN which has the following name PDB1_test1.oric.no In other words, the files listen...
Tuesday, February 14, 2023

Error fetching the value from a shell script executed by root, when doing "su - oracle"

›
Problem: Inside a new bash shell session, executed as user "oracle", like this: su - oracle <<! instructions here ! I ...
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...
‹
›
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.