Michael Dinh

Subscribe to Michael Dinh feed Michael Dinh
Michael T. Dinh, Oracle DBA
Updated: 5 hours 15 min ago

DON’T BE BITTER

Thu, 2024-05-23 23:30

Imagine a manager complimenting you, “I sleep better knowing you are at the helm.”
I have been laid off three times in a row now.

The last 2 positions were given to me without any interviews because the managers knows me and my work ethics.

I found this on LinkedIn and is just bad ethics.

BEST

Thu, 2024-05-23 07:38

I have always said the best part of me is my spouse.

Always do your best because you do not know who is paying attention!

Don’t Know + Don’t Try = Don’t Care.

Remove the don’t and do your best!

EFFECTIVE vs EFFICIENT

Mon, 2024-05-20 17:45

What is the difference?

SRDC – Collect Data Guard Diagnostic Information (Doc ID 2219763.1)

Fri, 2024-05-17 07:47

Auto Collection Using TFA (Recommended)
Manual Collection Using Script for Unix

Note: Oracle support typically request TFA; however, some environment disable TFA due to resource.

This means manual collection is required.

Want To vs Have To

Tue, 2024-05-14 22:38

Of course, it’s better to have people act because they want to vs have to.

Like everything, it depends.

Going back to the team I led decades ago. When asked to perform a task, I would typically get the same set of volunteers. They are the ones I can always count on.

Unfortunately that’s not the case for my new team. It’s so quiet that one can hear a dog fart.

In a crisis situation, asking for volunteers is not ideal.

A lifeguard resuscitating a person would not shout, “Someone call 911!”

Instead, lifeguard will need to select a specific person.

You! What’s your name. Do you have a phone? If yes, call 911. This create accountability vs having everyone calling 911.

Know the situations!

CONFIDENCE

Sun, 2024-05-05 20:21

Cleaning emails from a decade ago to find what I used to have as part of signature.

Confidence comes not from always being right but from not fearing to be wrong – Peter T Mcintyre

Great minds discuss ideas; average minds discuss events; small minds discuss people – Eleanor Roosevelt

BELIEVE

Fri, 2024-05-03 22:27

If I told you that I am timid, then would you believe me?

I was asked, “If you don’t believe in yourself, then who will?”

I was told by a dear departed friend, Jerry Roberts, to tell yourself, “Every day in every way, I get better and better.”

I was once complimented, “There is a fine line between confidence and cockiness and you walk that line well.”

Believe in yourself and the best you can be.

FUN

Fri, 2024-05-03 19:15

Leadership

Thu, 2024-05-02 16:20

Good leadership is when people do things because they want to versus have to.

Recently, I was given a position as team lead and it seems I have fallen in the second position (have vs want).

Wondering if I need to make someone cry? Here’s the story for that.

I was promoted to lead at a young age at Puritan Bennet.

The company had 2 strikes with FDA.

Current team lead has made me aware of my short fuse.

First day as a lead, a manager tells me “One of your team member is crying in the corner.”

CRAP! I went to see her and ask what I did wrong.

I was not scolding nor yelling but rather spoke in a calm voice. She then tells me, “I can see the anger in your eyes.”

Thank God for remote work.

They are the best!

What is Success?

Wed, 2024-05-01 23:39

To laugh often and much;

To win the respect of intelligent people and the affection of children;

To earn the appreciation of honest critics and endure the betrayal of false friends;

To appreciate beauty;

To find the best in others;

To leave the world a bit better, whether by a healthy child, a garden patch or a redeemed social condition;

To know even one life has breathed easier because you have lived;

This is to have succeeded.

– Ralph Waldo Emerson

I actually have this in my photo album from decades ago.

IF

Sat, 2024-04-20 08:14

Oracle Is Guilty Until Proven Innocent

Fri, 2024-04-19 22:26

Received email from Technical Lead | Senior Manager for the following errors.

Error Description: 0: Invalid pool name ‘oraclePool’ while getting a database connection.
Please check for consistency of the properties files or BPML
Time of Event: 20240419141429
Workflow Id: 88867

First inclination is to check Oracle database parameters (sessions and processes) which wasted time on a wild goose chase.

I am by no mean an expert but Google is your friend.

SI fails to startup with error: “Invalid pool name ‘NewPool_oraclePool’ while getting a database connection. Please check for consistency of the properties files or BPML” (SCI91968)

It puzzle me how a Technical Lead | Senior Manager does not know how to Google.

LMGTFY – Let Me Google That For You for all those people who find it more convenient to bother you with their question rather than to Google it for themselves.

Oracle OEM Read Only Access

Sun, 2024-04-14 20:47

With great power comes great responsibility.

Reference: https://en.wikipedia.org/wiki/With_great_power_comes_great_responsibility

On boarding 4 Database Consultants and they have request access to OEM. Sharing SYSMAN password with every DBA is not a good idea and also difficult to determined who messed up.

Here are 2 articles and I favor Doc ID 2180307.1 based on last update and contains screenshots.

OEM 13c How To Create an Administrator with Read Only Access (Doc ID 2925232.1)
Enterprise Manager Base Platform – Version 13.4.0.0.0 and later
Last Update: Feb 1, 2023

EM 13c : How to Create an EM Administrator with Read Only Access to the Performance Pages of a Database Target? (Doc ID 2180307.1)
Enterprise Manager for Oracle Database – Version 13.1.1.0.0 and later
Last Update: May 9, 2023

