Cannot determine Oracle RDBMS version.

[Former Member]

HI,

  i am trying to install oracle patch 'SAP11203V3P_1402-20009981.ZIP' while executing the installation i am geeting following error.

kindly advise.

or if possible to share the steps to apply the patch. my SAP ECC 6 EHP7 installation got stuck.

Regards

Sunil

[former_member182657 · Accepted solution]

Hi Sunil,

Could you please elaborate steps which you followed for ORACLE installation ?

Thanks,

Gaurav

[Former Member · Accepted solution]

Hi Gaurav,

   i have started installing SAP ECC6 EHP7 and in the mid of that i got following error.

any suggestion please.

Regards

sunil

[Former Member · Accepted solution]

Please attach log file from 2nd screenshot.

[Reagan · Accepted solution]

I suspect that this could be an issue with the Suse Linux configuration.

Have you got the OS set for the Oracle 11G installation.

Check the prerequisites link on this link and make sure all the RPM's and OS packages are installed.

Oracle® Database

Regards

RB

[Former Member · Accepted solution]

Hi Reagan,

  thanks a lot for your support.

  i reformatted and installed all linux package mentioned in the given link. Oracle® Database

  i am able to proceed further my installation.

  thanks

  sunil

[former_member182657]

Hi Sunil,

As per analysis of second screenshot please confirm me a point :

1.For the installation of oracle 11g you used to go /oracle/stage/112_64/database/SAP/ through user ora<sid> .Here please clarify me have you set any environment variable except display variable before execution of ./RUNINSTALLER (Means please unset LD_LIBRARY_PATH,ORACLE_PATH etc if you did).

For successful installation first use to set environment variable xhost + from the root terminal & switch to su - ora<sid> and on this terminal don't set any other environment variable like LD_LIBRARY_PATH,ORACLE_PATH etc.Please do a clean installation of ORACLE 11G w/t setting any variables except display parameter.

Hope this will help you.

Regards,

Gaurav

[former_member182657]

Hi Sunil,

The parameters

export ORACLE_HOME=/oracle/SID/112_64
export ORACLE_BASE=/oracle/SID

you assigned are fine.But here you need to set two more env variables as like:

export IHRDBS /oracle/SID/11203

export OHRDBMS /oracle/SID/112_64

and also confirm proper permissions for the stage directory from which you are performing the patch implementation.

Thanks,

Gaurav

[Former Member]

Gaurav,

  i shall execute this as root.

export IHRDBS=/oracle/SID/11203

export OHRDBMS=/oracle/SID/112_64

right?

regards

sunil

[Reagan]

Hello

You need to run it under orasid

/bin/sh $ORACLE_HOME/MOPatch/mopatch.sh -v -s SAP11203V3P_1402-20009981.ZIP

Regards

RB

[Former Member]

No luck still i am getting the same error.

i restarted my SAP installation and this time it stuck on the following error.

sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory

any advise please.

Regards

Sunil

[former_member188883]

Hi Sunil,

This error has few possible solutions

1) Note 819829 - Oracle Instant Client Installation and Configuration on Unix

    Based on this note check instant client is correctly installed for Oracle 11g

2) Set LD_LIBRARY_PATH=$ORACLE_HOME/lib

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Sunil,

as user orasid, check your environment variable for libraries:

echo $LD_LIBRARY_PATH

It should be set to $ORACLE_HOME/lib.

Regards,

Mark

[Former Member]

Hi Mark,

  please find the output.

eccdev:oradvr 51> echo $LD_LIBRARY_PATH

/usr/sap/DVR/SYS/exe/run:/usr/sap/DVR/SYS/exe/uc/linuxx86_64:/oracle/DVR/112_64/lib

i think it is already correct.

regards

sunil

[Former Member]

Provide output of

> ldd `which sqlplus`

> ls -l /oracle/DVR/112_64/lib | grep libclntsh

[Former Member]

Hi Roman,

  please find the output bellow.

eccdev:~ # ldd `which sqlplus`

which: no sqlplus in (/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin)

ldd: missing file arguments

Try `ldd --help' for more information.

eccdev:~ # ls -l /oracle/DVR/112_64/lib | grep libclntsh

-rwxr-xr-x 1 oradvr dba             0 Mar 15 15:36 libclntsh.so

eccdev:~ #

Thanks

Sunil

[Former Member]

Not sure that you have correctly installed Oracle RDBMS software. Can you provide Oracle installation logs?

[Former Member]

Hello Sunil.

Please provide what DB nad OS version did you run ? This patch suites to:

SAP Bundle Patch 11.2.0.3.9 - 201402V3
	Support Package ORACLE PATCHES 11.2.0.3 Linux on x86_64 64bit

BR,

K.

[Former Member]

Hi Kamil,

  the OS is SUSE 11  x86_64 and 11g

THanks

sunil

[former_member188883]

Hi Sunil,

Please update the mopatch and opatch versions.

Secondly check permission to oracle executable under $ORACLE_HOME/bin/oracle it should have sticky bit assigned

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi,

Download Readme.htm document which comes with SBP, it will give you the step by step procedure of SBP installation.

Regards,

Nick Loy

[former_member182657]

Hi Sunil,

Before execution of oracle patch have you set environment variables IHRDBMS & OHRDBMS.

e.g values for env variable IHRDBMS /oracle/SID/11203   &  OHRDBMS  /oracle/SID/112_64.

Hope it helps you.

Thanks,

Gaurav

[Former Member]

Hi Gaurav,

   could you please share the command to set env in suse linux.

   i have set the ORACLE_HOME to /oracle/SID/112_64 only

Thanks

sunil

[former_member182657]

Hi Sunil,

You can use export / setenv command as per shell you are using to set these environment variables.

Regards,

Gaurav

[Former Member]

Hi Gaurav,

  i have set it as

  export ORACLE_HOME=/oracle/SID/112_64

  export ORACLE_BASE=/oracle/SID

  still i am geeting same error.

please advise.

regards

sunil