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 […]
Recently one of my client faced issue after upgrading Exadata image in DB server, image was showing its status as failure. I did review all patchmgr logs but didn’t see anything weird. root@testserver1 ]# imageinfo Kernel version: 4.1.12-94.8.4.el6uek.x86_64 #2 SMP Sat May 5 16:14:51 PDT 2018 x86_64 Image kernel version: […]
Yesterday one of my customer had issue with running telnet command on exadata server. It was failing with below error: [root@extestserver ~]# telnet telnet: /lib64/libc.so.6: version `GLIBC_2.15′ not found (required by telnet) I asked him to provide me details like telnet version & kernel version running on the server: [root@extestserver […]
In my previous post Oracle Histograms Simplified: Part 1, I focused on what is histogram & why it is used. In this post I will explain different ways to create & drop histograms. HISTOGRAM CREATION: Creation of histogram is always depends on parameter method_opt that you specify during gathering statistics. […]
Adityanath's Oracle Blog 