Archive for July, 2008
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]
11G:SYSASM role
Starting from Oracle 11g ASM, new privilege has been created for Administering Oracle ASM instances. This is called SYSASM role. You can continue using SYSDBA role to connect to ASM but it will generate following warning messages at time of startup/shutdown, create [Read More]
