Wednesday, January 31, 2024

How come I cannot logon to my instance as sysdba, when the ORACLE_SID variable is set correctly?

›
Here's a reminder if you use a symbolic link for your ORACLE_HOME variable: You will not be able to attach to your instance using OS a...
Saturday, January 27, 2024

Solution to ERRORMSG: Invalid SYSTEM database user credential when running txkPostPDBCreationTasks.pl as a part of an EBS database upgrade

›
When upgrading an EBS database from version 12c to 19c, you have to convert to the mulitenant architechture. Oracle supplies script for t...
Friday, January 26, 2024

How to find installed patches through SQL in an EBS database

›
During an EBS upgrade, I had to check whether or not a specific patch, 8796558, still needed to be applied. Turned out is no longer releva...

[DBT-50000] Unable to check available system memory when running dbca

›
dbca returned the following error upon launch: [FATAL] [DBT-50000] Unable to check available system memory. CAUSE: An exception occured...
Friday, January 12, 2024

Syntax for dropping standby redo logs

›
In one of my primary databases, I had several old standby redo log files that were forgotten from a previous relocation using Data Guard. T...
Wednesday, January 3, 2024

Workaround for error adstpall.sh: too few arguments specified when stopping the EBS 12.2 server processes

›
ebs@ebsserver1.oric.no 35642926]$ $ADMIN_SCRIPTS_HOME/adstpall.sh –skipNM -skipAdmin You are running adstpall.sh version 120.22.1202000...
Monday, December 11, 2023

How to write custom messages to the alert log file

›
exec sys.dbms_system.ksdwrt(2,'Your message here') The first argument can be either 1 -> Write to the trace file 2 -> Wr...