2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'

[Former Member]

Hello,

I am in the process of Upgrading SAP 4.7 to ECC 6.0 so first i have upgraded Oracle database from 9.2 to 10g. It is completed successfully.

Presently Oracle Database - 10.2.0.2.

Oracle Client - 8.1.7

OS - Sun Solaris sparc

But now when i go to upgrade Kernel from 6.2 to 6.4 so it gave me Oracle Client Library errors. So I am trying to upgrade it to Client 10.2 only ....but its giving me below ERRORS ................

Pls guide me how to resolve error after Oracle Client Installation. I refered note 180430 and now SAP also is not starting after changing Envt Variable: LD_LIBRARY_PATH.

bssltests:prdadm 1% R3trans -x

This is R3trans version 6.09 (release 620 - 13.08.03 - 15:59:00).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'"

R3trans finished (0012).

bssltests:prdadm 2% more trans.log

4 ETW000 R3trans version 6.09 (release 620 - 13.08.03 - 15:59:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 23.05.2007 - 15:12:28

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Wed May 23 15:12:28 2007 385 0.000385

4 ETW000 [dev trc ,00000] db_con_init called 37 0.000422

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 107 0.000529

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' ...

4 ETW000 155 0.000684

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/PRD/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 29376 0.030060

4 ETW000 [dev trc ,00000] Library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' loaded

4 ETW000 128 0.030188

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so

4 ETW000 70 0.030258

4 ETW000 [dev trc ,00000] Version of '/usr/sap/PRD/SYS/exe/run/dboraslib.so' is "620.02", patchlevel (0.876)

4 ETW000 413 0.030671

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so

4 ETW000 43 0.030714

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so

4 ETW000 107 0.030821

4 ETW000 [dev trc ,00000] New connection 0 created 36 0.030857

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 58 0.030915

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 74 0.030989

4 ETW000 [dev trc ,00000] find_con found the following connection for reuse:

4 ETW000 39 0.031028

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 33 0.031061

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/PRD/102_64 from environment

4 ETW000 977 0.032038

4 ETW000 [dev trc ,00000] -->oci_initialize 54 0.032092

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIInitialize' failed: rc = -1

4 ETW000 3090 0.035182

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIErrorGet' failed: rc = -2

4 ETW000 67 0.035249

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error -1 performing CON [dblink#1 @ 419]

4 ETW000 123 0.035372

4 ETW000 [dblink ,00419] ***LOG BY0=>Can't get error text from Oracle [dblink#1 @ 419]

4 ETW000 34 0.035406

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'"

After executing ldd dboraslib.so i am geting below output. I don't understand when i hav chgd everthing in Envt ...then from where does it pick path as "/oracle/client/81x_64/lib/libclntsh.so.8.0

??

bssltests:prdadm 4% cd /usr/sap/PRD/SYS/exe/run/

bssltests:prdadm 5% ldd dboraslib.so

libdl.so.1 => /usr/lib/sparcv9/libdl.so.1

libclntsh.so.8.0 => /oracle/client/81x_64/lib/libclntsh.so.8.0

libwtc8.so => /oracle/client/81x_64/lib/libwtc8.so

libc.so.1 => /usr/lib/sparcv9/libc.so.1

libnsl.so.1 => /lib/64/libnsl.so.1

libsocket.so.1 => /lib/64/libsocket.so.1

libgen.so.1 => /lib/64/libgen.so.1

libaio.so.1 => /lib/64/libaio.so.1

libm.so.1 => /lib/64/libm.so.1

librt.so.1 => /lib/64/librt.so.1

libmp.so.2 => /lib/64/libmp.so.2

libmd5.so.1 => /lib/64/libmd5.so.1

libscf.so.1 => /lib/64/libscf.so.1

libdoor.so.1 => /lib/64/libdoor.so.1

libuutil.so.1 => /lib/64/libuutil.so.1

libm.so.2 => /lib/64/libm.so.2

/platform/SUNW,Sun-Fire-V440/lib/sparcv9/libc_psr.so.1

/platform/SUNW,Sun-Fire-V440/lib/sparcv9/libmd5_psr.so.1

bssltests:prdadm 6%

Waiting for reply .............

Regards,

Ankita

[Former Member · Accepted solution]

Hello,

Kernel 6.20 is NOT supported to work with Oracle 10g. You MUST upgrade to kernel 6.40.

Kernel 6.20 uses OCL 8.1.x

Kernle 6.40 uses OCL 9.2

I think you have not read the note 720886 where is indicate the 10g requeriments in a SAP environment.

You must

- Install new kernel 6.40

- Install new OCL 9.2.0.7

[Former Member]

Hi Dabinder,

Follow Database upgarade guide from SAP,

Upgrade to Oracle Database 10g Release 2 (10.2): UNIX, which is very helpful and look at the following notes:

Note 407314 - Released operating systems SAP R3 kernel 6.x ORACLE

Note 886783 - Installing Oracle 9207 Client Software on UNIX

Regards,

Nisch

[Former Member]

Hi Dabinder,

You said: <b>Oracle Client - 8.1.7</b> ???

For upgrading Oracle from 9.2 to 10g you must install the most recent 9.2.0.x Oracle Client (9.2.0.8 at this moment). This is a prerequisite before the upgrade. You can check it at the Upgrade Guide:

www.service.sap.com/instguides >Other Documentation>Database Upgrades-->Oracle

Install it (follow Note 886783), and try again.

Best Regards,

JC Llanes.