Enable / Disable Archive Mode From The Pfile In Oracle 10g?

Jul 12, 2012

I am using oracle 10g. Is there any mechanism to / parameter to enable or disable archive log mode? can I enable arching directly from pfile without touching the startup process?

View 2 Replies


ADVERTISEMENT

Forms :: How To Enable / Disable Keyboard Shortcuts In Oracle Apps

May 12, 2010

How do we need to enable or disable the keyboard shortcuts in Oracle Apps like Shift+F6 for duplicate record, also how do I change the functionality, I mean suppose I want Key-M to do the same function as shift+F6.

View 2 Replies View Related

Enable / Disable Auditing From PHP

Dec 15, 2010

In PL/SQL Plus, i can enable/disable auditing when i connect as sysdba by using these command:

SQL> ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE
SQL> shutdown
SQL> startup

I've done it successfully with PL/SQL Plus command line. But in PHP, how can i do that?How to execute "shutdown" and "startup" from PHP?
I've found this code for connect to oracle as sysdba:

oci_connect("/", "", null, null, OCI_SYSDBA);

From the following link:

[URL]......

But, i still can't execute "shutdown", "startup";

View 4 Replies View Related

SQL & PL/SQL :: How To Disable Or Enable All Constraints In A Table

Apr 8, 2010

I knew, how to enable or disable a constraint on a table.

>alter table <table_name> disable constraint <constraint_name>;

But if we know all the data is correct, it's better to disable all constraints to improve the performance.

We are allowed to Disable or Enable only a single constraint.

Enable or Disable All Constraints.

View 11 Replies View Related

Server Administration :: Enable / Disable Row Movement

Oct 20, 2011

for defragment of a table,

after enable it:

alter table test enable row movement;

do i need to:

alter table test disable row movement; ??

View 3 Replies View Related

Client Tools :: Disable And Enable Constraints?

Feb 7, 2011

how to disable and enable all constraints pertaining to one table at once. I want to disable them at once and also enable them at once. I make use of TOAD.

View 14 Replies View Related

Forms :: Enable Or Disable Current Item In Block?

Feb 1, 2011

I have one tabular block on the canvas and there is one check box on this block. I want that when I uncheck this checkbox, one item on the current record gets disabled.

i manage to turn all the records enabled or disabled.

I am attaching a dummy form in which I have tried. Checkbox is acting on field :ecc_no.

The DB table for the same is:

