If you run into the following errors when attempting to startup an Oracle db (11gr2 in my case) on VM created on an intel chipset, then copied to an amd chipset, you could face the following errors:
SQL>startup
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel
then, subsequent commands:
SQL>startupORA-01012: not logged on
Log onto support.oracle.com and get the following patch:
8670579
if you also search the knowledgebase, you'll find some info about installing.
I ran into this issue when first attempting to run the patch:
"Following executables are active :/app/rsulliv1/product/11.2.0/dbhome_2/lib/libnnz11.soApplySession failed during prerequisite checks: Prerequisite check "CheckActiveFilesAndExecutables" failed.System intact, OPatch will not attempt to restore the system
OPatch failed with error code 74"
I had to search for any running oracle processes:
ps -ef | grep oracleps -ef | grep tns
if any related pids show, kill them.
Then manually copy the libnnz11.so file to any backup location. the patch installation will replace that file, but verify that it is replaced.
After that organizing, the patch installed correctly. The patching process brought up my db and I was successfully able to access it on my VM running on the AMD x64 host.
Please feel free to post any questions or comments if you have similar issues and this helped. Or, if you ran into any additional hurdles along the way, let us know and we'll see if we can help each other out.
Thanks,
-ryan
