How To Clear Audit Files In Dump In HP-UX

Mar 31, 2013

i got many audit file in a dump it is on hp-ux linux normally in linux i use to give

find -name "*.aud" -mtime +20 -exec rm {} ;

what to give in HP-UX linux ?

View 2 Replies


ADVERTISEMENT

Compare Two Dump Files And Their Respective Log Files

Jun 20, 2012

I want to compare two dump files and their respective log files, to see the difference. Is there any way.

View 8 Replies View Related

Server Administration :: Cannot Audit Entry In Dump

Jul 26, 2012

I am trying to enable auditing as

SQL> alter system set audit_trail=OS SCOPE=SPFILE;

System altered.

SQL> STARTUP FORCE
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 2019320 bytes
Variable Size 113246216 bytes
Database Buffers 50331648 bytes
Redo Buffers 6369280 bytes
Database mounted.
Database opened.

SQL> show parameter audit

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u01/app/oracle/admin/orcl/adu
mp
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string OS
SQL>

SQL> create user apexos identified by abc1;

User created.

SQL> grant connect, resource to apexos;

Grant succeeded.

SQL> audit select table, insert table by apexos by access;

Audit succeeded.

SQL> audit table by apexos by access;

SQL> SELECT audit_option, failure, success, user_name
FROM dba_stmt_audit_opts;

AUDIT_OPTION FAILURE SUCCESS USER_NAME
---------------------------------------- ---------- ---------- ------------------------------
TABLE BY ACCESS BY ACCESS APEXOS
SELECT TABLE BY ACCESS BY ACCESS APEXOS
INSERT TABLE BY ACCESS BY ACCESS APEXOS

cONN APPOS/ABC1

SQL> CREATE TABLE TAB1 (ID NUMBER, NAME VARCHAR2(20));

Table created.

SQL> insert into tab1 values (10, 'Michel');

1 row created.

SQL> insert into tab1 values (30, 'Andrew');

1 row created.

SQL> select * from tab1;

ID NAME
---------- --------------------
10 Michel
30 Andrew

SQL> /

ID NAME
---------- --------------------
10 Michel
30 Andrew

SQL>

SQL> select username, timestamp, action_name, action, SES_ACTIONs, sql_text
2 from USER_audit_trail where username='APEXOS';

no rows selected

SQL>

I also did not find any file contiaing the above statement as audit record in
/u01/app/oracle/admin/orcl/adump.

There are numerous old file in the /u01/app/oracle/admin/orcl/adump locaton. But When I executed the sql statement then that time no audit file was not generated in the location.

how to find audit record.

View 5 Replies View Related

SQL & PL/SQL :: How To Dump And Transfer Files With Same Table

Apr 6, 2011

how can i dump and transfer it to another year with the same table

View 6 Replies View Related

Windows :: Scheduled Removing Of Trm And Trn Files From Dump Area

Sep 19, 2011

As I was observing the space issues on my db server. I found that there is lots of Trm and Trc file which is being created very much frequently. Due to this its consuming lots of space even the size of each files is not more than 1Mb.

For cleaning I am deleting all the trm and trc files mannully using DEL command Os level. How can i schedule the purging of trm and trc files.

View 3 Replies View Related

Server Utilities :: How To Export One Table To Few Separated Dump Files

Mar 24, 2010

I have a table with 9 regions. How can I export them in 9 seperated dump file?

View 4 Replies View Related

Server Utilities :: Multiple Export / Import Dump Files?

Apr 25, 2011

I am trying to export/import of a schema who's size is around 60 GB.

Export parfile goes like this..
file=expdmp1.dmp, expdmp2.dmp, expdmp3.dmp, expdmp4.dmp, expdmp5.dmp, expdmp6.dmp, expdmp7.dmp
filesize=10240M
log=explog.log
owner=owner1

Import parfile goes like this..

file=impdmp1.dmp, impdmp2.dmp, impdmp3.dmp, impdmp4.dmp, impdmp5.dmp, impdmp6.dmp, impdmp7.dmp
filesize=10240M
log=implog.log
fromuser=owner1
touser=owner2
ignore=y

I am going to run this on production. So want to check it..

View 2 Replies View Related

Export/Import/SQL Loader :: IMP With Multiple Dump Files And Remap_tablespace

Jan 17, 2013

