OEM Metrics Extension || What || Why || How
Dear Readers, My first YouTube Video on “OEM Metrics Extension || What || Why || How” Hope u will find this post very useful. Cheers Regards, Adityanath
GRID 19c AIX patching with GI RELEASE UPDATE 19.6.0.0.0 fails with CLSRSC-196: ACFS driver install actions failed
Today while applying “Patch 30501910: GI RELEASE UPDATE 19.6.0.0.0” on recently upgrade GRID home from 12.2 to 19.6, I received error related ACFS ==> CLSRSC-196: ACFS driver install actions failed. Command used for patching ==> opatchauto apply -oh /u01/app/19.6.0.0/grid /u05/ADI/patch/30501910 Detailed error is as given below: Execution of [SIHAStartupAction] patch […]
Oracle 18C new features : Part I
Dear Readers, I have published two more articles on KT EXPERTS. This articles focuses on new DB features that have been introduced in Oracle 18C along with its significance. Oracle 18C new feature: Cancel SQL instead of killing session Oracle 18C new feature: Schema Only Account Hope u will find […]
Oracle 18C New Initialization Parameters
Dear Readers, I am very happy to announce that I posted my first ever article on KT EXPERTS. This article focuses on new DB parameters that have been introduced in Oracle 18C along with its significance. Oracle 18C New Initialization Parameters Hope u will find this post very useful. 🙂 Stay […]
DBMS_LOCK.SLEEP is now deprecated, the new SLEEP is DBMS_SESSION.SLEEP
We need sleep function many a times in our code, may be for application logic or even sometimes for monitoring purpose. We always had this available with sleep() function that resides within DBMS_LOCK ==> DBMS_LOCK.SLEEP This was always a big security risk as granting access to DBMS_LOCK will make a […]
SQL*Plus command line history on UNIX platform
One of the best feature I came across recently. Oracle SQL*Plus is now support command line history similar to UNIX “history” command. This feature is available from Oracle 12.2. Sample example is given below: You can refer below link for more details: SQL*Plus HISTORY Hope u will find this post […]
Why should people attend AIOUG events :-)
Dear Connections, I was chatting to one of my dear friend yesterday during Sangam19 and he turned to me and asked “Why should people attend any AIOUG events”. It made me pause to think for a moment. Any type of such events is going to take up your time and […]
OEM agent version 13c installation on AIX fails with OUI-10039:Unable to access the inventory /u01/app/oraInventory on this system.
Hello Readers, Few days ago, I was installing OEM agent version 13.3.0.0.0 on my DEV box with OS AIX version 7.2. I was using silent method using agentDeploy.sh. Previously I had installed it successfully on multiple machines without any issues but this one failed with below error: java.io.IOException: OUI-10039:Unable to […]
./roothas.sh -postpatch OR root.sh failing with CLSRSC-400: A system reboot is required to continue installing.
Recently I was doing fresh Grid Infrastructure(GI) 12.2 install on one of our UAT boxes, wherein I was facing strange issue. Both “root.sh” & “./roothas.sh -postpatch” exiting with below error/warning: CLSRSC-400: A system reboot is required to continue installing. test-server01:/u01/app/12.2.0.1/grid/bin # cd $ORACLE_HOME/crs/install test-server01:/u01/app/12.2.0.1/grid/crs/install # ./roothas.sh -postpatch Using configuration parameter […]
DST_UPGRADE_STATE = DATAPUMP(1) causing issue in Oracle DB upgrade.
Yesterday, I was busy upgrading my UAT database from 12.1.0.2 to 12.2.0.1. As a prerequisite when I ran preupgrade.jar into 12.1 RDBMS home it gave me below warning: — CHECK/FIXUP name: pending_dst_session — — The call to run_fixup below will test whether — the following issue originally identified by — […]
