Stopping Cluster Along With HAS?

Sep 17, 2013

I wanted to make my11g cluster down along with high availability.Documents says, Stop the cluster stack by using crsctl stop cluster and then execute crsctl stop crs command to stop HA. What is the difference if I am using the following commands?

1. crsctl stop cluster
crsctl stop crs

OR

2. crsctl stop crs

As per my understanding, crsctl stop crs command stops entire cluster stach plus has.

View 1 Replies


ADVERTISEMENT

RAC & Failsafe :: Stopping Oracle 11g R2 Cluster Services In Windows 2008

Jan 22, 2013

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.

View 4 Replies View Related

RAC/ASM Clusterware Installation :: REG - Sequence Of Stopping RAC Database?

Sep 3, 2013

we need to take care of all the components in a RAC Database 11g rel 2 .  what is the sequence of stopping RAC database ?  databsae ?? ASM ??? listeners ??? cluster services ???  commands and also sequence to start / stop ...and to check status of each components  

View 2 Replies View Related

Scan In 4 Node Cluster

Jun 24, 2013

We are going to setup a 4 node rac cluster. So i think we need to configure only one SCAN with 3IP's. And how the scan listeners are configured on these 4 nodes.

View 1 Replies View Related

RAC & Failsafe :: Cluster In Oracle

Apr 23, 2013

Are Oracle cluster and Oracle clusterware are same and has same in meaning in RAC ?

View 6 Replies View Related

To Query The Cluster Name From Server

Dec 20, 2012

We have few Solaris RAC Clusters. When I try to query the cluster name from server using the following command i get the same result for all the clusters.

soc02n02-oracle> cemutlo -n -w
ORA_CRS_01
2:1:

soc03n01-oracle> cemutlo -n -w
ORA_CRS_01
2:1:

While in the OEM Grid Console it shows the separate name given to each of them. Check the attached .pdf

Q.Why the cluster names are same from the OS level but different in the OEM console.
Q.Is there any way we can find out the individual cluster names other than cemutlo commands.
Q.In OEM why is the "Cluster" different from the "Cluster name"

Attached File(s)

SOC_Cluster.pdf ( 27.63K )
Number of downloads: 2 

View 1 Replies View Related

Combining Hash Cluster And Indexes

Oct 28, 2010

A basic select and group by query I am optimising for my Database course has returned results that indicate it will perform better on a clustered index when returning a smaller number of rows (5% of the largest table) and on a hash clustered index when returning higher volumes (50% and 80%). I understand that it is possible to use more than one index type on a table to improve performance, but I am struggling to understand how I might establish a hash cluster and a cluster on the same table? and then use hints to drive the query down one access path or the other.

Site admin - this site is a very useful resource.

View 5 Replies View Related

Consolidate RAC Databases In Single GI For A Cluster

Jul 11, 2012

I had installed grid infrastructure for a cluster, and RAC database. The ASM is the storage option. The configurations as follows:

Grid Home: /u01/grid/app

Oracle RAC Home: /oracle/db1/app/product/11.2/dbhome1

Can I have another RAC Database to use the existing Grid infrastructure ? The second RAC database will have different owner than db1.

The configurations as follows:

Grid Home: /u01/grid/app

DB1 Oracle RAC Home: /oracle/db1/app/product/11.2/dbhome1 and Database Name: RACDBA so the current instances are RACDBA1 and RACDBA2

DB2 Oracle RAC Home: /oracle/db2/app/product/11.2/dbhome2 and database name: RACDBB so the future instances will be RACDBB1 and RACDBB2

View 1 Replies View Related

RAC & Failsafe :: Oracle Cluster 10 Installation

Oct 27, 2010

Steps for installing Oracle Cluster 10?

View 9 Replies View Related

SQL & PL/SQL :: How To Create Single Table Cluster

Mar 6, 2010

I have one table called posh, which has about 50,000 ids (millions of rows) so far. It is currently at about 50 gb. So each series of rows for a particular id is about 1 mb.

CREATE CLUSTER posh_cluster (id int)
SIZE 2M
STORAGE (initial 2000K next 2000K)
PARALLEL 4;
CREATE INDEX posh_cluster_index ON CLUSTER posh_cluster;

[code].......