I have 3 dump files: A.dmp, B.dmp, C.dmp . Can I use multiple REMAP_TABLESPACE entries in a par file to remap the table spaces for the above dump file?

Parfile would look something like this:

DIRECTORY=dpump
DUMPFILE=A.dmp,B.dmp,C.dmp
JOB_NAME=import_3_schemas
REMAP_TABLESPACE=A1:D1
REMAP_TABLESPACE=B1:E1
REMAP_TABLESPACE=C1:F1

The first remap entry is only relevant to A.dmp file
The second remap entry is only relevant to B.dmp file
etc.

View 2 Replies View Related

Server Utilities :: IMPORT (Impdp) Multiple Dump Files

Aug 2, 2012

i have more than 100 dumpfiles to import into my oracle 11g database. i know how to import(impdp) for same named dumps but here all the dumpfile names are totally different(ex: aa.dmp,bb.dmp,).

View 3 Replies View Related

Server Administration :: User Dump / Trace Files With Huge Size In MBs

Mar 22, 2012

I am facing problem in user_dump_dest directory...I have noticed that there are a lot of trace files with huge size in MBs.I clean it and after 4 days there are 40G of size..

View 1 Replies View Related

Audit Vault/Firewall :: How Max Storage Can Audit Vault Server Support

Aug 18, 2013

AVDF current version 12.1 not support External/SAN storage. my question is, if customer get a huge number of Audit log and DBFW event records, then how max size can Audi Vault server support for online data (not archive data)? and can I use a Hardware server with multiple HDDs for AV Server?

View 0 Replies View Related

SQL & PL/SQL :: Clear Data On Column?

Jun 20, 2011

I have one table employer. It has column loginid, password, address, regdate, fullname, identno.

So i want to clear all data before 1 June 2011 in regdate. What command i need to use? I quite new with command prompt.

View 10 Replies View Related

Forms :: How To Clear Record

Feb 13, 2012

In a master and detail relation ship block..When a cursor is placed in the details and enter some thing and giving back space..once value is cleared a empty record is saved in the database with the header values , but in details customer didn't enter anything.

how to clear the detail record in pre insert or when validation ?

View 6 Replies View Related

Forms :: Clear Block If Value Change?

Dec 28, 2011

I Require to Fetch the Group of Value in Item Block Selected through the User Selected LOV Value in Master.

Through Loop i Fetch the Records in Item Block.

When User Change the Selected LOV Value Require to Clear the Item Block.

BEGIN
FOR NRM IN (SELECT MTRLTYPE,STATUS,
MTRL_NO,MTRL_ID FROM JAWOADMIN)
LOOP
GO_BLOCK('NRMTRL_ITEM');
:NRMTRL_ITEM.NRMTRL_TYPE := NRM.MTRLTYPE;
:NRMTRL_ITEM.REMARKS := NRM.STATUS;
:NRMTRL_ITEM.NRMTRLREF_NO := NRM.MTRL_NO;
:NRMTRL_ITEM.NRMTRLREF_ID := NRM.MTRL_ID;
NEXT_RECORD;
END LOOP;
END;

How to Clear the Block before the above loop.

View 1 Replies View Related

PL/SQL :: How To Clear Runtime Error In Ref Cursor

May 27, 2013

the code as follows

create or replace
procedure Country_sel(key in varchar2)
as
cc Res_RelcountryLan.countrycode%type;
len Res_Language.langname_en%type;
lid Res_Language.langid%type;
ab Res_Language.Abrivation%type;

[code]....

when i am running this code im getting

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "RASOOL.COUNTRY_SEL", line 11
ORA-06512: at line 6

View 2 Replies View Related

Forms :: Clear Specific Block?

Sep 21, 2010

i have 4 blocks in one form.my requirement is this that can i user the clear_block or any other built-in for clear the specific block....

View 2 Replies View Related

Application Express :: Checkbox Not Clear Cache

Oct 18, 2013

i have created form with table  page to enter hotel details there is on 6 check box which are not database column .i have create these check box to keep days details when hotel give service .so i have use

LOV FORP1_MON      STATIC2:;1   MONDAYP1_TUE       STATIC2:;2   TUESDAYP1_WED     STATIC2:;3   WEDNESDAYP1_THR       STATIC2:;4  THURSDAYP1_FRI        STATIC2:;5   FRIDAYP1_SAT       STATIC2:;6   SATURDAYP1_SUN       STATIC2:;7   SUNDAY 

