Oracle expdp & impdp with sysdba accounts
So ideally, you would create an account and grant it the necessary privileges to perform datapump export and import But, in the rare occasions that you need to do this,…
IIS 7.x and Oracle Client 11.x : System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
Applies to: IIS v7 on Windows 2008/R2 Oracle client v11.x 64-bit Symptom: an exception “System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater” may occur when Combination of IIS…
A bit more on sudo: Assigning selective privileges to executables
So I have a user in my box, dedicated only to run database dump from our oracle database. All they have to do, is to execute a specific command, with…
Create a raw Logical Volume for Oracle ASM on AIX
Oracle’s ASM uses raw device to perform their disk operation. What we usually do is that we assign a LUN from a SAN to a server, then assign the raw…
Preparing LUNs for Oracle RAC ASM on AIX
RAC clusters share the same disk(s) among its nodes, and basically you what we need to make sure that the disk(s) is recognized by each RAC nodes under the same…
how to find files by age
So I don’t know what that vendor engineer did to my EBS install, some of the concurrent manager function is spitting temporary files to my /tmp directory. The thing is,…
ORA-27054 on RHEL
I previously encountered this issue on my 10.2 RAC nodes running on top of HP-UX. I faced it the 2nd time when performing postclone operation on a Oracle EBS 12.0.0.5…
sqlplus with crontab
Ever want to run oracle’s sqlplus with crontab? Most of the time, the script won’t be executed, even though you’re already using the right user account. This is because crontab…