According to the Oracle documentation size is "the average cluster key size", I am not really sure what that means. Is this the 1mb in posh table space I am using for each series of rows for an id, or the space used for the index? Secondly, the storage parameter for 'CREATE CLUSTER' should be what?

View 11 Replies View Related

SQL & PL/SQL :: Cluster Creation On Already Existing Table

Feb 20, 2012

I have table property and flat , in both of these tables I have cvp_id common colomn .Now I want to add cluster on this colomn so how can I add cluster to table which is already exists.

View 3 Replies View Related

SQL & PL/SQL :: What Is Cluster / Bitmap And Functional Index

Dec 26, 2011

index types like cluster,bitmap,binary tree,functional. Specify the differences between these types

View 5 Replies View Related

SQL & PL/SQL :: How To Check If The Cluster Exist In Database

Apr 27, 2010

We can use the clause "CREATE CLUSTER mycluster.." to create a cluster.

How to check if the cluster exist in my database, so I don't have to create the cluster again.

View 1 Replies View Related

Install RAC Cluster Onto Linux Server

Apr 1, 2011

What I wanted to know was the steps to place a RAC cluster onto a brand new Linux server.

Step 1 - Install Cluster Software , CRS & Voting Disks
Step 2 - VIPCA - VIP Config (VIP, GSD, ONS) Resouce Apps
Step 3 - Create ASM Instance
Step 4 - Install Grid Infrastructure
Step 5 - Install RAC
Step 6 - Create Cluster DB - using DBCA with Enterprise Manager

This will be a 2 node RAC cluster going onto a Redhat 5 Linux box

View 2 Replies View Related

RAC & Failsafe :: Download Cluster Ware 11g

Jan 22, 2013

I must setup RAC 11g but I haven't meta link account to download cluster ware.

View 2 Replies View Related

RAC & Failsafe :: RMAN Backup On Cluster

Dec 1, 2011

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

View 6 Replies View Related

Server Administration :: Few Cluster Services Are Down

Nov 9, 2010

on 6th of August at 02:36 our following cluster services were down,i see the logs and found that ASM is down and disk group are not accessible and ASMb process is terminated and both instances was restarted, i checked the cluster services so five services were down and these are

Quote: ora_ OCR_DG.DG, ora_fedb96.asm2.asm, ora_fedb96.gsd, ora_fedb96.ons and ora_fedb96.oc4j...

I restarted the services and they were successfully up and application become available . What can be the reason of the service failure?

alert.log

ORA-03113: end-of-file on communication channel
Process ID:
Session ID: 157 Serial number: 6655
ASMB (ospid: 23903): terminating the instance due to error 15064
Mon Aug 06 02:36:38 2012
NOTE: Deferred communication with ASM instance
Errors in file /u01/app/oracle/diag/rdbms/grid12/grid91/trace/grid91_ora_25856.trc:
ORA-15055: unable to connect to ASM instance
ORA-01092: ORACLE instance terminated. Disconnection forced
[code]...

View 1 Replies View Related

Clusterware :: Oracle RAC And Ocfs2 On One Cluster

Aug 26, 2012

I have a RAC working with SAN raw devices presented to ASM and working fine. My situation has changed since the installation of the RAC. Now I need a shared storage (with a filesystem) to upload some files (so DB can read these as external tables) for this I have used OCFS2.

As you can see I have Oracle RAC on raw ASM + shared storage on OCFS2 and for the time been all seems to be well and working perfectly. Can these coexist with out effecting the other?

View 2 Replies View Related

RAC/ASM Clusterware Installation :: Patching Cluster From 11.2.0.1 To 11.2.0.3?

Aug 15, 2012

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.

View 2 Replies View Related

Clusterware :: 2 Oracle SE Instances In 1 Cluster?

Jun 21, 2013

I would like to build a 2-node cluster without RAC.  I desire to operate 2 Oracle database instances for use by 2 separate applications.  I plan to run Linux.  I would like node1 to act as the primary server for the databases in application1 and node2 to act as the failover server for the databases in application1.  Conversely, I want node2 to act as the primary server for databases in application2 and node1 to act as the failover server for databases in application2.  Can Oracle SE and Oracle Clusterware be configured in this this way?

View 2 Replies View Related

Adding New Node Back To Cluster Via Documentation

Apr 10, 2012

I have a 3 node RAC server on Windows Server 2008. Last week the hard drive went out on one of the nodes and I have had to rebuild as I could not recover anything.

I went through and deleted the old node and now I have just finished adding the new node back to my cluster via documentation. Once I created the new instance on that server DBCA attempted to start and it failed gaving me a crs error. I found out later that the other 2 nodes went down and the new one that did not start correctly was the only one up!! I went and stopped the new instance and restarted the first 2. The associated services did not start with the instance so I had to start each manually. The trace files show an ORA-29702 error with cluster group service and the instance being stopped on both of the existing nodes. No other error messages stood out.

Now I cannot get any crs services to start on that 3rd node even if I attempt to start manually. I have also tried stopping all and restarting and that does not work. I found another post on this forum from you and followed it. The ASM service was fine the entire time through all the logs and I don't know how to verify LMON in Windows but I didn't see any LMON errors in the alert log. Also, the voting disks are online. Each node has their own and they are mirrored. Where else to look?

View 7 Replies View Related

High Cluster Waits During RMAN Backup

Jul 1, 2010

We had a massive jump in cluster waits specifically; gc buffer busy acquire during an RMAN backup. We identified the cause of the waits to a few hot blocks with a table that may well need re-building in terms of ITLs and PCTFREE (Although I thorght ASSM would manage PCTFREE and PCTUSED..)

What happens during an RMAN backup that may cause huge cluster waits on hot tables? Is there some crazy redo issue going on or maybe flashback?

Either way the spike is there and we can pinpoint the activity on the database but just dont understand why RMAN would cause the issue.We have just found that the LARGE_POOL has not been set, in fact there is no SGA_TARGET either! Could this have an effect on RMAN and cluster waits?

View 3 Replies View Related

RAC & Failsafe :: 11.2.0.2 Patch For Oracle 11gR2 RAC Cluster?

Sep 29, 2010

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

Which option should I have to choose here ?

View 1 Replies View Related

SQL & PL/SQL :: Difference Between Normal And Cluster Index On Table?

Aug 4, 2010

Difference between Normal Index on Table and Cluster Index on Table?

View -1 Replies View Related

CVU To Validate Readiness For Oracle Cluster 11g Upgrade

Sep 24, 2013

I have a 11.2 Grid Infrastructure with the July PSU applied. I ran the CVU and reveive the following error. I checked the file in error and I find nothing wrong. Why does CVU fail the pre-check?

RUN CVU:
./runcluvfy.sh stage -pre crsinst -upgrade -n cusms1,cusms2 -src_crshome /u01/grid11203 -dest_crshome /u02/grid12101 -dest_version 12.1.0.1.0 -verbose

RECEIVED ERROR:
Starting check for zeroconf check ...
ERROR:
PRVE-10077 : NOZEROCONF parameter was not specified or was not set to yes in file "/etc/sysconfig/network" on node "cusms2.us.com"
PRVE-10077 : NOZEROCONF parameter was not specified or was not set to yes in file "/etc/sysconfig/network" on node "cusms1.us.com"
Check for zeroconf check failed

Pre-check for cluster services setup was unsuccessful on all the nodes.

VERIFIED FILE IS CORRECT:
[root@cusms1 ~]# cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=cusms1.ca.us.com
GATEWAY=121.1.160.1
NOZEROCONF=yes

[root@cusms2 ~]# cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=cusms2.ca.us.
GATEWAY=121.1.160.1
NOZEROCONF=yes

View 1 Replies View Related

Oracle 11.2.0.2.0 Running On Microsoft 2008 Cluster

Apr 8, 2013

Is Oracle certified Oracle 11.2.0.2.0 to run under a Microsoft 2008 Cluster ?

View 6 Replies View Related

RAC & Failsafe :: CRS-4535 / Cannot Communicate With Cluster Ready Services

Nov 21, 2012

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]....

View 2 Replies View Related

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.

View 5 Replies View Related

RAC & Failsafe :: ORA-29701 / Unable To Connect To Cluster Manager

Aug 8, 2011

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

[code]....

This is the same case when i used reset option.

View 3 Replies View Related

RAC & Failsafe :: Change Cluster Interconnection From Public To Private?

Jul 3, 2013

how to change the cluster interconnection from public to private.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved