Installe EHP4 Error phase "check oracle patch"

[Former Member]

Dear Masta,

I install EHP4 but have a problem at phase check oracle patch.

I finish install oracle and finish patch the oracle, but finish patch oracle, not have a popup running for the execute /oracle/SID/102_64 (root.sh).

Log Error Sapinst_dev.log

sapinst_dev.log - Google Drive

Maybe this error:

TRACE      2014-01-12 18:00:40.943

sqlplus file not exists: /oracle/SBX/102_64/bin/sqlplus

TRACE      2014-01-12 18:00:40.943

OraSqlContext._checkDbSidDbHome: dbHome: '/oracle/SBX/102_64' is not a valid ORACLE_HOME directory.

ERROR      2014-01-12 18:00:40.943 [iaxxinscbk.cpp:260]

CJS-00030  Assertion failed: OraSqlContext constructor: arguments dbSidOrSrcObject and dbHome are not valid.

TRACE      2014-01-12 18:00:40.944 [iaxxejsbas.hpp:408]

           handleException<ESAPinstException>()

Converting exception into JS Exception Exception.

I hope resolve this issue,

Regards,

RhA.

[Former Member · Accepted solution]

Dear,

This issue is cannot find sqlplus, and logon to oracle sqlplus "/as sysdba".

this issue finish and resolve by, I reinstall Oracle 10g and finish, restart OS, after that I patch oracle. and the last run sapinst again.

regards,

-RhA

[former_member193518]

Before you retry the Oracle install, just try relinking it.

It's possible that the problems you had during install caused it to not link SQL*Plus properly.

As the ora<sid> user, run the command:   relink all

See here DBA-Village

See if you have sqlplus after the relink.

If not, then you should try the re-install.

Regards,

Darryl

[Former Member]

Hi,

the best would be to restart the whole installation - as sapinst has already created the database sqlplus was available for a while. To me it means that it was removed/moved/whoknows manually.

Next time you may create a filesystem backup of the oracle directories.

Good luck

Tamás

ps: Install oracle 11g, 10g is not supported anymore.

[Reagan]

Hello

Please provide the output of these commands.

ls -la /oracle/SBX/102_64/bin/sqlplus

su - orasbx

env

Regards

RB

[Reagan]

Hello

Follow this solution mentioned in this thread.

http://scn.sap.com/thread/3291524

Regards

RB

[Former Member]

Dear Reagan Benjamin,

I finish follow your mention, but I thing the issue not same with me.

because I canot find:

oracom.setAndCheckABAPSchemaUser(context.get("ABAPSchema"),

context.get("osUser"),

context.get("thread"),

context.get("oracleHome"));

at control.xml in master EHP4.

Error log form the Sapinst_dev.log

TRACE      2014-01-12 18:00:40.943

sqlplus file not exists: /oracle/SBX/102_64/bin/sqlplus

TRACE      2014-01-12 18:00:40.943

OraSqlContext._checkDbSidDbHome: dbHome: '/oracle/SBX/102_64' is not a valid ORACLE_HOME directory.

ERROR      2014-01-12 18:00:40.943 [iaxxinscbk.cpp:260]

CJS-00030  Assertion failed: OraSqlContext constructor: arguments dbSidOrSrcObject and dbHome are not valid.

TRACE      2014-01-12 18:00:40.944 [iaxxejsbas.hpp:408]

           handleException<ESAPinstException>()

Converting exception into JS Exception Exception.

TRACE      2014-01-12 18:00:40.944

Function setMessageIdOfExceptionMessage: modlib.jslib.caughtException

WARNING[E] 2014-01-12 18:00:40.945

           CJSlibModule::writeError_impl()

MUT-03025  Caught ESAPinstException in Modulecall: OraSqlContext constructor: arguments dbSidOrSrcObject and dbHome are not valid..

TRACE      2014-01-12 18:00:40.945 [iaxxejsbas.hpp:483]

           EJS_Base::dispatchFunctionCall()

JS Callback has thrown unknown exception. Rethrowing.

TRACE      2014-01-12 18:00:41.052 [syuxctask.cpp:1382]

           CSyTaskImpl::start(bool)

A child process has been started. Pid = 7340172

TRACE      2014-01-12 18:00:41.347 [syuxctask.cpp:1382]

           CSyTaskImpl::start(bool)

A child process has been started. Pid = 7340174

ERROR      2014-01-12 18:00:41.569 [sixxcstepexecute.cpp:950]

