Articles Comments

AskDba.org Weblog » Archive for August 2008

10,000 Hits – First Milestone

August 30th, 2008 | 2 Comments

10,000 Hits – First Milestone

Hi All. Yesterday we crossed 10,000 Blog Visits on our 2.5 month old blog . Actually this blog was started 5 months back on blogger and after some time we moved to wordpress hosted blog. After moving to wordpress, we saw our blog gaining popularity with 5000+ blog visits. At that time we decided to move to our own domain. Then came up setting up of blog and creation of site which was quite a … Read entire article »

Filed under: Random

UNKNOWN State Of RAC Resources

August 27th, 2008 | Add a Comment

While Checking the status of database resources, ASM was shown as UNKNOWN on one node of a two node RAC. $ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.orcl.db application ONLINE ONLINE rac1 ora....11.inst application ONLINE ONLINE rac1 ora....SM1.asm application ONLINE ONLINE rac1 ora....DC.lsnr application ONLINE ONLINE rac1 ora....idc.gsd application ONLINE ONLINE rac1 ora....idc.ons application ONLINE … Read entire article »

Filed under: oracle, rac

Using RDA As RDBMS Pre-Install Check Tool

August 27th, 2008 | Add a Comment

Many of us would have come across RDA (Remote Diagnostic Agent) while working on a ticket with Oracle support. In case you have not heard about it, I would recommend to go through Metalink Note:314422.1 – Remote Diagnostic Agent (RDA) 4 – Getting Started RDA captures System Information such as OS,Hardware Details (like number of CPU and amount of RAM),OS error log,OS Monitoring tool output (like vmstat,TOP,etc). This can be handy in case you do not know the command or the location of the OS logs.Similary you can find Database version,Database Patch inventory,Database Alert log and trace files. This can help save lot of time as you need not remember all OS commands to capture the information. Similarly RDA also collects Database Performance Statistics like OS Statistics (CPU,Memory and Disk I/O Stats) … Read entire article »

Filed under: database, oracle

Checking Database Feature Usage Stats

August 25th, 2008 | 5 Comments

Today I came across view DBA_FEATURE_USAGE_STATISTICS (10g) which let’s us know whether particular Database Feature has been used till now or not. If yes, then it also let’s us know when it was used for the first time and also the last usage time. This can be helpful to check if anyone is using Database feature which is not licensed . I have used filter DETECTED_USAGES >0 for checking the features which has been used in this Database. SQL> SELECT NAME,DETECTED_USAGES AS "USAGE",CURRENTLY_USED,FIRST_USAGE_DATE,LAST_USAGE_DATE 2 FROM DBA_FEATURE_USAGE_STATISTICS WHERE DETECTED_USAGES >0 order by 1; NAME … Read entire article »

Filed under: database, oracle

Upgrading Oracle RAC Database -10g

August 19th, 2008 | 3 Comments

Upgrading Oracle RAC Database -10g

Continuing my experiments with our 2 Node 10g RAC Test system, I carried out upgrade of Oracle Clusterware and Oracle RAC Database from 10.2.0.1 to 10.2.0.4. I have tried to document the steps for upgrading Oracle Clusterware(Rolling Upgrade) and RAC Database upgrade in this post. In case you observe any mistakes, please let me know First step is to download the 10.2.0.4 Patchset from metalink. In our case ,we downloaded Patch 6810189 (10g Release 2 … Read entire article »

Filed under: oracle, rac

Verification of CRS Integrity Was Unsuccessful

August 19th, 2008 | 4 Comments

While going through the routine checks from Grid Control, I found a critical alert stating “clusterware integrity check failed” and by clicking on this message it says that there is problem with some metric collections on RAC environment. To check the node reachability status following query was run: $ $CRS_HOME/bin/cluvfy comp nodecon -n all This will check the internode connectivity for all nodes in the cluster. It came out with following message: $ $CRS_HOME/bin/cluvfy comp nodecon -n all Verifying node connectivity Verification of node connectivity was unsuccessful on all the nodes. Even the CRS component check was unsuccessful: $ $CRS_HOME/bin/cluvfy comp crs -n all It came out with the following message: $ $CRS_HOME/bin/cluvfy comp crs -n all Verifying CRS integrity Verification of CRS integrity was unsuccessful on all the nodes. After this it was quite obvious to check the CRS status: $ crsctl check … Read entire article »

Filed under: oracle, rac

Next Page »