RAC & Failsafe :: Oracle Cluster 10 Installation
Oct 27, 2010Steps for installing Oracle Cluster 10?
View 9 RepliesSteps for installing Oracle Cluster 10?
View 9 RepliesI 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
[Code]....
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
Are Oracle cluster and Oracle clusterware are same and has same in meaning in RAC ?
View 6 Replies View RelatedYesterday 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
Which option should I have to choose here ?
I got following error on Oracle 10.2.0.4.0 RAC on solaris 10
Oracle clsomon failed with fatal status 12.
Oracle CRS failure. Rebooting for cluster integrity.
I think this problem in 11g but I am using 10g.
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 ,
View 2 Replies View RelatedWhat is the different between the new RAC feature - real application cluster and OPS... for me it sound the same..
View 3 Replies View RelatedThe 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.
the ./cluvy shows the cluster is valid.
I am doing the following steps for stopping the Oracle RAC Services on a 2 node.(OS is Windows 2008 Release 2).
srvctl stop database -d <database_name>
Node 1:
crsctl stop has
Node 2:
crsctl stop has
But i am getting error like Oracle HAS Service not stopped successfully. Finally what i did was stopped the OHAS Service from Windows Services.
which is the right procedure to have a clean stopping of RAC Services in 11g R2.
While installing 11g oracle grid cluster software. I am getting below error.
[INS-40724] No locally defined network interface matches the SCAN VIP subnet.
i have given scan name as scan-cluster.invent
host-name virtual ip name
rac3 rac3-vip
rac5 rac5-vip
I am able to ping rac3 and rac5 from both nodes.
MY /etc/host file look like this.
192.168.2.133 rac3.invent.com rac3
192.168.2.132 rac3-priv.invent.com rac3-priv
192.168.122.1 rac3-vip.invent.com rac3-vip
192.168.2.136 rac5.invent.com rac5
[code]...
ssh connectivity everything works fine.
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?
I created Virtual Private Network for VIP and subnet is 255.255.255.255. I need VPN subnet as 255.255.255.0. How to i create
INS-40911: Ensure that nodes in the list are up and reachable, and ensure that the node addresses are all in the same subnet.
After installing a 4 node cluster 11.2.0.3 with 16 CPU's (4 on each node) on IBM 795 with aix 6.1 each server is using 0.5 CPU with no user load on the system. Running SIHA on one server typically uses 0.05 CPU with no user load on the system.
View 5 Replies View RelatedWe have 2 servers running Oracle 11gR2 Window server 2008 64 bit RAC. Today I add new shared disk visible from both servers. All our data placed on ASM partitions, but we need Windows volume for exchanging some data between servers & users;Actions:then i have prepare disk on shared storage from 1st node, run diskmfmt.msc & rescan disks when windows recognizes new hdd, initialize it.create an Extended partition & Logical drive & Assign drive letter. from another nodes, make sure no drive letter is assigned.
Sometimes Windows automatically assign drive letter. If drive letter is assigned, right click & Change drive letter & Remove. from 1st node, format this logical drive using ocfsFormat.exe after execute below scripts i have face some issues
E:app11.2.0gridcfs>ocfsformat /m P: /c 1024 /v DATA /f /d /aReg Get Cluster Name(): Reg Query ValueEx for CFS_CLUSTER_NAME failed with error 203
This indicates that the Cluster Name has not been configured on this node for OCFSThe volume formatted in this condition will be seen by all nodes running OCFS.
I am using newstart cluster software. currently I have two blade servers in my system and I have configured cluster as well. right now I have one issue. I am using the ip address of 10.34.14.0/28 network for cluster but this can not be accessed from all network so I want to use different range of IP of 10.68.1.0/28 network in the same blade servers. Can I configure two different floating (cluster) IP? the first IP range is for signalling and second IP range 10.68.1.0/28 network is for OMM. I need to use both IP in two blade servers.
View 1 Replies View Relatedi need to make RAC database setup ,so where can i get the operating system Rpm like bleow
compat-gcc-7.3-2.96.128.i386.rpm
compat-libstdc++-7.3-2.96.128.i386.rpm
compat-libstdc++devel-17.3.3.96.128.i386
compat-gcc-c++7.3.296.128.i386
send me link for the above require rpm for linux AS4.
I have some confusions regarding to 11gR2 RAC installation:
- Is Grid Infrastructure only the solution to install Clusterware Application 11gR2? My requirement is to install only the Cluster ware Software for 11gR2 (For 11gR1 we have "linux.x64_11gR1_clusterware.zip") using ocfs2 file system, Archive Mode not enabled.
I am in process of installing Oracle 11g R2 Grid Infrastructure on 2-node virtual RAC. All went very well until the Grid Installation stuck on 65%. It is saying copying file on remote node ('Copying Oracle Home '/u01/app/11.2.0/grid' to remote nodes 'cxm-vl-rman02'). From the logs it is difficult to figure out where the bottlenecks lies.
View 2 Replies View RelatedI must setup RAC 11g but I haven't meta link account to download cluster ware.
View 2 Replies View RelatedI 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
I tried to install 11gR2 grid infrastructure for 2 nodes RAC using VMWare as per the instructions provided in the below link.
[URL]
Until 65% installation went fine without any issues but after reaching this step "updating '/u01/app/11.2.0/grid/install/cluster.ini",it starts to hung. In the installation log file, I found these details.
Quote:filename = /tmp/.GsdDisplayed
INFO: Query Returned: false
INFO: Calling Action fileActions10.2.0.6.0 appendStringToFile
source = /u01/app/11.2.0/grid/install/cluster.ini
stringToAppend = [cluster_info]
cluster_name=rac-scan
[code]....
RAC star crs failed
[root@tyan147 crsd]# /orahome/grid/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager
cssd.log
2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnpm_connect: [at clsgpnpm.c:1100] GIPC gipcretConnectionRefused (29) gipcConnect(ipc-ipc://GPNPD_tyan147)
2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnpm_connect: [at clsgpnpm.c:1101] Result: (48) CLSGPNP_COMM_ERR. Failed to connect to call url "ipc://GPNPD_tyan147"
2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnp_getProfileEx: [at clsgpnp.c:546] Result: (13) CLSGPNP_NO_DAEMON. Can't get GPnP service profile from local GPnP daemon
2012-11-21 11:12:29.313: [ default][3613030480]Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).
2012-11-21 11:12:29.313: [ CSSD][3613030480]clsgpnp_getProfile failed, rc(13)
[code]....
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.
View 5 Replies View Relatedwhen 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
[code]....
This is the same case when i used reset option.
how to change the cluster interconnection from public to private.
View 6 Replies View RelatedIt 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.
I'm a long time Oracle DBA but have only recently started with RAC and have never done any patching or upgrades in a RAC environment.
My environment consists of a 2 node RAC cluster, and 2 physical standbys at separate remote locations.
The database, GI, ASM, and clusterware are all at version 11.2.0.1.
I want to upgrade all components to the latest patchset which is 11.2.0.3. Eventually I also want to apply the latest PSU.
Can I do this without down time? It is a mission critical database where downtime could conceivably endanger lives. If it can't be done with zero downtime, then downtime must be kept to an absolute minimum (minutes, not hours).
I suspect the clusterware needs to be patched first and I do not know whether I can do it on one node at a time.
im having problems with CRS in a Rac installation. Because of this i cant start the database.I installed Oracle Rac 11.2.0.1 with ASM in a Red Hat 5.8 linux server. Everything was ok until a server reboot. I have 2 nodes, nodo1 and nodo2. Both got rebooted and after that im not able to start the cluster.
All the other resources seem to be just fine .
At nodo1:
[root@nodo1 oracle]# crsctl start cluster -all
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'nodo1'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'nodo2'
CRS-2676: Start of 'ora.cssdmonitor' on 'nodo1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'nodo1'
CRS-2672: Attempting to start 'ora.diskmon' on 'nodo1'
CRS-2676: Start of 'ora.cssdmonitor' on 'nodo2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'nodo2'
[code]....
I have been asked to look at making an existing Oracle server resilant. The technology I need to use are:
- Windows 2008 R2 Enterprise SP2
- Microsoft Cluster Services
- Oracle Enterprise 11g release 2
- Oracle Fail-Safe (latest version available)
Unfortunately ApEX 4.1 and Mod_plsql are install on the existing stand-alone server. I'm afraid i know very little about Oracle and ApEX but i need to make a design decision and check fiesablilty.
I believe the HTTP service and Mod_plsql can be moved to a independant server which should work but ApEX itself must remian on the database server (i'm told).Will ApEX work in a MSCS setup? I can only find references to RAC support, RAC is out of scope.