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.

Thursday, August 31, 2023

How to extract all datafile names without path using substr and instr functions

›
select trim( substr(file_name, (instr(file_name,'/', -1, 1) +1) ) ) ...

More on how to display the current container in a multitenant database

›
My listener is listening for connections to a service called "myservice1", which runs out of the pluggable database "pdb1...
Friday, August 25, 2023

How to exchange a line in a text file with a different one, when using double quotation marks in the text itself?

›
The following sed command will exchange the string initParams= with initParams=undo_tablespace=UNDOTBS1,sga_target=9GB,db_block_size=327...
Tuesday, August 22, 2023

Cause and solution to ORA-00058: DB_BLOCK_SIZE must be 8192 to mount this database (not 16384)

›
You attempt to execute dbca silently, using a response file, as shown below: dbca -createDatabase -responsefile mydb01.rsp -silent But i...
Tuesday, August 15, 2023

Simple PL/SQL script to alter parameter in database

›
At my current workplace, we use emcli for mass-updates of database parameters in groups of databases. Below is a simple PL/SQL script that...
Friday, August 4, 2023

How to trace the dbca tool

›
These notes are taken directly from MOS, and jotted down here so I have it readily available for the future. To trace the DBCA, we need ...
Thursday, August 3, 2023

Script to check the services in a multitenant container databaser

›
A simple script to check services running out of a specific PDB, or for all PDBs if the root container is selected: column pdb_name format...
‹
›
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.