SP2-0750: You may need to set ORACLE_HOME to your Oracle
When we are trying to migrate objects in 12.2 EBS environment , receiving below error. This error is coming after we upgrade stat to 5.7.4. Please look on it.
Below error is coming in process request log...
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Once the sql objects are migrated, they are then executed in SQLPlus. I think the sql objects migrated fine but SQLPLus was unable to start. Try to start SQLPlus from outside of Stat to see whether or not it starts. On the host in question, login as the apps user and try to start SQLPlus. The message indicates Oracle_home is not defined but it could be some other environment setups. Check the ORACLE_HOME on the host in question to make sure it is correct. Also check LD_LIBRARY_PATH and make sure the Oracle libraries are listed. For example $ORALCE_HOME\lib or $ORACLE_HOME\lib32.
If all above points check fine set loglevel on the host in question to debug in stat.conf, stop/restart E-business agent on the host in question (make sure the E-business agent starts with aplmgr user) perform the migration once more and if it fails agian on SQLplus e-mail me the latest agent log file from the host in question from $AGENT_HOME/log directory. Here is an example from stat.conf on how you can set the log.level to "debug" mode: