P A G E S

▼
Saturday, February 27, 2021

Exadata - Oracle Hardware -- SFP Transceiver types & models

›
Yesterday, one of my collegues made me revisit the following article that I wrote after completing a field operation in an Exadata environme...
Monday, February 15, 2021

RDBMS / RAC -- Inteconnect: RDS , IPC , RAC relink/make, skgxpinfo & ORA-27300 - bind_fail

›
Recently my team reported this issue to me.. An Oracle 11.2.0.4 database couldn't start on an Exadata with a freshly installed RAC Home....
Wednesday, February 10, 2021

RDBMS -- Failed add column operation may cause ORA-14097 & ORA-14278 during Partition Exchange

›
Recently an interesting issue escalated to me.. Customer was complaining about failed queries on a partitioned table.. The problem was obvio...
Tuesday, February 9, 2021

OVM - Changing Cluster Heartbeat nw, Questions related to High availability & DR, Comments on bond device problems - LACP activity unknown , LACP suspend-individual

›
Recently I was asked 4 interesting questions. Questions about OVM... In this blog post, I will share my answers and comment for these questi...
Sunday, February 7, 2021

RDBMS -- Analyze AWR reports (part by part /section by section) using Python

›
I like dealing with Python nowadays. By using Python (I used to use perl for these types of things), I am trying to address some issues, esp...
Monday, February 1, 2021

Erman Arslan's Oracle Forum -- January 2021 - "Questions and Answers Series"

›
Question:  How much time do you spend/lose? Answer:   Well, how much time I gain? :)  Remember, you can ask questions and get remote support...
Sunday, January 31, 2021

EBS -- Using Python to catch and terminate runaway forms runtime processes / Runaway Forms Runtime Handler

›
 Whenever I need to develop some tools to ease dev ops or administration, I usually use perl and some bash scripts to do the job.. Sometimes...

RDBMS-- Parsing the listener log with a straight forward in-database method / by taking that jdbc_url anomaly into consideration :)

›
Remember; years ago, I shared a method for reading the listener log files in a scriptized way.. This type of a method can be used during sec...
Wednesday, January 27, 2021

RDBMS -- DBMS_IJOB.CHANGE_ENV - Change Log_user, Priv_user, Schema_user and NLS_ENV of a DBMS_JOB -- without the need to recreate.

›
Here is a quick tip for the ones using DBMS_JOB. Using DBMS_IJOB (undocumented), we can manipulate  dbms jobs. Ofcouse, DBMS_JOB is the best...
Thursday, January 21, 2021

EBS 12.2 19C DB environments -- Suggestions for some issues (including performance related ones) / based on a real life story

›
In my previous blog posts, I made some suggestions for dealing with problematic discoverer reports, which may have performance issues especi...