RAC & Failsafe :: OCR_DG1 Is In Quiescing Mode Not Mounted

Mar 13, 2012

i am having "quiescing" instead of "mounted" on one of disk group where OCR is lying. i.e OCR_DG1 is the name of disk group , now i have search the internet and found that.

Quote: CRSCTL utility attempted to dismount a disk group that contains the Oracle Cluster Registry (OCR). The disk group cannot be dismounted until Cluster Ready Services (CRS) exits, because the disk group contains the OCR

now my question is that whether the local DBA tried to dismount this disk group and to make it mounted whether i have to stop CRS or there is another method to do.

View 2 Replies


ADVERTISEMENT

Creating ASM Disks From NFS Mounted Files

Jul 25, 2010

Regarding 11gR2 RAC, ASM, and NFS. Installing 11gR2 Grid Infrastructure and 11gR2 RAC on OEL 5.5 servers with storage supplied by NetApp NFS shares over TCP/Ethernet.

How do I mount NFS file systems as block devices so ASM will use them?

It is my understanding that Linux mounts NFS file systems as anonymous file systems rather than block devices. ASM requires block devices. The only way I know to have Linux treat an anonymous file system mounted over NFS as a block device is to subsequently mount it as a loop device.The Oracle 11gR2 documentation states, "ASM does not support loop devices". Without defining NFS mounts as loop devices, oracleasm createdisk complains the given file on the NFS mounted file system is not a block device when i run

/usr/sbin/oracleasm createdisk DATA /oradata/prod/data/disk01

where /oradata is an NFS mount from a NetApp volume defined in /etc/fstab and disk01 was created with the dd command.I followed the steps in section 3.3.1.2 'Creating Files on a NAS Device for Use with Oracle ASM' of the Oracle guide..

When I use asmca, it does not find any candidate disks with the search path set accordingly.If successfully implemented ASM using NFS shares for database disk groups from a NAS, Steps I followed are below.

In /etc/fstab:
server-ip-address:/vol/data /oradata nfs rw,bg,hard,nointr,tcp,nfsvers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0 0 0
-- mount and verify. /oradata is mounted with specified options.
# mount -a
# mount
[code]...

Command fails with error message "File /oradata/prod/data/disk01 is not a block device." None of the OUIs (grid installer, asmca, or dbca) identify any disks as ASM candidate disks with the search string '/oradata/prod/data/*'. I also tried using '/*', '/oradata/*', '/oradata/prod/data/*' to no avail.

View 4 Replies View Related

Error In Identifying Control File / Database Not Mounted ORACLE Instance Shut Down

Nov 21, 2012

i have a problem when i try to login to oracle...i found this message error.

ora-01033 oracle initialization or shutdown in progressafter i logged on with / as sysdba...i did the following

SQL> shutdown immediate;
ORA-01507: database not mountedORACLE instance shut down.
SQL> startup mount;
[code]....

View 6 Replies View Related

Forms :: Run 10g In Mode Debug?

Jan 5, 2012

I want to run form 10g in mode debug, however when i set break point in code and press shift+ F9 ( or run Debug by click icon on Form 10) then Form still run but not run in mode debug. Now i want to run form 10g in mode debug, how do i do?

View 2 Replies View Related

Auditing No Archive Log Mode

Jun 8, 2012

I am using Oracle Database 10.2 in No Archive Log Mode. what auditing options are available in No Archive Log mode ?

View 4 Replies View Related

RMAN :: No Archive Log Mode

May 6, 2013

resolving the below issue.

environment:
DB version:11.2.0.3.0
OS : IBM/AIX RISC System/6000
backup tool : Symantec net backup.

When I start RMAN backup through Symantec net backup tool same is failing. when I see in log file below error message is recorded in the same.

################################################################################

Starting backup at 06-MAY-13
channel ch00: starting compressed incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ch00 channel at 05/06/2013 07:09:16

[Code]....

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 05/06/2013 07:09:16
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

RMAN> RMAN>

Recovery Manager complete.

####################################################################################

But, DB is up and operating fine with ARCHIVELOG mode at that movement not even restart also.

how to resolve.

View 14 Replies View Related

Table Locks In Exclusive Mode

Jan 6, 2011

Under what scenarios do we lock a table in the exclusive mode.

View 1 Replies View Related

Putting A Database In Backup Mode?

Aug 25, 2010

I have Oracle loaded on a server. I have three database instances - /db1, /db2, /db3. I want to put the database in backup mode before I take a backup copy of the three database instances.