i have one more column operating days where i have use computaation to keep operating days.

:P1_MON||:P1_TUS||:P1_WED||:P1_THR||:P1_FRI||:P1_SAT||:P1_SUN 

these 6 check box are used Source used :Only when curren value in session state is nullSource Type : Static Assignment (Value equals source attibute)  Problem are when i create new record then these 6 check box are not clear cache and when i update any record value are not clear cache . i need when i create or update recor then all 6 check box should be null after keep recor. 

View 1 Replies View Related

Precompilers, OCI & OCCI :: Make Files That Compile PC Files In Unix

Jul 31, 2008

I have written make files that compile .pc files in unix. This was for several projects that use an oralib source code directory.Just running proc on one target .pc file works fine on unix. I am trying to use proc - Oracle 10.2.0 - in windows and I keep getting:

Quote:unable to open include file
#include <stdio.h>
and other C library headers.

I am doing all development under cygwin, this way I can write a makefile just like under unix instead of using nmake.All C library headers are in /usr/include When I run proc on Solaris as that:

proc program.pc
No problems, and I do get program.c.

However in windows I get the previous error message. I have tried to do proc include=/user/include program.pc and proc include=/user/include parse=full program.pc but I still get the same error message.

View 3 Replies View Related

Forms :: Clear A Block For Enter Query Mode?

Jan 16, 2012

I am using Forms 6i,Oracle 10g. In a form I created, I have 3 blocks, first is a toolbar type with buttons to save, exit etc., other two are one master and detail data block.

how to get the default Oracle toolbar with the buttons, save, delete etc. I dont get in my form.

When the cursor is inside the detail block and then I click on an EnterQuery button in the first block, how do I clear the detail block, using the on btn press code.

What happens when I click the Enter Query button, is that the cursor and current block becomes the button block and when I run the command ENTER_QUERY, no use.

I need to set the block in which the cursor is to be cleared for query, whether it is master or detail, by pressing the button on the first block.

View 7 Replies View Related

Forms :: To Clear Form And Execute Procedure In Same Trigger

Sep 13, 2011

I have a problem in my form. In my form there are 4 blocks and in one of the block i have a button. In which i put a code same as below:

BEGIN
IF NAME_IN('SYSTEM.FORM_STATUS') = 'CHANGED'
THEN
CLEAR_FORM(NO_VALIDATE);
END IF;
PROCEDURE ABC;
END;

So as per code i want to clear all the changes in form for current session and want to call the procedure ABC after that. But it is not calling the procedure ABC. And what would i do to perform the same?

View 19 Replies View Related

How To Not Expose Password (clear Text) In Expdp Parfile

Jul 3, 2013

I like to create an expdp parfile that would not expose my password in clear text. 

PARFILE:userid=MyAccountName/$MYPASSWORD  <-----this substitution does not work in a parfiledumpfile=xxxxxlogfile=xxxxtables=xxxx

View 3 Replies View Related

Forms :: Clear Block B Once Click FIND Button

Jul 6, 2011

I am working on form builder 6i.I have FIND widnows and MAIN window.

FIND Window: contains field1 and field2, FIND Button.

block A: Multi record data block on table t1. It contains field1,field2,field3.
block B: non datablock, it contains field4, field5.

If i enter something and click FIND button, it will populate data in Block A.If i put the cursor in any record in block A, and after that put the cursor in Block B, it will populate block B related to Block A record.For this, In Block A--> post record(block level) trigger, i am capturing values in variables.

:GLOBAL.f1:=:BlockA.field1
:GLOBAL.f2:=:BlockB.field2

In Block B--> When-New-Block-instance(Block Level)

select field3, field 4 from t2 where t1=:global.f1 and t2=:global.f2;

and populating data in block B.It's working fine.

REQUIREMENT: If i click the FIND second time, in Block B--> it's retaining previous value. I want to clear the block B once i click the FIND button. I tried to write in POST-BLOCK (Block B-->block level)

CLEAR_BLOCK('NO_VALIDATE');

But it's not working.In which trigger i have to write code to clear block.

View 3 Replies View Related

Forms :: How To Clear Line Records When F11 Is Pressed In Header Block

Sep 4, 2011

I am working in form 6i, EBS 11i. I have below requirement to achieve.

