Clusterware :: Extended RAC / Quorum And Storage On Different Networks?
Mar 5, 2013
We use extended RAC 11gR2 on two servers in two different server rooms.Data are stored on ISCSI devices, mounted from "storage" linux hosts on a network called "SAN".Third voting disk is also stored on a ISCSI device mounted from a "quorum" linux host on our "PUBLIC" network.The RAC interconnect link is on a separate "PRIVATE" network.
During tests, when we totally disconnect the "SAN" link between the two servers, clusterware has an undefined behaviour.Sometimes (more often) it crashes, sometimes one node stays alive.At this moment, each RAC server is able to access only the ISCSI storage in its own server room, and the two servers are able to access the third voting disk (because it is on a separate network).
View 0 Replies
ADVERTISEMENT
Dec 11, 2012
I am having 2 data centers within 1/2 km distance. And we kept each vote disk in once site. In case of site failure, the cluster needs a 3rd set. We don't have 3rd site.
Last open world, Oracle announced that oracle storage on cloud as announced. If I get the small space on the cloud, can i put my 3rd vote disk on the cloud?
View 1 Replies
View Related
Oct 29, 2013
About the concept of quorum failgroup ORACLE says:QUORUM disks, or disks in quorum failure groups, cannot contain any database files,the Oracle Cluster Registry (OCR), or dynamic volumes. However, QUORUM diskscan contain the voting file for Cluster Synchronization Services (CSS). Oracle ASMuses quorum disks or disks in quorum failure groups for voting files wheneverpossible.
To sum up, i think the different between a regular failgroup and a quorum failgroup is a quorum failgroup can only contain vote files and a regular one can contains multiple kinds of files.So i didn't see any advantage to place voting files on a quorum failgroup than on a regular one. Why Oracle introduce the concept of quorum failgroup?
View 2 Replies
View Related
Aug 6, 2012
I am trying to install Oracle RAC 11g on Oracle Linux via Virtual Box. My host server is windows. How to create shared storage on windows?
View 5 Replies
View Related
Sep 30, 2013
We have two database servers(10g with OEL 5) to be clustered and two visible disk groups to each of those nodes. So question is can we choose only one disk group as a shared storage leaving the rest one as the redundant copy during database a creation window while installing the database. Because some of us argue that oracle database has a built-in capability to decide on what level of RAID we store our data.
View 7 Replies
View Related
Mar 1, 2013
My organisation is currently discussing different storage options for the database storage. Our production database is nearly 2TB and we do not want to continue with the existing NetApp storage (we use a 2 node RAC running 11.2.02 with nfs filesystem from NetApp filer).
We were looking at different options and came across Nimble Storage, they are very fast growing company aiming mid-range storage customers. The initial talks and demonstration looked very promising in terms of IO performance (they claim 40,000 - 60,000 IOPs for their CS400 series Nimble Storage array) and other options they are providing but we understand that majority of their customers are using it for VDI and other infrastructures.
They have demonstrated us using if for Oracle database with ASM storage over iSCSI LUNs. We are yet to do the POCs and benchmarking.
Has anyone come across Nimble Storage for running Oracle databases?
View 3 Replies
View Related
Aug 24, 2010
I have a database in which DB extended auditing is enabled but there are no audit specifications in privileges or statements or objects. So what will be audited in that case.
View 12 Replies
View Related
Jan 27, 2011
I have requirement to convert the extended ascii to character. Is there any function available .
View 9 Replies
View Related
Sep 19, 2013
I have a table like mentioned below
create table test1( test_no number, test_description varchar2(100));
insert into test1 values (1,'ABC£¥');
insert into test1 values (2,'BCD£¥');
Now I am selecting from the above table and the expected rest it should have shown is as shown below
TEST1
-----------------------
TEST_NO TEST_DESCRIPTION
1 ABC£¥
2 BCD£¥
But instead of showing the extended ascii characters, it is showing some different characters as shown below
select * from test1;
TEST1
-----------------------
TEST_NO TEST_DESCRIPTION
1 ABCLY
2 BCDLY
I have an requirement where i need to fetch the exact ascii characters for £ and ¥ instead of L and Y respectively.
View 1 Replies
View Related
Nov 2, 2012
I have the following DDL:
drop table tmp_guid;
CREATE TABLE tmp_guid (
c1 raw(16) not null
,c2 raw(16) not null
);
begin
[code]...
It seems that a combination of a unique index and extended stats are to blame. Removing any one of them causes the query to also produce correct results.Extended stats basically captures the fact that despite being unique, c1 depends on c2.
View 0 Replies
View Related
Mar 15, 2013
I'm trying to create star schema via extended analytic from work space but getting below error
'Invalid Extn Analy templete label. Please provide a valid template label. '
I followed all steps provided on
[URL].........
View 2 Replies
View Related
Nov 29, 2012
i am trying to replicate sdo_geometry datatype object using oracle11gr2 streams but the capture process didnt capture the change made on the table.
View 2 Replies
View Related
Jul 26, 2010
i'm facing a problem while i'm inserting millions of record from table to table that undo tablespace reach 100% full and execution aborted. , how can free the undo tablespace ??? many of extendes are offline. will it flush automatically ??? or what i should do
View 4 Replies
View Related
Mar 8, 2007
I'm trying to insert a character from the extended ascii character set. Specifically, there's a company that has an accented e (�) in the name. Right now, the company name doesn't have the e at all, accent or no accent. So I'm trying to do an update, something like
update table1 set company_name='blah�" where company='blah'
It runs, but doesn't do the update. Even when I try to forcefully do an insert (instead of an update) I get nowhere; the accented is simply dropped. So the basic question is, how do you insert extended ascii characters into oracle?
View 3 Replies
View Related
Oct 4, 2011
we are moving datacenter from one place to another where existing datacenter has got ASM(RAC env) with HP storage which needs to be moved into target datacenter for EMC storage.basically How ASM can be disassociate from source HP storage then associate target EMC storage with very minimal down time.
what are all the ways and all step by steps required for the same.
View 1 Replies
View Related
Dec 23, 2012
How password value is stored in 9i/10g/11g internally and how to retrieve those password values ?
View 1 Replies
View Related
Oct 9, 2012
I am an Oracle dba new to xml db,we have binary storage with 4schemas ,Right now indexing on 2gb table takes like 20GB on Path table and secondary xml index.
I want to change the table storage without disturbing the application development just the xml type column into Object relational and merged all the 4xml schemas into master schema.
Right now i want to insert the data from old tables which had different URL . How I can improve performance without having 20Gb on secondary index objects.
View 1 Replies
View Related
Aug 29, 2013
In one of the book (Personal Oracle Real Application Clusters: Create Oracle 10g Grid Computing) I have seen the detailed explanation to configure Oracle 10g RAC on external disk- MAXTOR A01A200.
Is it possible to configure Oracle 11g Release 2 RAC with two node using MAXTOR disk?
or Is there any other external disk available which I can use it as a shared storage?
View 2 Replies
View Related
Feb 4, 2011
I need a 2-3 TB storage server group for Oracle Database. We want SAN Storage & Server for Oracle Replication, but not Microsoft Storage Server.
For example : HP DL380 G6 as a server and EMC CLariion CX4 120 as a SAN Storage etc...
We have an option, but want some others. What do you recommend for a Server & for SAN Storage (Make & Model) to use for Oracle Replication?
View 2 Replies
View Related
Aug 9, 2013
I wanted to setup a two node 11g RAC with ASM at my home for learning purpose. I have read many documents to configure shared storage using NFS, Openfiler, VMsetup etc. Is there any hardware available (something like maxtor disk) which is not much expensive to setup a shared storage ?
View 3 Replies
View Related
May 11, 2005
I need to extract DDL's without storage parameters. if i use the export and import using indexfile or if i try to extract using the DBMS_METADATA.GET_DDL package , in both ways my output is with the storage parameters
eg:
CREATE TABLE "SEPT"
( "DEPTNO" NUMBER(2,0),
"DNAME" VARCHAR2(14),
[Code].....
View 6 Replies
View Related
May 25, 2012
what type of storage is supported by ASM? I know of RAW storage but does it run on something else?
We are running on Power7, AIX 6.1.
View 1 Replies
View Related
Sep 9, 2013
Database Version is 11.2.0.3 & OS version is RHEL5. How can I find the OS storage type? Which command should I execute to find this?
View 3 Replies
View Related
Jul 26, 2013
Some shops run Oracle RAC using "conventional" storage, like emc, netapp, etc. Some shops run Oracle RAC using JBOD, just bunch of disks, all redundancy is managed by ASM.
How would you distinct these two approaches? JBOD approach sounds cheaper, so why serious enterprises are still using traditional conventional storage, like netapp and emc?
View 1 Replies
View Related
Dec 23, 2012
Sequence nextval is a pseodocolumn, but where the value of nextval is stored and why before we use CURRVAL for a sequence in our session, we must first initialize the sequence with NEXTVAL?
View 5 Replies
View Related
Oct 26, 2006
I am new to oracle which command do I use to set the file storage in oracle? I learnt the we have the option of specifying the storage pattern as per our queries.
View 2 Replies
View Related
Sep 3, 2009
I am using the below command,
lv_ret := WEBUTIL_FILE_TRANSFER.AS_To_Client_with_progress(lv_clnt_file, lv_srvr_file,
'Download from Application Server in progress', 'Please wait');
to download a file to my H: drive.Here lv_ret is a boolean variable.The file is not downloaded to my H drive when there is no enough space.How to capture that error?
View 1 Replies
View Related
Jun 20, 2011
DB: Oracle 10g R2
OS: SUSE Linux SP 1 x864
We are maintaining a DR of our Database Server(oracle 10g R2 atop SUSE SP1 Linux) using Platespin(
[URL]......
Platespin is set to replicate(block based), incremental data(delta) every 1.5 hour from Production to DR site over a 30 Mbps dedicated fiber link.
Our maximum changes of data per day(during business hours) wont exceed 300 MB. During business hours Platespin replicates at least 1 GB at every replication cycle, while during off hours it replicates 300 to 500 MB per replication cycle. We are facing this strange issue with this box only(SLES 10 SP1 + Oracle 10g R2), we have protected MS Exchange 2007 Server based workloads without this strange issue, i.e in case of Exchange only delta replicates from Production server to DR site on Platespin.
Platespin support says us that Oracle re-indexes its database for better performance, so it is possible that re-indexing causes the blocks level changes on the storage, and since Platespin works on Block level, thats why it replicates so much(even though data is not changed that much)
here is actual words of Platespin support
<snip>
I think whenever Oracle database Indexing happens, it changes almost most of the Blocks of database and Platespin replicate all those Blocks.
As you know, Platespin checks the Date/Time attribute of every blocks before replication and if Date/Time attribute changes from last replication, it considers as changed block and replicate those blocks on Platespin Appliance. So, my suggestion is just look into the Oracle server behaviour before/after Data indexing process and do needful or do some workaround to overcome this issue.
</snip>
is there anything we can do at oracle level ?
View 1 Replies
View Related
Jan 5, 2008
I am having an issue with the LOBs in our Database. Our production DB is about 71G right now - if i do export/import using the DataPump - I see the data volume becomes 40G. I am sure its because of the LOBs in my Database. Our application uses lots of LOB datatype and I think the space is not being released.
The challenge is I cant do a full export/import in my Production DB as its a 24/7 system and to do export/import I need min. 5 hrs - which my business will not permit. I can I claim the unused space here. I have used Segment Advisor - but it has only given me 6G of space gain.
Is there any script I can try to use to reclaim space in the database.
View 4 Replies
View Related
Apr 10, 2008
Let me explain in detail. I have three tables
1. Emp Table: Columns-> EMPID and DeptID
2. Dept Table: Columns-> DeptName and DeptID
3. Team table : Columns -> Date, EmpID1, EmpID2, DeptNo.
There is a stored procedure which runs every day, and for "EVERY" deptID that exists in the dept table, selects two employee from emp table and puts them in the team table. Now assuming that there are several thousands of departments in the dept table, the amount of data entered in Team table is tremendous every day.
If I continue to run the stored proc for 1 month, the team table will have lots of rows in it.
The real problem is when I want to retrive data for a employee(empid1 or empid2) from Team table and view the related details like date, deptno and empid1 to empid2 from emp table.
How do we optimise the data retrieval and storage for the table Team. optimize the query and data retrieval time from Team table.
View 4 Replies
View Related