Is the database put in backup mode just once and then the three instances can be backed up? Or does each instance need its own script to put the database in backup mode?

View 4 Replies View Related

Oracle 11g R2 Installation Using Silent Mode / GUI

Oct 29, 2012

I have to install oracle 11g R2 on AIX. but I need to install from putty I have configured cygwin Xwindow. able to get GUI from my local VMware linux server but unable to get GUI for remote servers.

and followed the same process as I did for my local vmware linux box. How to get the GUI for remote servers as well. If it not possible or any configuration needs to be done at remote site.

View 5 Replies View Related

Netca.rsp Installation In Silent Mode 9i?

Dec 30, 2003

I can't seem to get TNS Listener to install using a responsefile in Oracle 9i... I've been using the netca.rsp file that comes included on disc one of the Oracle 9i Release 2 cds. I've tried calling netca.rsp from inside a custom install response file template...

# Oracle Net Configuration Assistant
[oracle.networking.netca_9.2.0.1.0]
#-----------------------------------------------------------------------------
# Name : OPTIONAL_CONFIG_TOOLS

[Code].....

but when I check the services in Administrative settings the listener has not been created...I'm using OraInst as my staging directory.

I've also tried using the "Using Configuration Assistants in Non-Interactive Mode" section at:
URL

I also tried adding:

[Session]
TOPLEVEL_COMPONENT={"oracle.net.ca","9.2"}

to the netca.rsp file, since it wasn't there by default...

I've also tried going to my staging directory from the command prompt and running E:OraInst> launch.exe -silent -responseFile netca.rsp where launch.exe is a copy from launch.exe generated in oracleora92in

View 4 Replies View Related

Implementing Archive Log Mode In RAC Environment

Nov 23, 2010

Questions about implementing ARCHIVELOG mode in RAC environment.

Oracle 11gR1 RAC + ASM database. I'd like to implement ARCHIVELOG mode. Each node will have its own archive log.

Does it make sense to place archivelogs on ASM (shared storage)? Or the best practice would be to have some aside "BACKUP" server to place and keep archivelogs from all the RAC nodes there?

Additional question is about archive logs space required estimation. If it's correct to know estimate archive logs space required to get the daily avg number of switch logs

CODEselect round(avg(n_of_switch_logs), 3) avg_num_of_switch_logs
from (select trunc(first_time), count(*) n_of_switch_logs
from gv$log_history
group by trunc(first_time))
and multiply it on size of single redolog?

View 2 Replies View Related

Standby Database Protection Mode?

Mar 10, 2013

I have changed from the "ARCH" attribute to "LGWR" attribute of the LOG_ARCHIVE_DEST_n initialization parameter. But I have not changed the protection mode(Maximum Performance). I would like to know whether there is any impact in the behavior of the database, if we do not change the mode from "MAXIMUM PERFORMANCE" to "MAXIMUM AVAILABILITY"?

View 3 Replies View Related

SQL & PL/SQL :: Difference Between Timestamp And Signature Mode

Mar 19, 2011

what is difference between timestamp mode and signature mode.

View 2 Replies View Related

Forms :: Compressed Mode Using Text_io

Jun 14, 2011

When I used to work with foxpro we had used dot matrix printer. At that time if we want, we can print in normal mode, expanded mode and compressed mode. it will be part of your spool file.

Now am printing a text file from forms using text_io package. I would like to know in this how do i print the content in compressed mode using CHR function or some other method.

View 3 Replies View Related

Forms :: Default Mode While Entering?

May 25, 2010

Is there any property that can be set at design time or dynamically altered during runtime about the default mode in which a form opens? I have created a new FORM in Forms 6i and it opens in the Enter-Query mode. I do not want to open it in the Enter-Query mode. This is because I will be doing my own execute_query on some click of a button in the form. How do I alter this Enter-Query mode in which the form opens?

View 2 Replies View Related

Forms :: Calculation Mode With Conditions

Sep 24, 2013

I have 2 fields f1,f2

I define f1 a summary in calculation mode

I want to sum f1 where f2 = 5

View 3 Replies View Related

Forms :: How To Change Updatable Mode

Jul 18, 2011

how to change form in updatable mode?

View 1 Replies View Related

Data Guard :: What Is The Most Common Mode

Feb 27, 2012

what is the most common mode in dataguard? maximize protection or maximize availability or maximize performance

View 6 Replies View Related

Dedicated Vs Shared Server Mode

Sep 17, 2013

Why for dedicated server mode session memory is alloted from PGA and same in shared server mode by SGA ??

