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 […]
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 18.104.22.168.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/22.214.171.124/grid/bin # cd $ORACLE_HOME/crs/install test-server01:/u01/app/126.96.36.199/grid/crs/install # ./roothas.sh -postpatch Using configuration parameter […]
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 […]
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 $OSSCONF/cellmskey.ora file.
IHAC who is on Exadata image version: 188.8.131.52.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 […]
New Exadata install getting Warning:Flash Cache size is not consistent for all storage nodes in the cluster.
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 […]
Exadata image 18.1.5 in status failure due to Validation check ERROR – NOT RUNNING for service: dbserverd
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: […]
Telnet command fails with telnet: /lib64/libc.so.6: version `GLIBC_2.15′ not found (required by telnet)
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. […]
Oracle Histogram is very nice feature to help CBO to make right decision while constructing execution plan. But many of DBA’s do not use it, assuming it is complex concept to use. In next few posts, I will try to simplify it, so that we can achieve maximum benefit from […]