Would have been nice to have emcli script to do this but beggars cannot be choosers.

Zero-Sum Game

Thu, 2024-04-11 07:11

Zero-sum is a situation, often cited in game theory, in which one person’s gain is equivalent to another’s loss, so the net change in wealth or benefit is zero.

A zero-sum game may have as few as two players or as many as millions of participants.

Reference: Zero-Sum Game Definition in Finance, With Example

This is what the database team is facing because system team is upgrading operating system to Red Hat Enterprise Linux 7 which will reach its end of life on June 30, 2024 (2 months later).

Here are some Oracle Docs with may be helpful.

IMPORTANT: Need to relink GI and DB

There is one step missing and do you know what it is? Keep in mind, not all environments are the same.

How To Relink The Oracle Grid Infrastructure Standalone (Restart) Installation Or
Oracle Grid InfrastructureRAC/ClusterInstallation (11.2 to 21c).
Doc ID 1536057.1

Relinking Oracle Home FAQ ( Frequently Asked Questions)
Doc ID 1467060.1

Executing “relink all” resets permission of extjob, jssu, oradism, externaljob.ora
Oracle Database – Enterprise Edition – Version 10.2.0.3 and later
Doc ID 1555453.1

The Best vs. The Rest

Sat, 2024-04-06 09:53
I was looking how to start and title blog post and found great read above.

CAUTION: whine being served next.

Currently, Oracle database version 11.2.0.4 is running on RHEL 6.10 and database version 12.1.0.2 is running on RHEL 6.10, 7.1, 7.5.

System administrators decides to upgrade OS to RHEL 7.9 which will be EOL.

Basically, ZERO sum gain.

In addition, there are plans to migrate away from Oracle RDBMS and to Non-Oracle cloud.

I am not the sharpest tool in the shed, but isn’t this like putting lipstick on the pig before the pig get slaughter?

Common Sense

Tue, 2024-04-02 18:21

I am often reminded of of my experience at 24 Hour Fitness24 Hour Fitness from 2005.

Just purchased Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning and a consultant (we call him Dibs) tells me to throw the book away.

Book is not going to help you if you don’t have commons sense.

SQL Server Gateway (/tmp 100% FULL)

Sun, 2024-03-31 10:05

Trouble Shooting :=)

hostname:/home/oracle$ df -h /tmp
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg01-tmplv
                       12G   12G  4.2M 100% /tmp
hostname:/home/oracle$

hostname:/home/oracle$ lsof +D /tmp
lsof: WARNING: can't opendir(/tmp/lost+found): Permission denied
COMMAND   PID   USER   FD   TYPE DEVICE    SIZE/OFF    NODE NAME
dg4msql  7319 oracle   10u   REG 253,26 11290202112      39 /tmp/qe9vfnzS
java    18849 oracle  mem    REG 253,26       32768 1441794 /tmp/hsperfdata_oracle/18849
hostname:/home/oracle$

hostname:/home/oracle$ rm -fv /tmp/qeOGiDuK
removed `/tmp/qeOGiDuK'
hostname:/home/oracle$

The process dg4msql (Oracle Database Gateway for SQL Server) used up 100% tmp space.

Temp space for dg4msql is analogous to temporary tablespace for Oracle database.

There can be Multiple Temporary Tablespaces in Oracle and why not multiple tmp directory for OS!

Solution provided by Oracle support.

Those temp files starting with “qe*” are a necessity by the driver and they will be created nevertheless.

One option to avoid to generate in /tmp files if you are running out of space is to set the variable QE_TMPDIR.

This variabe would only change the location where the tmp files are stored. In case you have a partition with more space than the default location of /tmp

You can set this parameter choosing one of the below options –

A) – Set the env variable in the gateway init file specifying the new location of the files, adding the below parameter

HS_FDS_CONNECT_INFO=…
:
#
SET PRIVATE QE_TMPDIR=/var/tmp

B) – Or place it into the listener.ora entry for the gateway using the ENV= parameter, for example:

(SID_DESC=
(SID_NAME=sid_name)
(ORACLE_HOME=)
(ENVS=QE_TMPDIR=/var/tmp,LD_LIBRARY_PATH=/dg4msql/driver/lib:/lib)
(PROGRAM=dg4msql)
)

Either specifying in the gateway init file or in the listener.ora file, stop/start the listener and monitor again.

One suggestion is to check the contents of the QE_TMPDIR or /tmp once a week and see if there are files there, how big they are and how old they are.

If the contents of the QE_TMPDIR or /tmp seem empty and suddenly it fills up; then it is one of your queries that is passing thru a lot of data.

You would need to have that query or session identified and check if there is one way you can make it spread the work a little bit, using a PL/SQL stored procedure that does a few commits along the way, releasing some space.

Closing thought, FS and DB TEMP space should be the same size to prevent issues.

Back With DataGuard Bad Practice

Tue, 2024-03-05 19:39

OS authetication is typically bad practice. In my case, it was HELL.

Back to retirement?

The Beginning Of The End

Sat, 2024-02-10 20:05

Started blogging June 19, 2007.

Thank you for reading!

No better way to end it than the year of Dragon [Wood] (Chinese Horoscope).

Be well; be kind; be happy.

Extract DB User Using OEM

Thu, 2024-02-08 06:43

I know what you are probably thinking.

Number of lines from Create User and GRANTS.

$ wc -l *.sql
1310 CRYSTAL.sql
1383 TMTRCK.sql

Pages