cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

BRconnect with error -1017 at location db_connect-2 when CE7.1Installtion

Former Member

on ‎08-26-2008 5:49 AM

0 Kudos

Hi guys,

I am experiencing some problems when I install the NW CE7.1 with SID CE1 on Windows server with oracle. Note,At this server , the PI7.1 have been installed with SID PI1, now I want to install the CE7.1 on that with MCOD, the oracle db instance name is PID.When install the CE7.1,On the phase execute, it shows

An error occurred while processing service SAP NetWeaver CE Productive Edition > Installation Options > Standard System > Standard System( Last error reported by the step :Process call 'E:\usr\sap\CE1\SYS\exe\uc\NTAMD64\brconnect.exe -u / -c -o summary -f stats -o SAPSR4DB -t all -p 2 -f nocasc' exits with error code 3. For details see log file(s) brconnect.log.). You may now

u2022 choose Retry to repeat the current step.

u2022 choose View Log to get more information about the error.

u2022 stop the task and continue with it later.

Log files are written to C:\Program Files/sapinst_instdir/CE71_PROD_ORA/INSTALL/ORA/STD/AS.

The detailed log is below,

BR0801I BRCONNECT 7.10 (3)

BR0805I Start of BRCONNECT processing: cdyrdcop.sta 2008-08-26 00.03.23

BR0252E Function fopen() failed for 'F:\oracle\PID\sapcheck\cdyrdcop.sta' at location main-11

BR0253E errno 2: No such file or directory

BR0121E Processing of log file F:\oracle\PID\sapcheck\cdyrdcop.sta failed

BR0280I BRCONNECT time stamp: 2008-08-26 00.03.25

BR0301E SQL error -1017 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance PID failed

BR0806I End of BRCONNECT processing: cdyrdcop.sta 2008-08-26 00.03.24

BR0280I BRCONNECT time stamp: 2008-08-26 00.03.25

BR0804I BRCONNECT terminated with errors

How to resolve this issue? Thanks in advance

Roger

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
‎11-19-2009 6:42 PM
0 Kudos

Quick Fix ,

If it is windows 2008 server you can create logical links (symbolic links ) .

eg: My oracle is installed in "c:/oracle/<sid>" . But my sap Data Database is created in H:/oracle/<sid> .

mklink /D C:\oracle\CUS\sapcheck H:\oracle\CUS\sapcheck

mklink /D C:\oracle\CUS\mirrlogA H:\oracle\CUS\mirrlogA

mklink /D C:\oracle\CUS\mirrlogB H:\oracle\CUS\mirrlogB

mklink /D C:\oracle\CUS\oraarch H:\oracle\CUS\oraarch

type this commnad in the Command prompt.IT is like a Shortcut in windows

Show replies
Show replies
Former Member
‎08-26-2008 8:39 AM
0 Kudos

Ashok,

the log is below,

4 ETW000 r3trans version 6.18 (release 710 - 28.07.08 - 15:52:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 26.08.2008 - 03:00:17

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

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

4 ETW000 [dev trc ,00000] Tue Aug 26 03:00:19 2008 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 0 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0, addr 0000000187240000

4 ETW000 8444 0.008444

4 ETW000 [dev trc ,00000] using "E:\usr\sap\XID\SYS\exe\uc\NTAMD64\dboraslib.dll"

4 ETW000 21 0.008465

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 32 0.008497

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 22 0.008519

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "710.16", patchlevel (0.106)

4 ETW000 179 0.008698

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 20 0.008718

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 52 0.008770

4 ETW000 [dev trc ,00000] New connection 0 created 61 0.008831

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 2 0.008833

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 123 0.008956

4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 22 0.008978

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection:

4 ETW000 18 0.008996

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 24 0.009020

4 ETW000 [dev trc ,00000] DIR_CLIENT_ORAHOME is not set as profile nor env. parameter.

4 ETW000 Assuming using instant client with unspecified location.

4 ETW000 1917 0.010937

4 ETW000 [dev trc ,00000] -->oci_init1 39 0.010976

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 27524 0.038500

4 ETW000 [dev trc ,00000] Default connection: tnsname ='PID' 151 0.038651

4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 36 0.038687

4 ETW000 [dev trc ,00000] application info callback registered 15 0.038702

4 ETW000 [dev trc ,00000] OCIEnvCreate(mode=16384=OCI_UTF16) 8552 0.047254

4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrHp=0000000005C7F3D0)

4 ETW000 179 0.047433

4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrBt=0000000005C82B98)

4 ETW000 43 0.047476

4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 235 0.047711

4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): 'AMERICAN_AMERICA.UTF8'

4 ETW000 26 0.047737

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 25 0.047762

