RAC & Failsafe :: Installing / Configuring Real Application Cluster Using NFS Instead Of ASM?
Feb 28, 2012
i want to install oracle real application cluster using shared file system and not using ASM. we are not creating LUN for our data to kept and SAN admin will give us NFS share where we will place the database.
I have two node RAC on a test server. I have installed database software but it failed with an error that OEM could not be installed. Now I need installing Enterprise manager.
I have recently setup a 2 node Rac on oracle linux 5.4 with oracel 11gR2, the installation went smoothly and all the cluster resources are up and running however the data is not syncing across the nodes, when I create a table it shows up on the other node but when I insert rows into the tables they don't show up on the other node and when I restart the cluster the inserted rows are completely gone even from the node where I inserted them.
[oracle@server03 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME CLUSTER_NODES="" -local Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 20127 MB Passed The inventory pointer is located at /etc/oraInst.loc The inventory is located at /u01/app/oraInventory 'UpdateNodeList' was successful.then I executed:
To deinstall the Oracle home from the node you are deleting, run the following command from the Oracle_home/oui/bin directory:
Checking swap space: must be greater than 500 MB. Actual 20127 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-11-06_12-05-36PM. Please wait ...[oracle@server03 bin]$ Oracle Universal Installer, Version 11.1.0.7.0 Production Copyright (C) 1999, 2008, Oracle. All rights reserved.
[code]....
When I arrive to the point 5 I see one resource ora.DPCTTest.db ONLINE on one server (server02 or server03 that are the nodes I want to remove). If I execute:
crs_relocate ora.db_name.db
I obtain: [oracle@server03 bin]$ ./crs_relocate ora.DPCTTest.db Attempting to stop `ora.DPCTTest.db` on member `server02` Stop of `ora.DPCTTest.db` on member `server02` succeeded. Attempting to start `ora.DPCTTest.db` on member `server03`
i got a problem while configuring asm in linux operation system for practice purpose and it troughs error the folllowing details are as fallows.
operting system = oracle enterprise linux 5 software =oracle 10g version= 10.1.0.2.0 oerating system kernel parameters=2.6.18-194.el5PAE
when i'as issuing commed(Localconfig add) on root users i'm getting the following error [root@prod ~] localconfig add /uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 392: /etc/init.d./init.cssd : no such file or directory /bin/rm: cannot remove '/etc/init.d/init.cssd' no such file or directory /uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 402: /etc/oracle/ocr.loc no such file or directory in/rm : cannot remove /etc/oracle/ocr.loc' no such file or directory bin/rm: missing operand try '/bin/rm --help for more information
solution i tried for this errror 1.i tried to locate lidbl.so.2 libraies using locate libdl.so.2 and cpoied to location create soft link but still its the same error. 2)i tried ti install rpm pakages for kernel 2.6.18-194.el5PAE but still same eror. 3)i export the library path in bash_profile but still i got same problem
I am setting a RAC on vmware follow:URL....And i have a problem in the last step when Installing Clusterware Software. Oracle Cluster Verification Utility failed. The problem is:
OCR itegrity found invalid for nodes: RAC2 OCR itegrity found valid for nodes: RAC1
I am trying to install Oracle 10g RAC clusterware on RHEL-ES-4 using vmware. everything works properly till the time root.sh on second node.
I am getting the below error.
Adding daemons to inittab Expecting the CRS daemons to be up within 600 seconds. Failure at final check of Oracle CRS stack. 10
After googling this topic, I found I have to check this first below
This particular case is caused by the OS init system does not working.
" Failure at final check of Oracle CRS stack.10" means CRS daemon did not startup during 600 seconds period.In the root.sh script, it adds CRS related entry in /etc/inittab, run "init q" and expect 3 CRS related daemon processes to start, eg:
init.cssd init.crsd init.evmd
With init system problem, none of these daemon processes are spawned, this causes CRS process startup failure as they rely on the CRS daemon processes to start first.
This can be verified by adding a simple entry in /etc/inittab:
I have a table called dept table with nested collection as below. Nested Table Collection:
create or replace type courselist as table of varchar2(64) Table Using Nested Table Collection: CREATE TABLE "FCSDWH_STG"."DEPT" ( "NAME" VARCHAR2(20 BYTE), "DIRECTOR" VARCHAR2(20 BYTE), "OFFICE" VARCHAR2(20 BYTE), "COURSES" "FCSDWH_STG"."COURSELIST" ) Content Of Table:NameDirectorofficecoursesAccountingJames CharlesUNOFCSDWH_STG.COURSELIST('natural science','chemistry','Computer Science','Computer Science')
I am trying to select and print an element from nested table collection using below plsql block.
MY_COURSE VARCHAR2(64 CHAR); BEGIN SELECT courses INTO MY_COURSE FROM TABLE(SELECT COURSES FROM DEPT) where courses='chemistry'; DBMS_OUTPUT.PUT_LINE(MY_COURSE); END; Error Message: PL/SQL: ORA-00904: "COURSES": invalid identifier
Yesterday I was installing 11.2.0.2 patch to our Oracle 11gR2(11.2.0.1.0) Two node RAC cluster on OEL 5.4 x86 Linux.Before installing I have read [URL] support note which says "Note: All Oracle Grid Infrastructure patch set upgrades must be out-of-place upgrades, in which you install the patch set into a new Grid home. In-place patch set upgrades are not supported. "
During Installation I found following Installation Option :
1) Install and configure Oracle grid Infrastructure for a cluster
2) Configure Oracle Grid Infrastructure for a Standalone Server
3) Upgrade Oracle Grid Infrastructure or Oracle Automatic Storage Management
4) Install Oracle Grid Infrastructure Software Only
when i'm creating ASM instance, i'm getting an error
Quote:ora-29701: unable to connect to cluster manager
for this there were some workaround given to start css.
i tried everything from /etc/init.d/init.cssd start/enable but nothing worked, then i tried with executing
localconfig delete localconfig add====>it failed and recommended to go for reset option
when i executed localconfig reset i get this following error:
Quote: [root@rac2 bin]# sh localconfig add Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. Configuration for local CSS has been initialized
I am trying to create a rac setup on oracle 10.2. through NFS cluster configuration .i succeeded with the installtion of cluster configuarion and installation of oracle software ,but when i am trying to create database ,
I am installaing oracle RAC 11.2.0.1. After I installed the grid infrastructure, when I ran root.sh, I got below errors;
ASM failed to start. Check /d1/app/grid/cfgtoollogs/asmca/asmca-1109068AM4612.log for details.
Configuration of ASM failed, see logs for details Did not succssfully configure and start ASM CRS-2500: Cannot stop resource 'ora.crsd' as it is not running
It appears that the Oracle RAC cluster does not recognize the 'dba' group membership assignment to a user, unless it is assigned as the user's primary group.This also only affects newly created users, older users do not have this issue.
This affects us in the following way:
We are unable to create new cluster resources with the SAPCTL tool with the <sid>adm user.
When we try to create a resource using sapctl as the <sid>adm user we receive the following error:
CRS-0259: Owner of the resource does not belong to the group. SAP ABAP VIP creation failed.
The description of this error is that the resource owner (<sid>adm) is not a member of the group defined by 'osdbagrp' (what the cluster expects group membership for os users to control cluster resources), in our case this group is 'dba'.This is despite the user definitely being a member of the group.
Resource creation workaround:We are able to get around the resource creation by creating the resources either as root user, or by assigning 'dba' as <sid>adm's primary group.However, although we are able to control the VIP cluster resource, we are unable to control the other SAP enqueue resources as we assume that they need to be created by a user with 'sapsys' as a primary group (i.e. the resources do not start or it appears that there is not even an attempt to start the resources as there are no SAP startup logs created).
We have attempted multiple variations of creating and controlling cluster resources: changing <sid>adm primary group, changing cluster resource permissions, with nothing working for us.
The bottom line is that we need to be able to create these sapctl resources with a <sid>adm user that has 'sapsys' as a primary group while also being a member of the 'dba' group.
The installation of CRS is successfull & at end it ask to execute 2 scripts on both nodes i.e. orainstRoot.sh and root.sh
When the scripts are executed,the execution of orainstRoot.sh is successfull , but root.sh give following error:
[root@rac2host crs]# ./root.sh WARNING: directory '/home/oracle/product' is not owned by root WARNING: directory 'home/oracle' is not owned by root Checking to see if Oracle CRS stack is already configured /etc/oracle does not exist. Creating it now.
[code]....
Is this concerned with permissions on OCR, Voting Disk.
My application consists of Oracle RAC and Oracle Enterprise Manage (OEM) on same two nodes. I am exploring the idea of utilizing Oracle Clusterware (which is already installed with Oracle RAC) to support OEM in active passive mode.
Here is the scenario.
Node A running Solaris 10.9 on SPARC and Node B running Solaris 10.9 on SPARC. Node A and Node B are both Oracle RAC Nodes ( Active Active ) which use Shared Storage for Oracle using ASM.
Node A and Node B will run Oracle Enterprise Manager (OEM) Application in active passive scenario which will be using Oracle RAC for its database. So, both Oracle RAC and OEM are sharing same server A and B for its clusters.
Now, OEM application need a third party clusterware to fail it over. It needs clusterware to provide floating VIP and shared folder of the size of 20GB which will keep software libraries. If node A goes down, node B have access to same libraries and will come up as active.
Do you know if oracle clusterware which comes with Oracle RAC can support OEM for failing over i.e. it can provide floating VIP and shared file system?
RAC installation on vmware is failing with following errors. I followed below link for installation. URL..... Found the following errors:
[root@rac2 ~]# cd /crs/oracle/bin/ [root@rac2 bin]# ./vipca PRKR-1062 : Failed to find configuration for node rac1 PRKR-1062 : Failed to find configuration for node rac1 [code]....
The "/crs/oracle/cfgtoollogs/configToolFailedCommands" script contains all commands that failed, were skipped or were cancelled. This file may be used to run these configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.The "/crs/ oracle/cfgtoollogs/configToolAllCommands" script contains all commands to be executed by the configuration assistants. This file may be used to run the configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.
[root@rac2 bin]# /crs/oracle/bin/racgons add_config rac1.localdomain:6200 rac2.localdomain:6200 [root@rac2 bin]# /crs/oracle/bin/oifcfg setif -global eth0/192.168.2.0:public eth1/192.168.0.0:cluster_interconnect PRIF-10: failed to initialize the cluster registry [root@rac2 bin]# /crs/oracle/bin/oifcfg setif -global eth0/192.168.2.0:public eth1/192.168.0.0:cluster_interconnect PRIF-10: failed to initialize the cluster registry
So as luck would have it my Win XP OS crashed. Yes, its the office laptop and I cannot upgrade the OS for now. Anyhow, I got the whole machine re-imaged and installed 10g which had version 2.1 and everything was okay. I was earlier running apex 4.1.1. I could not find that setup on the oracle site so I downloaded apex 4.2 and ran the installation as per page
[URL].........
Everything went through properly except for step
5. Log back into SQL*Plus (as above) and load images:
SQL> @apxldimg.sql APEX_HOME
[Note: APEX_HOME is the directory you specified when unzipping the file. For example, with Windows 'C:'.]
where it asked me to enter the directory and I entered C:
This is what happened
SQL> @apxldimg.sql
PL/SQL procedure successfully completed.
Enter value for 1: C: old 1: create directory APEX_IMAGES as '&1/apex/images' new 1: create directory APEX_IMAGES as 'C:/apex/images'
Directory created.
^C C:apex>
I see a backslash and forward slash so I did a ctrl c . When I tried running the command again - @apxldimg.sql
it just would open the .sql file.
Not sure if this is the issue, but anyhow, after this, when I tried the "go to database page. It just shows a blank page. I was happy with 4.1.1. Is that available anywhere? Maybe I can remove XE and do a fresh install with that.
I m trying to make ORACLE RAC 10gr2 on two nodes with openfiler , with ocfs and asm.but i didn't have clusterware 10.2 software to install because oracle has removed software to download, that's why i install clusterware 11.2 . after installation clusterware 11.2 i check status and output is below on both nodes.
[oracle@linux2 bin]$ ./crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online
but when i try to install oracle 10gr2 software and when i reach to configure asm disks it says "in order to use AUTOMATIC STORAGE MANAGEMENT the oracle cluster synchronization service (CSS) must be up and running. and says to run "/u01/app/oracle/product/10.2.0/db_1/bin/ localconfig reset* as root user.. I run it and it give no error.