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 […]
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 […]
Interesting issue happened today, while creating index in database(running 11.2.0.4 DB on Linux), I got ORA-01450: maximum key length (6398) exceeded. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> CREATE INDEX […]
Few days back, I was applying OPatch on one of the database residing on windows server. I tried it multiple times without any luck as everytime when I tried applying patch, I was getting below error: OUI-67073:UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed. This was due to some of the DLL […]
Yesterday I was trying to start DB services using SRVCTL on one of the new environment. I was able to start individual database instances using sqlplus, but it was giving issues for SRVCTL, I was able to start one of the two instances using SRVCTL, but not both, it was […]
Yesterday, application team informed us about production job failure with error: ORA-08103 Object no longer exists. It was simple select query on object with type VIEW. I tried rerunning query which ran without any issue. I tried to investigate, if the underlying objects have been dropped when job was running. […]
In this post, we are discussing about issue which I faced on fresh oracle software install. [oracle@test1.test.com ] Ora:TEST2 $ sqlplus “/ as sysdba” SQL*Plus: Release 11.2.0.4.0 Production on Mon May 30 12:30:31 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-01031: insufficient privileges Normally this issue points […]
Adityanath's Oracle Blog 