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.

Tuesday, July 30, 2019

How do identify a transport error in a Data Guard setup using the broker

›
Applicable to Oracle 12.2 If the broker has been setup, check the configuration basics: dgmgrl / show configuration; Configuration - DGC...
2 comments:

How to find the last archivelog received and applied in a standby database

›
The last archive log received: select max(sequence#) "Last Standby Seq Received" from v$archived_log val, v$database vdb wh...

How to find out if your standby database lags behind the primary database

›
Applicable to Oracle 12.2. Use the view V$DATAGUARD_STATS, which will only return results when executed on a standby database : set line...
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...
‹
›
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.