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


ADVERTISEMENT

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 :: 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 :: Hierarchy To Stop And Start Oracle RAC Instance

Apr 20, 2013

What is the hierarchy to stop and start oracle RAC instance ?

View 10 Replies View Related

SQL & PL/SQL :: Dbms-scheduler - Stop Jobs When Database Down?

Nov 13, 2011

How to stop all jobs(dbms_scheduler) when ever database down or power failure and I need to restart all jobs when ever database is up.

View 3 Replies View Related

Data Guard :: Stop Log Shipping To Standby Database

Mar 29, 2012

i want to stop log shipping to standby database. the whole configuration was done by someone else and now i have been ask to stop it. it is done on test bases and now want to stop it.what i have got from internet is as follows:

Alter system set log_archive_dest_2='DEFER';
and i have got the fol error
ORA-32107:failure in updating spfile
ORA-16179:Incremental changes to "Log_archive_dest_2" not allowed

View 1 Replies View Related

Clusterware :: Add Listener To Grid Infrastructure Using Srvctl

Jan 14, 2013

We have a two node 11.2.0.3 Grid Infra cluster running on SLES11 Linux. Everything is ok with the SCAN and standard listeners.

However we have a listener running on each node which is used by Oracle Gateway. These listeners were created manually using info provided by Oracle (i.e. definition copied to $ORACLE_HOME/network/admin/listener.ora and started using lsnrctl). This all works.

These listeners are currently not managed by Grid Infra. We would like them to be.

I thought this was easy enough using srvctl to register them with Grid Infra using...

srvctl add listener -n mynode1 -l LISTENER_MYNODE1_GW -o $ORACLE_HOME -p 1529
srvctl add listener -n mynode2 -l LISTENER_MYNODE2_GW -o $ORACLE_HOME -p 1529

These commands worked but did give a warning stating that the -n flag is deprecated and will be ignored.

This has left us with the following listener config....

grid@MYNODE1:~> srvctl status listener -n mynode1 | grep mynode
Listener LISTENER_MYNODE1_GW is enabled on node(s): mynode1
Listener LISTENER_MYNODE1_GW is not running on node(s): mynode1
Listener LISTENER_MYNODE2_GW is enabled on node(s): mynode1
Listener LISTENER_MYNODE2_GW is not running on node(s): mynode1

grid@MYNODE1:~> srvctl status listener -n mynode 2 | grep mynode
Listener LISTENER_MYNODE1_GW is enabled on node(s): mynode2
Listener LISTENER_MYNODE1_GW is not running on node(s): mynode2
Listener LISTENER_MYNODE2_GW is enabled on node(s): mynode2
Listener LISTENER_MYNODE2_GW is not running on node(s): mynode2

You can see that Grid Infra knows about the listeners but they are available on both nodes. What we would like is a result like the following example....

grid@MYNODE1:~> srvctl status listener -n mynode1 | grep mynode
Listener LISTENER_MYNODE1_GW is enabled on node(s): mynode1
Listener LISTENER_MYNODE1_GW is not running on node(s): mynode1

grid@MYNODE1:~> srvctl status listener -n mynode 2 | grep mynode
Listener LISTENER_MYNODE2_GW is enabled on node(s): mynode2
Listener LISTENER_MYNODE2_GW is not running on node(s): mynode2

i.e one listener registered with just the node it is running on. This used to be possible with using the -n flag but no longer works.

View 2 Replies View Related

Intermediate State / Check Cluster Resources By Srvctl Status Resource

Oct 17, 2013

We are in 11gR2 in windows 2008. Our database is 2 nodes rac. I got alert message below.

Host=xxxx.xxxx.xxxx.xx.xxTarget type=Cluster Target name=ora-scan Message=ora.registry.acfs has 1 instances in INTERMEDIATE State Severity=Warning Event reported time=Oct 17, 2013 6:40:45 AM EDT Operating System=Windows Platform=x64 Associated Incident Id=xxxx Associated Incident Status= New Associated Incident Owner=SYSMAN Associated Incident Acknowledged By Owner=No Associated Incident Priority=Low Associated Incident Escalation Level=0 Event Type=Metric Alert Event name=resource_status:crs_event_composite_status Metric Group=Resource StateMetric= State ChangeMetric value=PARTIALLY_INTERMEDIATEKey Value=resource_ora.registry.acfs.type_ora.registry.acfsKey Column 1=KeyRule Name=EDC - Metric Alert,Warning Rule Owner=SYSMAN Update Details:ora.registry.acfs has 1 instances in INTERMEDIATE State Incident created by rule (Name = EDC - Metric Alert, Warning; Owner = SYSMAN).

I did check the cluster resources by srvctl status resource -t and all of resources are in online and none of them i saw in intermediate state. Is there any other command and option to investigate this error?

View 6 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 :: 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 :: 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 :: 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

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

SQL & PL/SQL :: Stop A Scheduler Job

Jun 1, 2011

There is one maintenance job owned by SYSMAN running continuously. I want to stop that scheduler job .How ?

IS this the correct syntax to stop the running job ?

exec dbms_scheduler.stop_job(job_name=>'jobname');

View 1 Replies View Related

SQL & PL/SQL :: Stop Loop On One Process?

Jul 3, 2010

i want check some data from one process instead of last record

i.e

process data
uuu 1
2
3
4
ppp 1
2
3
4

[code].....

View 2 Replies View Related

Forms :: How To Stop Going To Next Record If It Is Last One

Jan 31, 2012

how to stop going to next record if it finds the last record. Because when i click my next button(it is the last record), i try to click my previous or first button but it won't go back, enter-query mode is the error message.

View 9 Replies View Related

SQL & PL/SQL :: How To Stop Update In PK Column

Apr 1, 2012

HOW TO STOP THE UPDATE IN PK COLUMN?

View 3 Replies View Related

Forms :: SQL Server In Stop Position?

May 25, 2011

SQLserver in stop condition when i play it. it again stop

View 1 Replies View Related

Windows :: How To Stop All Oracle Products On XP

Apr 9, 2012

I'm trying to install additional Oracle products on my XP VM, but it is telling me to kill all running oracle products. It states that by running the Oracle utility: oradim80 or the Windows NT service Control Panel I can stop all of these services, but I cannot find either.

View 2 Replies View Related

Forms :: How To Stop System Message

Nov 3, 2010

I have a form with multiple data block. When i want to query and go to next record then this displayed a message "Do you want save changes". But i would like to stop this message(i.e would not see the message) is it possible.

View 3 Replies View Related







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