View 4 Replies View Related

Backup And Restore Tablesapces In Noarchivelog Mode?

Dec 30, 2011

after setting a full database backup and restore in noarchivelog mode , i would like to perform backup and restore just a tablespaces.

View 1 Replies View Related

Forms :: How To Cancel Enter-Query Mode

Aug 31, 2011

When i entered for modification/deletion process initially i prefer to entry-query mode then execute the query.

Suppose when i am in entry-query mode but i want to cancel(abort) the mode ie. entry query. How to achieve this.

View 3 Replies View Related

Forms :: Close A Window In Query Mode

Apr 10, 2010

How do I close a window in query mode?My form has a button "Populate from Charge Master" which opens a window containing a List Item (Department Names) and 2 buttons,

1. "Select the Dept" and
2. "Cancel"

The WHEN-BUTTON-PRESSED trigger code for "Populate from Charge Master" button is as follows:

begin
SHOW_WINDOW('WINDOW_POP_FROM_CHARGE_MASTER');
go_block('bl_med_dep');
enter_query;
end;

Code for "Select" button in the window is:

populate_from_charge_master(:bl_med_dep.med_dep_code,:bl_med_charge_party.charge_party_no);
execute_query;
COMMIT;
HIDE_WINDOW('WINDOW_POP_FROM_CHARGE_MASTER');
GO_BLOCK('BL_MED_CHARGE_PARTY');
EXECUTE_QUERY;

Code for "Cancel" button in the window is:

BEGIN
hide_window('WINDOW_POP_FROM_CHARGE_MASTER');
show_window('WINDOW1');
GO_BLOCK('BL_CHARGE_COMPANY');
END;

Here WINDOW1 is the main window and WINDOW_POP_FROM_CHARGE_MASTER is the window which must be closed when "Cancel" button is pressed.

When I remove "enter_query" statement in "populate from charge master" trigger code, I am not able to select any of the departments from the list. and If I have that statement, I am not able to hide/close the window.

View 5 Replies View Related

SQL & PL/SQL :: Pass More Characters To In Mode Parameter Using Procedure

Feb 26, 2012

I am trying to pass many characters to the in mode parameter using procedure , but i am getting the below error.

ORA-06550:
PLS-00172: string literal too long

CREATE TABLE USR_DETAILS
(
LOAD_ID NUMBER NOT NULL,
LOAD_DATE DATE,
USER_VALUE VARCHAR2(4000 BYTE),
USERID VARCHAR2(4000 BYTE)
)
insert into user_details values('1','2/10/2011','PROD1','USER1');
insert into user_details values('2','2/10/2011','PROD2','USER2');
[code]......

I have written the code as below...

Procedure concept :

Here i will seperate the strings(input parameters) using comma(,) symbol . Here users may pass more than 5000 characters to single in mode parameter, so i have tried with clob datatype but no luck.

CREATE OR REPLACE procedure user_details_proc (user_value1 IN varchar2,
user_value2 IN varchar2,
user_value3 IN varchar2,
user_value4 IN varchar2,
user_value5 IN varchar2,
userid IN varchar2
) as
[code].......

View 2 Replies View Related

Server Administration :: Archive Mode In Database

Dec 28, 2011

what is the techniques to set the archive mode in oracle database on???????

View 4 Replies View Related

Server Utilities :: Run Exp Utility In Background Mode

Oct 29, 2013

I have executed the exp utility to take schema backup as below.

DB_NAME=name
DAY=`date +%a_%d-%m-%Y`
gzip < exp_test_pipe > exp_test_${DAY}.dmp.gz &
exp username@test.cis.cat.com file=exp_test_pipe log=exp_test_dumps.log parfile=export_options.par

more export_options.par
compress=n
statistics=none
CONSISTENT=n
indexes=Y
owner=test
direct=Y

my password is starts with $

example: $12300$ahhh and hence its not allowing me to execute when given like below..

exp username/$12300$ahhh@test.cis.cat.com file=exp_test_pipe log=exp_test_dumps.log parfile=export_options.par

View 3 Replies View Related

Performance Tuning :: Querying GTT In Parallel Mode

Apr 24, 2012

I am inserting data into a global temporary table and then using 'parallel' hint to query from this temporary table. I remember reading that the queries on the temp table may not run in parallel as the parallel sessions may not be able to see the data in the temporary table

However the execution plan as well as px_session, v$sql indicate that the query on the temporary table in fact run in parallel mode

select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST'));

