Posts Tagged ‘oracle’
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]
Enabling Flashback On RAC Database
Enabling Flashback /Archive Log mode on a Single Instance Database is quite straight forward. In case of RAC, you need to follow additional steps. The requirements for enabling Flashback Database are: Your database must be running in ARCHIVELOG mode, because archived logs [Read More]
11g New Feature: Database Replay
Database Replay: In critical production systems, before making changes to the environment( Hardware or software related), lots of testing is required in test systems to know the effect of those changes and this usually takes lots of time to test for the stability and [Read More]
10.2.0.4 Window’s Patchset overwrites Sqlnet.ora
Not sure, how many of you are aware of this alert. Oracle has published an Alert document NOTE:726418.1 -ALERT: The 10.2.0.4 Windows Patchset Overwrites %ORACLE_HOME%\network\admin\sqlnet.ora According to it, Patch 6810189 – 10.2.0.4 RDBMS patchset on Microsoft [Read More]
Simplified Approach to Resolve ORA-4031
After writing few Case studies and other related articles, I will be sharing my approach for Resolving ORA -4031 error. First we will see what ORA-4031 actually means. 04031, 00000, "unable to allocate %s bytes of shared memory [Read More]
Oracle Database 11G Installation on Solaris 10
I had installed Oracle Database 11g on Solaris 10 few days back. I thought of documenting the steps for easy reference. Please find below steps for the same Installation Pre-Requisite Refer to Oracle Database Installation Guide 11g Release 1 (11.1) for Solaris Operating [Read More]
Effect of OS Terminal Setting “STTY” on Oracle Database
Few days back, while trying to create a synonym over dblink I experienced following error: SQL> create synonym synonymn_name for dual@DBLINK9i; SP2-0042: unknown command "DBLINK9i" - rest of line ignored Strange error !!! Also while trying to perform a simple [Read More]
Automatic Storage Management (ASM) FAQ
We have tried to consolidate list of Frequently Asked Questions (FAQ) on ASM. Please feel free to ask any other question or contribute to this FAQ by using comment section Frequently Asked Question on ASM 1) What is ASM? Automatic storage Management (ASM) is a new type of [Read More]
High Database Sessions
Yesterday I was working on issue where our Monitoring system reported increased number of database connections. We were already aware of this issue and application team was asked to look into it. On checking GV$RESOURCE_LIMIT, we found that it had touched the limit value on [Read More]
ORA-01426 After Upgrade to 10g
Oracle seems to have a tendency to make small changes to database code which impacts application in a big way. Sad part is, these changes are not always documented properly. One of these cases is what I encountered. A simple PL/SQL code errors out as below: Oracle Database [Read More]
