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

    Oracle Restart – new in 11g R2

    Similar to the clusterware processes in a RAC environment, in 11g R2 even for a standalone instance, functionality is now available to automatically restart components like the database, listener, ASM diskgroup, service etc in the event of their failure.

    This feature is called Oracle Restart and it runs out of the Grid Infrastructure home which is separate from the database home.

    Oracle Restart is managed by CRSCTL utility and it uses Oracle High Availability Services to start and stop the components managed by Oracle Restart.

    Using Oracle Restart, we can stop or start all the components running out of a single Oracle Home with a single srvctl command as well as Oracle Restart will automatically start all components on machine reboot in the proper order taking into account dependencies like ASM instance and the managed database instances. So no more do we have to use the dbstart and dbstop scripts to manage this.

    Oracle

    Continue reading Oracle Restart – new in 11g R2

    October 29th, 2009 | Tags: , , , | Category: Administration, High Availability, Oracle 11g release 2 | 5 comments

    11g Release 2 Grid Infrastructure Installation

    Let us have a look at the installation screenshots of 11g Release 2 on a Red Hat Linux platform. Currently the 11g R2 software has only been released for the Linux platform with release dates for other platforms like Solaris and AIX set for sometime end October to mid November.

    There are quite a few new installation options available as can be seen from the screenshots below. What we are installing below is “Grid Infrastructure for a stand alone server”.

    In 11g R2, ASM is now part of what is called the Grid Infrastructure (nothing to do with Grid Control). It is no longer an option available in dbca and there is a command line option asmca which is launched from the Grid Infrastructure home. The ASM instance will be running from the Grid Home and not the database Oracle Home.

    Further, the Grid Infrastructure can be installed for a stand alone server

    Continue reading 11g Release 2 Grid Infrastructure Installation

    October 23rd, 2009 | Tags: , , | Category: Administration, Oracle 11g, Oracle 11g release 2 | Leave a comment

    11g Release 2 ACFS (Automatic Storage Management Cluster File System)

    The following are some of the new ASM related features introduced in 11g R2:

    In Oracle 11g Release 2, ASM and the Oracle Clusterware are now installed in a common home called the Grid Infrastructure Home.
    The clusterware files like the Voting Disk and the Cluster Registry can no longer be installed on raw devices. They can now be installed on ASM Disk Groups
    Need to connect as SYSASM to perform any administrative operations on the ASM instance or we will get an ORA-01031 error as shown below

    [oracle@redhat346 stage]$ sqlplus sys/xxx as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 16 09:10:55 2009

    Copyright (c) 1982, 2009, Oracle. All rights reserved.

    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
    With the Automatic Storage Management option

    SQL> shutdown immediate;
    ORA-01031: insufficient privileges

    ACFS or Automatic Storage Management Cluster File System is an extension of the ASM technology to support storage of files like Oracle binaries

    Continue reading 11g Release 2 ACFS (Automatic Storage Management Cluster File System)

    October 16th, 2009 | Tags: , , , | Category: Administration, Oracle 11g, Oracle 11g release 2 | 4 comments

    Cross Platform Transportable Tablespace using ASM with Oracle XML DB

    In one of my earlier posts How To Transport a Tablespace from 10g ASM to 11g ASM on AIX we discussed how to transport a tablespace stored on ASM storage from Windows to AIX using the DBMS_FILE_TRANSFER package.

    We will now look at how the same thing can be done using FTP with Oracle XML DB Repository and its virtual folders.

    All we need to do is to run the following script and provide the port numbers which will be used for the FTP and HTTP protocols for accessing the repository.

    @?/rdbms/admin/catxdbdbca 8080 7787

    In this case we have assigned the port 8080 for the FTP protocol and the port 7787 is for HTTP access.

    The ASM related directories on the Windows Oracle database are accessed via the sys/asm virtual folder and then we use FTP to copy the ASM files over the network and then use RMAN to convert it to AIX 64 bit

    Continue reading Cross Platform Transportable Tablespace using ASM with Oracle XML DB

    October 14th, 2009 | Tags: | Category: Administration | Leave a comment