Author's details

Name: Aaron Myers
Date registered: March 30, 2014
URL: https://www.balddba.com

Latest posts

  1. RMAN table recovery error — May 20, 2022
  2. Getting and formatting index ddl — September 17, 2021
  3. pythonGit private repository — September 2, 2020
  4. cx_Oracle ORA-24418 — April 30, 2020
  5. Patching 19.3 to 19.6 — March 19, 2020

Author's posts listings

May 20

RMAN table recovery error

I had a user delete the data in a table that they didn’t mean to. It took them a week to notify us, so no chance to use flashback to get the data back. I was not looking forward to restoring 100TB of datafiles and recovery logs just to restart a couple GBs of data. …

Continue reading »

Sep 17

Getting and formatting index ddl

This is a little useful sql I used this morning for stripping out all the additional information that dbms_metadata.get_ddl outputs. This strips the create index statements down to their bare bones.

Sep 02

pythonGit private repository

I built an online editor for modifying some files. They need to be checked into git after they are edited. Unfortunately there is no direct way of setting the username and password for the git repository. Instead you need to use http authentication, and put the username and password into the URL of the repository. …

Continue reading »

Apr 30

cx_Oracle ORA-24418

I am writing a web portal for a bunch of database tasks, and storing information in an oracle database. I am creating a connection pool but seeing this error. This looks like an ORA-24418 out of sessions error. However when I check the database, there are only 120 of the 1200 available sessions being consumed. …

Continue reading »

Mar 19

Patching 19.3 to 19.6

I’m not going to go through the entire patching process, there are lots of other sites that can walk you through this. What I am going to talk about is some issues that I had after patching. The patch to the binaries went fine, however when I tried to run Datapatch against my database, I …

Continue reading »

Jan 24

wrong number or types of arguments in call to ‘CHECKDATAFILEFORSTANDBY’

I started seeing this today in one of our databases I found metalink article 2360045.1 which states that it is a catalog version mismatch, however running upgrade catalog doesn’t resolve the problem.  I remember hitting this error a long time ago, and although I can’f find the reason why, running upgrade catalog two times in …

Continue reading »

Sep 13

TDE Wallet on RAC

So I have been having trouble getting the oracle wallet to auto open, and it’s always messed up in gv$encryption_wallet

According to Oracle this is is because TNS_ADMIN is not set, so I set it and several other suggested variables.

After restarting the database, the ACFS volume now shows 

Sep 09

DBSNMP long running query

I noticed a long running query in one of my databases this morning.

Its computing tablespace size. The average runtime is 272.03 sec, or 4.5 minutes. This isn’t right, its running in a few seconds in other databases. I started looking at the query in OEM, and noticed almost all the execution time was …

Continue reading »

May 14

ORA-01422: exact fetch returns more than requested number of rows

The other night on of my databases started throwing the following error. From the RMAN trace The solution here is actually quite simple, the rout table, which stores previous rman output from previous runs so that it can displayed in OEM had excessive rows in it. Since we don’t really use OEM to track our …

Continue reading »

Apr 24

New Server

My old web server has been retired. I have been moving sites the last couple of days to a new box. I took the time to virtualize the machine and set everything up properly. The old box was starting to show it’s age with lots of modified configuration files and outdated software. The website seems …

Continue reading »

Older posts «