Articles Comments

AskDba.org Weblog » Archive for August 2009

OCFS2 Configuration Issue

August 19th, 2009 | Add a Comment

While setting up ocfs2 for OCR and Voting disk storage with following commad: # ocfs2console After clicking on ==>cluster ==> configure nodes, I got a pop-up saying: "Could not start cluster stack. This must be resolved before any OCFS2 filesystem can be mounted." Soon I realized that the thing which takes few minutes to get installed, is going to give me a tough time. /var/log/messages shows following details: Aug 17 14:53:40 rac1 modprobe: FATAL: Module configfs not found. Aug 17 14:55:23 rac1 modprobe: FATAL: Module configfs not found. Aug 17 14:56:56 rac1 modprobe: FATAL: Module configfs not found. This prevents the configuration of OCFS2’s cluster stack, but it is mandatory to have OCFS2 cluster stack “O2CB” running, before we can start anything with OCFS2 filesystem. The stack includes the following services: * NM: Node Manager that keep track … Read entire article »

Filed under: database, oracle

GATHER_STATS_JOB – Is it enabled?

August 18th, 2009 | 2 Comments

Few days back , Martin had posted a series of post on a issue where GATHER_STATS_JOB was failing silently for a large object. If you have missed it, you can check following links Automated statistics gathering silently fails http://mwidlake.wordpress.com/2009/07/20/automated-statistics-gathering-silently-fails/ Automated Statistics Gathering Silently Fails #2 http://mwidlake.wordpress.com/2009/07/23/automated-statistics-gathering-silently-fails-2/ Automatic Statistics Gathering Fails #3   http://mwidlake.wordpress.com/2009/07/29/automatic-statistics-gathering-fails-3/ Automated statistics gathering silently fails Automated Statistics Gathering Silently Fails #2 Automatic Statistics Gathering Fails #3 This post is based on some of the discussions on the thread. Please note that this is not intended to discuss bugs (if any) associated with the job Gather_stats_job was introduced with Oracle 10g to gather statistics for database objects which has stale statistics (10% of data has changed, you can query dba_tab_modifications) or the tables for which the statistics has not been gathered (new tables … Read entire article »

Filed under: database, oracle

Failed dependencies error: lib* needed by unixODBC-devel-2.2.11-7.1.i386

August 2nd, 2009 | 4 Comments

While trying to install 11gR1 on Oracle Enterprise Linux (OEL5), runInstaller failed for unixODBC* packages. To solve the issue , I started following OTN article http://www.oracle.com/technology/pub/articles/smiley-11gr1-install.html When trying to install RPM from CD3, faced following errors for unixODBC* rpm #rpm -ivh compat-libstdc++-33* libaio-devel* sysstat* unixODBC* warning: compat-libstdc++-33-3.2.3-61.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 error: Failed dependencies: libboundparam.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libesoobS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libgtrtst.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libmimerS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libnn.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbccr.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcdrvcfg1S.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcdrvcfg2S.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcinst.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcminiS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcnnS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbctxtS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 liboplodbcS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 liboraodbcS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libsapdbS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libtdsS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libtemplate.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 unixODBC = 2.2.11-7.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbc.so.1 is needed by … Read entire article »

Filed under: Unix, oracle