>  Operating System
>  VMWARE
>  Installations - Apps11i
>  R12 Topics
>  Installations - Apps R12
>  Patching
>  Cloning
>  Oracle Apps Upgrades
>  System Administration - R11/R12
>  Advance Features - Oracle Apps R12
>  Want to Become an Apps DBA ?
>  Certification - Apps DBA
>  Apps Performance
>  Oracle Apps DBA Interview Questions
>  Apps Day to Day Queries

Home

Username

Password

Remember Me







Installation
RMAN - Backup & Recovery
Replication
Convert DB Character Set
DATAPUMP
Recoveries
Oracle 11g Topics
Oracle 11g DBA course

   Installation

Install Oracle 11g RAC (Rel 2) using Oracle VM

1. Installation of Oracle 11g R2 RAC using Oracle VM


Install Oracle 11g RAC (Rel 2) using Open Filer

1. Installation of open filer 2.3 - Storage Device
2. Prepare Steps
3. Install Grid Infrastructure
4. Install 11g R2 Database
5. Duplicate RAC Database - ASM - Non ASM

Patches

6. Installation of Patch 16989137 on 2 Node RAC (Minimum Downtime Opatch)

Add Node

7. Add Node in RAC Environment

8. Single Instance to RAC Conversion



Install Oracle 10g RAC (Rel 2) on VMWARE

1. VMWARE Installation
2. Configure First Virtual Machine - RAC1
3. Install Linux (OEL4 update) on First Virtual Machine - RAC1
4. Create and Configure the Second Virtual Machine - RAC2
5. Configure Oracle Automatice Storage Management - RAC1 & RAC2
6. Configure Oracle Cluster File System (OCFS2) - RAC1 & RAC2
7. Install Oracle Clusterware
8. Install Oracle Database 10g Release 2
9. Install Grid Control 10g
10. Apply CPU Patch - Rolling Upgrade

Install Oracle 11g RAC (Rel 1) on VMWARE

Follow steps 1 to 6 from above links, RAM required is 1.5 GB per node

7. Install Oracle 11g Clusterware
8. Install Oracle Database 11g Release 1

Created on 10/31/2008 02:33 AM by akr14feb
Updated on 01/31/2011 11:26 AM by akr14feb
 Printable Version

The comments are owned by the poster. We are not responsible for its content.
No Subject
Posted on: 2009-09-18 21:40:04   By: Anonymous
 
your comments are appreciated


    Re:
    Posted on: 2009-11-03 17:04:26   By: Anonymous
     
    Dear Sir,
    i really like your site i am 9i, 10g, 10g managing on Liunx, 11i(first peron in pakistan who passed exam), R12 (first person in Saudia who passed paper) and Linux certified. now i am installing Rac and grid on liux

    i like your site it nice and easy to manage

    my work e-mail is waseem-it@almutlaq.com, personal mwchaudhry@yahoo, hotmail, gmail.com

    thanks

    best regards

    Muhammad Waseem Chaudhry


    Re:
    Posted on: 2010-04-10 11:47:42   By: Anonymous
     
    Dear Sir,

    It was an beautiful document u uploaded. I am working according to this document only. I got stuck at one stage and for that i need your help. I am configuring the ASM, i configured accordingly on the first RAC node, but when i am doing on the another RAC node i.e after running "scandisks", i was not able to get those VOL on second node. Can you please help me for this one. my email address : sheth.dhaval@gmail.com

    Thanks & Regards,

    Dhaval


      Re:
      Posted on: 2010-06-03 07:33:56   By: akr14feb
       
      Let me know if the problem still exists, shoot a mail to me @akr14feb@gmail.com

      Kishore


Create Service in 11g - RAC
Posted on: 2010-05-18 14:39:17   By: akr14feb
 
http://surachartopun.com/2009/04/dbca-11g-rac-no-service-management.html


TAF and Load balancing links
Posted on: 2010-06-03 07:32:54   By: akr14feb
 
http://www.dba-oracle.com/art_oramag_rac_taf.htm
http://www.dbasupport.com/oracle/ora10g/LBA02.shtml



