Regresar
-
Título
SP2-0750: You may need to set ORACLE_HOME to your Oracle -
Descripción
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 -
Resolución
Resolution:Once the SQL objects are migrated, they are then executed in SQLPlus. I believe the SQL objects migrated fine, but SQLPLus was unable to start.1. Try to start SQLPlus outside of Stat to see whether it starts.On the host in question, log in as the app's user and try to start SQLPlus.The message indicates that the Oracle_home is not defined, but it could be some other environment setup. 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\libIf all the above points check fine, set the log level on the host in question to debug in stat.conf, stop/restart the 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 again on SQLplus, please share the latest log file from the host in question found in $AGENT_HOME/log directory.