FCO-00011  The step CheckOraclePatchInstalled with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|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_OraPatch|ind|ind|ind|ind|10|0|CheckOraclePatchInstalled was executed with status ERROR ( Last error reported by the step :Assertion failed: OraSqlContext constructor: arguments dbSidOrSrcObject and dbHome are not valid.).

TRACE      2014-01-12 18:00:41.614 [iaxxgenimp.cpp:752]

            CGuiEngineImp::showMessageBox

<html> <head> </head> <body> <p> An error occurred while processing option SAP ERP 6.0 EHP4 Ready - Support Release 1 > SAP Application Server ABAP > Oracle > Central System > Central System( Last error reported by the step :Assertion failed: OraSqlContext constructor: arguments dbSidOrSrcObject and dbHome are not valid.). You can now: </p> <ul> <li> Choose <i>Retry</i> to repeat the current step. </li> <li> Choose <i>View Log</i> to get more information about the error. </li> <li> Stop the option and continue with it later. </li> </ul> <p> Log files are written to /tmp/sapinst_instdir/ERPEhP4/AS-ABAP/ORA/CENTRAL/. </p> </body></html>

TRACE      2014-01-12 18:00:41.614 [iaxxgenimp.cpp:1255]

           CGuiEngineImp::acceptAnswerForBlockingRequest

Waiting for an answer from GUI

regards,

RhA

[Former Member]

Hi,

Can you please check that orasid has the Oracle_home env defined.

The ORACLE_HOME should be /oracle/SID/102_64.

Can you please check that the /oracle/SID/102_64 is valid mount point and proper permission in case you have installed 10G.

Few more questions...

Did you install oracle before starting the sapinst?

Did you install oracle using orasid?

Thanks

Rishi Abrol

[Former Member]

Dear Rishi Abrol,

Oracle_home:

command : env

SANDBOX:orasbx 4> env

TERM=xterm

AUTHSTATE=files

SHELL=/usr/bin/csh

HOME=/oracle/SBX

USER=orasbx

PATH=/oracle/SBX/102_64/bin:.:/oracle/SBX:/usr/sap/SBX/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java5/jre/bin:/usr/java5/bin

TZ=CST6CDT

LANG=en_US

LOCPATH=/usr/lib/nls/loc

LC__FASTMSG=true

ODMDIR=/etc/objrepos

LOGNAME=orasbx

LOGIN=orasbx

SAPSYSTEMNAME=SBX

DIR_LIBRARY=/usr/sap/SBX/SYS/exe/run

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=SBX

dbs_ora_schema=SAPSR3

ORACLE_SID=SBX

DB_SID=SBX

ORACLE_BASE=/oracle

ORACLE_HOME=/oracle/SBX/102_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/SBX

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

LIBPATH=/usr/lib:/lib:/usr/sap/SBX/SYS/exe/run:/oracle/SBX/102_64/lib

SANDBOX:orasbx 5>

Permission /oracle/SID/102_64

drwxr-xr-x   18 orasbx   dba            4096 Jan 13 09:30 102_64

Did you install oracle before starting the sapinst? No, Im running sapinst first.

Did you install oracle using orasid? Yes, I install oracle with user oraSID.

regards,

RhA

[Former Member]

Hi,

Can you please check the below file ...

sqlplus file not exists: /oracle/SBX/102_64/bin/sqlplus

It is not able to find sqlplus ....

But it is always there in /oracle/SID/1X2_64 and /oracle/DTD/1X2_64/bin

have you got softlink 1X_64 pointing to 1X20Y

where x can be 0 or 1 related to oracle release..

can you please do ls -la in /oracle/SID

Thanks

Rishi Abrol

[Former Member]

Dear Reshi Abrol.

I trying find and cannot finded.

sqlplus file not exists: /oracle/SBX/102_64/bin/sqlplus

is not exists.
how ?