CREATE TABLE ECC_MASTER
(
PARTY_TYPE CHAR(1 BYTE) NOT NULL,
PARTY_CODE CHAR(5 BYTE) NOT NULL,
ECC_NO VARCHAR2(25 BYTE) NOT NULL,
RANGE_DIVISION VARCHAR2(30 BYTE),
EMP_NO NUMBER(4) NOT NULL,

[code]....

View 7 Replies View Related

Forms :: Enable / Disable Menu Items For Different Users?

May 14, 2011

Enable / Disable menu items for different users.

how to create different users give in demo files i am using 10gforms.

View 1 Replies View Related

Forms :: How To ENABLE / DISABLE Item Dynamically During 6i Runtime

Mar 24, 2012

I have a master-detail form showing multiple records (tabular) in data-block. Now my problem is, based on certain column's value of a particular item in a particular row on the data-block to ENABLE/DISABLE during run-time .

For example, in a detail-block of 5 rows, if 3rd row's 'detail-block.item1' is equal to lets say, "X", then 'detail-block.item2' of that particular row ONLY must be 'disabled'. otherwise, it must 'enable' the 'detail-block.item2' of that particular item in that particular row on the data-block.

Even when, I query the form, it must enable/disable that particular item of that particular row from the data-block based on item1's value.

View 4 Replies View Related

Forms :: How To Use ALTER TABLE Command To Disable / Enable Constraints

Aug 11, 2010

can you use alter table command to disable/enable constraints in a form if you can how, if you cant why

View 4 Replies View Related

Application Express :: Enable / Disable Of Button Based On LOV Not Working

Oct 10, 2012

I have a Select list which when null should disable a button and when not null should enable it. For which I tried the Advanced DA. Strangely, in the final page where we select the item that is going to be controlled, the button is not listed! I can see other display items etc which I can select but not the button.

View 0 Replies View Related

Performance Tuning :: Disable Db_block_buffers Parameters In Order To Enable Sga_target?

Jun 15, 2012

What value should i set for sga_target in my oracle 10g database?

Currently -
sga_max_size = 32GB
pga_aggregate_target = 6GB
RAM on server = 64 GB

I'll need to disable db_block_buffers parameters in order to enable sga_target. right?

View 8 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

Normal Pfile With Many Parameters In Pfile That Can Be Changed

Jan 22, 2013

I have issued to create pfile from spfile. When I run the create command it is done successfully but in my pfile content has only one parameter of *.SPfile='D:apporacleproduct11.2.0dbhome_1databaseSPFILEORCLE1.ORA'

I want to have a normal pfile with many parameters in the pfile that it can be changed.

View 17 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

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

Backup & Recovery :: Change Archive Log Mode During DB Running?

Aug 24, 2011

changing archive mode during DB running.Before in 9.2, 'ALTER SYSTEM ARCHIVE LOG START/STOP' is available for this job. But, after 10g/11g, it cause 'archive log stop has been deprecated'.

However, for my practice, I need to estimate archived logs size before backup them, so I need to stop archive log for a while and enable it later during DB running.

I check Oracle documents, it only mentions changing archive log mode at DB mounted but not open.

View 12 Replies View Related

Server Administration :: How To Offline Datafile In No Archive Mode

Oct 31, 2011

I want to drop a datafile in my test db which is in no archive mode,at first, i want to offline the datafile,but it failed,is there any way to do it?

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 3237
[code].......

View 8 Replies View Related

How To Enable And Disable A Field Dependent On Another Field In Apex

May 9, 2013

I am New to Apex. Im using Apex Version 4.2.

I have a tab named APPROPRIATIONS it has 10 fields. Among which is PROJECT NUMBER, AUTHORIZAION DATE (CALENDER TYPE POPUP), And FUNDS CHECK FLAG.

The Scenario is depending upon PROJECT NUMBER the Fields are Populated including FUNDS CHECK FLAG .

But the AUTHORIZAION DATE is a MANDATORY field has to be filled by User

The Requirement is to make AUTHORIZAION DATE as MANDATORY only when the FUNDS CHECK FLAG is *"BLANK "* or *“Y”*

If the FUNDS CHECK FLAG is *“N”* then the AUTHORIZAION DATE to be made OPTIONAL.

View 2 Replies View Related

Replication :: Should Target DB In Replication Be In Archive-log Mode

Jul 26, 2008

I am implementing one-way replication between 2 databases.

Do people leave the target database in archive-log mode? Do they backup the target database?

View 4 Replies View Related

Security :: How To Enable Auditing In Oracle

Dec 8, 2011

How to enable auditing in oracle ?

View 2 Replies View Related

Performance Tuning :: How To Enable AWR In Oracle 10g

Jul 12, 2013

I have installed database in one server. I would like to enable AWR into it. Statistics_level is set to Typical. While running the below script to enable the AWR, its gives error -

SQL> exec dbms_scheduler.enable('GATHER_STATS_JOBS');
BEGIN dbms_scheduler.enable('GATHER_STATS_JOBS'); END;

*
ERROR at line 1:
ORA-27476: "SYS.GATHER_STATS_JOBS" does not exist
ORA-06512: at "SYS.DBMS_ISCHED", line 4343
ORA-06512: at "SYS.DBMS_SCHEDULER", line 2802
ORA-06512: at line 1

make AWR automatical generation.

View 3 Replies View Related

SQL & PL/SQL :: Disable Oracle 11 Audit (AUD)

May 31, 2012

is it possible to disable audit logging (audit_file)? (Ora 11)

View 27 Replies View Related

SQL & PL/SQL :: How To Disable Procedure On Oracle

Oct 18, 2010

how to disable procedure on oracle

View 3 Replies View Related

Server Administration :: How To Enable Firewall For Oracle Database

Sep 15, 2010

How to enable firewall for Oracle Database..? Is it db specific..? or If I implement the firewall It will be applicable to all the databases in the server which are using same oracle home..?

View 7 Replies View Related

How To Enable Oracle Advance Compression For EXIST Partitioned Table

Feb 8, 2013

I have to enable oracle advance compression for existing table which PARTITION BY RANGE then SUBPARTITION BY HASH.

ORacle version: 11.2.0.2.0

View 5 Replies View Related

Disable Archiving In Session Level Oracle 11g Rel 2?

Jul 30, 2013

I  just want to write some data  in a particular table,But  I  dont  want it  to be  archivedSo is  it possible to disable archiving in session level Oracle 11g Rel 2

View 3 Replies View Related

Installation :: 11g R2 In Fedora 17 (32 Bits) System - Oracle Patch To Enable DB Console?

Apr 23, 2013

I have been working in the installation of oracle 11g r2 in my fedora 17 (32 bits) system for a few days and still have not gotten.Now I found that I need the OPtatch for enable the db console and even being a member of My Oracle Support I can not request the patch for a technical question.

1) Note to the Approver: I am that one because I am an end user (freelance)

2) Support Identifier: How can I get it?

View 6 Replies View Related

Reports & Discoverer :: How To Disable Printing Option In Oracle 10g

Sep 17, 2012

By setting the parameters in set_report_object_property parameters we can disable the printing option in 11g. Do we have some kind of option , to do the same in 10g.

View 1 Replies View Related







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