Archive for August, 2008
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. [Read More]
UNKNOWN State Of RAC Resources
While Checking the status of database resources, ASM was shown as UNKNOWN on one node of a two node RAC. $ crs_stat -t <span style="font-family: arial,helvetica,sans-serif;">Name Type Target State Host [Read More]
Using RDA As RDBMS Pre-Install Check Tool
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 [Read More]
Checking Database Feature Usage Stats
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 [Read More]
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 [Read More]
Verification of CRS Integrity Was Unsuccessful
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 [Read More]
10g RAC – Single Node Install Error
Last week we were trying to setup a 2 Node 10g RAC System on Linux with openfiler used for shared storage. We were using the article written by Jeffery Hunter. This was not the first time I was doing it, but by mistake we chose the machine with 500Mb memory to be used for [Read More]
Raw Devices to be deprecated in 12G
I was browsing through the OraNA.info posts and found an interesting post from Steve Karam which referred to a metalink Note:578455.1 – Announcement of De-Support of RAW devices in Release 12G If you go through the note, it mentions desupport of Raw devices from [Read More]