This content has been marked as final. Show 3 replies
Is ORACLE_HOME properly set?
Is $ORACLE_HOME/bin in your PATH?
Edited by: EdStevens on Sep 19, 2012 2:52 PM
id env|grep ORA|sort env|grep PATH
We had the exact same error. The issue is there a conflicting file set install. For example on our system there it was at version 6.1 TL 6 ML 5. However someone installed a ML 6 fileset. Everything worked just fine until a reboot. We update our system to TL 6 ML 6, rebooted, and the problem went away.
Is necessary to relink the Oracle binaries following an OS upgrade. OS upgrades include upgrading to a maintenance level of the same release or upgrading from one OS release to another.
Oracle software comes as object files or source files which get relinked with OS libraries at the time of installation to generate the executable. When one upgrades or applies patches to the operating system, the libraries which are linked with Oracle binaries, may get updated. Ideally, updated libraries also would work fine with Oracle binaries as OS vendors maintain backward compatibility. It may still happen that new libraries may not compatible with old libraries (because of bugs in OS libraries or with the Oracle product itself). Therefore, to be safe, one should always relink post OS upgrade. This also serves as a sanity check should there be problems of what changed in the environment when linking last worked.
So, as user Owner of ORACLE_HOME.
Stop all Oracle Process under this ORACLE_HOME
I recommend you use this tech note on MOS: *Is It Necessary To Relink Oracle Following OS Upgrade? [ID 444595.1]*
Edited by: Levi Pereira on Sep 19, 2012 11:37 PM