DB 13 error in distributed system (brconnect)

[Former Member]

hi expert,

I installed distributed system .

DB instance is Unix (hp) and Central instance is NT.

I install standalone gateway in DB host for DB13 and then configured TCP/IP detination SAPXPG_DBDEST_<DBhost> .

I checked SAPXPG_DBDEST_<DBhost> connection is OK.

but check db error in DB13

=================================================================

Job started

Step 001 started (program RSDBAJOB, variant &0000000000020, user ID ADMIN)

No application server found on database host - rsh/gateway will be used

Execute logical command BRCONNECT On host stwdbdev

Parameters: -u / -jid CHECK20100624162600 -c -f check

BR0801I BRCONNECT 7.10 (19)

BR0152E Environment variable ORACLE_SID is not set

BR0806I End of BRCONNECT processing: cedngqgn.log2010-06-24 16.26.01

BR0280I BRCONNECT time stamp: 2010-06-24 16.26.01

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

==================================================================

previous this error, `brconnect not found error` is corrected by copy br* kernels to gateway kerenl directory.

I thought brconnect is started by gateway`s <sid>adm user so I gave environment value "ORACLE_SID,ORACLE_HOME,SAPDATA_HOME" to gateway`s <sid>adm .

but error is same.

finally, I want to know who execute brconnect in DB instance and how can I correct this problem.

thanks and regards

jun

[former_member227283]

Hi,

Login to OS of CI server and check what all the enviroment varible set to user SIDADM.

Thanks

Anil

[Former Member]

hi Anil,

I already set DB parameter to SIDADM in CI.

thanks

jun

[former_member227283]

Hi jun,

pls give the output of command in forum.

run command

if you are using windows, then run command SET .

If you ate using unix flavor, then run command ENV .

this command should be run on CI server and with user SIDADM.

share the output on forum.

Thanks

Anil

[Former Member]

hi

I attach SET

======================================================

C:\Documents and Settings\dpiadm>set

ALLUSERSPROFILE=C:\Documents and Settings\All Users

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

CLIENTNAME=MYCOM

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

CommonProgramFiles=C:\Program Files\Common Files

CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files

COMPUTERNAME=STWDMDDEV

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

DBMS_TYPE=ora

dbs_ora_schema=SAPDPI

dbs_ora_tnsname=DPI

DB_SID=DPI

FP_NO_HOST_CHECK=NO

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\dpiadm

JAVA_HOME=C:\Program Files\Java\jdk1.5.0_21

LOGONSERVER=
STWDMDDEV

NLS_LANG=AMERICAN_AMERICA.UTF8

NUMBER_OF_PROCESSORS=2

ORACLE_HOME=/oracle/DPI/102_64

ORACLE_SID=DPI

OS=Windows_NT

Path=C:\Program Files (x86)\Windows Resource Kits\Tools\;C:\WINDOWS\system32;C:\

WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft Network Monitor 3\;C

:\Admin\bin;C:\Program Files\OmniBack\bin\;D:\usr\sap\DPI\SYS\exe\uc\NTAMD64

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

PROCESSOR_ARCHITECTURE=AMD64

PROCESSOR_IDENTIFIER=EM64T Family 6 Model 26 Stepping 5, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=1a05

ProgramFiles=C:\Program Files

ProgramFiles(x86)=C:\Program Files (x86)

PROMPT=$P$G

SAPDATA_HOME=/oracle/DPI

SAPEXE=D:\usr\sap\DPI\SYS\exe\uc\NTAMD64

SAPLOCALHOST=stwdmddev

SAPSYSTEMNAME=DPI

SAP_DIR_PERF=D:\usr\sap\PRFCLOG

SESSIONNAME=RDP-Tcp#17

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=D:\usr\sap\DPI\tmp\1

TMP=D:\usr\sap\DPI\tmp\1

TNS_ADMIN=D:\usr\sap\DPI\SYS\profile\oracle

USERDOMAIN=STWDMDDEV

USERNAME=dpiadm

USERPROFILE=C:\Documents and Settings\dpiadm

windir=C:\WINDOWS

==========================================================================

thanks

jun

[former_member227283]

Hi Jun,

Run R3trans -d in CI server .

If you get return code otherthan 0000, then pls share error part of trans.log in forum.

