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 […]
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 […]
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 […]
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 […]
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 […]
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 — […]
Recently I was busy upgrading our DEV database from 12.1 to 12.2 & found JServer JAVA Virtual Machine registry component was in INVALID state. COMP_NAME COMP_ID VERSION STATUS ———————————– —————————— —————————— ———– Oracle Application Express APEX 4.2.5.00.08 VALID OWB OWB 11.2.0.3.0 VALID OLAP Catalog AMD 11.2.0.4.0 OPTION OFF Spatial SDO […]
Few days ago I observed, all of a sudden, one of the application related cron job started failing with following error. ORA-06598: insufficient INHERIT PRIVILEGES privilege This job was intended to drop temporary tables in application schema. We had written a shell script in which SYS user executes procedure owned […]
IHAC who is on Exadata image version: 11.2.3.3.0.131014.1, faced below issue. Any command on cellcli was failing with error: CELL-02630. CELL-02630: There is a communication error between Management Server and Cell Server caused by a mismatch of security keys. Check that both servers have access to and use the same […]
Recently my customer faced the following issue, wherein after completing the X7-2 Exadata Install, Flash cache was showing different size in one of the cell node than other cells. Everything went well with onecommand install until step 15 which had this warning: Warning:Flash Cache size is not consistent for all […]
Adityanath's Oracle Blog 