That’s Me

Gavin Soorma
  • Oracle Certified Professional
    • 7.3, 8i, 9i,10g, 11g
  • 11i Apps DBA OCP
    •
  • 10g RAC OCE
    •
  • Certified GoldenGate Implementation Specialist
    •
  • 10g OCM
    •
  • 11g OCM
    •

    Feedback

    1,650,000 hits

    Thanks A MILLION for your support!

    Please send me your valuable feedback and suggestions

    Building a test 11gR2 RAC environment in minutes using Oracle Virtual Machine templates

    This note illustrates how we can set up an Orace 11g Release 2 Real Application Clusters environment for test purposes using the Oracle VM templates which are currently available in under 30 minutes!

    The templates are available from the Oracle E-Delivery web site and are available in both OEL 32bit Linux as well as 64bit Linux.

    While we are demonstrating a test or development RAC setup where a single Oracle VM server is hosting both the guest nodes, a ‘Production’ type envrionment is also supported using the Oracle VM Templates where we have multiple OVM Servers and the shared disks are configured as ‘phy’ devices which are then passed on to the guest Oracle VM’s. So there are a number of Oracle VM Servers in this case.

    In this test environment, however, the shared disk is configured as ‘file’ devices and both guests can run on the same Oracle VM Server.

    In other words

    Continue reading Building a test 11gR2 RAC environment in minutes using Oracle Virtual Machine templates

    November 30th, 2011 | Tags: | Category: Administration, Oracle 11g release 2, Real Application Clusters | Leave a comment

    Oracle 11g Fusion Middleware Installation on Linux

    This note describes the (long) process of installing an 11g Fusion Middleware environment with Forms, Reports, Discoverer and Portal on an Oracle Enterprise Linux 5.6 64 Bit platform.

    If you are not using Oracle Portal , then you do not need to configure Identity Management and Single Sign On which is a real big pain as there is no 11g SSO as yet and we have to install, upgrade and configure 10g SSO/DAS as well with a number of patches.

    These are the top level steps:

    Install Java SE Development Kit 6u25

    Install Oracle Weblogic Server 11g Release 1 ( 10.3.2)

    Install Oracle 11g R2 Database software (can be on same machine as Middleware or different server)

    Create the 11g R2 repository database

    Download the Repository creation for Windows available in 32 bit for Linux and Windows ( ofm_rcu_win32_11.1.1.3.3_disk1_1of1.zip) – change compatibility for Windows 7 to run it

    Make changes to the database required for running

    Continue reading Oracle 11g Fusion Middleware Installation on Linux

    November 25th, 2011 | Tags: , , , , , | Category: 10g Application Server, 11g Fusion Middleware | Leave a comment

    OEM Tablespace Space Used % Alerts and the AUTOEXTEND effect

    I performed a simple test to try and help clarify a rather confusing topic about when OEM will send out alerts for tablespace usage and what happens when autoextend is turned on and what about the MAXSIZE and UNLIMITED parameters of the AUTOEXTEND ON clause.

    A number of Metalink support notes discuss this topic like:

    Database Tablespace Full Metric Alerts not Generated In Grid Control [ID 357049.1]
    Troubleshooting a Database Tablespace Used(%) Alert problem [ID 403264.1]
    Oracle Recommended Patches For Tablespace Monitoring using the Tablespace Space Used % metric [ID 849498.1]

    What happens if autoextend is turned on but in some cases we have specified an upper limit for the MAXSIZE parameter or have just left it to UNLIMITED? How will OEM handle those cases?

    To clarify things, OEM alert notification mechanism will query the DBA_TABLESPACE_USAGE_METRICS view to determine the Used % in a tablespace in relation to the Warning and Critical thresholds which have been

    Continue reading OEM Tablespace Space Used % Alerts and the AUTOEXTEND effect

    November 16th, 2011 | Tags: , , , , , | Category: Administration, EM Grid Control | Leave a comment

    Oracle 11g Cross platform Active Standby - Windows Primary database and Linux Active Standby

    This note describes the procedure of configuring a cross platform using the 11g RMAN Active Duplicate as well as an Active Standby Database setup over a Windows and Linux platform.

    The Metalink note Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1] describes the supported cross platform combinations between a primary and standby database.

    In Oracle 10g, we could have a 32 bit and 64 bit Primary/Standby combination on some supported platforms and in 11g this has been extended to cover heterogenous platforms for the Primary and Standby database.

    The environment used is as follows:

    Primary

    Windows 7 64 bit
    11g Release 2
    DB_UNIQUE_NAME=orcl

    Active Standby

    Oracle Enterprise Linux 5.7 64 bit
    11g Release 2
    DB_UNIUE_NAME=orcl_dr

    Read the rest of the note Oracle 11g Cross platform Active Standby – Windows Primary database and Linux Active Standby

    November 8th, 2011 | Category: Backup and Recovery, High Availability, Oracle 11g release 2 | Leave a comment