Articles Comments

AskDba.org Weblog » Archive for February 2009

Upgrade to Wordpress 2.7.1

February 12th, 2009 | Add a Comment

Wordpress 2.7.1 is out..While using upgrade button, it will be stuck at downloading files and will not proceed further. This issue will be faced by people using “Automatic Upgrade” plugin available in prior release. You need to disable the plugin and then re-try the operation. Also note that you have to take a “Backup ” of database as the plugin does not take automatic backup. Wordpress Automatic Upgrade plugin did not work for me , as this gave message for my 2.7 installation “Congratulations!!! Your WordPress version is already up to date” So you can easily go ahead and disable this plugin and use the Upgrade option available with Wordpress 2.7 Cheers Amit … Read entire article »

Filed under: Random

Scheduling Job through Cron??

February 9th, 2009 | Add a Comment

In case you came across this link searching for Cron syntax, then you can refer to following link http://www.adminschoice.com/docs/crontab.htm Other’s can continue reading the article …. This was a problem which I faced yesterday. We had a mview refresh which was lagging on one of the server. On checking master site, I found that there were many pending requests coming from the second materialized view site . Checking second site revealed that there were multiple sessions running in database which were waiting on ‘enq :JI Contention’ wait event. These mviews were being refreshed by job scheduled through a cron. Doing a grep for the refresh script gave following result $ps -ef|grep scott|grep -v grep oracle 11725 11714 0 13:00:00 ? … Read entire article »

Filed under: database, oracle

Creating ASM devices on AIX

February 1st, 2009 | 2 Comments

I thought of sharing few tips on creating ASM devices on AIX which I will be helpful to Oracle DBA’s. Suppose SysAdmin gives you list of Serial numbers for LUN instead of device Name pcmpath query device DEV#: 33 DEVICE NAME: hdisk33 TYPE: 2107900 ALGORITHM: Load Balance SERIAL: 75DM0111101 =========================================================================== Path# Adapter/Path Name State Mode Select Errors 0 fscsi0/path0 CLOSE NORMAL 9 … Read entire article »

Filed under: Install, oracle

CRS Fails to Start – 10.2.0.1 RAC Install on AIX

February 1st, 2009 | Add a Comment

I was installing 10.2.0.1 on IBM AIX 5L and while running root.sh from first node (as part of Clusterware installation) got following messages Now formatting voting device: /dev/voting_disk01 Now formatting voting device: /dev/voting_disk02 Now formatting voting device: /dev/voting_disk03 Format of 3 voting devices complete. Startup will be queued to init within 30 seconds I waited for quite some time and found that it was stuck. To check what was status of CSS, I did a grep for CSS and found that it was running /etc/init.cssd startcheck css script. This indicated that Oracle was stuck trying to start CSS. Following errors were recorded in /tmp/crsct.7459 Failure in CSS initialization opening OCR. Metalink notes suggested checking OCR Disk permission , though in my case they had correct permissions i.e ownership as oracle:dba and permission set to 660. To diagnose further, … Read entire article »

Filed under: oracle, rac