RAC & 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
ADVERTISEMENT
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 :: 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 :: Change Cluster Interconnection From Public To Private?
Jul 3, 2013how to change the cluster interconnection from public to private.
View 6 Replies View RelatedRAC & 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
Reports & Discoverer :: Middle Ware Web Logic Server
Aug 9, 2013I installed web logic server and form & report on my linux system and gave configuration option later . so now web logic admin server is running on different port and wls_reports server is running to different port in cluster. How its running on cluster and when i run
localhost:9002/reports/rwservlet/getserverinfo?server="report_server_name" i am getting rep-51002 error.
Where To Download OUI Installer
Feb 5, 2012I'm studying to 1Z0-052 and i want to know where can i download the OUI for oracle 11g.Actually, i'm using this oracle version:URL....Also, oracle site has this: URL.... Where can i download the OUI Installer? or am i using the correct one?
View 1 Replies View RelatedFrom Where To Download Oracle 9i?
Dec 4, 2010from where I can download Oracle9i ?
View 2 Replies View RelatedStopping Cluster Along With HAS?
Sep 17, 2013I 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.
XE :: Download And Use Version For Mac Using OS X 10.4.11
Jun 14, 2012Can I download & use a version for a Mac using OS X 10.4.11?
View 1 Replies View RelatedOracle 10g R2 Download
Jul 17, 2012I needed to use oracle 10g R2 (for any of following platforms : Windows 7/2008/Linux) as I am preparing for my 10g DBA OCP certification. But when I go to Oracles site for download it shows only the 11g not 10g.
View 46 Replies View RelatedDownload Oracle BI Publisher 10?
Jan 25, 2013I am working on Oracle Developer (Forms/Reports). I want to learn Oracle BI Publisher 10.Whenever i try to download BI Publisher 10 (Win 32 bit) from the below link,
[URL]....
it stops after about 30 minutes. As per the the Internet speed it takes about 45-60 minutes to complete such file.I tried multiple times but not able to download this file.
Scan In 4 Node Cluster
Jun 24, 2013We 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 RelatedDownload Oracle Database 10g
Aug 3, 2012I need download the Oracle 10g to do some migration tests, but isn't not available in oracle website.
View 1 Replies View RelatedHow Long Will It Take To Get Download Link
Mar 24, 2011i just bought the oracle scripts from rampant. any know how long will it take for me to get the download link. for these scripts...
View 3 Replies View RelatedForms :: Oracle 9i Download
Sep 8, 2010Provide me links for Oracle 9i forms to download. i am unable to find in Oracle site.
View 1 Replies View Related
