Record log in rman with SPOOL

1) Login RMAN $rman target /
2) Turn on output logfile RMAN> SPOOL LOG to '/home/oracle/crosscheck.txt'
3) Execute command will be keep log
Example:RMAN> crosscheck backupset;
4) Turn off output logfile RMAN> SPOOL LOG OFF;
--------------------------------------------------
RMAN target /
SPOOL LOG to '/home/oracle/audit_sep.txt';
crosscheck backupset;
crosscheck backup of controlfile;
crosscheck archivelog all;
SPOOL LOG OFF;


Fix VLC bad sound in Linux Ubuntu 12.04

After install Ubuntu 12.04, the most of bad thing in this Distribute is sound quality of VLC. For fix this, i take follow solution bellow.

1) Open Terminal and Edit file default.pa: sudo gedit /etc/pulse/default.pa input password and press ENTER

2) lookup load-module module-udev-detect and modify follow: load-module module-udev-detect tsched=0 Click save, reopen VLC and listen with new quality.

ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O

When check Oracle database alert log, we found message: ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O

Cause
The core of this error is kernel limit parameter too slow. Example # cat /proc/sys/fs/aio-max-nr
65536 # cat /proc/sys/fs/aio-nr
65536 Solution:
We can increase aio-max-nr for resolver this error Example: Change kernel parameter: # sysctl -w fs.aio-max-nr=3145728 Check again: # cat /proc/sys/fs/aio-max-nr
3145728 If problem continues, we need to try configuration system parameter higher.

Install Keypass on Ubuntu

keepass is software for generate pass and keep password. For install keepass we need open Terminal and take command follow: sudo apt-add-repository ppa:jtaylor/keepass sudo apt-get update sudo apt-get install keepass2

Apply Patch EBS R12

1) Download Patch from Metalink and uzip patch file.

2) set Enviroment parameter by run env file.
. /oracle/erp/R12/apps/apps_st/appl/APPSERPR12_erp.env

3) Stop Application Services
$INST_TOP/admin/scripts/adstpall.sh apps/apps

4) Change system to maintain mode
sqlplus -s apps/apps @$APPL_TOP/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE

5) apply patch
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u7677429.log patchtop=/d01/7677429 interactive=yes workers=8

6) Take system out of maintain mode
sqlplus -s apps/apps @$APPL_TOP/ad/12.0.0/patch/115/sql/adsetmmd.sql DISABLE

7) Start EBS application services
$INST_TOP/admin/scripts/adstrtal.sh apps/apps

How To Install Unikey on Ubuntu 12.04

1) Open Termial and Install Ibus-unikey sudo apt-get install ibus-unikey

2) Open System Setting> Language Support > Keyboard input method: Ibus

3) Reboot system  sudo reboot 4)  On top of right click icon Keyboard  >  Preference >  Input Method >  Customize Active Method input > Vietnamese: Unikey > add > close