on 06-18-2010 3:49 PM
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.
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.