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

CVE-2022-21500

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

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 12.2.1.4 – File not found $ORACLE_HOME/lib/libvsn12_ee.a.dbl using GUI

$ORACLE_HOME error

After installing Weblogic and Fusion Middleware (FMW) 12.2.0.4, 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 >

Migrate RDB to Cloud SQL Using Google’s Dataflow

rdbms data transfer

Most corporations have huge amounts of data in RDBMS (relational database management system). When considering a RDBMS data transfer and you only need a subset of data to migrate to the cloud, follow this very efficient and easy data ingestion…

Read More >
Page 1 of 3212345...10...Last Page »