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


ADVERTISEMENT

RAC & Failsafe :: Difference Between Crsctl And Srvctl

May 21, 2012

Difference between this two command to start this rac database

srvctl start database -d ORCL
crsctl start cluster -all

if i run this above command this both command impact its same or different.

View 7 Replies View Related

RAC & Failsafe :: Oracle 9i - Difference Between Real Application Cluster And OPS

Jul 17, 2002

What is the different between the new RAC feature - real application cluster and OPS... for me it sound the same..

View 3 Replies View Related

PL/SQL :: Difference Between Install Database And Create Database?

Jan 11, 2013

1.what is the difference between install database and create database?

2. if i have connected with remote database(server) then it is an instance again?

View 3 Replies View Related

RAC & Failsafe :: Startup Sequence 10g RAC Database With ASM?

Dec 28, 2012

I want to restart a 10g database on ASM ? startp and shutdown sequence?I would like to shutdown everything including database, ASM and cluster and startup again

I read at various places but not sure of the sequence For database DB with database instance DB01 and DB02 having ASM instances ASM01 and ASM02 on node1 and node2, I understand following would be the sequence

1)
Login as root on node1
cd $CRS_HOME/bin
./crsctl start crs

2)
Login as root on node2
cd $CRS_HOME/bin
./crsctl start crs

3)
login as oracle on node1
$ORACLE_HOME/bin/srvctl start nodeapps -n node1

4)
login as oracle on node2
$ORACLE_HOME/bin/srvctl start nodeapps -n node2

5)
login as oracle on node1
start ASM instance on node1
$ORACLE_HOME/bin/srvctl start asm01 -n node1

6)
login as oracle on node2
start ASM instance on node2
$ORACLE_HOME/bin/srvctl start asm02 -n node2

7)
Start oracle database (from any node)
$ORACLE_HOME/bin/srvctl start database -d DB

A. confirm if the above sequence is correct?
B. This sequence if corrrect, is same for 10g and 11g?
C. Is shutdown sequence exact reverse of the above?

View 9 Replies View Related

RAC & Failsafe :: Database Creation Hangs - RAC On SP2 On AIX-4.3.3?

Jan 17, 2003

Creating RAX 9.2.0 on SP2-AIX-4.3.3 64 bit hangs (2 node configuration) tablespacess are on VSD/raw partitions.

View 3 Replies View Related

RAC & Failsafe :: JDBC Connection To A 10g Database?

Mar 30, 2005

The problem i mentioned in my last posting "CRS installation/PRIF-10: failed to initialize the cluster registry" was due to the fact i was using Redhat Linux 9 that seems to have some missing packages. I installed White Box RH 3 and everything worked fine.

if it's possible to connect to a 10g RAC database using the jdbc java thin client. the java thin client requires an ip, and database sid. I am running a two node cluster and i have two ip's and a service name that uses TAF option.

View 5 Replies View Related

RAC & Failsafe :: Can Create Directory On Two Node Database

Feb 2, 2013

here we have san server and rac database two node database.i want to know how can i create directory on rac database. i know how to create directory on single database but i do not know how can i create directory on rac database.

View 3 Replies View Related

RAC & Failsafe :: Single Instance - Migration To Database

Oct 20, 2010

2 Database.

TP1 Database - Oracle RAC 11g (2 Node)
TP2 database - Single Instance

Is it possible to migrate from RAC to Non-RAC(Single Instance)?

Our requirement is, 3 Oracle Schemas@TP1(having DW data) we need to move it to TP2 Database.

View 4 Replies View Related

RAC & Failsafe :: Srvctl Stop Database D Devdb1?

Jul 21, 2011

srvctl stop database d devdb1

After that i got this below status .how to make it up Steup by steup procedure

crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.devdb.db application ONLINE ONLINE islr...v345
ora....b1.inst application ONLINE ONLINE islr...v333
ora....b2.inst application ONLINE ONLINE islr...v345
ora....dbap.cs application OFFLINE OFFLINE

[code]...

View 2 Replies View Related

RAC & Failsafe :: Upgrade Of Oracle And Standby Database In HP UX

Mar 9, 2011

we had our Oracle RAC database at primary and Standby database as DR. It was running in 10g (10.2.0.1.0) in HP UX 11i platform.

