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.
21 Comments »
Leave a Reply to Irfan Rasheed Cancel reply
-
Archives
- February 2017 (1)
- November 2016 (1)
- October 2016 (1)
- May 2016 (2)
- March 2016 (3)
- December 2014 (2)
- July 2014 (1)
- June 2014 (6)
- May 2014 (5)
- February 2014 (1)
- December 2012 (2)
- November 2012 (8)
-
Categories
-
RSS
Entries RSS
Comments RSS
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.
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,
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
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.
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,
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 ~]$
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
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,
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 🙂
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,
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 🙂
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,
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?
Hi,
Good idea.I will take some spare time to really test it and post the documented steps for installation.
Regards,
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,
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
Hi,
Please provide more details about what are you trying to accomplish.
Best Regards,
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
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?
[…] About […]
Pingback by RAC Performance Tuning | amkiv | December 23, 2013 |
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