Using asmcmd to Find the spfile and Password from ASM


I’m currently reviewing an environment that has been upgraded to 19c based on information from oratab. The reason for the review is to remove previously installed versions of the software.     Oracle software is installed to ORACLE_HOME, with variables…

Read More >

How to Create an Oracle SE2 Database and Avoid Licensing Problems

If you recently created an Oracle Standard Edition 2 database, you might not be in compliance with Oracle after all. There are several obscure traps you could fall into during the SE2 database creation process. This post details each step…

Read More >

Token-Based Authentication for ADB with IAM: Part 2

adb authentication

In Part 1, we discussed the essentials of DB token-based authentication and looked at examples to set up authentication for IAM users with exclusive or shared schema mappings. In this second  part, we’ll look at use cases for setting up…

Read More >

Token-Based Authentication for ADB with IAM: Part 1

ADB authentication

Oracle has introduced an authentication mechanism that enables Oracle Cloud Infrastructure (OCI) users to use their Identity and Access Management (IAM) credentials to access the Autonomous Databases (ADB) transparently.       Earlier, IAM credentials could be used to access…

Read More >

Slow Query in eBS AutoConfig with DB 19c

slow query

We recently completed a few e eBS R12.2 database upgrade installations and noticed an issue with a particular SQL running as part of the AutoConfig.       The query sql_id is 5da8tjzfafw6j and it looks like this (formatted): select…

Read More >

CVE-2022-21500 and Your Oracle E-Business Suite


Something  exciting happened a few days ago. It started with a tweet and a blog post, and has evolved into an official CVE-2022-21500. I thought it would be good to publish some details beyond the official MOS note document.  …

Read More >

Moving your Oracle Database to the Cloud? Here’s Why You Should be Thinking Google Cloud

Oracle has long been a top choice for relational databases—but migrating those workloads to the cloud requires a lot more effort than a simple lift and shift. Oracle databases are typically large and complex, so if you’re looking to migrate…

Read More >

Automating Scripts Via SSH


Have you ever logged on to a Linux machine, only to be greeted by a prompt requesting you make some choice? It’s probably a script being called from .bash_profile or .profile, and that script doesn’t let you exit until a…

Read More >

Installing Forms – File not found $ORACLE_HOME/lib/libvsn12_ee.a.dbl using GUI


After installing Weblogic and Fusion Middleware (FMW), I came across the following error when I tried to install Forms with OUI GUI. Here’s how I fixed it.     The problem   Here’s what using the proper WLS RHEL…

Read More >

Unusual Use of the RMAN uncatalog Command

rman uncatalog command

A fresh year is the perfect time to learn something new. Recently, I have come across warning messages in the RMAN level 0 backup log file and this post describes how I dealt with them.       The file…

Read More >
Page 2 of 3312345...10...Last Page »