RAC For Separate Node's Physical Location

Mar 21, 2012

I would like to implement Oracle RAC with 2 nodes for SE Licence. I did a lot when both this nodes with 3 NICs each were plugged at the same switch. Now I have a need to construct a RAC when two nodes will be in separate locations, abot 4 miles from each one. What should I explain to our network administrator he needs to do to implement this solution? I've been told that they can do a FO channel to each location. But don't have exact clear explicaton.

View 3 Replies


Archivelog Location In Separate Date Format

Nov 10, 2013

archive logs to be stored in its own "date formatted" separate folders.I have already configured flashrecovery area and I dont want to change it as backups are stored there.How can I achieve this without changing the flash recovery area location ? db_recovery_file_dest is set to G:log archive dest is set to F

View 8 Replies View Related

RMAN :: Looking At Different Location To Restore On Physical Standby (10g)

Feb 12, 2013

I have 2 databases. Primary ( DB1 ) and Standby ( STBY1 ). My standby database went kaput, and i have as a result deleted the standby database in order to re-create it from a full primary backup.

Oracle 10g R2 on Server 2003.

I have followed several guides, and at this time i have done the following:

- Configured standby re-do logs on primary
- backed up current controlfile for standby
- backed up database plus archivelog
- configured the tnsnames

The problem is here. I connect to RMAN from standby

rman nocatalog
connect target sys/password@ DB1
connect auxiliary /
set until scn xxx;
duplicate target database for standby dorecover;

I receive an error message saying that it cannot find the file location of the backups that its trying to find. I see in the error that it tries to look locally for

E:FLASH_RECOVERY_AREA DB1 BACKUPSET2013_02_12), however the actual location is (E:FLASH_RECOVERY_AREA STBY1 BACKUPSET2013_02_12)

I have read that the locations need to be the same, however the instance names are different, and i thought i changed the pfile to accommodate that. My assumption is that i have made an error in the pfile. However i cannot see any issues there. Some things that i have changed in the pfile for standby:


View 2 Replies View Related

RAC & Failsafe :: How To Prevent VIP Transfer Back To Its Original Node Location

Nov 11, 2012

Normally if node fails, VIP & resources are transferred to another node (clients need to failover).

if node is back again CRS detect this, make it as 'family member' and try transfer VIP & resources back to this node (clients will force to failover again).

this failover (despite of failover method I use) make each uncommitted transaction to be rolled back. client need to be disconnected from the service and VIP through they are connected to this service and they need reconnect to the new node - during this stage all DMLs modifications are gone, and need to be re execute.

View 11 Replies View Related

Impdp Speed Differ From Location To Location

Oct 4, 2013

We have taken export expdp backup from prod database (primary database- Data Guard).

1.) Import impdp is very slow 10GB/Hrs on staging database (Data Guard MAXIMUM AVAILBILITY)Since Server configuration, database version and configuration, operating system everything are same as production. No blocking, locking or waiting sessions

2.)import impdp is fast 90GB/Hrs on Test standalone database and this test database is running in NOARCHIVE LOG mode with oracle standard version after that no more difference.

CPU,Memory,network and disk I/O are look normal while importing on both databases.why that much difference on import.

View 1 Replies View Related

Difference Between (ocrconfig -export Location) And (ocrconfig -manualbackup Location)?

Aug 13, 2013

what is difference between "ocrconfig -export location" and "ocrconfig -manualbackup location"

View 1 Replies View Related

RAC/ASM Clusterware Installation :: Query On Adding New Node To Existing 2 Node Cluster

Jun 15, 2012

current environment

Oracle VM 2 Node RAC cluster
Oracle 11G
Oracle 11g rel 2 GI

on current 2 node cluster we have GI and RAC db configured Nodes: vmorarac1,vmorarac2

we shutdown vmorarac1 to clone it to vmorarac5

on new node I have changed the hostname to vmorarac5 In /etc/sysconfig/network-scripts/ifcfg-eth0 change ip to new ip and same for /etc/sysconfig/network-scripts/ifcfg-eth1,

mad echanges to /etc/hosts on vmorarac1/2 for 2 new IP address assigned to vmorarac5 vmorarac1.pbi.global.pvt vmorarac1 vmorarac1-priv.pbi.global.pvt vmorarac1-priv vmorarac1-vip.pbi.global.pvt vmorarac1-vip