Thanks

Anil

[JPReyes]

Check that SAPServiceSID has the env variables set too... then try again

Regards

Juan

[Former Member]

hi all

first, R3trans -d

=======================================================

C:\Documents and Settings\dpiadm>r3trans -d

This is r3trans version 6.19 (release 711 - 16.12.09 - 16:57:00).

unicode enabled version

r3trans finished (0000).

=======================================================

second, how can I check and add SAPServiceDPI environment value ??

thanks

jun

[Former Member]

Hi,

From above messages seems like its windows platform. Login to server using SAPServiceDPI login and password which was given at the time of installation and after that check the environment variable by right click on My Computer->Properties->Advanced->Environment Variables->check if values are available under user variables. if not then set the same.

Regards,

Sharath

[Former Member]

hi, sharath

how can I log on SAPServicePID user ??

I aleady try log on but failed.

please let me know

thanks and regards

jun

[Former Member]

Hi,

I guess it might have given a message that logon is disabled or not enabled for login SAPServicePID user. Just ask your OS guys to enable the Remote login for this ID in domain if your installation is domain installation or if it is a local installation then right click on mycomputer->Manage and then choose Local Users and Groups->Groups where you can find Remote Desktop Users. Add SAPServicePID user to this group which will allow login.

Regards,

Sharath

[Former Member]

hi,

I log on SAPServicePID but db13 error is same

===========================================

Job started

Step 001 started (program RSDBAJOB, variant &0000000000024, user ID ADMIN)

No application server found on database host - rsh/gateway will be used

Execute logical command BRCONNECT On host stwdbdev

Parameters: -u / -jid CHECK20100625125243 -c -f check

BR0801I BRCONNECT 7.10 (19)

BR0152E Environment variable ORACLE_SID is not set

BR0806I End of BRCONNECT processing: cednkvdj.log2010-06-25 12.52.43

BR0280I BRCONNECT time stamp: 2010-06-25 12.52.43

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

===============================================

and SAPServicePID environment variant

==============================================

C:\Documents and Settings\SAPServiceDPI>set

ALLUSERSPROFILE=C:\Documents and Settings\All Users

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

CLIENTNAME=MYCOM

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

CommonProgramFiles=C:\Program Files\Common Files

CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files

COMPUTERNAME=STWDMDDEV

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

FP_NO_HOST_CHECK=NO

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\SAPServiceDPI

LOGONSERVER=
STWDMDDEV

NUMBER_OF_PROCESSORS=2

ORACLE_HOME=/oracle/DPI/102_64

ORACLE_SID=DPI

OS=Windows_NT

Path=C:\Program Files (x86)\Windows Resource Kits\Tools\;C:\WINDOWS\system32;C:\

WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft Network Monitor 3\;C

:\Admin\bin;C:\Program Files\OmniBack\bin\

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

PROCESSOR_ARCHITECTURE=AMD64

PROCESSOR_IDENTIFIER=EM64T Family 6 Model 26 Stepping 5, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=1a05

ProgramFiles=C:\Program Files

ProgramFiles(x86)=C:\Program Files (x86)

PROMPT=$P$G

SAPDATA_HOME=/oracle/DPI

SAP_DIR_PERF=D:\usr\sap\PRFCLOG

SESSIONNAME=RDP-Tcp#24

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=C:\DOCUME_1\SAPSER2\LOCALS~1\Temp\1

TMP=C:\DOCUME_1\SAPSER2\LOCALS~1\Temp\1

USERDOMAIN=STWDMDDEV

USERNAME=SAPServiceDPI

USERPROFILE=C:\Documents and Settings\SAPServiceDPI

windir=C:\WINDOWS

==========================================================================

brconnect working is sure by SAPServiceSID??

why error is still??

regards

jun

[Former Member]

Hi,

After logging in with SAPServiceDPI user try to execute the command at OS level from command prompt using BRTOOLS and see if you can execute from there. Also, check under user variable of Environment variable under SAPServiceDPI if variables are set properly or not.

Regards,

Sharath

[former_member269824]

HI jun,

I am also facing the same probs, i also tried everything mentioned by the experts still no luck.

Please let me know whether you were able to resolve this or not or any alternative solution

Regards

Kishore