on 06-24-2010 8:59 AM
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
Hi,
Login to OS of CI server and check what all the enviroment varible set to user SIDADM.
Thanks
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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:\DOCUME1\SAPSER2\LOCALS~1\Temp\1
TMP=C:\DOCUME1\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
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
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.