# pwd
/oracle/SBX
# ls -la
total 320
drwxr-xr-x   19 orasbx   dba            4096 Jan 12 16:15 .
drwxr-xr-x    8 orasbx   dba             256 Jan 12 14:32 ..
-rw-r-----    1 orasbx   dba            1801 Jan 12 14:10 .cshrc
-rw-r-----    1 orasbx   dba            1548 Jan 12 14:10 .cshrc.1
-rw-r-----    1 orasbx   dba            4823 Jan 12 14:10 .dbenv.csh
-rw-r-----    1 orasbx   dba            4790 Jan 12 14:10 .dbenv.sh
-rw-r-----    1 orasbx   dba            4823 Jan 12 14:10 .dbenv_SANDBOX.csh
-rw-r-----    1 orasbx   dba            4790 Jan 12 14:10 .dbenv_SANDBOX.sh
drwxrwx---    3 orasbx   dba             256 Jan 12 14:23 .java
-rw-r-----    1 orasbx   dba            1801 Jan 12 14:10 .login
-rw-r-----    1 orasbx   dba            1548 Jan 12 14:10 .login.1
-rw-r-----    1 orasbx   dba            1660 Jan 12 14:10 .profile
-rw-r-----    1 orasbx   dba            1315 Jan 12 14:10 .profile.1
-rw-r-----    1 orasbx   dba            8359 Jan 12 14:10 .sapenv.csh
-rw-r-----    1 orasbx   dba            7724 Jan 12 14:10 .sapenv.sh
-rw-r-----    1 orasbx   dba            8359 Jan 12 14:10 .sapenv_SANDBOX.csh
-rw-r-----    1 orasbx   dba            7724 Jan 12 14:10 .sapenv_SANDBOX.sh
-rw-r-----    1 orasbx   dba            1548 Jan 12 14:10 .sapsrc.csh
-rw-r-----    1 orasbx   dba            1315 Jan 12 14:10 .sapsrc.sh
-rw-r-----    1 orasbx   dba            1548 Jan 12 14:10 .sapsrc_SANDBOX.csh
-rw-r-----    1 orasbx   dba            1315 Jan 12 14:10 .sapsrc_SANDBOX.sh
drwxr-xr-x   18 orasbx   dba            4096 Jan 13 09:30 102_64
drwxr-xr-x    2 orasbx   dba             256 Jan 12 16:15 mirrlogA
drwxr-xr-x    2 orasbx   dba             256 Jan 12 16:15 mirrlogB
drwxr-xr-x    2 orasbx   dba             256 Aug 27 10:23 oraarch
drwxr-xr-x    3 orasbx   dba             256 Jan 12 16:15 origlogA
drwxr-xr-x    3 orasbx   dba             256 Jan 12 16:15 origlogB
drwxr-xr-x    2 orasbx   dba             256 Jan 12 16:15 saparch
drwxr-xr-x    2 orasbx   dba             256 Aug 27 10:23 sapbackup
drwxr-xr-x    2 orasbx   dba             256 Jan 12 16:15 sapcheck
drwxr-xr-x    7 orasbx   dba             256 Jan 12 16:15 sapdata1
drwxr-xr-x   18 orasbx   dba            4096 Jan 12 16:15 sapdata2
drwxr-xr-x   16 orasbx   dba            4096 Jan 12 16:15 sapdata3
drwxr-xr-x    3 orasbx   dba             256 Jan 12 16:15 sapdata4
drwxr-xr-x    2 orasbx   dba             256 Aug 27 10:23 sapdata5
drwxr-xr-x    2 orasbx   dba             256 Jan 12 16:15 sapreorg
drwxr-xr-x    4 orasbx   dba             256 Jan 12 16:15 saptrace
-rwxr-xr-x    1 orasbx   dba           16688 Aug 22 23:00 startdb
-rwxr-xr-x    1 orasbx   dba           12049 Aug 22 23:00 stopdb

regards,

-RhA

[Former Member]

Hi,

This means that you cant connect to sqlplus via orasid as the file is not there.....

Su - orasid

sqlplus "/as sysdba"

It would give an error.....

Did you get any error while installing oracle ore patch..

Can you please use the find command and check if you can find the sqlplus command in /oracle/SID.

find -H . -name 'sqlplua' -print

Thanks

Rishi Abrol

[Former Member]

Hi

Are you able to login as ORASID in your system and try to give the command SQLPLUS?

What is the output ? Is the executable being found.

Also give the output of the following for the ORASID and SIDADM users.

echo $PATH

Also from the initial error - looks like your environment variables are not set properly

Thanks

RD

[Former Member]

Dear Rishi Abrol,

SANDBOX:orasbx 2> sqlplus "/as sysdba"

sqlplus: Command not found.

# find / -name sqlplus -print

not finded.

regards,

ruhul

[Former Member]

Dear,

i cannot use command sqlplus,

# echo $PATH

/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/amin/bin:/usr/bin/X11:/sbin:.

[Former Member]

Hi,

I don't think that oracle is installed properly.... Do you have any file in the /oracle/SBX/102_64....

Please uninstall and reinstall it. But before that try to find sqlplus file on the server in any directory.

Hope you used the dvd for installation from Servie Market Place.

Thanks

Rishi Abrol