We need to upgrade both the setups from 10.2.0.1.0 to 10.2.0.4.0 . I will go through the upgrade guide, i like to know is there any special case for upgrading when we do for both primary and standby database.

And whether i need to create a new Oracle home with 10.2.0.4.0 software or i can upgrade in the same oracle home which already exists.

View 2 Replies View Related

RAC & Failsafe :: 5 Node Database - Services Management

Aug 17, 2012

We have 5 node RAC database. I want to user 2 node for OLTP and 3 for DSS system. Guide now to create service for the requirement.

View 10 Replies View Related

RAC & Failsafe :: ORA-01033 On One Node But Database Is Started

May 23, 2012

we encounter a problem with a 2-nodes RAC with 11gR2 SE : Database RAC is correctly running but we encounter problems using RAC TNS entry, obtaining the message ORA-01033.We can access to the DB using a TNS entry using each one of IP addresses but when we use the SCAN address, it fails. 2 weeks ago RAC2 node could connect perfectly with the SCAN address but RAC1 (used as a client) obtained error message almost 30% of tries.

We made a reboot of RAC1 node and now SCAN address works correctly from RAC1 and RAC2 (used as a client) fails systematically with SCAN address but works perfectly with direct access to the database.On both nodes, SCAN address is perfectly resolved by DNS server, cluster seems correct, listeners seems correct...We have opened an SR on Metalink 4 weeks ago but we don't progress.

View 4 Replies View Related

RAC & Failsafe :: Database Instance Using Srvctl Command

Aug 13, 2013

Would there be any issue in application and database when i down RAC database instance using below srvctl command ?

srvctl stop instance -d DB -i DB1
srvctl start instance -d DB -i DB1

View 18 Replies View Related

RAC & Failsafe :: Manual Failover To Standby Database Without RAC And DG?

May 13, 2013

if it is possible to create a failover setup without RAC and DG...For example:

I have 11.2.0.2 database (with EBS 12.1.3) on dbnode1...I would like to create another node to failover my primary datbas in case of any failure.

Steps i will follow:
1: creat dbnode2
2: install same os as dbnode1
3: install same oracle as dbnode1
4: share dbnode2
database between dbnode1
and dbnode2

Now, if hardware fails on dbnode1, can i manually failover and start my database on dbnode2?

I know we can do with RAC and DG,BUT without RAC and DG If not possible..

View 4 Replies View Related

Difference Between Database Or SID Upgrade

Oct 19, 2012

i want to know is there any difference between upgradation of SID and database. while upgrading my database from oracle 11.2.0.2 to 11.2.0.3 in DBUA it shows my SID is upgrading (ORCL) but i have few other databases ex (test and prod).

is it enough if we upgrade the SID or we must perform any other actions..

and
2nd QUERY :

i have 2 oracle homes in my server with different versions like (11.2.0.2 and 11.2.0.3)and i have few databases and there tablespaces. how to determine which database is created on which version and which database is upgraded from 11.2.0.2 to 11.2.0.3.

View 3 Replies View Related

RAC & Failsafe :: Database Time Spent Waiting Warning

Jan 16, 2012

i'm keep on getting below error every morning in my Database.this indicate in Grid control every morning.

Metrics "Database Time Spent Waiting (%)" is at 34.336 for event class "Concurrency"
Metrics "Database Time Spent Waiting (%)" is at 100 for event class "Other"
Metrics "Database Time Spent Waiting (%)" is at 44.78 for event class "Other"

i need to know, this is something that i should consider as a critical warning and how can i solve this .

View 1 Replies View Related

RAC & Failsafe :: Query On Dependency Between Database Instance And Service?

Jul 8, 2013

suggest on the dependenecy between the database service and the database instance?

srvctl start instance -i db1
will this start service as well for which the above instance is either preferred or available instance?
will it start the listener as well?

srvctl stop instance -i db1
will this stop service as well for which the above instance is either preferred or available instance?
will it stop the listener as well?

srvctl start service -d db -s dbserve
will this start service as well for which the above instance is either preferred or available instance?

srvctl stop servive -d db -s dbserve
will this stop service as well for which the above instance is either preferred or available instance?

srvctl start database -d db
will it start instance, listener and service as well?

srvctl stop database -d db
will it stop instance, listener and service as well?

View 1 Replies View Related

RAC & Failsafe :: Upgrade Database With ASM Storage From 10gR2 To 11gR2?

