Monthly Archives: September 2014

USER xxx is being audited for all SELECTS in alert log


There are some (or many) messages in the alert.log as follows: USER 231 is being audited for all SELECTS USER 231 is being audited for all SELECTS Tue Sep 23 16:18:13 2014 USER 232 is being audited for all SELECTS USER 232 is being audited for all SELECTS The cause is best explained with a […]

How To Determine the SQL Expression That May Be Causing ORA-01000


#sqlplus / as sysdba SQL> select c.sid as “OraSID”, c.address||’:’||c.hash_value as “SQL Address”, COUNT(c.saddr) as “Cursor Copies” from v$open_cursor c group by c.sid, c.address||’:’||c.hash_value having COUNT(c.saddr) > 2 order by 3 DESC ; then pass the result from ‘SQL Address’ to the following : SQL> select SQL_FULLTEXT from v$sql where ADDRESS ||’:’||HASH_VALUE = ‘<SQL Address>’ […]

Connecting to Microsoft SQL Server database from Oracle using Database Gateway for SQL Server


Copying files from ASM to file system


Method 1 : Using ASMCMD Utility oracle@anartest datafiles]$ pwd /u01/datafiles [oracle@anartest datafiles]$ ls [oracle@anartest datafiles]$ [oracle@anartest ~]$ asmcmd ASMCMD> ls -lt State Type Rebal Name MOUNTED EXTERN N DATA/ MOUNTED EXTERN N DG1/ MOUNTED EXTERN N FRA/ MOUNTED EXTERN N OCR/ ASMCMD> cd dg1 ASMCMD> cd testdb/datafile ASMCMD> ls -lt Type Redund Striped Time Sys […]

ORA-27167: Attempt to determine if Oracle binary image is stored on remote server failed


ORA-27167: Attempt to determine if Oracle binary image is stored on remote server failed ORA-27300: OS system dependent operation:parse_df failed with status: 2 ORA-27301: OS failure message: No such file or directory ORA-27302: failure occurred at: parse failed $ sqlplus ‘/as sysdba’ SQL*Plus: Release 11.1.0.7.0 – Production on Thu Jun 24 07:27:29 2010 Copyright (c) […]

ORA-12751: cpu time or run time policy violation


Q: What is the error “ORA-12751: cpu time or run time policy violation” means? A: This is an undocumented error. Cause: A piece of code ran longer than it is supposed to Action: If this error persists, contact Oracle Support Services. This error happens most commonly  with MMON process while taking AWR snapshots. If the […]

Active Session History (ASH) performed an emergency flush. This may mean that ASH is undersized. If emergency flushes are a recurring issue, you may consider increasing ASH size by setting the value of ASHSIZE to a sufficiently large value. Currently, ASH size is 67108864 bytes. Both ASH size and the total number of emergency flushes since instance startup can be monitored by running the following query: select total_size,awr_flush_emergency_count from v$ash_info;


MOS: Active Session History (ASH) Performed An Emergency Flush Messages In The Alert Log (Doc ID 1385872.1) bash-3.2$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.3.0 Production on Thu Sep 11 14:03:36 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production With the Partitioning, […]

How to protect your sensitive data using Oracle Database Vault


Any measures that should be taken for data security purposes should also be considered at the database level, similar to hardware, network and operation system levels. Generally, companies buy a firewall product and think that they have already solved the problems related to security. Researches show that despite it is possible to take measures against […]

Expdp / ORA-39065 / ORA-01403


expdp DIRECTORY=DATA_PUMP_DIR DUMPFILE=xxxxxxxxxxxxxxxxxx….. Username: / as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options ORA-39006: internal error ORA-39065: unexpected master process exception in DISPATCH ORA-01403: no data found ORA-39097: Data […]

ORACLE 11G EXPDP AND IMPDP FEATURE


COMPRESSION parameter in expdpOne of the big issues with Data Pump was that the dumpfile couldn’t be compressed while getting created. In Oracle Database 11g, Data Pump can compress the dumpfiles while creating them by using parameter COMPRESSION in the expdp command line. The parameter has three options: METDATA_ONLY – only the metadata is compressed, […]

ORA-00376 : file 43 cannot be read at this time


connect to Oracle AS SYSDBA sqlplus / as sysdba SQL> select * from v$recover_file; FILE# status 43 OFFLINE SQL> recover datafile 43; ORA-00279: change 271477927444 generated at 15/11/2013 10:30:46 needed for thread 1 ORA-00289: suggestion : /export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arcORA-00280: change 271477927444 for thread 1 is in sequence #170675 Specify log: {=suggested filename AUTO CANCEL} AUTO ORA-00308: cannot […]