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, June 19, 2019

What to remember when adding temporary tablespaces on primary databases

›
Are temporary tablespaces automatically replicated to the standby databases? No, they are not. This is documentet in Oracle support not...
Wednesday, June 12, 2019

How to use dbms_stats.report_col_usage

›
set long 10000 select dbms_stats.report_col_usage('SALES', 'ORDERS') from dual; exit Output could look something like thi...
Wednesday, June 5, 2019

How to solve "FAILED: file csrrsreg.sql on worker " when applying RPC5 to an EBS 12.1.3 installation

›
During a patching of EBS 12.1.3 to RPC5, I encountered an unexpected problem. A while into the patching, the patching procedure failed w...
Tuesday, June 4, 2019

What is the admsi.pl utility that is used during EBS patching?

›
Thanks to the blog post by Atul Kumar for explain this. It's a tool for generating instance-specific patch installation instructions...
Thursday, May 30, 2019

How to create a new database in PostgreSQL

›
postgres=# create role music; CREATE ROLE postgres=# create database musicdb with owner = music; CREATE DATABASE postgres=# Documented he...
Sunday, May 26, 2019

How to display Linux kernel and version information on debian platforms

›
Use the lsb (Linux Standard Base) utility: lsb_release -a Output: No LSB modules are available. Distributor ID: Ubuntu Description: Ubunt...
Wednesday, May 22, 2019

Deprecated security parameter in Oracle 12c: SEC_CASE_SENSITIVE_LOGON

›
Oracle states: "The use of the Oracle instance initialization parameter SEC_CASE_SENSITIVE_LOGON is deprecated in favor of setting t...
‹
›
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.