Mar 7, 2011

I have a database running on 10205 version. It is a RAC database with ASM storage.

I want to migrate this database to other server and upgrade this database to 11202 version .

View 1 Replies View Related

RAC & Failsafe :: Configure Oracle Dataguard For 2 Node Database

Oct 28, 2010

We have to configure Dataguard for our 24x7 critical banking 2 Node RAC database(10.2.0.4). Before proceeding with the configuration we have to make sure what steps we should follow to have minimum or no downtime.

1) Document covering DG setup in RAC environment.
2) We have to perform switchover as well so need its steps too. Either the normal switchover steps would be used or have to stop/start rac services as well.

View 7 Replies View Related

RAC & Failsafe :: RMAN Backup / Unable To Open Database

Aug 31, 2013

I tried to run the duplicate script after transferring new rman backup to standby. Even after transferring the backup, duplicate command and was unable to open the database.

View 1 Replies View Related

Difference Between Auxiliary And Target Database

Nov 15, 2010

I want clear the concept of auxiliary database. What's the use/advantages of it. Is it the another oracle instance? What is the difference between Auxiliary Database and Target Database?

View 3 Replies View Related

Difference Between Database Modelling And Designing

Apr 29, 2013

What is the difference between Database Modelling and Database Designing ?

View 5 Replies View Related

Windows :: Difference Between Standby And Clone Database

Aug 19, 2011

Difference of standby and clone,i know their uses but i want a detailed explanation.

View 2 Replies View Related

Difference Between Oracle Database Server And Client?

Jul 22, 2011

Currently I am doing one Oracle installation.But very much confused where to start from. Since I am installing oracle on my personaly Laptop,do I need to install Oracle database server and Oracle client both or only installing database server is sufficient.

What is the exact difference between oracle database server and client.Only knowledge I have is that client is used to access database server remotely.are Oracle database server and client installable to be downloaded separately?

View 1 Replies View Related

SQL & PL/SQL :: Difference Between File Catproc That Run After Creation Of Database In Oracle 9i /10g / 11g R2

Aug 18, 2010

I want to know what is the difference between the file catproc that we run after creation of the database in the Oracle 9i,10g and 11g r2. I have run that file in 11g R2 but it is taking more time and more over there are many new things that i saw in 11g R2 than what were there in 9i and 10g.

View 11 Replies View Related

Backup & Recovery :: Difference Between Flashback Database And Incomplete Recover

Jul 23, 2012

What is difference between the flashback database(10g later) and incomplete recover?

View 5 Replies View Related

RMAN :: Difference Between Recover Database And Alter Database Recover?

May 9, 2013

Oracle database 11.2

What is the difference between

recover database until cancel using backup controlfile; and alter database recover automatic until cancel;

1. in user managed and server managed backups. What would be the location of the controlfile which is used in (recover database until cancel using backup controlfile;) .

2. why user first option and why use second option.

View 2 Replies View Related

Networking And Gateways :: Oracle 11gR2 Database - Performance Difference Between Windows PC And On VMware

Feb 9, 2012

We are having major differences in performance when accessing an Oracle 11gR2 database from two different environments.

I won't sadden you with the gory details of the full application but I will use an indicative example of our problem.

We have SQL Developer in both environments. In each of these SQL Developer instances is a defined a connection to the same database on another machine. So there is the PC looking at a database and a virtual instance looking at the same database.

Selecting the '+' sign next to 'tables' for that connection, on the PC the list of four tables comes back in 4 seconds but on the virtual instance the list of the same four tables comes back in 1 minute and 50 seconds.

This sort of timing issue is repeatable for all accesses to the Oracle database on the third machine.

View 4 Replies View Related

PL/SQL :: Calculate Difference By Which Day Count Of Difference Is Going?

Oct 17, 2012

Detail table will look like below:

Product_id issue_date action_date Force_date
1 10/10/2012 10/10/2012 10/10/2012
2 10/10/2012 10/10/2012 10/10/2012
3 10/10/2012 13/10/2012 15/10/2012
[code]....

Need the data like

Issue_date count_action_date count_Force_date (diff(action_date,force_date) 1 2 3 4 5 6(days since over)

10/10/2012 3 4 1 4 2 1 0 0

How to get the data like this? automatically how to get 123.... and how to calculate the difference by which day the count of difference is going?

View 3 Replies View Related







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