RAC & Failsafe :: Change Cluster Interconnection From Public To Private?
Jul 3, 2013how to change the cluster interconnection from public to private.
View 6 Replies
ADVERTISEMENT
RAC & Failsafe :: Differences Of Enabling Thread As Public Or Private?
Aug 25, 2012differences of enabling thread as public or private?
lets assume that i have two threads (1, 2) for two instances (1, 2) and each of thread consists of 2 redolog groups - minimum configuration.in case i need add third node i need third thread.
what will be difference if i set this thread as public instead private?
Networking And Gateways :: Testing Private Database Link With Same Name As Public
Oct 13, 2010We are currently replacing all public database links with private db links in our prod environment. The requirement is
1) private db link name should be same as public
2) Need to create and test out private db links before we can drop public db links.
How can we test out private db links while public db links are still there with the same name?
when I execute SELECT * FROM DUAL@DBLINK from user who created this private db link, which db link it will be using- public or private?
Real Application Clusters :: Change Only Netmask Of Private Interconnect 11g R2
Sep 9, 2013I want to change only the netmask of private interface in 11.2.0.3 RAC.
e.g. IPADDR=169.254.0.1NETMASK=255.255.128.0 to IPADDR=169.254.0.1NETMASK=255.255.0.0
Do I have to run any oifcfg commands?
RAC & Failsafe :: Cluster In Oracle
Apr 23, 2013Are Oracle cluster and Oracle clusterware are same and has same in meaning in RAC ?
View 6 Replies View RelatedRAC & Failsafe :: Oracle Cluster 10 Installation
Oct 27, 2010Steps for installing Oracle Cluster 10?
View 9 Replies View RelatedRAC & Failsafe :: Download Cluster Ware 11g
Jan 22, 2013I must setup RAC 11g but I haven't meta link account to download cluster ware.
View 2 Replies View RelatedRAC & Failsafe :: RMAN Backup On Cluster
Dec 1, 2011I 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
RAC & Failsafe :: 11.2.0.2 Patch For Oracle 11gR2 RAC Cluster?
Sep 29, 2010Yesterday 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 ?
RAC & Failsafe :: CRS-4535 / Cannot Communicate With Cluster Ready Services
Nov 21, 2012RAC 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]....
RAC & Failsafe :: Installing / Configuring Real Application Cluster Using NFS Instead Of ASM?
Feb 28, 2012i 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 RelatedRAC & Failsafe :: ORA-29701 / Unable To Connect To Cluster Manager
Aug 8, 2011when 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.
RAC & Failsafe :: Oracle CRS Failure / Rebooting For Cluster Integrity
Sep 7, 2013I 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.
RAC & Failsafe :: Create Setup On Oracle 10.2 Through NFS Cluster Configuration
Jun 29, 2012I 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 RelatedRAC & Failsafe :: Root.sh Fails On Oracle Cluster Installation?
Sep 7, 2011I 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 & Failsafe :: Oracle 9i - Difference Between Real Application Cluster And OPS
Jul 17, 2002What is the different between the new RAC feature - real application cluster and OPS... for me it sound the same..
View 3 Replies View RelatedRAC & Failsafe :: Cluster Does Not Recognize DBA Group Membership Assignment To User
Aug 18, 2011It 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 & Failsafe :: Failed To Upgrade Oracle Cluster Registry Configuration?
Sep 18, 2008The 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.
RAC & Failsafe :: Stopping Oracle 11g R2 Cluster Services In Windows 2008
Jan 22, 2013I 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.
RAC & Failsafe :: 11g Oracle Grid Cluster Software Configuration - Getting Error?
Jan 31, 2013While 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.
RAC & Failsafe :: Creating Cluster Resources For Oracle Enterprise Manager Using Clusterware
Oct 24, 2012My 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 & Failsafe :: Installation Error On Vmware - Failed To Initialize Cluster Registry
Nov 19, 2011RAC 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
RAC & Failsafe :: Cannot Change Owner Of Cifs Mount On Linux
Nov 6, 2008We are configuring NAS device on linux for RAC installation.
ISSUE: I had mounted NAS device to Linux server.As root user I can create directory but cannot change owner of cifs mount.It say permission denied.When I try to change permission it doesn't work.The mount point show the uid and gid as 33 and permissions drwxr-xr-x
I had mounted using the following command
#mount -t cifs storage:/ocr1 /u02/ocr1 -o username=XXXX,password=XXXX,uid=oracle,gid=dba
Permission denied
[root@SSIPL-WRKST-116 u02]# chown -R oracle:dba ocr1
chown: changing ownership of `ocr1': Permission denied
chown: changing ownership of `ocr1/ss': Permission denied
[root@SSIPL-WRKST-116 u02]#
Change owner
[root@SSIPL-WRKST-116 u02]# ls -lrt
total 0
drwxr-xr-x 3 33 33 0 Dec 4 2006 ocr1
[root@SSIPL-WRKST-116 u02]# chmod -R 777 ocr1
[root@SSIPL-WRKST-116 u02]# ls -lrt
total 0
drwxr-xr-x 3 33 33 0 Dec 4 2006 ocr1
[root@SSIPL-WRKST-116 u02]#
Data Guard :: Data Change In Metro Cluster
Oct 21, 2012Our organization has recently decided to go for storage metro cluster solution for disaster recovery. In a Data guard environment, we normally calculate how much archive log is generating and based on that value we calculate the required bandwidth.
For storage metro cluster, we need to find how much block is changing in our primary database, and the same rate of change would apply on DR cluster. Now, i need to give the assumption how much changing is happening in my system. How to calculate the change.
Unable To Create Public Synonym
May 22, 2011I have exported and imported a schema from one server to another. In the source schema, I have a public synonym. I do not know the name of that synonym. In the destination schema, the public synonym is missing. How to create the public synonym which is missing in the destination database? In the source, I queried dba_synonyms, all_synonyms... but it returns no rows selected.
View 2 Replies View RelatedSecurity :: Encrypt File With GPG Using PGP Public Key?
Oct 21, 2010I need to encrypt a file with GPG using a pgp public key I never done this, what are the commands..
View -1 Replies View RelatedPL/SQL :: Creating View And Public Synonym With The Same Name?
Feb 15, 2013I am able to create view and the public synonym with the same name but when I am quering view result is showing .
Is there any logic behind this .
CREATE OR REPLACE VIEW emp_dtls as SELECT * FROM emp;
CREATE PUBLIC synonym emp_dtls for emp;
SELECT * FROM emp_dtls;
view result is showing
SQL & PL/SQL :: How Make Complete Schema Public Synonym
Apr 15, 2013how to make the complete schema public synonym, instead of creating public synonym object by object.
View 2 Replies View RelatedApplication Express :: Deletion Of Public Reports In 4.0?
Sep 4, 2012As far as I know, in APEX 4.0 no other user other than the one who created a Public report can delete it. Can this behavior be changed somehow?
View 3 Replies View RelatedSecurity :: Grant Privileges To Public User
Jul 9, 2011grant insert,update,delete,select on staging_tb1 to public;
What is public here? i know something about public user like it is users exist in the database .