Hi Gurus,

I am installing solman 7.0 installation on Linux x86_64 ending with follwing error .

WARNING 2008-07-18 19:24:27.733
SQL statement or script failed. DIAGNOSIS: Error message: SP2-0310: unable to open file "ora_query3_tmp0_1.sql"
Disconnected
. SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

ERROR 2008-07-18 19:24:35.745
CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-01092: ORACLE instance terminated. Disconnection forced

ERROR 2008-07-18 19:24:35.747
MUT-03025 Caught ESAPinstException in Modulecall: ORA-01092: ORACLE instance terminated. Disconnection forced

ERROR 2008-07-18 19:24:35.863
FCO-00011 The step runCatblockSql with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|runCatblockSql was executed with status ERROR ( Last error reported by the step :Caught ESAPinstException in Modulecall: ORA-01092: ORACLE instance terminated. Disconnection forced

We tried changing permission to the file "ora_query3_tmp0_1.sql"
but sapinst is changing the permissions every time.

my tmp directory is in /WORK/SAP/<SId>/install

PLease sugest ..

Regards,
Sriram

Hi Kevin,

II tried running sapinst as oraadmin by switching as suora but still the same issue , I hope this what you are referring to ?

Please let me know .

Regards,
Sriram

by which user u started ur installation ?

is it root ?

Hi Markus, Please check the log , database : oracle 10.2.04 TRACE 2008-07-23 14:47:18.474 [iaxohsqlx.hpp:1128] COraSQLScriptExec::executeScript() Temporary SQL script file: TRACE 2008-07-23 14:47:18.496 [syuxctask.cpp:1382] CSyTaskImpl::start(bool) A child process has been started. Pid = 3260 TRACE 2008-07-23 14:47:18.907 [iaxohsqlx.hpp:1028] COraSQLScriptExec::executeScript() Executable started and waited successfully. Return code = 0 TRACE 2008-07-23 14:47:18.907 [iaxohsqlx.hpp:1048] COraSQLScriptExec::executeScript() COraSQLScriptExec::executeScript: Script executed successfully. TRACE 2008-07-23 14:47:18.908 OraSqlStatement3.execute: Result of SQL: {executionWasSuccessful: true} TRACE 2008-07-23 14:47:18.911 OraSqlStatement3.execute: Going to execute 'STARTUP' TRACE 2008-07-23 14:47:18.911 _objectContainsFunction: found function checkValid TRACE 2008-07-23 14:47:18.913 [iaxobsqlex.cpp:815] COraSQLExecute::executeSQLStatement_impl(...) Temporary SQL script file: TRACE 2008-07-23 14:47:18.914 [iaxohsqlx.hpp:1128] COraSQLScriptExec::executeScript() Temporary SQL script file: TRACE 2008-07-23 14:47:18.936 [syuxctask.cpp:1382] CSyTaskImpl::start(bool) A child process has been started. Pid = 3272 TRACE 2008-07-23 14:47:25.926 [iaxohsqlx.hpp:1028] COraSQLScriptExec::executeScript() Executable started and waited successfully. Return code = 0 TRACE 2008-07-23 14:47:25.926 [iaxohsqlx.hpp:1043] COraSQLScriptExec::executeScript() COraSQLScriptExec::executeScript: Script executed with error message. TRACE 2008-07-23 14:47:25.929 OraSqlStatement3.execute: Result of SQL: {errorMessage: "ORA-01092: ORACLE instance terminated. Disconnection forced\n\n\nDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\nWith the Partitioning, Data Mining and Real Application Testing options\n", executionWasSuccessful: false} ERROR 2008-07-23 14:47:25.929 [iaxxinscbk.cpp:260] CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-01092: ORACLE instance terminated. Disconnection forced Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options . SOLUTION: See ora_sql_results.log and the Oracle documentation for details. TRACE 2008-07-23 14:47:25.929 [iaxxejsbas.hpp:408] handleException() Converting exception into JS Exception Exception. TRACE 2008-07-23 14:47:25.930 Function setMessageIdOfExceptionMessage: modlib.jslib.caughtException ERROR 2008-07-23 14:47:25.930 CJSlibModule::writeError_impl() MUT-03025 Caught ESAPinstException in Modulecall: ORA-01092: ORACLE instance terminated. Disconnection forced Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options . TRACE 2008-07-23 14:47:25.931 [iaxxejsbas.hpp:483] EJS_Base::dispatchFunctionCall() JS Callback has thrown unknown exception. Rethrowing. TRACE 2008-07-23 14:47:25.957 [syuxctask.cpp:1382] CSyTaskImpl::start(bool) A child process has been started. Pid = 3303 TRACE 2008-07-23 14:47:26.011 [syuxctask.cpp:1382] CSyTaskImpl::start(bool) A child process has been started. Pid = 3304 ERROR 2008-07-23 14:47:26.45 [sixxcstepexecute.cpp:951] FCO-00011 The step runCatblockSql with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|runCatblockSql was executed with status ERROR ( Last error reported by the step :Caught ESAPinstException in Modulecall: ORA-01092: ORACLE instance terminated. Disconnection forced Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options .). TRACE 2008-07-23 14:47:26.77 [iaxxgenimp.cpp:752] CGuiEngineImp::showMessageBox

An error occurred while processing service SAP Solution Manager 4.0 Support Release 4 > SAP Systems > Oracle > Central System > Central System( Last error reported by the step :Caught ESAPinstException in Modulecall: ORA-01092: ORACLE instance terminated. Disconnection forced Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options .). You may now

• choose Retry to repeat the current step.
• choose View Log to get more information about the error.
• stop the task and continue with it later.

Log files are written to /WORK/SAP/ZTS/install/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS.