RAC & Failsafe :: LUNS Allocation To RAC

Dec 18, 2011

We are planning the RAC installations. We are allocate 3TB on HP SAN Storage to be used to setup rac environment with 2 nodes.

Question.

1. Do we accept one 3 TB from SAN engineers or ( Which RAID)
2. Multiple Luns totality to 3 TB.
3. Remember this is 11g R1 OCR and VOTING DISK cannot be managed by ASM.

View 3 Replies


ADVERTISEMENT

RAC/ASM Clusterware Installation :: Size Of LUNs For ASM

Nov 11, 2013

ENV: Oracle 10g R2 EE on ADM, RHEL 5.8 64bit 

Is there a difference performance wise if ASM gets two LUNs of 1.7TB (DATA) and 0.6TB (FRA) respectively compared to 17 LUNs of 100GB each (for DATA) and 6 LUNs of 100GB each (for FRA)? Is there a recommended size from Oracle? 

View 6 Replies View Related

SGA And PGA Size Allocation?

Nov 21, 2012

I Have a server System Configuration with

RAM size: 16GB Ram & Hard disk Size of 1TB.

I Installed Oracle 11g R2 in the server SystemI want to Allocate Dedicated Memory for oracle..How Should i calculate the Memory size of SGA+PGA for good Performance..

View 2 Replies View Related

Allocation Unit And Striping Attribute

Dec 21, 2012

difference between stripe attribute and the AU size.The ASM distributes the data in AU in the disk, and what the role of strip size in this case?

View 2 Replies View Related

Performance Tuning :: Memory Allocation In 11 G?

Jun 10, 2013

I am using 11g version, and trying to understand the Memory Allocation.

1) The new feature Memory target parameters are dynamic? is in it? But when I set with the ALTER SYSTEM... it was not changed, then I had to restart the DB.

2) With the new 2 parameters (MEMORY_MAX_TARGET, MEMORY_TARGET), the SGA_MAX_SIZE parameter should be 0, right? But in my case, the SGA_MAX_SIZE value is automatically assigned.

View 5 Replies View Related

PL/SQL :: Calculating Inconsistency In Associate Allocation?

Oct 17, 2012

[URL] ...... Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product

I have the following table