PLAN_TABLE_OUTPUT
-----------------------------------------------------------------------------------------------------------------------
SQL_ID 7d68g52g0mskz, child number 0
-------------------------------------
select /*+ gather_plan_statistics parallel(t,4) */ * from dbo_gtt t order by id,object_id

Plan hash value: 5815349
--------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | OMem | 1Mem | Used-Mem |Used-Tmp|
--------------------------------------------------------------------------------------------------------------------------
| 1 | PX COORDINATOR | | 1 | | 99999 |00:00:01.46 | 3 | | | |
|
| 2 | PX SEND QC (ORDER) | :TQ10001 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|
| 3 | SORT ORDER BY | | 0 | 1 | 0 |00:00:00.01 | 0 | 11M| 1311K| 424K (0)|
|
| 4 | PX RECEIVE | | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|
| 5 | PX SEND RANGE | :TQ10000 | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|
| 6 | PX BLOCK ITERATOR | | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|
|* 7 | TABLE ACCESS FULL| DBO_GTT | 0 | 1 | 0 |00:00:00.01 | 0 | | | |
|
--------------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------
7 - access(:Z>=:Z AND :Z<=:Z)

select px_servers_executions from v$sql where sql_text like 'select%dbo_gtt t%';

PX_SERVERS_EXECUTIONS
---------------------
0
4

select sid, qcsid, server#, degree from v$px_session where qcsid = 228;

SID QCSID SERVER# DEGREE
---------- ---------- ---------- ----------
247 228 1 4
196 228 2 4
224 228 3 4
234 228 4 4
226 228 1 4
252 228 2 4
212 228 3 4
229 228 4 4
228 228

9 rows selected.

unfortunately I do not have access to get trace (tkprof) report. What must have happened during the execution?

View 3 Replies View Related

Forms :: Getting Data After Pressing TAB In INSERT MODE In 10g?

Nov 9, 2010

What to write in a form for getting data after pressing TAB in 'ENTER-QUERY' MODE on a field having a LOV i.e. a trigger / program unit or what?

View 12 Replies View Related

Replication :: Error During Add New Master In Not Acquiescing Mode

Oct 27, 2008

I have a multimaster replication between 2 sites (BASE1 and BASE3). BASE1 is the master definition site. I want to add a new master site without acquiescing the master group (named GM_ADMINISTRATEUR).

First, I have used the script provided by Oracle :

DBMS_REPCAT.SPECIFY_NEW_MASTER (
gname => 'GM_ADMINISTRATEUR',
master_list => 'BASE2.WORLD' );
and
DBMS_REPCAT.ADD_NEW_MASTERS( ....);

The first time, I had Errors, so I use the command

DBMS_REPCAT.UNDO_ADD_NEW_MASTERS_REQUEST

and I drop the master site BASE2 (connected as repadmin to BASE2 site).

The master site BASE2 is not present at BASE1 master definition site, The master repgroup is not present at BASE2 BUT, the master site BASE2 is always present at BASE3 master site. I think that the command UNDO_ADD_NEW_MASTERS_REQUEST undo the changes on BASE1 (the master definition site) but don't undo the changes on the site BASE3.

And now, when I want redo the add_new_masters, the command

DBMS_REPCAT.ADD_NEW_MASTER
return a error on the command ADD_NEW_MASTER in the DBA_REPCATALOG for the following reason:
ORA-00001: violation de contrainte unique (SYSTEM.REPCAT$_REPSCHEMA_PRIMARY)
ORA-06512: � "SYS.DBMS_REPCAT_UTL", ligne 4484
ORA-06512: � "SYS.DBMS_REPCAT_RPC", ligne 1758

And I can't continue because the new master site BASE2 does not appear at BASE1 master definition site. I think I have to drop the master site BASE2 at the master site BASE3, but I dont know how to do this.

**** Following information at BASE1 (master definition site : *****
prompt Replication schemas/ sites
Replication schemas/ sites
select
sname,
masterdef,

[code].....

View 14 Replies View Related

Precompilers, OCI & OCCI :: Batch Error Mode?

Mar 4, 2010

what is OCI_BATCH_ERRORS and BATCH ERROR Mode ?and how the user can set it ?

View 6 Replies View Related

Forms :: How To Make Query Mode Work (f11)

Apr 2, 2012

I have created a custom form. I have field called Order No. When i query on Order no.. i should be able to pick order no as well as other fields related to it. how do i acheive this functionality. I mean the f11 and ctrl f11 querying functionality.

View 18 Replies View Related







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