I have header data block A, line control block B. My requirement is, i know that in master detail block, if i press F11 in header block, it will clear the line block, like this, in my case if i press F11 in header data block A, i want to clear the line block B. Is there any way we can achieve this.

View 3 Replies View Related

Performance Tuning :: How To Clear Cache For Testing Tuned Code

Jul 4, 2011

i am testing a proc after tuning it but the problem is, it is taking a very very less time which it shouldn't. I know that it is because of the buffer cache and the shared pool. that why i need to clean the cache to retest it.

I cannot bounce the database as other schemas are part of it. so is there any way to clean the cache for that particular schema i.e bouncing any particular schema(i know that the term is not appropriate).

View 4 Replies View Related

Application Express :: Clear Page Cache - All Except Specific Items?

Feb 21, 2013

APEX 4.2.1 On a page with dozens of editable page items, when branching back to the same page on-submit, is there a way to clear cache for all items except a few (key) items? The branch attributes (via the f?p= syntax) support clearing cache for the entire page and setting specific item/value pairs but no support for exclusions.

View 2 Replies View Related

Know If Database Files Are On File System Or Raw Files?

Oct 11, 2012

How can I know if database files are on file system or raw files?

View 4 Replies View Related

Server Administration :: How To Avoid Clear Password In Checkpoint File With Oracle DBCA

Nov 15, 2011

I found there is clear password in the xml file in the process of Oracle instance creating. The process like below

1, when using the following process to create the instance

Login as user Oracle
/home/Oracle11home/bin/dbca -createDatabase -silent -templateName /home/Oracle11home/assistants/dbca/templates/Small.dbt -gdbName testDB -sid testSID -sysPassword [b]testpwd[/b] -systemPassword [b]testpwd[/b]

2. Found the file in $ORACLE_HOME/checkpoints/dbca/OraDb11g_home2_oracle_creation_checkpoint.xml , it listed the sys and system passwd (like testpwd for sys and system password) directly.

<CHECKPOINT LEVEL="MAJOR" NAME="db_oracle" DESC="db creation checkpoint" STATE="FAIL">
<PROPERTY_LIST>
<PROPERTY NAME="command" TYPE="STRING" VAL=" -silent -createDatabase -templateName Small.dbt -gdbName testDB -sid testpwd -sysPassword testpwd -systemPassword testpwd"/>
</PROPERTY_LIST>
</CHECKPOINT>

I hope to confirm :

1. what is the purpose for oracle to genate the checkpoint.

2, can we remove the file safely ?

3, if there is configuration that we can avoid to show clear password in checkpoint file?

View 1 Replies View Related

Application Express :: How To Show Alert When Data Not Exist In Table And Clear Field

Jun 8, 2012

Recently i created a form which contains emp_name,deptno,supervisor_name.For emp_name if i type the emp name (eg:allen) it will show me a list of employees named allen as a select list.For that i used a jquery script on page header

<link rel="stylesheet" href="URL.....
<script type="text/javascript" src="URL....
<script type="text/javascript">
[code]....

and i have created a dynamic action for emp name to fetch the deptno,supervisor_name if select the employee name it is working fine is if i type a emp_name which doesn't exist in the employee table it will show me a alert message employee does not exist and it will clears all the fields.

View 0 Replies View Related

Forms :: First Form Clear Previous Data And Then Populate Data From Table

May 7, 2012

when i press when button pressed trigger, i want first the form will delete all the previous data and then populate the data from the table, that's why i used clear_block first, but this clear_code is not working here. my coding is given below

go_block('show');
clear_block(NO_VALIDATE);
declare
cursor c1 is select *
from qtr_demand order by 1;
begin
[code]..........

View 26 Replies View Related

Forms :: Clear Block Message In Oracle Forms?

Nov 30, 2012

I am creating a form with 3 blocks.

Control block,
Header Block,
Detail Block.

First i have entered a record in the control block.

Then i navigate to header block,entered the first record for Header Block.

Then i navigate to Detail block,entered the first record for detail Block.

then i again navigate to Header Block..

Now the Problem comes....As i am Trying to enter second record for header block,the pop up comes as "Do you want to save the changes".

Condition 1:i dont want that message to appear for every header record i enter.

Condition 2:For every header record i enter,Corresponding detail record would have been entered.i want that detail records to be retained if i am clicking that header record as i have already created relationship for both header block and detail block.

View 1 Replies View Related







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