CREATE TABLE  "ALLOCATEASSOCIATES"
   (     "PROJID" VARCHAR2(30) NOT NULL ENABLE,
     "ASSOCIATEID" NUMBER(*,0) NOT NULL ENABLE,
     "ALLOCATIONSTARTDATE" DATE,
     "ALLOCATIONPERCENT" NUMBER(*,0),
    
[code]...

Given that
1. An associate must be allocated to at-least and a maximum of 100% at any given point of time
2. User selects 2 dates between which inconsistency of allocation needs to be displayed

If the end user selects 1st Apr 2012 and July 31st 2012 between which reports needs to be generated, am looking for the following output

ASSOCIATE_ID FROM_DATE TO_DATE ALLOCATION_INCONSISTENCY
2 01-APR-12 15-APR-12 75
2 16-APR-12 15-JUN-12 25
2 16-JUN-12 30-JUN-12 50

The Allocation_Inconsistency denotes that the associate has a deficit of allocation between the 2 dates. The associate with ID 2 has a deficit of 75% of allocation from 1st Apr 2012 till 15th Apr 2012. Similarly 25% deficit between 16th Apr 2012 and 15th June 2012 and so on so forth. However, there is no allocation deficit for the month of July as he is allocated 100% for this month and hence is not appearing in the expected output.

View 5 Replies View Related

Oracle SGA Components Manual Allocation

May 13, 2013

Phyical memory : 420G My database version : 11.2.0.3 running on linux machine.

Memory_target = 200G . I would like to allocate this value to following SGA components. I don't want to automatic memory management enabled. how to split 200G for following components. Is there any percentage for each components ?

db_cache_size
db_recycle_cache_size
db_keep_cache_size
large_pool_size
java_pool_size
shared_pool_size
pga_aggregate_target
streams_pool_size
log_buffer

View 10 Replies View Related

Allocation Of Memory In Standard 10g Or 11g Install

Jan 17, 2013

I wanted to know what is the standard memory allocation for SGA & PGA in a normal installation of Oracle database 10g or 11g? Are the figures of 270M and 90M standard for a 10g or 11g installation using automatic memory management feature?

View 9 Replies View Related

SQL & PL/SQL :: Rows To Columns With Dynamic Allocation Column Names

Nov 16, 2012

I want the output from two tables with rows to columns and generate dynamic basing on the columns.

For example: Table A (a1) , Table B(a1,b1)

Data: A B
------ ----
a1 a1 b1
--- ---- ----
1 1 x
2 1 y
3 2 a
2 b
2 c

o/p: Columnname col_1 col_2 col_3
-----------------------------------------------
a1 b1_1 b1_2 b1_3
----- ---------------------
1 x y
2 a b c

Columns should be generated based on the second table second column.

View 18 Replies View Related

Server Administration :: Change Space Allocation For Character Columns In Database

Oct 24, 2012

I want to change space allocation for character columns in my database, So it will store them as 'CHAR' and not 'BYTE'.my character set is

SQL> SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET';
VALUE
----------------------------------------------------------------
AL32UTF8
SQL> alter system set NLS_LENGTH_SEMANTICS='CHAR' scope=both;

System altered.I bounced the instance just to make sure

System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

Connected to an idle instance.

SQL>
SQL>
SQL> startup
ORACLE instance started.
[code].....

And then I want to see that when I create a table with some varchar2 column,The space for it will be allocated by chars, and not by bytes! However, when I run a check of create table, this is what I get:

SQL> drop table check_char;

Table dropped.

SQL> create table check_char (some_name varchar2(10));

Table created.

SQL> select a.char_used
2 from all_tab_columns a
3 where table_name='CHECK_CHAR'
4 and a.owner='SYS';

C
-
B
SQL>

What is the reason for space allocation to remain in BYTES and not CHAR, or what else I can check?

View 4 Replies View Related

Backup & Recovery :: RMAN-12010 / Automatic Channel Allocation Initialization Failed

Nov 15, 2011

while executing a clone script i got the below error : -

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/15/2011 20:07:34
RMAN-12010: automatic channel allocation initialization failed
RMAN-06758: DB_UNIQUE_NAME is not unique in the recovery catalog

Here i understand that RMAN couldn't find which SPFILE to use to restore the target DB.

How do i check for the DB_UNIQUE_NAME in recovery catalog?

The proposed solution that i found was Use the FOR DB_UNIQUE_NAME option to specify the name of the instance whose parameter file you want to restore. how to implement this in my clone script?

View 7 Replies View Related

RAC & Failsafe :: CRS Is Not Starting?

Oct 13, 2011

I am getting problem while starting the CRS. Below is the necessary details:

1) I am using oracle 11g R2 RAC, with 2 node named RAC1 and RAC2

2) I have 3 diskgroup named DATA, DATA1, DATA2

3) OCR and voting disks are stored on ASM diskgroup

On node RAC1, CRS is started and /etc/oracle/ocr.loc is having the below entry:

ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA1

On node RAC2, CRS is stopped and /etc/oracle/ocr.loc is having the below entry:

ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA2

note the difference in "ocrmirrorconfig_loc". The difference was occured because I updated the OCR location on RAC1 when RAC2 was down.

Now I am trying to repair the RAC2 using below command. This command must be run as root user when HA service is started but CRS must be stopped.

ocrconfig -repair -replace +DAT2 -replacement +DATA1

but this showing error "PROT-21: Invalid parameter", because to run this command diskgroup must be mounted. But diskgroup cannot be mounted until the CRS start. SO this is a conflicting situation.

View 4 Replies View Related

RAC & Failsafe :: DB Migration To New SAN?

Apr 30, 2012

We have to perform migration for our RAC database to new SAN that is at new data centre. Since OS is IBM AIX, we can take backup from mksysb for VG and and storage will migrate data from OLD SAN to NEW SAN.

But even we restore VG and SAN data but since our old SAN is emc and new SAN is hitachi, so disk path for all the asm disk group will be changed.

So is there will be any way to rename this disk path for disk group..

View 1 Replies View Related

