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.
Are Oracle cluster and Oracle clusterware are same and has same in meaning in RAC ?
View 6 Replies View RelatedSteps for installing Oracle Cluster 10?
View 9 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 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 RelatedI 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]....
What 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?
What could be the reason for Such Errors.?OCR Integrity was Successful on one node and on the cloned node it was failed.
View 8 Replies View RelatedI 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
Today, I've got an error:
$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Nov 17 09:45:50 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
idle> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/DOISOAT/spfileDOISOAT.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/DOISOAT/spfileDOISOAT.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
idle> exit
SP2-0042: unknown command "exit" - rest of line ignored.
idle> exit
Disconnected
First time, I tried to recreate spfile from pfile, however, it - the errors continued to occur. And I searched in metalink, so, I've got ID 387217.1. I've been beging followed:
1- Check the REQUIRED_RESOURCES was listed by crs_stat -p command, wasn't it? Then, the REQUIRED_RESOURCES did not contain anything
2- Modify by Metalink comment solution:
srvctl modify instance -d <database name> -i <instance name> -s <ASM instance name>
Everything is done, however, I still did not startup database instance. The above error continued, and I force to stop all by crs_stop -all.
I 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
when running the root.sh on second node the following error occured
adding daemons to inittab
expecting the crs daemons to be up within 600 seconds
failure at final check of oracle CRS stack. 10.
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.
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
Version :11.2.0.1
We reboot the server.After that we have seen ORA-15027 and ORA-15032 in alert log.
select INSTANCE_NAME,db_name ,STATUS,SOFTWARE_VERSION,COMPATIBLE_VERSION from V$ASM_CLIENT
INSTAN DB_NAME STATUS SOFTWARE_VERSIO COMPATIBLE_VERS
------ -------- ------------ --------------- ---------------
+ASM IT8 CONNECTED 11.2.0.1.0 11.2.0.0.0
+ASM IT8 CONNECTED 11.2.0.1.0 11.2.0.0.0
+ASM IT8 CONNECTED 11.2.0.1.0 11.2.0.0.0
+ASM IT8 CONNECTED 11.2.0.1.0 11.2.0.0.0
select name,MOUNT_STATUS ,HEADER_STATUS ,MODE_STATUS ,STATE ,path from v$asm_disk
IT8_DATA_DISK9 CACHED MEMBER ONLINE NORMAL /dev/IT8_DATA_DISK9
I install oracle 11g2 on centos, in prerequisite checks step ,oracle database show this failed "Oracle Restart integrity Failed", I don't know what should i do ?
View 2 Replies View RelatedOS=Redhat 5
Oracle=11gr2
Grid=11gR2
I am trying to install Oracle Database 11gR2 database on Oracle Grid 11gR2. I successfully installed Grid without errors. However, when installing the database, I got an OLR Integrity error during the prerequisit Check
OLR Integrity - This test checks the integrity of OLR on the local node.
Expected Value : n/a
Actual Value : n/a
List of errors:
- Permissons of file
"/u01/app/oracle/product/11.2.0/grid/cdata/localhost/localhost.olr" did not match the expected value. [Expected = "0600"; Found = "0660"]
- Cause: Cause of Problem Not Available
- Action: User Action Not Available.
I have two machines with oracle 11g . Both having ODP 11.2 Beta. I've to communicate between these two machines using Oracle Advanced queuing. The message sent from one machine will reach the second machine only if the Firewall of both machine is OFF.But based on requirement, we cannot switch OFF firewall or add exceptions as ports or applications.
View 1 Replies View RelatedWe have a server that crashed due to hardware failure and although brought back up OK Oracle DB's are no longer mounting. I am not a DBA but it looks bad to me and it seems there are no backups. This is Oracle 11G XE running on Centos 6. There is no Oracle contract here.
[root@627963 trace]# sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Thu Sep 12 23:18:26 2013
Copyright © 1982, 2011, Oracle. All rights reserved.
SQL> connect sys as sysdba;
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2233344 bytes
Variable Size 893389824 bytes
Database Buffers 167772160 bytes
Redo Buffers 5541888 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 10571
Session ID: 62 Serial number: 3
SQL> startup /nomount
SP2-0714: invalid combination of STARTUP options
SQL> startup nomount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
Alert_XE.log:
Thu Sep 12 21:26:18 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
[Code]....
I'm getting the error messaage:
Database Connection failure. Reason: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory
I'm not an Oracle expert, but I have research a little and seems that the SID could be wrong or that the DB is down, in fact I have already checked trhe server but everything seems normal to me.
I m using Windows Vista Business 32 bit , Oracle 10.2.0.3
while running my setup so many time i got same error each and every time Error:12560 TNS Protocol Adapter error and it shows me i attached my screen shot with my thread , and remember i already installed earlier but at that time there was no error and successfully installed, i removed the total software before installing and i also removed my environment variable and after getting this Database Configuration Assistant failure there is no service is started regarding my database.. I also tried manually but there also i got some other problem if by Database Configuration Assistant it ll b solved then it ll be good for me.