Error by patching of SAP NetWeaver with Oracle on Windows

[Former Member]

Hi!

I am about to patch my SAP system (SAP NetWeaver 04S) with Oracle on Windows.

The following error occurs:

Import phase 'CHECK_REQUIREMENTS' (05.02.2008, 16:00:39)

Error during executing the tp command 'tp CONNECT B11 ...'

tp return code: '0232' , tp message: 'connect failed' , tp output:

This is tp version 340.16.38 (release 640, unicode enabled)

ERROR: Connect to B11 failed (20080205160039, probably wrong environment).

TRACE-INFO: 1: [dev trc ,00000] Tue Feb 05 16:00:39 2008 29426 0.029426

TRACE-INFO: 2: [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 38 0.029464

TRACE-INFO: 3: [dev trc ,00000] using "E:\usr\sap\B11\SYS\exe\run\dboraslib.dll" 35 0.029499

TRACE-INFO: 4: [dbsloci. ,00000] *** ERROR => Cannot connect: dbs/ora/tnsname in Profile missing

TRACE-INFO: 5: 738 0.030237

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

standard output from tp and from tools called by tp:

Can some one give some recommendations how to proceed?

Is something wrong with oracle environment?

Thank you very much!

regards

Thom

[stefan_koehler]

Hello Thom,

>> TRACE-INFO: 4: http://dbsloci. ,00000 *** ERROR => Cannot connect: dbs/ora/tnsname in Profile missing

Please check your SAP profiles for the parameter "dbs/ora/tnsname".. the parameter is not set.

Set the parameter with RZ10 and activate your profile... after that you have to restart your SAP system.

After that the patches should be work.

Regards

Stefan

[Former Member]

Hi Stefen!

Thank you very much!

I set the parameter dbs/ora/tnsname to my SID value in both DEFAULT and Instance profile.

Unfortunately I get the same error.

Do you have some other ideas?

Do I miss perhaps some other envirornments?

Thank you!

Thom

[Former Member]

Hi,

check tp profile \usr\sap\trans\bin\*.pfl

if it is wrong regenerate using ->Transaction STMS. In the System Overview, -> distribute the TMS

regards,

kaushal

[stefan_koehler]

Hello Thom,

have you activated the profiles and restarted your sap system?

Are the profiles correctly written down to the filesystem (after activation) ?

Regards

Stefan

[Former Member]

Hi Stefan,

both steps were executed.

Strange...

Thank you!

regards

Thom

[stefan_koehler]

Hello Thom,

ok so please check the following for us as sap user on windows and post the results

> cmd > R3trans -d

> cmd > set

> cmd > tnsping B11 (maybe this step must be executed as ora user, if the environment does not fit)

Regards

Stefan

[Former Member]

Hi!

Thank you!

The problem is my <sapsid> user (B11adm) cannot log in into OS, but I can log in as an other <sid>user (E11adm) or as administrator.

If I execute the command as other <sid>user (E11adm) >r3trans -d I retrieve:

2EETW169 no connect possible: "DBMS = ORACLE

--- ORACLE_SID = 'B11'"

r3trans finished (0012).

The result of commando >set:

ALLUSERSPROFILE=C:\Documents and Settings\All Users

APPDATA=C:\Documents and Settings\e11adm\Application Data

CLIENTNAME=DZEM9001

ClusterLog=C:\WINDOWS\Cluster\cluster.log

CommonProgramFiles=C:\Program Files\Common Files

COMPUTERNAME=OLDA8005

ComSpec=C:\WINDOWS\system32\cmd.exe

dbms_type=ORA

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\e11adm

JAVA_HOME=C:\j2sdk1.4.2_06

LOGONSERVER=
OLDA8001

NUMBER_OF_PROCESSORS=2

ORACLE_HOME=E:\oracle\B11920

ORACLE_SID=B11

OS=Windows_NT

Path=C:\j2sdk1.4.2_06\bin;E:\usr\sap\B11\sys\exe\run;E:\oracle\B11920\jre\1.4.2\

bin\client;E:\oracle\B11920\jre\1.4.2\bin;E:\oracle\B11920\bin;C:\Program Files\

Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;E:\oracle\BWX920\bin;

C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microso

ft SQL Server\80\Tools\Binn\;E:\usr\sap\B11\SYS\exe\uc\NtI386

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PROCESSOR_ARCHITECTURE=x86

PROCESSOR_IDENTIFIER=x86 Family 6 Model 8 Stepping 6, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=0806

ProgramFiles=C:\Program Files

PROMPT=$P$G

RFCEXEC_SEC_FILE_PATH=E:\usr\sap\B11\SYS\exe\uc\NtI386

SESSIONNAME=RDP-Tcp#22

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=C:\DOCUME_{1\e11adm\LOCALS}1\Temp\1

TMP=C:\DOCUME_{1\e11adm\LOCALS}1\Temp\1

USERDNSDOMAIN=PORTAL.LOCAL

USERDOMAIN=PORTALGROUP

The result of >tnsping B11

TNS Ping Utility for 32-bit Windows: Version 9.2.0.5.0 - Production on 07-FEB-20

08 10:34:15

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

E:\oracle\B11920\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (C

OMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = olda8005) (PORT = 1527))) (CONNEC

T_DATA = (SID = B11) (GLOBAL_NAME = B11.WORLD)))

OK (50 msec)

USERNAME=e11adm

USERPROFILE=C:\Documents and Settings\e11adm

windir=C:\WINDOWS

Is it possible to activate the right sidadm user (B11adm)?

Thank you!

regards

Thom

[Former Member]

Hi,

login with administrator user on windows ( B11 SAP Server)

now right click on my computer -> manage -> under computer management expand local user and groups -> users -> right click on b11adm user and set new password

now log off with administrator user and login with b11adm user

regards,

kaushal

[Former Member]

Hi,

Please do a tp consistency check. this is how it goes

stms --> click the system overview button.

Then in the next screen

SAP System --> check --> Transport tool.

Check and post if there is any discrepancy there.

Sudha