RAC & Failsafe :: How To Implement Non-RAC

Jan 12, 2013

We have an Implementation of Non-RAC (Single Instance with Existing ASM-RAC as storage) and below is the Details,

The client have a Real Application Cluster configuration on their AIX Server from there Data Center and they want to implement a Single instance Database that will used ASM as Storage and the storage or Disk that they want to use is the same Disk or Mirror copy of the Disk from their RAC Database.

Scenario:
-The AIX Server that they have is a one-way Hardware Mirroring (PPRC) only and it is not designed to run a 24/7 activity.
-DATAGUARD is not an option.

View 5 Replies View Related

RAC & Failsafe :: Add 3 More RAC Node

Jul 14, 2011

I have 2 node 11gR1 running on Unix, I want to add 3 more RAC node to it. What are all the steps involved and should I first add 3rd node and then the 4th node or I should add both at the same time? is there any difference between these two methods?

View 1 Replies View Related

RAC & Failsafe :: Software Version In RAC

Jul 14, 2013

I heard, in RAC environment both clusterware software and oracle software should have similar version.how to find the version of both softwares ?

View 2 Replies View Related

RAC & Failsafe :: Rshd And Rexecd?

Jan 28, 2013

Do we need to start rsh and rexec services in oracle 11gR2 RAC database servers? Is it required to setup and run RAC database?

View 1 Replies View Related

RAC & Failsafe :: Dynamic Remastering In 11g R2

Jan 2, 2012

finding out which instance is the resource master of a object.Also select * from V$GCSPFMASTER_INFO

returns zero rows.

Does this mean dynamic remastering is disabled???if so which instance will own a object?

View 1 Replies View Related

RAC & Failsafe :: Difference Between RAC And Non-RAC Database

Sep 13, 2012

Tell me the difference between Oracle RAC and Non RAC database including commands and architecture?

View 4 Replies View Related

RAC & Failsafe :: Changing VIP In RAC Node?

Nov 16, 2011

I need to change Virtual IP for one of my RAC node as it is conflicting with another server's IP.

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

RAC & Failsafe :: RPM For Oracle Installation

Nov 28, 2010

i need to make RAC database setup ,so where can i get the operating system Rpm like bleow

compat-gcc-7.3-2.96.128.i386.rpm
compat-libstdc++-7.3-2.96.128.i386.rpm
compat-libstdc++devel-17.3.3.96.128.i386
compat-gcc-c++7.3.296.128.i386

send me link for the above require rpm for linux AS4.

View 1 Replies View Related

RAC & Failsafe :: Can Just Install CRS Only If OS Crashed

Aug 3, 2012

we have RAC database on two node here on windows server 2008 unfortunately today morning my one my one node os crash its on windows server 2008 my other node its working ok so my database is accessible so i just want to ask if i install again this os on node -1 system so i just want to install only again crs only.because my database is accessible through my other node-2

View 6 Replies View Related

RAC & Failsafe :: Adding New ASM Disk

Dec 23, 2012

I have DB on cluster and it set to active/active. ASM disk currently using raw device and connect to SAN storage. So i want to add new ASM disk on current environment.

Does oracle have this doc? What i can see from their said just show adding new ASM to new installation. Does it same as adding new ASM disk to current system? Does it success on implementation?

View 1 Replies View Related

RAC & Failsafe :: ASM Configuration For Servers?

Jul 8, 2011

I get following error when i'm configuring ASM.

I'm using Enterprise Linux and Oracle 11.1.0.6.0

[U]Note:[/U]
[root@RAC1 ~]# rpm -qa|grep asm
oracleasm-2.6.9-78.0.0.0.1.EL-2.0.3-2
oracleasm-support-2.0.3-2

only these two packages in my server. should i have to install oracleasmlib??

