Pages

▼
Monday, October 14, 2024

Oracle Database 11g -- How to Quickly Reset RMAN Configuraiton

›
Problem You want to reset RMAN configuration to its default state, quickly with one step Solution Use the below procedure: SQL> exec dbms...
Saturday, October 12, 2024

Oracle GolgenGate 21c -- Configure a CDB Database for GoldenGate Extract

›
Problem You need to configure a CDB database for enabling a GoldenGate extract for replication Solution Perform the following actions on the...
Thursday, April 25, 2024

Oracle GoldenGate 21c -- How Triggers Fired during Replication

›
Problem You need a better understanding on how Oracle database triggers work with Oracle GoldenGate replication Solution By default in an Or...
Wednesday, April 10, 2024

OCI Autonomous Database -- How to Create a DB Link

›
Problem You want to create a database link on an Autonomous Database in OCI (Oracle Cloud Infrastructure) Solution Use commands below to cre...
Saturday, March 30, 2024

Cygwin -- File permissions for ssh

›
Problem While configuring openssh for cygwin, ssh key authentication does not work, the key does not get accepted  Solution Make sure the .s...
Wednesday, March 20, 2024

AIX 7.2 -- setreuid fails with PermissionError

›
Problem You want to change euid or ruid for a process, for example, the snippet below tries to start bash as user oracle executed by user gr...
Sunday, March 17, 2024

Oracle Database 11.2 -- Manually Install Java Component in an Oracle Database

›
Problem You want to manually install the Java Component in a Oracle Database version 11.2 and up Solution Note. The solution is application ...
Friday, March 1, 2024

Oracle Database 12.2 -- How to Create a Dump of a Controlfile

›
Problem You need to create a dump of a controlfile Solution Use the below command to dump a controlfile to a trace file: alter session set e...
Friday, February 16, 2024

Oracle Database 19c -- Disable VIEW PUSHED PREDICATE

›
Problem You want to disable VIEW PUSHED PREDICATE transformation in a session or for the whole system Solution Apply the hidden parameter at...

Oracle Database 19c -- Display Actual Rows along with Estimated Rows on Execution Plans

›
Problem You want to have Actual rows and Estimated rows statistics displayed on execution plan of a query Solution First enable the optimize...