Query is is that all ok to reboot the new node to reflect changes as below and change the hostname to vmorarac2 vmorarac2.pbi.global.pvt vmorarac2 vmorarac2-priv.pbi.global.pvt vmorarac2-priv vmorarac2-vip.pbi.global.pvt vmorarac2-vip

hostname change in /etc/sysconfig/network

On new node vmorarac5, there is alreay software for RAC DB and GUI cloned from vmorarac1

addnode.sh is used to add existing node, but as part of pre-requisite configuratoin is there any config step missing

View 3 Replies View Related

Data Guard :: How To Find Apply Node In RAC Two Node Standby DB

Aug 16, 2013

I believe, in a multiple RAC Physical Standby nodes only one node applies the archivelogs to the standby database. How you can find which node is the APPLY NODE using a SQL query?

I know you can veiw this information by querying the standby configuration using DGMGRL but how would you find out this information from a remote client using SQLPlus/PLSQL?

View 2 Replies View Related

RAC & Failsafe :: Migrating Single Node Database To New 2-node Environment

Jan 24, 2011

We have oracle database 10g( running on AIX 5.1. we have installed 2-node RAC on another server AIX 6.1 . Now we want to migrate our single node database to new 2-node rac environment. how we can move/migrate/cluster-aware our single node database to 2-node rac?

View 3 Replies View Related

RAC/ASM Clusterware Installation :: VIP Node Application Failing In Second Node

Jul 18, 2013

I am installing Oracle 10g Clusterware in RHEL 5 Server. When i run root.sh in the second node the last step Running vipca(silent) for configuring nodeapps failed. Then i run VIPCA manually in second node and configured vip configuration successfully,but when i checked the post-checks for cluster services the Checking existence of VIP node application,Checking existence of ONS node application and Checking existence of GSD node application in second node failed. I am able to ping both the servers one another with vip name successfully and the CSS,CRS and EVM appears healthy in both nodes. 1. Does the vip configuration is proper? If no what is causing this error and how to rectify it? Find the output below

[root@Rhel52 bin]# ./crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthy[root@Rhel52 bin]#[root@Rhel52 bin]# clear[root@Rhel52 bin]#[root@Rhel52 bin]# ./crs_stat -tName           Type           Target    State              Host------------------------------------------------------------------------------------ora.rhel5.gsd  application     ONLINE    ONLINE      rhel5ora.rhel5.ons  application     ONLINE    ONLINE      rhel5ora.rhel5.vip  application      ONLINE    ONLINE       rhel5ora.rhel52.gsd application    ONLINE    ONLINE     rhel52ora.rhel52.ons application    ONLINE    ONLINE     rhel52ora.rhel52.vip application     ONLINE     ONLINE      rhel52 [root@Rhel52 bin]#./runcluvfy.sh stage -post crsinst -n 


View 0 Replies View Related

RAC & Failsafe :: Single Node RAC - Configure Only One Server Instead Of Two Node?

Sep 13, 2012

I would like get more details about single node RAC.. What is single Node RAC?..

1). just configure only one server instead of two node... same RAC installation.. cluster installation and shared disk configuration in single server itself.. in future we can add node to this ...
2). in 11gR2 having new feature Single Node RAC.. Multiple instances running on same node and configure using Cluster...

is there any advantage using single node rac(other than online upgrade to full RAC).

View 3 Replies View Related

Add Third Node To Existing Two Node Cluster

Feb 3, 2012

I'm trying to add the third node to my existing two node cluster. In fact i succeded adding the node but i have the following problem:

-when i start node 1 and 2, everything is ok, but on node 3 startup one of the other nodes fails
-this happens in any combination: start 1 and 3, everything is ok. when i start node 2, node 3 fails

The asm configuration (disks, permissions, etc) is the same on all three nodes.find below the asm and crsd log details from the failure time:

NOTE: enlarging ACD for group 1/0x124851d1 (DATA)
WARNNING: cache read a corrupted block group=DATA dsk=4 blk=1 from disk 4
+NOTE: a corrupted block from group DATA was dumped to /u01/app/oracle/diag/asm/+asm/+ASM3/trace/+ASM3_rbal_4109.trc+
WARNNING: cache read(retry) a corrupted block group=DATA dsk=4 blk=1 from disk 4

View 3 Replies View Related

SQL & PL/SQL :: How To Eliminate And Separate String