4 ETW000 [dev trc ,00000] Connecting as /@PID on connection 0 (nls_hdl 0) ... (dbsl 710 250408)

4 ETW000 32 0.047794

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

4 ETW000 31 0.047825

4 ETW000 [dev trc ,00000] 0 UTF8 0000000005C771A0 0000000005C7F3D0 0000000005C82B98

4 ETW000 25 0.047850

4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con_hdl=0, svchp=0000000005C82A58)

4 ETW000 6 0.047856

4 ETW000 [dev trc ,00000] Allocating server context handle 5 0.047861

4 ETW000 [dev trc ,00000] Attaching to database server PID (con_hdl=0, svchp=0000000005C82A58, srvhp=0000000005C832D8)

4 ETW000 421 0.048282

4 ETW000 [dev trc ,00000] Assigning server context 0000000005C832D8 to service context 0000000005C82A58

4 ETW000 59509 0.107791

4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con_hdl=0, usrhp=0000000005C7FBE8)

4 ETW000 165 0.107956

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0000000005C82A58, srvhp=0000000005C832D8, usrhp=0000000005C7FBE8)

4 ETW000 26 0.107982

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR

4 ETW000 56858 0.164840

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

4 ETW000 1430 0.166270

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 25 0.166295

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 1075 0.167370

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1017 27 0.167397

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 15 0.167412

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 859 0.168271

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 55 0.168326

4 ETW000 [dev trc ,00000] Try to connect with default password 17 0.168343

4 ETW000 [dev trc ,00000] Connecting as SAPR3/<pwd>@PID on connection 0 (nls_hdl 0) ... (dbsl 710 250408)

4 ETW000 808 0.169151

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

4 ETW000 30 0.169181

4 ETW000 [dev trc ,00000] 0 UTF8 0000000005C771A0 0000000005C7F3D0 0000000005C82B98

4 ETW000 25 0.169206

4 ETW000 [dev trc ,00000] Assigning username to user session 0000000005C7FBE8

4 ETW000 28 0.169234

4 ETW000 [dev trc ,00000] Assigning password to user session 0000000005C7FBE8

4 ETW000 61 0.169295

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPR3/<pwd>, svchp=0000000005C82A58, srvhp=0000000005C832D8, usrhp=0000000005C7FBE8)

4 ETW000 28 0.169323

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR

4 ETW000 15304 0.184627

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

4 ETW000 197 0.184824

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 21 0.184845

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 51 0.184896

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1017 16 0.184912

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 16 0.184928

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 55 0.184983

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 21 0.185004

4 ETW000 [dev trc ,00000] DbSlConnect(con_hdl=-1) -> orc=0, 99=DBSL_ERR_DB

4 ETW000 62 0.185066

4 ETW000 [dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 201 0.185267

4 ETW000 [dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied

4 ETW000 23 0.185290

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

*which password should be changed? i find below accounts from talbe adm_users.*

SYS

SYSTEM

OPS$FGRW20806\SAPSERVICESR3

OPS$FGRW20806\XIDADM

OPS$FGRW20806\SAPSERVICEXID

SAPSR3

SAPSR3DB

SAPSR4DB

OUTLN

DBSNMP

Show replies
Show replies
JPReyes
Active Contributor
‎08-26-2008 9:34 AM
0 Kudos

Read,

SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle

That should solve your problem

Regards

Juan

Former Member
‎08-26-2008 9:43 AM
0 Kudos

Hi,

"DIR_CLIENT_ORAHOME is not set as profile nor env. parameter. 4 ETW000 Assuming using instant client with unspecified location."

I think the problem lies as depicted above, which is missing, as it says the specified parameter is not set in the profile neither as an environment variable.

Check the sap profile parameter :-

Set DIR_CLIENT_ORAHOME in the instance profiles to the corresponding values of the ORACLE_HOME environment variable of the <sapsid>adm user. These variables point to the ORACLE_HOME used by the application server.

Even you can have a look at the SNote 556232 which speaks about the same scenario.

I hope this will help to resolve ur problem.

Rgds

Radhakrishna D S

Former Member
‎08-26-2008 6:34 AM
0 Kudos

Ashok,

the log for r3trans -d

This is r3trans version 6.18 (release 710 - 28.07.08 - 15:52:00).

unicode enabled version

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

r3trans finished (0012).

the log for r3trans -x

This is r3trans version 6.18 (release 710 - 28.07.08 - 15:52:00).

unicode enabled version

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

r3trans finished (0012).

Very Appriciate your reply fastly!

Roger

Show replies
Show replies
Former Member
‎08-26-2008 6:16 AM
0 Kudos

Hi Roger,

Could you please execute commands

r3trans -d

r3trans-x

After that paste the log of r3trans.log here.

Regards

Ashok

Show replies
Show replies
Ask a Question