cancel
Showing results for 
Search instead for 
Did you mean: 

46D_EXT 32 bit Kernel can not connect to Oracle 10.2.0.4 after DB Upgrade

Former Member
0 Kudos

I'm running SAP 4.6C with the 46D_EXT 32 bit kernel. I am upgrading the database to Oracle 10.2.0.4, and the database will

startup and shutdown OK, but SAP can not connect. I've followed the steps in the SAP Oracle 10 upgrade guide.

I am running on Windows 2003, Standard X64 Edition, with an AMD64

processor. The Product Availability Matrix shows that I should be able

to run the 46D_EXT 32 bit kernel on an AMD x64 environment, with Oracle

10.2.0.4 64 bit. I only see Itanium processors approved for running

the 46D_EXT 64 bit SAP kernel.

I've updated the 46D_EXT 32 bit kernel to the latest patch level. I've

downloaded and applied sapexe_2513-10002554.sar, sapexedb2513-

10002548.sar, R3trans_2434-10002554.car, tp_2366-10002554.car, dw and

enq of 2523_10002554.car) for the 46D_EXT 32 bit kernel.

I got the Oracle client software from swdc--> Database Patches -->

Oracle 10.2.0.4--> Instant Clietn-IC --> MS Windows x86-64 (64 bit)

OCL10264.SAR (patch 30). Is this correct, or should I have taken the 32 bit version. The DB is 64 bit, but the SAP kernel is 32 bit. Which one should the Oracle client software match to?

I also downloaded lib_dbsl_2449-10002548.car, librfc_66-10002554.car

I've applied the following Oracle patches for 10.2.0.4:

p9358800 (patchset 33)

p7592030

p9254968

When I do R3trans -d or R3trans -x I get the following in the trans.log

file. Thanks for any help that anyone can provide.

Rick

4 ETW000 r3trans version 6.05 (release 46D - 09.04.09 - 12:39:00).

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

4 ETW000

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -x

4 ETW000 date&time : 18.06.2010 - 15:10:45

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

4 ETW000 [developertra,00000] Fri Jun 18 15:10:45

2010 0.000000

4 ETW000 [developertra,00000] db_con_init

called 0.000000

4 ETW000 [developertra,00000] create_con

(con_name=R/3) 0.000000

4 ETW000 [developertra,00000] Loading DB

library 'dboraslib.dll' ... 0.000000

4 ETW000 [developertra,00000] load shared library (dboraslib.dll),

hdl 0 3851 0.003851

4 ETW000 [developertra,00000] Library 'dboraslib.dll'

loaded 15 0.003866

4 ETW000 [developertra,00000] function DbSlExpFuns loaded from

library dboraslib.dll

4

ETW000

14 0.003880

4 ETW000 [developertra,00000] Version of library 'dboraslib.dll'

is "46D.00", patchlevel (0.2311)

4

ETW000

88 0.003968

4 ETW000 [developertra,00000] function dsql_db_init loaded from

library dboraslib.dll

4

ETW000

19 0.003987

4 ETW000 [developertra,00000] function dbdd_exp_funs loaded from

library dboraslib.dll

4

ETW000

15 0.004002

4 ETW000 [developertra,00000] New connection 0

created 12 0.004014

4 ETW000 [developertra,00000] db_con_connect

(con_name=R/3) 11 0.004025

4 ETW000 [developertra,00000] find_con found the following connection

for reuse:

4

ETW000

12 0.004037

4 ETW000 [developertra,00000] --

>oci_initialize 130 0.004167

4 ETW000 [developertra,00000] Got

TNS_ADMIN=c:\usr\sap\MET\sys\profile\oracle from environment

4

ETW000

34 0.004201

4 ETW000 [developertra,00000] Got ORACLE_SID=MET from

environment 9 0.004210

4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC

from environment

4

ETW000

14 0.004224

4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPR3's

password 8 0.004232

4 ETW000 [developertra,00000] Connecting as /@MET on connection 0 ...

(dbsl 46D 220209)

4

ETW000

12 0.004244

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='',

dbname='MET') 11 0.004255

4 ETW000 [dbsloci. ,00000] *** ERROR => Couldn't initialize Oracle

Client Library

4 ETW000 please check your

installation 441 0.004696

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

Please advise. You can call me in the united states at 630-205-6050.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

> I'm running SAP 4.6C with the 46D_EXT 32 bit kernel. I am upgrading the database to Oracle 10.2.0.4, and the database will

> startup and shutdown OK, but SAP can not connect.

You need the 46D_EX2 kernel.

Markus

Answers (1)

Answers (1)

Former Member
0 Kudos

The 46D_EXT 32 bit kernel was OK. I had the wrong Oracle client software. I had the 64-bit OCL software, when I switched to the OCL 32 bit client, R3trans connected.