Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

About

Guenadi Jilevski is a Senior Oracle Professional (OCP 7, 8, 8i, 9i, 10g, 11g, 12c  OCE 10gR2 RAC, OCE  Oracle RAC 11gR2 and Grid Infrastructure Administrator, Oracle Exadata 11g Certified Implementation Specialist,Oracle GoldenGate 10g/11g Certified Implementation Specialist and OCM 9i, OCM 11g) with more than 20 years of industrial experience in high end Oracle technology starting with Oracle RDBMS version 6 up to 11g. He has been involved with multi platform High Availability Solutions starting with OPS and Veritas and Sun cluster as well as complex multiple node RAC 9i, 10g  and 11g implementations on AIX, Linux, Solaris and HP. He has experience in deploying disaster recovery solutions with standby databases compliant to Oracle MAA and third party solutions such as Shareplex and Goldengate. As a former employee of Oracle Corporation Advanced Technology Solutions Consulting Practice in Americas, Guenadi has been involved in multiple visible high end projects for RAC enabling EBS, Peoplesoft, Siebel ERP applications, end to end performance tuning, architectured High Availability and Disaster Recovery solutions to name a few. Presently he is working as A Senior Oracle Consultant in EMEA.

Guenadi Jilevski is Oracle OCP 7, 8, 8i, 9i, 10g, 11g, 12c OCE  10gR2 RAC, OCE  Oracle RAC 11gR2 and Grid Infrastructure Administrator, Oracle Exadata 11g Certified Implementation Specialist,Oracle GoldenGate 10g/11g Certified Implementation Specialist and Oracle OCM9i , OCM 11g, Teradata Certified DBA, Informix Certified DBA.

The views expressed on this blog are my own and do not necessarily reflect the views of  Current/Past/Future Employers. The views and opinions expressed by visitors on this blog are theirs solely and may not reflect mine.