Oracle HAS startup failed, After stop syslogd
Posted on: 2010-08-10 16:07:05   By: akr14feb
 
http://surachartopun.com/2010/01/oracle-has-startup-failed-after-stop.html


Setup SCAN Listener and Client
Posted on: 2010-10-13 19:47:27   By: akr14feb
 
How to Setup SCAN Listener and Client for TAF and Load Balancing [Video] (Doc ID 1188736.1)


11gR2 link
Posted on: 2010-10-20 06:12:13   By: akr14feb
 
http://www.emilianofusaglia.net/restore_ocr_vot_13.html


11GR2 GRID INFRASTRUCTURE INSTALLATION FAILS WHEN RUNNING ROOT.SH ON NODE 2 OF RAC (Doc ID 1059847.1)
Posted on: 2010-12-18 20:24:40   By: akr14feb
 
http://zhefeng.wordpress.com/category/1-oracle/rac/

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

While installing Oracle Grid Infrastructure with ASM, root.sh ran successfully in first node,
but fails on the second node.

Error example

1. root.sh failed on second node with following errors
-------------------------------------------------------
DiskGroup DATA1 creation failed with the following message:
ORA-15018: diskgroup cannot be created
ORA-15072: command requires at least 1 regular failure groups, discovered only 0


Configuration of ASM failed, see logs for details


2. rootcrs_nodename.log
-----------------------
2010-02-03 13:40:43: Configuring ASM via ASMCA
2010-02-03 13:40:43: Executing as oracle: /u01/app/1120/grid/bin/asmca -silent -diskGroupName DATA1 -diskList ORCL:DATA1 -redundancy EXTERNAL -configureLocalASM
2010-02-03 13:40:43: Running as user oracle: /u01/app/1120/grid/bin/asmca -silent -diskGroupName DATA1 -diskList ORCL:DATA1 -redundancy EXTERNAL -configureLocalASM
2010-02-03 13:40:43: Invoking "/u01/app/1120/grid/bin/asmca -silent -diskGroupName DATA1 -diskList ORCL:DATA1 -redundancy EXTERNAL -configureLocalASM" as user "oracle"
2010-02-03 13:40:51: Configuration of ASM failed, see logs for details

3. On the 2nd node
/etc/oratab files shows +ASM1, rather than +ASM2

4. The following commands on the 2nd node show the ASM disk information correctly
/etc/init.d/oracleasm listdisks
/etc/init.d/oracleasm scandisks
ls -ltr /dev/oracleasm/disks



Cause

After configuring multipath disks on Linux x86-64, proper parameters have not been configured in /etc/sysconfig/oracleasm


Solution

On all nodes,

1. Modify the /etc/sysconfig/oracleasm with:

ORACLEASM_SCANORDER="dm"
ORACLEASM_SCANEXCLUDE="sd"

2. restart the asmlib by :

# /etc/init.d/oracleasm restart

3. Run root.sh on the 2nd node



rac 11gr2
Posted on: 2010-12-28 20:27:00   By: akr14feb
 
http://learnwithme11g.wordpress.com/category/11gr2-rac/


    Re: rac 11gr2
    Posted on: 2010-12-28 20:54:52   By: akr14feb
     
    http://blogs.oracle.com/XPSONHA/2009/09/11gr2_grid_infrastructure_inst.html


NTP
Posted on: 2011-05-30 08:31:48   By: akr14feb
 
http://forums.theplanet.com/lofiversion/index.php/t39853.html

HOWTO: use NTP to keep your system clock accurate to one thousandth of a second
The Planet Forums > System Administration > HOWTOs
EdgewizeJan 15 2004, 11:03 PM
There is a wonderful net standard called NTP that can synchronize system clocks. You may already have followed someone's advice and used 'ntpdate' or 'rdate' to set the time on your server. But NTP is really designed to keep a large network of clocks perfectly synchronized. Not just accurate to the second, but to the millisecond! Here's how to set it up.


