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 18.104.22.168.0 VALID OLAP Catalog AMD 22.214.171.124.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 […]
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: 126.96.36.199.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 […]
Drop empty tablespace fails with ORA-14404 or ORA-144047 partitioned table contains partitions/subpartitions in a different tablespace
Recently I was performing database reorg operation on one of pre-prod environment with traditional way of table/lob movement followed by index rebuild. After moving all segments from current tablespace to new, I was ready to drop original one. SQL> select count(0) from dba_segments where tablespace_name=’MY_TABLESPACE’; COUNT(0) ———- […]
In this post, we are discussing about performance issue which I faced with EXPDP schema backup. We have a production database, for which we take daily EXPDP schema backup before EOD starts. The control-m job configuration has made in such a way that EOD will not start until schema level […]