21 Comments »

  1. dear brother, I am tring to configure golden gate for mysql 5.5.9 to oracle 11g release 2.
    can you give me guidance in this regard.
    I can start manager, extract & replicat without any error but unable to see any record on target table. I am placing extract log here

    2011-03-11 18:57:52 WARNING OGG-01008 Discarding bad record (discard recs = 1).

    ***********************************************************************
    * ** Run Time Statistics ** *
    ***********************************************************************

    Report at 2011-03-11 18:57:52 (activity since 2011-03-11 18:57:47)

    Output to riniprim:

    No records extracted.

    Records discarded: 10

    ——————–

    can you guide me where I am going wrong.

    Comment by Irfan Rasheed | March 15, 2011 | Reply

    • Hello,

      Is it an extract from MySQl or Oracle? Describe in greater detail what is the problem and what do you want to achieve. Make sure that you meet the prerequsites.

      Regards,

      Comment by gjilevski | March 22, 2011 | Reply

  2. Nice post I was checking constantly this blog and I’m impressed! Very useful info specifically the last part I care for such info a lot I was looking for this certain information for a long time Thank you and good luck

    Comment by cisco 1841, cisco 1841 router, cisco1841 router, cisco 1841 price, cisco1841 price, cisco switches | September 21, 2011 | Reply

  3. I am curious about your 11.2.0.1 –> 11.2.0.3 RAC upgrade on Linux. You did not mention where you got ASMlib .. as far as I can tell, there is no ASMLib for OEL 61 .. which means your guide is bogus in the part where you show you are marking ASM disks .. you typed that part versus showing us a screen shot .. please explain .. BTW, I am impressed with the overall quality of the guide except for this glaring error. Please advise.

    Comment by MIKE HOLLAND | April 16, 2012 | Reply

    • Hi,

      I am using OEL 6.0 and 6.1 for some my articles and ASMlib DOES come with the media in OEL 6.0 and OEL 6.1. So I reuse the old ASMlib knowledge that are still valid and applicable for OEL 6.X.

      There is ASMlib for OEL 6.X, look for the rpm that install it.

      Regards,

      Comment by gjilevski | April 16, 2012 | Reply

    • Hi,

      There is nothing bogus. See for yourself.

      [root@oel61 ~]# rpm -qa | grep asm
      ………………………………….
      oracleasm-support-2.1.5-1.el6.x86_64
      ………………………………….
      [root@oel61 ~]#
      [root@oel61 dev]# oracleasm
      Usage: oracleasm [–exec-path=] [ ]
      oracleasm –exec-path
      oracleasm -h
      oracleasm -V

      The basic oracleasm commands are:
      configure Configure the Oracle Linux ASMLib driver
      init Load and initialize the ASMLib driver
      exit Stop the ASMLib driver
      scandisks Scan the system for Oracle ASMLib disks
      status Display the status of the Oracle ASMLib driver
      listdisks List known Oracle ASMLib disks
      querydisk Determine if a disk belongs to Oracle ASMlib
      createdisk Allocate a device for Oracle ASMLib use
      deletedisk Return a device to the operating system
      renamedisk Change the label of an Oracle ASMlib disk
      update-driver Download the latest ASMLib driver
      [root@oel61 dev]# uname -a
      Linux oel61.gj.com 2.6.32-100.34.1.el6uek.x86_64 #1 SMP Wed May 25 17:46:45 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
      [root@oel61 dev]#

      SQL> select path from V$asm_disk;

      PATH
      ——————————————————————————–
      /dev/oracleasm/disks/DISK5
      /dev/oracleasm/disks/DISK4
      /dev/oracleasm/disks/DISK3
      /dev/oracleasm/disks/DISK2
      /dev/oracleasm/disks/DISK1

      SQL> exit
      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
      With the Real Application Clusters and Automatic Storage Management options
      [grid@oel61a ~]$ uname -a
      Linux oel61a.gj.com 2.6.32-100.34.1.el6uek.x86_64 #1 SMP Wed May 25 17:46:45 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
      [grid@oel61a ~]$ oracleasm listdisks
      DISK1
      DISK2
      DISK3
      DISK4
      DISK5
      [grid@oel61a ~]$

      Comment by gjilevski | April 16, 2012 | Reply

      • Hi,
        Thanks for your rapid reply. Everything in your response makes perfect sense. However, where did you get the kernel-specific portion of the 3 components of ASMlib. When I issue
        root@oel61a Packages]# /usr/sbin/oracleasm scandisks
        Reloading disk partitions: done
        Cleaning any stale ASM disks…
        Scanning system for ASM disks…
        [root@oel61a Packages]# /usr/sbin/oracleasm createdisk DISK1 /dev/sdb1
        Writing disk header: done
        Instantiating disk: failed
        Clearing disk header: done
        This is due to my not having the kernel-specific part ..I am running the same version of OEL61 as your guide .. in fact, I have been very successful in the execution of your clearly written steps; however, I cannot continue until I can stamp the 5 disks as ASM .. what am I missing?
        Thanks for your help.
        Mike

        Comment by Mike Holland | April 17, 2012

      • Hi,

        ASMlib is there it is a permission issue due to the SELINUX. I remember disabling SELINUX. Set the SELINUX=disabled and reboot the servers.

        vi /etc/sysconfig/selinux
        SELINUX=disabled

        Regards,

        Comment by gjilevski | April 17, 2012

  4. You got the missing part 🙂 I now have 5 ASM disks .. I might suggest that you put that step in your guide about disabling SELINUX .. I look forward to continue the setup with your excellent guide. Thanks for your continued assistance. BTW, are you from Sofia? I have a co-worker who is from Sofia 🙂

    Comment by Mike Holland | April 18, 2012 | Reply

    • Hi,

      Which article are you referring to that needs an update? Usually SELINUX is disabled for all my RAC installations as Oracle RAC used to be incompatible with SELINUX. Specify the URL so that I change it accordingly.

      Small world huh? No I am not.

      Regards,

      Comment by gjilevski | April 18, 2012 | Reply

      • I am working with ‘Build two node Oracle RAC 11gR2 11.2.0.3 with GNS .. the default install of OEL61 has SELINUX enforced by default. If you mention to disable it during the OS install, then there will not be an issue with creating the ASM disks .. it was from October 05 2011. BTW again, I only mentioned Sofia as your install screen in this guide showed Sofia as the time zone .. no big deal 🙂

        Comment by Mike Holland | April 19, 2012

      • Hi,

        Thank you for pointing it out.

        Added a Revision 1.0 : 19th April 2012 : DISABLE SELINUX in order to successfully create ASM disks using ASMlib

        https://gjilevski.wordpress.com/2011/10/05/build-two-node-oracle-rac-11gr2-11-2-0-3-with-gns-dns-dhcp-and-haip/

        Regards,

        Comment by gjilevski | April 19, 2012

  5. Hi,
    Love your website. Will you be posting example of VM Server 3x and Oracle VM Manager 3x installation either in Virtual Box or on actual Linux?

    Comment by steve | May 1, 2012 | Reply

    • Hi,

      Good idea.I will take some spare time to really test it and post the documented steps for installation.

      Regards,

      Comment by gjilevski | May 2, 2012 | Reply

    • Hi,

      Seems that you cannot run Oracle VM Server 3.0.X under VirtualBox, although you can install it. Oracle VM Server 3.0.3 relies on dmidecode for some hardware detection capabilities and this is not exposed to VirtualBox guests. Thus, discovery from VM Manager fails. VM Server 3.1.1 is supposed to drop the dmidecode requirement (Not released yet).

      https://forums.oracle.com/forums/thread.jspa?messageID=9829935

      Regards,

      Comment by gjilevski | May 5, 2012 | Reply

  6. Hi,

    iam installing 12c on my local machine .iam getting below error.

    IO error: the network adapter could not establish the connection. can any one plz help me with this.

    deepthi

    Comment by deepthi | February 6, 2013 | Reply

    • Hi,

      Please provide more details about what are you trying to accomplish.

      Best Regards,

      Comment by gjilevski | February 6, 2013 | Reply

  7. i want to install 12c on my local machine. my listener is not communicating with the database .tns error-01190 the user is not authorized to execute the requested listener command

    Comment by deepthi | February 6, 2013 | Reply

  8. Dear all,

    Does any body try to install oracle 10.2.0.1 64 bit RAC clusterware in OLE5 Update 8 using vmware workstation 9 and then update to it to 10.2.0.5 clusterware.

    I had installed 10.2.0.1 clusterware successfully. When I upgraded it to 10.2.0.5, the both nodes kept rebound suddenly.

    Does any body know why?

    Comment by Eldon | March 22, 2013 | Reply

  9. […] About […]

    Pingback by RAC Performance Tuning | amkiv | December 23, 2013 | Reply

  10. Hi,

    Thanks for posting the detailed steps for RAC to RAC Data Guard setup. It is very nice article. In your DG setup you temporarily set cluster_database=FALSE during the clone with RMAN, I am wondering what is the benefit of this or because there was issue with duplicate from RAC to RAC.

    Best

    Comment by lisa lni | March 30, 2016 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: