In the "Root script execution configuration" select "Automatically run configuration scripts" and check "Use root option", then type password oracle. Press "Next".
The results of prerequisite checks are shown on the next screen. You should see three warnings and one failure. The failure was caused by inability to lookup SCAN in DNS and that should be expected. Check "Ignore All" box and press "Next".
Press "Install" on the Summary screen.
Wait while installation takes place... When asked to confirm root scripts execution, answer Yes. The "root script" step was the longest one, so be patient!
We expect the verification phase to fail with errors related to low Host RAM, Swap File sizes, group mismatch for DISK1, and "udev information". These errors can be ignored. You can check errors opening log file. For example, for the log file shown below "gedit /u01/app/oraInventory/logs/installActions2013-09-30_10-25-44PM.log", then search for "Error".
Here is the example of offending lines from the log file for rac1 node:
INFO: INFO: Error Message:PRVF‐7530 : Sufficient physical memory is not available o INFO: INFO: Cause: Amount of physical memory (RAM) found does not meet minimum memo INFO: INFO: Action: Add physical memory (RAM) to the node specified. ... INFO: INFO: Error Message:PRVF‐7573 : Sufficient swap size is not available on node INFO: INFO: Cause: The swap size found does not meet the minimum requirement. INFO: INFO: Action: Increase swap size to at least meet the minimum swap space requ ... INFO: INFO: ERROR: [Result.addErrorDescription:618]
PRVF‐9992 : Group of device "/
... oracle INFO: INFO: ERROR: [Result.addErrorDescription:607 ] INFO: No UDEV rule found for device(s) specified INFO:
PRVF‐9802 : Attempt to get ude
Provided these are the only errors, it is safe to ignore them and continue by clicking the "Next" button. Close the Configuration Assistant on the next screen. Check the status of running clusterware. On rac1 as root user:
# . oraenv ORACLE_SID = [oracle] ? +ASM1 The Oracle base has been set to /u01/app/oracle # crsctl status resource ‐t ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ Name Target State Server State details ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ Local Resources ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ora.DATA.dg ONLINE ONLINE rac1 STABLE ONLINE ONLINE rac2 STABLE ora.LISTENER.lsnr ONLINE ONLINE rac1 STABLE ONLINE ONLINE rac2 STABLE ora.asm
ONLINE ONLINE rac1 Started,STABLE ONLINE ONLINE rac2 Started,STABLE ora.net1.network ONLINE ONLINE rac1 STABLE ONLINE ONLINE rac2 STABLE ora.ons ONLINE ONLINE rac1 STABLE ONLINE ONLINE rac2 STABLE ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ Cluster Resources ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE rac2 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE rac1 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE rac1 STABLE ora.cvu 1 ONLINE ONLINE rac1 STABLE ora.oc4j 1 OFFLINE OFFLINE STABLE ora.rac1.vip 1 ONLINE ONLINE rac1 STABLE ora.rac2.vip 1 ONLINE ONLINE rac2 STABLE ora.scan1.vip 1 ONLINE ONLINE rac2 STABLE ora.scan2.vip 1 ONLINE ONLINE rac1 STABLE ora.scan3.vip 1 ONLINE ONLINE rac1 STABLE ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ #
You should see various clusterware components running on both nodes. If there were serious problems during installation, the components of clusterware wouldn't start. Also you can check clusterware alert file "gedit /u01/app/12.1.0/grid_1/log/rac1/alertrac1.log" (on rac1 node, make adjustments for rac2). The grid infrastructure installation is now complete! Optionally, you can save this state using Simplified Way of Saving/Restoring Images. Check filesystem usage, about 8.6 GB are used:
$ df ‐k Filesystem 1K‐blocks /dev/mapper/vg_rac1‐lv_root 18420484 tmpfs 1544584 /dev/sda1 495844
Used Available Use% Mounted on 8691564 649740 78322
8793192 894844 391922
50% / 43% /dev/shm 17% /boot$
Install the Database Software Make sure the "rac1" and "rac2" virtual machines are started, then login to "rac1" or switch the user to oracle and start the Oracle installer.
$ cd /media/sf_oracle_sw/database $ ./runInstaller
Uncheck the "I wish to receive security updates..." checkbox and press the "Next" button:
Check "Skip software updates" checkbox and press the "Next" button:
Check "Install database software only" option and press "Next" button:
Select "Oracle Real Application Cluster database installation" and then press "Next" button.
Make sure both nodes are selected. Press on "SSH Connectivity" enter "oracle" password and then press "Setup" button. After the SSH connectivity setup is finished, press "Test" button to test it. Then press Next button.
Select Language on next screen and press the "Next" button. Accept "Enterprise Edition" option and press the "Next" button:
Accept default installation locations and press the "Next" button:
Accept default groups in "Privileged Operation System groups" and press the "Next" button:
Wait for the prerequisite check to complete. If there are any problems, either fix them, or check the "Ignore All" checkbox. On the screenshot below 3 warnings are shown which are safe to ignore. Click the "Next" button.
If you are happy with the summary information, click the "Install" button.
Wait while the installation takes place.
Execute root scripts when prompted on both nodes.
# /u01/app/oracle/product/12.1.0/dbhome_1/root.sh Performing root user operation for Oracle 12c The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/12.1.0/dbhome_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product‐specific root actions will be performed. #
Press "Close" button and the Oracle DB software is now installed! Optionally, you can save this state using Simplified Way of Saving/Restoring Images.
Install the Database Start dbca - DB Configuration Assistant:
$ cd /u01/app/oracle/product/12.1.0/dbhome_1/bin $ ./dbca
Accept "Create Database" option and press the "Next" button:
Check "Create a database with default configuration"; type in "Global Dtabase Name" the desired name; we have selected AL32UTF8 character set, make your choice as needed; also supply a password for SYS. We are going to create a reqular (pre-12c type) database, the "Create As Container Database is unchecked. Press Next button:
Wait for the prerequisite check to complete. The only reported problem was all familar "Swap Size". Check "Ignore All" checkbox and click the "Next" button.
Press "Finish" button in the Summary screen:
Click the "Close" button to exit the installer.
The RAC database creation is now complete!
Check the Status of the RAC There are several ways to check the status of the RAC. The srvctl utility shows the current configuration and status of the RAC database.
$ . oraenv ORACLE_SID = [oracle] ? racdb The Oracle base has been set to /u01/app/oracle $ srvctl config database ‐d racdb Database unique name: racdb Database name: racdb Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1 Oracle user: oracle Spfile: +DATA/racdb/spfileracdb.ora Password file: +DATA/racdb/orapwracdb Domain: localdomain Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: racdb Database instances: racdb1,racdb2 Disk Groups: DATA Mount point paths: Services: Type: RAC Start concurrency: Stop concurrency: Database is administrator managed $ srvctl status database ‐d racdb Instance racdb1 is running on node rac1 Instance racdb2 is running on node rac2 $
The V$ACTIVE_INSTANCES view can also display the current status of the instances.
$ export ORACLE_SID=racdb1 [oracle@rac1 Desktop]$ sqlplus / as sysdba SELECT inst_name FROM v$active_instances; INST_NAME ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐ rac1.localdomain:racdb1 rac2.localdomain:racdb2 exit $
Making Images of the RAC Database At any point earlier we could save the image of created virtual machine and then restor e it at will. Here we are going to save images of the newly created Oracle RAC system which we can restore in the same system or even hand over to another location and restore in a matter of few minutes! If all you need is saving and restoring images in the same VirtualBox setup, you can use Simplified Way of Saving/Restoring Images. The export of VM is a straightforward process and saving RAC images would be an easy task if not dealing with the shared disk. In my view the simplest way to handle that is by detaching shared disk from both nodes and taking care of these three parts (two self-contained VMs and one Shared disk) separately. In the end there will be three files: two files for VMs and a file representing the shared disk. These three files can be further zipped by your favorite archiver into one file which can be used for storage or transfer. After export is done, the shared disk can be easily attached back to the nodes. Same is true for the import of VMs back into VirtualBox along with the copy of shared disk - the shared disk is attached to the imported VMs as an extra step. Let's perform all these actions.
Clean Shutdown of RAC But first, we need to shutdown servers in nice and clean manner because we want save them in a robust state. Shutdown the database. As oracle user execute on any node:
$ . oraenv ORACLE_SID = [oracle] ? racdb The Oracle base has been set to /u01/app/oracle $ srvctl stop database ‐d racdb $
Shutdown the clusterware on the first node. As root user execute:
# . oraenv ORACLE_SID = [racdb1] ? +ASM1 The Oracle base remains unchanged with value /u01/app/oracle # crsctl stop crs ... CRS‐4133: Oracle High Availability Services has been stopped. #
Shutdown the clusterware on the second node. As root user execute:
# . oraenv ORACLE_SID = [racdb1] ? +ASM2 The Oracle base remains unchanged with value /u01/app/oracle # crsctl stop crs ... CRS‐4133: Oracle High Availability Services has been stopped. #
Shutdown both virtual machines. Wait until all VM windows are closed.
Detach Shared Disk and Make a Copy Of It In the VirtualBox Manager open Virtual Media Manager: Main menu | File | Virtual Media Manager. Then select the disk used by the RAC (rac_shared_disk1.vdi). Note that this disk shows as attached to rac1 and rac2 VMs:
Click on "Release" icon and then confirm in the pop-up window. Note that this disk now shows as "Not attached". Click on "Copy" to start Disk Copying Wizard.
Accept Virtual disk to copy and press "Next".
Accept Virtual disk file type as VDI and press "Next".
Select "Fixed size" and press "Next".
On the next screen you can set location and name of the new file. When done, press "Next".
On the Summary screen review details and press "Copy" to complete copying. Close the Media Manager when copying is done. Note. Do not try to copy .vdi file because the copy will retain same disk UID and VirtualBox will refuse to use it because there is already such disk. When copying trough the Virtual Media Manager, the new UID is assigned automatically.
Export VMs In the VirtualBox Manager select VM, then call Appliance Export Wizard: Main menu | File | Export Appliance. Exporting is generally as simple as saving a file. Export both VMs. Now you should have 3 files that can be further zipped into a single file with the size about 12 GB.
Re-attach Shared Disk to the Original RAC Setup Fix our current working RAC setup by re-attaching shared disk to rac1 and rac2 VM using "Storage" page. Don't forget to select correct controller before attaching the disk:
Press "Add Hard Disk" icon and use "Choose Existing Disk" to attach rac_shared_disk1.vdi . Once Shared disk is attached to both VMs, the RAC is ready to run.
Restoring RAC from Saved Files In this section we will import RAC from the saved files creating a second RAC system. Don't run both RAC at the same time because they will have same network attributes. Open Appliance Import Wizard: Main menu | File | Import Appliance. Choose the file and press "Next":
On the Appliance Import Settings different attributes of new VM can be changed. We are going to accept settings unchanged. It is interesting to note, that disks are going to be imported in VMDK format different from the original VDI format.
Wait until the VM is imported:
Import both VMs and copy Shared Disk rac_shared_disk1_copy.vdi file into the parent directory (Virtual VMs). This disk could be attached to both machines, but unfortunately current version (4.1.18) of VirtualBox doesn't preserve type of the disk then making a copy. Attach this disk to the either of imported VM, then select it and review disk information:
In the VirtualBox 4.1.18, the copied disk has "Normal" type. If you have a newer version and the type is "Shareable" then this bug has been fixed, and you can proceed to another VM. If not, de-attach the disk, then go to the Virtual Media Manager and change the disk type to "Shareable" as has been described above, then return to the Virtual machines and attached the Shared disk. Start new VMs. The clusterware should start automatically. You will need to bring up the database. Login as the oracle user and execute:
$ . oraenv ORACLE_SID = [oracle] ? racdb The Oracle base has been set to /u01/app/oracle $ srvctl start database ‐d racdb $
The RAC should be well and running!
Simplified Way of Saving/Restoring Images This is not a supported way to save/restore images in VirtualBox, but it is very simple and worked well. The restore is limited to the VirtualBox setup where images were saved. Stop both VMs. Find the location where VB stores images: Main menu | File | Preferences | General, "Default Machine Folder" box. For example: "C:\Users\sromanenko\VirtualBox VMs". Go to this folder and locate "rac1", "rac2" directories and "rac_shared_disk1.vdi" file. Make a .zip or .rar file containing these three items. If you don't have compressing tools and there is enough disk space, you can copy these three items to another location. The images are saved! In order to restore these images: Make sure VMs are stopped; Go to the "VirtualBox VMs" folder and delete "rac1", "rac2" directories, and "rac_shared_disk1.vdi" file; Restore these three items from the .zip file or copy from the location where these items were saved; The restored VMs are ready to run. That's it! Please send your feedback to: Back to the Top.
Comments Clifford Mathew says:
January 1, 2014 at 20:24, GMT Thank you for the instructions. During the GRID installation, I encountered error PRVF-7617 on "Setting Up Grid Infrastructure Step 8 of 19". Essentially, the multicast tests were failing. To identify and "workaround" (see CAUTION below) this error, the following steps were taken: 1. Executed the "runcluvfy" command as shown below from the shell prompt. This command file is located in the same directory as the "runInstaller". ./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verbose 2. Turned off the ipv4 firewall using the following commands on both RAC nodes (rac1 and rac2) service iptables stop chkconfig iptables off 3. Restart both VMs, and re-execute Step 1 above to make sure errors are all cleared up 4. Continue with GRID install as is documented in this blog.
CAUTION: By shutting down the Firewall as I did, I made the system vulnerable from a security standpoint. A proper solution should involve configuring the "iptables" correctly to allow what Oracle wants. At this point I don't have the steps to do this "proper" solution. Notes: ====== If anyone wishes to disable IPV6, the steps below worked for me. IPV6 was NOT the cause for the above issues - so this is not a required step. vi /etc/hosts # and comment out references to any ipv6 addresses bu placing a "#" character in front, and save vi /etc/sysconfig/network # and add the lines given below, and save NETWORKING_IPV6=no IPV6INIT=no vi /etc/modprobe.conf # and add the line given below, and save (this file was not present, so I created it by saving) install ipv6 /bin/true chkconfig ip6tables off Restart the machines
Sergei Romanenko says:
January 1, 2014 at 23:52, GMT Thank you for the comment. Let me ask if you already disabled firewall (as described in "Network Setup" section) before getting PRVF-7617 error? Clifford Mathew says:
January 2, 2014 at 00:26, GMT A second cluvfy failure occurr ed at the end of GRID install (running from server rac1). This had to do with SCAN addresses and nslookup. To resolve this I installed BIND on one of the servers (rac1) using instructions the URL below: http://www.oracle-base.com/articles/linux/dns-configuration-for-scan.php (This page refers to a GUI DNS editor - I could not find that package, so that was not installed. All required DNS files were created when "service named start" command was issued. After starting "named", I followed the instructions and edited(or created the additional) files mentioned in that article. I only added the 3 SCAN addresses and localhost in the DNS database. These 3 SCAN addresses were then removed from /etc/hosts by commenting them out. Did a final "service named restart", then tried "nslookup rac-scan.localdomain" which resolved
the name to 3 IP addresses. After this clicked "Retry" button the installer window, and it succeeded. Clifford Mathew says:
January 2, 2014 at 00:29, GMT Hello Sergei, I might have missed the "disable firewall". Sorry. Sergei Romanenko says:
January 2, 2014 at 02:02, GMT No problem. It is good you mentioned that disabling firewall is not a best thing in any real world system. John Hong says:
January 1, 2014 at 21:47, GMT Hi, for those people who is having this issue please see the link TO install guess addition error in the log that unable to find the source of your kernel .... " run kernel update refer this link http://oraclelabspace.blogspot.com/2012/06/setting-up-guestadditions-in-oracle.html Sergei Romanenko says:
January 2, 2014 at 02:09, GMT Yes, Virtual Box guest addition can be tricky and probably version dependent. So, you comment should be helpful. Thanks! Pragnesh says:
January 9, 2014 at 17:22, GMT Hi, Nice document. I installed VM RAC 2 node and then I wanted to add a node. When I clone the machine and run clufy after successfully installing the GRID software, RAC3 is not showing as part of the RAC clusetr. Did I miss anything? I still went ahead and installed the database software successfully. Then when I ran the DBCA from RAC1 to create instance on RAC3, after entering the SYS username and password I got error message: service RAC1-vip:1521:RAC1 is not available. Check your username, password and make sure the listener is up and available" I don't understand this error. The scan and the regular listener are up and running. Did I do anything wrong? Please help. Akash Shandilya says:
January 15, 2014 at 20:31, GMT Great Document! Just a note: I got another failed prerequisite. PRVE-0426 : The size of in-memory file system mounted as /dev/shm is "____" megabytes
which is less than the required size of "2048" megabytes on node rac1, rac2 Just in case you get this error, modify the size of tmpfs using the following steps: # vi /etc/fstab Modify the tmpfs line to look something like: tmpfs /dev/shm tmpfs size=3g 0 0 save the file and quit remount tmpfs: mount -o remount tmpfs check changes: df -h Run prerequisite checks again. Solved. Enjoy! Costi says:
January 25, 2014 at 08:36, GMT Hi. I followed your tutorial, step by step and everytime I have different space avai. For example now I have almost free 6 GB, therefore I will have an error when installing the Oracle DB. Do you know why? Is it possible to be increased, otherwise I will have to take it again all over. Thank you Sergei Romanenko says:
January 25, 2014 at 19:37, GMT Required disk space can fluctuate and each new installation can be different, I didn't keep exact numbers, but it was not very big. This can be dependent on many things including Linux version, which keeps changing, yum online repository which also gets bigger over time and your VM will cache it. By the way, don't forget to release yum repository when you don't need it anymore: 'yum clean all'. I think it is possible to resize .VDI disk using 'VBoxmanage modifyhd' command and then modifying Linux partitions by 'GParted' but I never tried that. You can search Internet for details on that. Prakash says:
June 10, 2014 at 15:53, GMT In "Install Guest Additions", Sometime Guest Addition Fails to Install. It will be safe to Execute below Two Commands Followed by "Reboot" for Smooth addition of Shared Folder. $yum install kernel* dkms gcc
$yum install kernel-uek-devel This Will Ensure your "Guest Additions" installation always Succeeds. Sergei Romanenko (http://kab128.com) says:
June 10, 2014 at 16:15, GMT Prakash, Thank you for your comment. VirtualBox Guest Addition is a bit tricky, so your hint should help. Jim says:
June 29, 2014 at 01:14, GMT I successfully create a two node rac 12c using oracle virtual box (node ol6-121-rac1, ol6-121rac2) system works fine. Now I want to create a third node. I tried using vbox to clone a new server ol6-121-rac3. it cloned ok and I reset the ip address for the new node, .etc. Since the node1 and node1 are using Grid Infrastutue and ASM, my node 3 clone has what node one had install. HOw do I change node3 to be added. It already has the GRID Home and ORACLE HOME...
Bill says:
July 4, 2014 at 11:14, GMT Great. I create rac1 and rac2. How do you add a third node. Thanks Sergei Romanenko (http://lab128.com) says:
July 6, 2014 at 02:44, GMT Jim, Bill: Although I didn't try that, I would do these steps: - remove one node, say rac1, from the cluster; - clone rac1 to rac3, doing all needed changes (MAC addresses, hostname, IP addresses etc) described in the article; - add two new nodes (rac1, rac3) to the cluster. Removing and adding nodes is a standard procedure covered in Oracle documentation, also available on many web sites. Bill says:
July 6, 2014 at 22:19, GMT I was able to create / add a third node rac3 to your setup above. Will send the docs. Thanks Anibal Lopez says:
August 15, 2014 at 09:16, GMT
Hi Sergei, The shared drives are not mounted on the Linux environment. Is there a way to check this? Do we need to do the mount of the shared storage manually? Thx, Anibal Sergei Romanenko (http://www.lab128.com) says:
August 15, 2014 at 17:54, 17:54 , GMT No. Check that shared drive is added and accessible: # ls /dev/sd* The output should be similar to this: /dev/sda /dev/sda1 /dev/sda2 /dev/sdb /dev/sdb1 Anibal Lopez says:
August 15, 2014 at 19:31, GMT Hi Sergei, The other problem is the SharedFolder. I have added the directory etc. When doing: [root@rac1 media] ls -l there is not oracle_sw. You know if I can check this too? Thx, Anibal Sergei Romanenko (http://www.lab128.com) says:
August 15, 2014 at 20:36, 20:36 , GMT In VirtualBox Manager, select VM and then open Shared Folders. Check that "oracle_sw" is in there. If not, see the document and add it. You may need to restart the VM if you made changes. Then in "/media" you should see sf_oracle_sw folder. Note that VB adds "sf_" prefix. Anibal Lopez says:
August 16, 2014 at 13:20, GMT Hi Sergei, I have done this but without success.
Is there any way to check why? Is there a missing option here? Thx, Anibal Sergei Romanenko (http://www.lab128.com) says:
August 16, 2014 at 14:58, 14:58 , GMT This functionality is provided by VB Guest Additions. Try to reinstall Guest Additions. If that doesn't help, you should look for help on Virtual Box forums. Anibal Lopez says:
August 17, 2014 at 10:32, GMT Hi Sergie, Have things working till the install of the database software. I got the error: not enough space. I have resized this with the VBoxManager from within the Windows 8 OS. I have also have to do a disk resizing in the Linux environment when starting up the rac vm's. Do you may have any advice or hint on this? Thx, Anibal David says:
August 18, 2014 at 05:01, GMT I am a beginner .I follow all your steps and finish install with no problem,thank you. I try to add a node, but I can't find addNode.sh in $ORACLE_HOME/oui/bin/ . Could you tell me how to run addNode.sh, appreciate. Sergei Romanenko (http://www.lab128.com) says:
August 18, 2014 at 17:49, 17:49 , GMT On the first node: [oracle@rac1 ~]$ . oraenv ORACLE_SID = [grid] ? +ASM1 [oracle@rac1 ~]$ echo $ORACLE_HOME /u01/app/11.2.0/grid
[oracle@rac1 ~]$ ls $ORACLE_HOME/oui/bin/addNode.sh /u01/app/11.2.0/grid/oui/bin/addNode.sh says:
September 19, 2014 at 17:49, GMT Hi Sergei, Great document and nice detailed steps, thank you very much for your effort :-) I was able to do the install; I did run in a few issues, but nothing that patience and google search could not solve. Thank you, Florin says:
September 28, 2014 at 12:59, GMT Hi, Thanks for sharing. This is gold! Just want to share some experience while setting up 12.1.2 instead of 12.1.1. 1. You need a larger storage for both shared disk and rac vms or else you will run into issues when installing the database. i use 10gb for shared disk and 30gb for rac vms. I believe a 30% bump will do (I just want to be safe) 2. I hit an memory_target issue while starting up the RAC vm after the creation of database. I resolved it by increasing my vm memory to 4gb and set tmpfs to 3gb. Not sure whats the best way to resolve it but it's working for me atm. Thank you, Roger says:
September 28, 2014 at 15:11, GMT Roger, Thank you for this valuable information! says:
September 29, 2014 at 20:37, GMT Sergei Romanenko , Why you didn't use SCAN / DNS server? Thanks Bhim Sohan says:
October 11, 2014 at 10:10, GMT
Do we don't need to define parameter in .bash_profile of both node? syed aleem says:
October 24, 2014 at 16:26, GMT Hi Sergei: Thank you very much for sharing this document and greatly appreciated for your effort. I used all instructions nicely laid out in this document and set up my the two node RAC successfully. Thank you again. Syed Aleem. Sohan says:
October 29, 2014 at 07:43, GMT Hi Syed , did you set kernel parameter for the configuration in /etcsysctl.conf? RuiXian BAO says:
December 12, 2014 at 23:49, GMT RuiXian BAO says:
December 13, 2014 at 00:02, GMT Hello Sergei and others, Sorry for the above empty post - a mistake:) BTW Sergei, since the first time I had more errors than expected after installing the Grid, then I deleted the old rac1 and rac2 and have done a re-installation, but got the same errors as below. Any idea will be highly appreciated. Best RuiXian INFO: INFO: Parsing KFOD-00311: Error scanning device /dev/sda INFO: INFO: Parsing ORA-27041: unable to open file INFO: INFO: Parsing Linux-x86_64 Error: 13: Permission denied INFO: INFO: Parsing Additional information: 42 INFO: INFO: Parsing Additional information: 140733744835552 INFO: INFO: Parsing KFOD-00311: Error scanning device /dev/sdb INFO: INFO: Parsing ORA-27041: unable to open file INFO: INFO: Parsing Linux-x86_64 Error: 13: Permission denied INFO: INFO: Parsing Additional information: 42 INFO: INFO: Parsing Additional information: 140733744835552 INFO: INFO: Parsing KFOD-00311: Error scanning device /dev/sda1 INFO: INFO: Parsing ORA-27041: unable to open file INFO: INFO: Parsing Linux-x86_64 Error: 13: Permission denied
INFO: INFO: Parsing Additional information: 42 INFO: INFO: Parsing Additional information: 140733744835552 INFO: INFO: Parsing KFOD-00311: Error scanning device /dev/sda2 INFO: INFO: Parsing ORA-27041: unable to open file INFO: INFO: Parsing Linux-x86_64 Error: 13: Permission denied INFO: INFO: Parsing Additional information: 42 INFO: INFO: Parsing Additional information: 140733744835552 INFO: INFO: Parsing KFOD-00311: Error scanning device /dev/sdb1 INFO: INFO: Parsing ORA-27041: unable to open file INFO: INFO: Parsing Linux-x86_64 Error: 13: Permission denied INFO: INFO: Parsing Additional information: 42 INFO: INFO: Parsing Additional information: 140733744835552 INFO: INFO: Parsing KFOD-00316: Error acquiring ASM discovery string: ORA-29780: unable to connect to GPnP daemon [CLSGPNP_ERR] INFO: INFO: Parsing KFOD-00105: Could not open pfile '
[email protected]'a RuiXian BAO says:
December 19, 2014 at 14:49, GMT Hello Sergei and others, FYI, I got the same error even when I tried udev instead of ASMLib. And my friend also gets the exact same error. Guess this is the result of the current software components' combination. In the end, we decided going farward anyway despite of the errors. And surprisingly all is the good in the end:) Thank you again for your nice instrucitons! Best RuiXian Paul (www.webgeest.nl) says:
February 27, 2015 at 09:21, GMT Hi, Perfect description, step by step works smooth. Except 1 thing: the SSH connectivity during Installing Database step 7 of 13. Before doing anything on this screen, open up a terminal on both nodes. Check that: * you can ssh oracle@rac2 AND ssh oracle@rac1 two ways * you can also ssh to yourself! so ssh oracle@rac1 from rac1 AND ssh oracle@rac2 from rac2. This makes the entry for the 'own' machine come into the known_hosts * make sure that the authorized_keys contains the pub keys for BOTH hosts If this works fine, then ONLY click the Test button. And then Next. Do NOT click Setup button, because I think this messes up the configuration.
Thank you very much for this excellent post! Paul raj says:
March 7, 2015 at 15:40, GMT Hi, This is an awesome post. I did setup successfully. It would be nice if you write posts on node addition and node deletion and standby setup in 12c. Thanks. Rajan says:
April 7, 2015 at 13:15, GMT While taking backup using RMAN, getting below errors due to /dev/sdb1 not mounted and need oracle user permission to write it, RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/07/2015 18:12:23 ORA-19502: write error on file "/u01/app/oracle/product/12.1.0/dbhome_1/dbs/b_RACDB_0kq3q7jv_20_1", block number 11648 (block size=8192) Pls advise. Thanks. Edgar Rangel says:
April 13, 2015 at 06:08, GMT Sergei, Thank you very much for this great guide!, I created the labs using VirtualBox in Linux (Red Hat Enterprise Linux Server release 6.5), as per other comment posted here I also used 12.1.0.2, but to get it working I had to increase memory up to 4 gb per each node, and also set tmpfs to 3gb. Vaibhav says:
June 7, 2015 at 13:10, GMT Excellent Dr. Hussien Sharaf (ite.from-masr.com) says:
August 13, 2015 at 19:28, GMT Excellent tutorial. - I used Oracle Linux 7 for 64 bit and I found that at the section titled "Udev Configuration" should be # /usr/lib/udev/scsi_id -g -u -d /dev/sdb instead of: # /sbin/scsi_id -g -u -d /dev/sdb
Dr. Hussien Sharaf (ite.from-masr.com) says:
August 16, 2015 at 14:31, GMT In Oracle Linux 7, disabling Firewall: # systemctl stop firewalld # systemctl disable firewalld omer ahmed says:
October 25, 2015 at 20:30, GMT Marcos says:
November 5, 2015 at 01:19, GMT I really appreciate your posting. It's so well-detailed that I had almost any issue. Even the expected error messages helped me to conclude the installation. Thanks! Spacibo! Tariq Ahmad Zafar says:
December 6, 2015 at 15:56, GMT TariqAhmad says:
December 6, 2015 at 15:58, GMT Excellent Article/Guide to proceed RAC ! Olivier says:
December 15, 2015 at 11:49, GMT One basic question : Why are you using both asmlib and udev ? Only one of them should be needed. abi says:
January 18, 2016 at 03:55, GMT Super Article. Thanks a Ton. Really useful. I was able to setup racdb properly for which I was struggling for many days. Kirk says:
February 15, 2016 at 04:52, GMT When i run the command fdisk /dev/sdb i enter the correct items but when i get the following: first sector 2048-8388607, default 2048 last sector 2048-8388607, default 8388607 i go with the defaults. Then when i run the following command oracleasm createdisk DISK1 /dev/sdb1 i get failed on instantiating disk What did i do wrong? Wu says:
March 14, 2016 at 19:32, GMT Somehow the instructions in the last part of section "Create Shared Disks" did not work for me. I could not see anything when I used "Choose existing disk" option to attach the newly created shareable virtual disk to the other VM. can I get some help? thanks!
Leave your comment: