Monday, August 31, 2020

How to zip files in the current directory

›
In its simplest form, to zip a number of similary named files, use this syntax: zip client_sql_trace client*.trc where the resulting zi...
Tuesday, August 18, 2020

How to check the password file version

›
oracle@oric01.oric.no:[PRODDB01]# orapwd describe file=/u01/oracle/product/12201/dbs/orapwPRODDB01 Password file Description : format=LEGA...
Thursday, August 13, 2020

How to perform a full export and import of an entire database in PostgreSQL

›
Export the database "db01" from your source postgres server: pg_dump db01 -v -Fc >db01.dmp The -v means ...
Monday, August 10, 2020

what is the difference between DBA_AUDIT_TRAIL and DBA_COMMON_AUDIT_TRAIL?

›
The difference between these views is that DBA_COMMON_AUDIT_TRAIL contains information from both standard and fine-grained auditing, while...

How to set parallelism for a data guard recovery process

›
If you need to manually set the apply-process DOP (Degree of Parallelism), you can do this by setting the property ApplyParallel= num whe...
Tuesday, August 4, 2020

What constitute "mandatory auditing" under Unified Auditing?

›
Activities from administrative users such as SYSDBA, SYSBACKUP, and SYSKM.   The following audit-related activities are mandatorily audite...
Monday, August 3, 2020

How to find offending process when getting error umount.nfs: /data1: device is busy

›
As root, use lsof ("list open files"): [root@myserver /home/oracle]# lsof | grep '/data1' extract 14041 oracl...