Apr 29, 2011

In my table i have a field called swistmsg, which contains value as

32a3:1000.|:33b1:USD(similarly around 100 rows)

and my requirement is

201 0001OTT11000004 23b1 CRED 32a1 01-01-2011 32a2 USD 32a3 1000 33b1 USD

and i have eliminate '.',':'&'|' (only quoted chars)from the string separate string

View 17 Replies View Related

SQL & PL/SQL :: Separate String Using REGEXP_SUBSTR

Jan 25, 2011

I can separate numbers from string (info) and the first value of the string using REGEXP_SUBSTR (see below):

with dat as (select '35263304 Alcatel One Touch 806' info from dual)
select info, REGEXP_SUBSTR ( info, '[[:digit:]]+',1 ) tac,
REGEXP_SUBSTR ( info, '[[:alpha:]]+',1) brand
from dat

But how can I get rest of the values from that string (red color) ?

I just would like to get separately like:
35263304 Alcatel One Touch 806

View 5 Replies View Related

SQL & PL/SQL :: Separate CSV Values In A Field?

Nov 6, 2012

create table nov06(
f_name varchar2(20),
l_name varchar2(50),
m_name varchar2(10)

insert into nov06 (l_name) values (aaa,bbb);

insert into nov06 (l_name) values (ddd,nnn,jr);

insert into nov06 (l_name) values (fff,mmm);

here the values in the l_name are seperated by ','.
comma seperated values represents "f_name,l_name,m_name".

I've to seperate the strings and put in their respective fields.

e.g in second insert statement value (ddd,nnn,jr), so the values will be
f_name -> ddd
l_name -> nnn
m_name -> jr

how can I do it???

View 2 Replies View Related

SQL & PL/SQL :: Separate Date And Time

Nov 1, 2012

I have a question with Oracle sql developer, i've installed oracle 11g express edition, and i want to insert values 'date' and 'time', but i only got the resultat like this:

Who can tell me how can i do to show just date info in 'date' and same for the 'time'?

View 7 Replies View Related

SQL & PL/SQL :: Separate Index And Tables In Two Different Tablespace

Apr 14, 2013

How to saperate inndexes and tables in two different tablespcae.......???

View 2 Replies View Related

Forms :: Opening New Form In Separate Tab

Dec 18, 2011

I have a multiple forms application and I use OPEN_FORM to call one form from another. However I want the new form to open in a separate tab ( the way it works in a tabbed canvas).

View 4 Replies View Related

SQL & PL/SQL :: Separate String Based On Comma?

Oct 28, 2013

This I want TO separate TO different COLUMNS based ON comma.

THE RULE IS LIKE out OF total five fields FIRST 3 comma will be FIRST 3 addresses AND rest will be address4 AND LAST NUMBER should appear IN pincode field IF found.

The trouble is for reading reverse to get the number.

WITH address AS (SELECT 'Avenue Supermarts Pvt Ltd,Anjaneya, Opp Hiranandani Foundation School, Powai, Mumbai,Pin Code 400076' addr1 FROM dual UNION ALL
SELECT 'Plot No. J-I, Block B-I, Mohan Co-operative Industrial Area, Mathura Road, New Delhi-110044' addr1 FROM dual UNION ALL
SELECT 'Padmashree Arcade, NH 5, Chinagantiyda Main Road, Gajuwaka, Vishakhapatnam' addr1 FROM dual UNION ALL
SELECT 'The Icon, 2nd 3rd Floor, #8, 80 Feet Road, HAL III Stage, Indiranagar, Banglore-560075' addr1 FROM dual UNION ALL
SELECT '13/1, International Airport Road, Bettahalasur Post, Bengaluru-562157' addr1 FROM dual)
SELECT addr1 FROM address;

View 10 Replies View Related

SQL & PL/SQL :: Separate Date Interval By Trimester

Jul 26, 2011

Let's say I have this table:

create table TEST


insert into test (CF, START_DATE, END_DATE)
values ('ME', to_date('01-01-2011', 'dd-mm-yyyy'), to_date('31-12-2010', 'dd-mm-yyyy'));

I need make a select where I get n rows, where n is the number of trimesters that compose the date interval in the table. Each of the returned rows must have as start_date/end_date the boundaries of that trimester.(ALL start dates are the first day of a month, and all end dates are the last day of a month)

In this case I need to get:

ME - 01/01/2010 - 31/03/2010
ME - 01/04/2010 - 30/06/2010
ME - 01/07/2010 - 30/09/2010
ME - 01/10/2010 - 31/12/2010

View 9 Replies View Related

PL/SQL :: Separate Different Arithmetic Operators In A Query?

May 14, 2013

I wrote an query and regarding one part, i have syntax problem, when should we seperate different arithmetic operators in a query?

for example

select  density_with_desert.popp  /  density_with_desert.arr  -  sum(darea)  from counytyi don't want to use variables.

View 8 Replies View Related

Forms :: Separate Frame Applet

Mar 17, 2011

We are using oracle forms 10g, in formsweb.cfg file i gave separeteFrame=true and it works fine also like IE & applet window is opening. But User wants to hide the IE in backegroud and they want only applet window, so using VBScript we are hiding the IE and now only applet window apears this also fine.

I am running the report and displaying the report using web.show_document, report is running fine and displaying in IE with PDF format. But the problem is if i press the run report button report is opening and displaying behind the applet window not infront of applet window and there is no focus on the report IE also. How to display the report output(IE with PDF format) infront of the applet window and current focus on the report window(IE with PDF).

Note: If i use separateFrame=false then report is displaying infront of the IE screen and focus is on the report IE.

View 1 Replies View Related

Forms :: Fmx Files Into Separate Folder

Apr 29, 2013

I have some .fmb files in 'F: ask" " ' location.and my question is can i store the .Fmx files in other location like 'D:" " '

that is if i create a .fmx file for the 'F: ask**.fmb'. i want That .fmx file will store into other location i.e 'D '

View 3 Replies View Related

Return Separate Result Set From Each Statement

Jul 19, 2008

I am simply trying to execute a couple of select statements in a single dynamic query. I also want it to return a seperate result set from each statement (something quite easy in T-SQL - but seemingly impossible in PL-SQL!)

This query is being run from C#, but i also get the same results from Sql Developer.This is what i'm trying to execute:

select * from studies;
select * from studyprogressions;

The error i get is "an INTO clause is expected in this SELECT statement" for each of the select lines - As you may already have worked out - I don't use Oracle very often and am starting to feel very stupid considering i have certifications in SQL Server/T-SQL!

I have searched online for a solution, but it seems that everyone with the same error is trying to do so much more.Why is nothing in Oracle simple? Give me SQL Server any day of the week.

View 14 Replies View Related

SQL & PL/SQL :: Make Query Like Separate List Of Orders

Mar 1, 2010

I have table called Orders with lots of fields from Imports Fields are ConsigneeKey,Shipto,ProductCode. and another table called Product. Main fields are ProductCode,Price,Weight,StdCube. Now I have two list of Consineekey,One which is shipto X area and another is of Y area. I want to make query like separate list of Orders which is shipto X,Y and Common Products in Both X and Y. I will supply list of Consigneekey in where clause.

View 8 Replies View Related

Separate ASM Diskgroup For Online Redo Logs

Sep 25, 2013

Version: : Solaris 10   

One of  the Hitachi support guy has suggested to create a separate disk group for Online redo logs. His rationale was that ORLs was write only files and it would be better to put in a separate disk group.

View 6 Replies View Related

SQL & PL/SQL :: Fetch All Emails Of Employees And Separate Them By Semicolon

Aug 17, 2010

Need pl/sql block to fetch all the emails of all the employees from the database and separate them by semicolon....

View 4 Replies View Related

Bash_profile Location In IBM AIX?

Sep 30, 2010

Where will i find the bash_profile location in IBM AIX server.

View 2 Replies View Related

Create A Separate Sort Order Column On Table

Oct 31, 2006

I have data that i am sorting, the data is mostly numeric (format of XXX-1234). is there any way to have my query sort xxx-1000 AFTER xxx-999? right now i am thinking i will have to create a separate sort order column on my table.

View 2 Replies View Related

Separate Date Format For Specific Columns In A Database

May 25, 2011

As we know that date datatype can store both date part and time part. If I specify the Date format for my database as 'DD-MM-YYYY HH@$:MI:SS' can i ensure i anyways for a particular columns in the database containing date values the format is 'DD-MM-YYYY' i.e without the time part.Can we specify seperate date formats for specific columsn in database during table creation?

View 1 Replies View Related

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