Pages

▼
Friday, June 20, 2025

SSL Connection Fails with SSL routines:final_renegotiate:unsafe legacy renegotiation disabled

›
Problem SSL connection fails with and error:  SSL routines:final_renegotiate:unsafe legacy renegotiation disabled:ssl/statem/extensions.c:94...
Saturday, May 24, 2025

Oracle Database 19c -- Enable Tracing for an impdp Job

›
Problem When an impdp job fails with an error, you want to identify the failing statement Solution Enable tracing for the impdp job with:  S...

Oracle Database 19c -- impdp fails with ORA-14401 inserted partition key is outside specified partition

›
Problem Importing data into an Oracle Database 19c with impdp fails with the errors like: ORA-31693: Table data object <table> failed ...
Friday, May 23, 2025

Oracle Restart 19 -- roothas.sh fails with CLSRSC-752: incorrect invocation of script

›
Problem Deconfiguring ( roothas.sh -deconfig -force ) or configuring ( roothas.sh ) Oracle Restart might fails with the error like: CLSRSC-7...

Oracle Restart 19 -- Managing a Database Fails with PRCR-1055 : Cluster membership check failed

›
Problem When using Oracle Restart, and trying to add, start, stop, or check status of an Oracle Database, you get the errors below: $ srvctl...

Oracle Restart 19 -- roothas.sh fails with CLSRSC-762: Empty site GUID for the local site name

›
Problem After cloning Oracle Restart to another host, reconfiguration might fail with the errors:  # $GRID_HOME/grid/crs/install/roothas.sh ...
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...