set fileformat=unix

Short, sweet and very useful.

Was running a shell script in Linux to execute some SQL, and got the following error during start of script:

^M: bad interpreter

Yes, received the script from the windows.

Now to rectify this, open the script file in VI editor and give following command:

:set fileformat=unix

save it with :wq

and run it again.

Should Run like a beaut. 

Bundle Patch 14 Installation for Exadata Quirk

While applying BP14 in half rack of Exadata V2, got following error from node 2:

The opatch Component check failed. This patch is not applicable for /u01/app/oracle/product/11.2.0.2/dbhome_1

The opatch Applicable check failed for /u01/app/oracle/product/11.2.0.2/dbhome_1.

The patch is not applicable for /u01/app/oracle/product/11.2.0.2/dbhome_1

The patch ran successfully at the node 1.

After a little poking found out that the OPatch directory in the grid home had its owner set to root, while at the node 1 the owner was oracle.

So I ran chown -R OPatch/ in grid home and ran the patch again, and it worked like a charm.