Using Vagrant with Oracle Database
Vagrant is an excellent tool for provisioning environments for quick tests. With just a few commands you can deploy a virtual machine and an…
ORA-01400: cannot insert NULL into
When applying the datapatch, the following error was encountered ORA-01400: cannot insert NULL into…
ORA-29548: Java system class reported
When trying to view the Java version, using a query in the database, the error ORA-29548 is reported.Here’s how to quickly solve this…
ORA-01623
Here’s a quick tip on how to resolve the error: ORA-01623: log 12 is current log for instance UNNAMED_INSTANCE_2 (thread 2) –…
gDBClone a script you NEED to know
I came across this script looking for something to snapclone databases, other than SPARSE DISKGROUP.If you don’t want to read this post,…
How to remove an old GRID_HOME
The ORACLE_HOME I want to remove is OraGI19Home2. 1. Create a variable with the value of GRID_HOME, which will be removed. 2. Check that the…
LsInventorySession failed: RawInventory gets null OracleHomeInfo
Running the command opatch lsinv displays the error below: The error occurs because ORACLE_HOME was entered incorrectly in the inventory.To…
OPATCHAUTO-72115
Problem: When trying to execute opatchauto outofplace, the execution failed with the error below: Solution: Clear checkpoint file(s) from a…
ORA-12547: TNS:lost contact
Ao tentar conectar-se com sqlplus / as sysdba é apresentado o erro de ORA-12547: TNS:lost contact. Abaixo apresento algumas formas de correção…
OEM agent is not collecting metrics
Today I found one of the OEM agents running normally, but it wasn’t sending the metrics to Enterprise Manager.Fortunately, the solution…