Note: you may need to open incoming UDP port 123 on your firewall for NTP to work properly. You should restrict this port to the IP addresses that you are using as time servers. I personally recommend using a state-monitoring firewall which would only open the port in response to an outgoing NTP time requests, but that is beyond the scope of this HOWTO. (If you have an iptables entry to allow state=RELATED, that will be enough.)

To properly use NTP, you need to have the full set of NTP tools. You may already have them installed; you can check by running the following as root:

rpm -q ntp

If it says it is not installed, then you need to download and install the appropriate RPMs. Head over to http://www.rpmfind.net/linux/rpm2html/sear...h.php?query=ntp and find the right package for your operating system. (Red Hat 7.x is about halfway down the page, in green.) Download the RPM, and install it as root:

rpm -ivh ntp-*.rpm

Now, you have to configure it. I've done all the hard work and found some reliable servers with open access policies ... all you have to do is copy my files!

You need to edit your /etc/ntp.conf file and REPLACE the contents with the following:
CODErestrict default nomodify notrap noquery

restrict 127.0.0.1

server now.okstate.edu

server clock.nyc.he.net

server clock.via.net

server ntp-2.vt.edu

server 127.127.1.0 # local clock

fudge 127.127.1.0 stratum 10

driftfile /etc/ntp/drift

Also edit your /etc/ntp/step-tickers file and REPLACE the contents with:
CODEnow.okstate.edu

clock.nyc.he.net

clock.via.net

ntp-2.vt.edu

Now run the following:

/sbin/chkconfig --level 345 ntpd on
/sbin/service ntpd restart


And you're all done! The ntpd program is running in the background, accurately keeping time down to the millisecond, with absolutely no drift. Your clock will always be accurate!

BTW, If you ever get curious and want to see exactly what is happening, you can run the following command as root:

ntpq -p localhost


Datagaurd with RAC
Posted on: 2011-05-30 08:32:20   By: akr14feb
 
http://wiki.oracle.com/page/11gR2+RAC+on+a+Mac+-+Part+20


    RAC queries
    Posted on: 2011-09-22 08:36:43   By: akr14feb
     
    http://www.shutdownabort.com/dbaqueries/Administration_RAC_10gR2.php


No Subject
Posted on: 2011-12-12 15:57:49   By: ramprasad
 
very nice blog and i got more information from ur site R12,11i & RAC


11.2.0.1 to 11.2.0.2 upgrade
Posted on: 2011-12-31 10:41:47   By: akr14feb
 
http://hemracedition.blogspot.com/2011_03_01_archive.html


root.sh failing on second node with "ora.asm -init" failed
Posted on: 2012-07-22 19:28:53   By: akr14feb
 
https://forums.oracle.com/forums/thread.jspa?threadID=2387790
http://apunhiran.blogspot.in/2010/09/oracle-11gr2-grid-rootsh-fails-on-node2.html
get to this point I am already having to do:

ls -la /tmp/.oracle/ /var/tmp/.oracle/ /usr/tmp/.oracle/ in another terminal and as soon as I see files turn up I am doing
/bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1 because of the issue (Inappropriate ioctl) shown at https://forums.oracle.com/forums/thread.jspa?messageID=9579932




rconfig error with system09.dbf
Posted on: 2012-07-23 06:36:09   By: akr14feb
 
ORA-19566: exceeded limit of 0 corrupt blocks for file /d01/oracle/RACERP/db/apps_st/data/system09.dbf


http://www.dbatutor.com/2011/09/blocks-corrupted-in-system09dbf-after.html
alter database datafile '/d01/oracle/RACERP/db/apps_st/data/system09.dbf' resize 1000M;


Oracle11gR2 RAC: Adding Database Nodes to an Existing Cluster
Posted on: 2012-11-16 20:16:34   By: akr14feb
 
http://cgswong.blogspot.in/2010/12/oracle11gr2-rac-adding-database-nodes.html




o2cb_ctl: Configuration error discovered while populating cluster ocfs2. None of its nodes were considered local. A no
Posted on: 2014-01-30 17:16:26   By: akr14feb
 
http://www.oracledba.org/11g/rac/11g_RAC_Add_Node.html