Category Archives: Linux

Copy files from remote to remote through local host

Well, I just realized I have to copy oracle data pump files from Data Center A to Data Center B and they can’t reach each other. But I can reach both of them from my local machine, named C. In … Continue reading

Posted in Linux, Oracle Database | Tagged , , , , | Leave a comment

Reset Oracle Linux root password if forgot it

It is a procedure “edit GRUB boot menu , enter user single mode, update password and boot”. For Oracle linux. Check out steps in post at “oraworld.co.uk“. For other linux , see this post at  “linuxconifg.org“. Mine is Oracle linux … Continue reading

Posted in Linux | Tagged , , , | Leave a comment

automate killing processes older than N days

It saves a lot of efforts once I scheduled such script in crontab, to kill ftp program older than 2 days ago. find /proc -maxdepth 1 -user oracle -type d -mtime +2 -exec basename {} \; 2>/dev/null | xargs ps|grep … Continue reading

Posted in Linux | Tagged , , , , | Leave a comment

Send email with text attachment

Always forgot it when use it , but it is simple. $ mail -s “Subject” page_me@my_company.com <attachment.txt  

Posted in Linux | Tagged , , | Leave a comment

Workaround for RMAN-20204: translation not started in RMAN catalog database

I tested ‘open resetlogs’ is the quick workaround if RMAN stuck with “RMAN-20204: translation not started“. Well, it caught my attention when I saw “RMAN-20204: translation not started” in RMAN log file, of course, RMAN aborted right away. >> RMAN-00571: … Continue reading

Posted in Linux, Oracle Database, Oracle RMAN backup | Tagged , , , , , , , | 1 Comment

Oracle Bug: ORA-600 [krbmror_sameline_2]

Well, I got page again today, “RMAN backup failed” shows off in the title. It eventually proved RMAN session hit Oracle bug in 11.2.0.1 though RMAN finished backup successfully. It is because RMAN scripts has “set echo on”, LoL. Wed … Continue reading

Posted in Linux, Oracle Database, Oracle RMAN backup | Tagged , , , | 1 Comment

ORA-16086: standby database does not contain available standby log files – Standby database FRA filled up

Well, Oracle Metalink covered some scenarios where error messages shows off like this: “ORA-16086: standby database does not contain available standby log files” (see MOS 1155773.1). However, I got new reason for this: Flash recovery area is filled up in … Continue reading

Posted in Linux, Oracle Data Guard, Oracle Database | Tagged , , , , , , | 1 Comment