[root@RAC1 ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets ('[]'). Hitting <ENTER> without typing an answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Fix permissions of Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: [ OK ]
[B]Loading module "oracleasm": Unable to load module "oracleasm"
[FAILED][/B]

I don't have this package in my installation cd, when i searched in the web i could not find

View 2 Replies View Related

RAC & Failsafe :: SCAN IP For Oracle 11g R2?

Sep 1, 2011

I am planning to install oracle RAC 11g R2 on RHEL 5.3. I have 2 RAC nodes and one openfiler NAS. I need to understand how will I configure SCAN IP. Do I need to configure it some where in DSN and OS level or just I need to give this IP and SCAN name while grid install and oracle will create these things?overall steps to configure this or direct me to some documentation where this thing is detailed.

View 6 Replies View Related

RAC & Failsafe :: Upgrade 10g To 11gR2 RAC On AIX?

Aug 26, 2011

Is there any document available for 10g to 11gR2 RAC upgrade on AIX?

View 1 Replies View Related

RAC & Failsafe :: Error While Configuring Css?

Jul 23, 2011

i got a problem while configuring asm in linux operation system for practice purpose and it troughs error the folllowing details are as fallows.

operting system = oracle enterprise linux 5
software =oracle 10g version= 10.1.0.2.0
oerating system kernel parameters=2.6.18-194.el5PAE

when i'as issuing commed(Localconfig add) on root users i'm getting the following error
[root@prod ~] localconfig add
/uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 392: /etc/init.d./init.cssd : no such file or directory
/bin/rm: cannot remove '/etc/init.d/init.cssd' no such file or directory
/uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 402: /etc/oracle/ocr.loc no such file or directory
in/rm : cannot remove /etc/oracle/ocr.loc' no such file or directory
bin/rm: missing operand
try '/bin/rm --help for more information

solution i tried for this errror
1.i tried to locate lidbl.so.2 libraies using locate libdl.so.2 and cpoied to location create soft link but still its the same error.
2)i tried ti install rpm pakages for kernel 2.6.18-194.el5PAE but still same eror.
3)i export the library path in bash_profile but still i got same problem

View 1 Replies View Related

RAC & Failsafe :: Upgrade From 10g To 11gr2?

Jul 20, 2013

up gradation steps from 10g RAC to 11gr2 RAC.

View 1 Replies View Related

RAC & Failsafe :: Sap Backups From Node 207

Aug 11, 2011

I am having an issue when trying to run a backup from node 207...Initially When trying to run the backup I got this error.

scrbdefrmr207:orarer 54> brbackup -u / -c force -t online -m all -p initRER_online.sap
BR0051I BRBACKUP 7.00 (40)
BR0055I Start of database backup: begnlswy.anf 2011-08-11 21.29.08
BR0484I BRBACKUP log file: /oracle/RER/sapbackup/begnlswy.anf
BR0477I Oracle pfile /oracle/RER/102_64/dbs/initRER001.ora created from spfile /oracle/RER/102_64/dbs/spfileRER001.ora

BR0280I BRBACKUP time stamp: 2011-08-11 21.29.13
BR1351I Configuration of database services:
RER001 PREF: RER001 AVAIL:
RER002 PREF: RER002 AVAIL:
DVEBMGS50_scrbdefrmr207 PREF: RER001 AVAIL: RER002
DVEBMGS50_scrbdefrmr208 PREF: RER002 AVAIL: RER001
[code]....

I have many other rac servers and sids setup this way and they all work,,I can login to sqlplus and do any changes .. no issues going into sqlplus in node 207 and node 208..I have checked the directory i.e mesg and teh files are there ..

scrbdefrmr207:orarer 56> pwd
/oracle/RER/102_64/sqlplus/mesg
scrbdefrmr207:orarer 57> ls
cpyus.msb cpyus.msg sp1us.msb sp1us.msg sp2us.msb sp2us.msg

I think the message is decieving as it complains about oracle home and sp1<lang>.msb not found ,, when i tis there.I have also checked my env variables .. they all there i.e

scrbdefrmr207:orarer 58> env |grep ORA
dbms_type=ORA
ORACLE_SID=RER001
ORACLE_HOME=/oracle/RER/102_64
ORACLE_BASE=/oracle

scrbdefrmr207:orarer 59> env | grep LD_
LD_LIBRARY_PATH=/usr/sap/RER/SYS/exe/run:/oracle/RER/102_64/lib

I an run archives log backups perfectly.. So its only when its trying to connect into the db.

View 4 Replies View Related







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