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: 

R3trans error

Go to solution
Former Member

on ‎03-30-2010 6:03 PM

0 Kudos

Hello SAP,

During the post processing the R3trans show a error (0012) when execute the parameter R3trans -x

sappre1:ssiadm 87> tail -30 trans.log

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1403 14 0.949235

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 59 0.949294

4 ETW000 [dev trc ,00000] Rolling back transaction ... 28 0.949322

4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=6000000000c88328,usrhp=6000000000c94250)

4 ETW000 200 0.949522

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 742 0.950264

4 ETW000 [dev trc ,00000] Try to connect with default password 15 0.950279

4 ETW000 [dev trc ,00000] Connecting as SAPSSI/<pwd>@SSI on connection 0 (nls_hdl 0) ... (dbsl 640 070308)

4 ETW000 24 0.950303

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

4 ETW000 99 0.950402

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 6000000000c7fda0 6000000000c88a60 6000000000c883f8

4 ETW000 21 0.950423

4 ETW000 [dev trc ,00000] Assigning username to user session 6000000000c94250

4 ETW000 20 0.950443

4 ETW000 [dev trc ,00000] Assigning password to user session 6000000000c94250

4 ETW000 29 0.950472

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=6000000000c88328,srvhp=6000000000c8a7e8,usrhp=6000000000c94250)

4 ETW000 20 0.950492

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 36397 0.986889

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

4 ETW000 23 0.986912

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 13 0.986925

4 ETW000 [dev trc ,00000] Tue Mar 30 18:56:47 2010 131494 1.118419

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 1017 performing CON [dblink#3 @ 428]

4 ETW000 40 1.118459

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 428]

4 ETW000 21 1.118480

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

sappre1:ssiadm 88>

Regards.

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎03-31-2010 11:05 AM
0 Kudos

hello colleagues,

SAPSYSTEMNAME=SSI

DIR_LIBRARY=/usr/sap/SSI/SYS/exe/run

SHLIB_PATH=/usr/sap/SSI/SYS/exe/run

JAVA_HOME=/opt/java1.4

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=SSI

dbs_ora_schema=SAPSSI

ORACLE_PSRV=SSI

ORACLE_SID=SSI

DB_SID=SSI

ORACLE_HOME=/oracle/SSI/102_64

ORACLE_BASE=/oracle

ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/SSI

SQL> select owner from dba_tables where table_name = 'T000';

OWNER

-

-

SAPSSP

Regards

Edited by: Víctor Barahona Cimas on Mar 31, 2010 12:07 PM

Show replies
Show replies
Former Member
‎03-31-2010 11:15 AM
0 Kudos

Hi,

Please refer Note 534765 - db connect fails because of wrong db schema in environment

Also paste starting lines of trans.log file.

Sachin

Former Member
‎03-31-2010 11:32 AM
0 Kudos

Hi,

I know that you have set the environment correctly, but still I think you need to look into the below note for your SVERS error.

It is saying this problem may be related to database libraries (DBSL).

Please go through the note word by word...

Try updating the Kernel including the database libraries. Also check that you are usign proper kernel version (unicode/nonunicode)

***LOG BZA=> table SVERS      does not exist on database

[Note 556232 - Environment settings for R/3/Oracle on Windows|https://service.sap.com/sap/support/notes/556232]

Regards.

Rajesh Narkhede

Answers (12)

Answers (12)

Former Member
‎03-31-2010 11:29 AM
0 Kudos

SAPSYSTEMNAME=SSI

DIR_LIBRARY=/usr/sap/SSI/SYS/exe/run

SHLIB_PATH=/usr/sap/SSI/SYS/exe/run

JAVA_HOME=/opt/java1.4

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=SSI

dbs_ora_schema=SAPSSI

ORACLE_PSRV=SSI

ORACLE_SID=SSI

DB_SID=SSI

ORACLE_HOME=/oracle/SSI/102_64

ORACLE_BASE=/oracle

ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/SSI

SQL> select owner from dba_tables where table_name = 'T000';

OWNER

-

SAPSSP

Show replies
Show replies
ashish_mishra2
Contributor
‎03-31-2010 12:07 PM
0 Kudos

Victor,

This thread has been marked as answered by you.

In case the problem has been resolved, please let others know the solution which worked.

Regards,

Ashish

Former Member
‎03-31-2010 11:28 AM
0 Kudos

sappre1:ssiadm 43> R3trans -d

This is R3trans version 6.13 (release 640 - 17.07.08 - 08:11:00).

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

db call info -

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len: 5

2EETW000 key: TADIR

2EETW000 retcode: 2

R3trans finished (0012).

sappre1:ssiadm 44> R3trans -x

This is R3trans version 6.13 (release 640 - 17.07.08 - 08:11:00).

R3trans finished (0000).

sappre1:ssiadm 45> more trans.log

4 ETW000 R3trans version 6.13 (release 640 - 17.07.08 - 08:11:00).

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

4 ETW000

4 ETW000 date&time : 31.03.2010 - 12:21:38

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

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

4 ETW000 [dev trc ,00000] Wed Mar 31 12:21:38 2010 344 0.000344

4 ETW000 [dev trc ,00000] db_con_init called 28 0.000372

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SSI/SYS/exe/run/dboraslib.so' ...

4 ETW000 84 0.000549

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/SSI/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 30694 0.031243

4 ETW000 [dev trc ,00000] Library '/usr/sap/SSI/SYS/exe/run/dboraslib.so' loaded

4 ETW000 35 0.031278

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/SSI/SYS/exe/run/dboraslib.so

4 ETW000 97 0.031375

4 ETW000 [dev trc ,00000] Version of '/usr/sap/SSI/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.220)

4 ETW000 214 0.031589

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/SSI/SYS/exe/run/dboraslib.so

4 ETW000 27 0.031616

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/SSI/SYS/exe/run/dboraslib.so

4 ETW000 70 0.031686

4 ETW000 [dev trc ,00000] New connection 0 created 48 0.031734

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

opt = 255, occ = NO

4 ETW000 49 0.031783

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

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

4 ETW000 20 0.031832

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

pt = 255, occ = NO

4 ETW000 21 0.031853

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/SSI/102_64 from environment

4 ETW000 586 0.032439

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 73 0.032512

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 20 0.032532

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 3093 0.035625

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSSI's password 66 0.035691

4 ETW000 [dev trc ,00000] Connecting as /@SSI on connection 0 (nls_hdl 0) ... (dbsl 640 070308)

4 ETW000 21 0.035712

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

4 ETW000 30 0.035742

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 6000000000c7fda0 6000000000c88a60 6000000000c883f8

4 ETW000 22 0.035764

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 40 0.035804

4 ETW000 [dev trc ,00000] Allocating server context handle 16 0.035820

4 ETW000 [dev trc ,00000] Attaching to DB Server SSI (con_hdl=0,svchp=6000000000c88328,srvhp=6000000000c8a7e8)

4 ETW000 78 0.035898

4 ETW000 [dev trc ,00000] Assigning server context 6000000000c8a7e8 to service context 6000000000c88328

4 ETW000 265742 0.301640

4 ETW000 [dev trc ,00000] Allocating user session handle 70 0.301710

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=6000000000c88328,srvhp=6000000000c8a7e8,usrhp=6000000000c94250)

4 ETW000 42 0.301752

4 ETW000 [dev trc ,00000] Assigning user session 6000000000c94250 to service context 6000000000c88328

4 ETW000 10148 0.311900

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 138 0.312038

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 205 0.312243

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

4 ETW000 1151 0.313394

4 ETW000 [dev trc ,00000] Wed Mar 31 12:21:39 2010 874 0.314268

4 ETW000 [dev trc ,00000] Connected to session 80. 12 0.314280

4 ETW000 [dev trc ,00000] Now '/@SSI' is connected: con_hdl=0, nls_hdl=0, session_id=80.

4 ETW000 20 0.314300

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 24 0.314324

4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 304 0.314628

4 ETW000 [dev trc ,00000] Got SAPSSI's password from OPS$-user 803 0.315431

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 26 0.315457

4 ETW000 [dev trc ,00000] Rolling back transaction ... 45 0.315502

4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=6000000000c88328,usrhp=6000000000c94250)

4 ETW000 203 0.315705

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 750 0.316455

4 ETW000 [dev trc ,00000] Connecting as SAPSSI/<pwd>@SSI on connection 0 (nls_hdl 0) ... (dbsl 640 070308)

4 ETW000 38 0.316493

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

4 ETW000 22 0.316515

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 6000000000c7fda0 6000000000c88a60 6000000000c883f8

4 ETW000 128 0.316643

4 ETW000 [dev trc ,00000] Assigning username to user session 6000000000c94250

4 ETW000 19 0.316662

4 ETW000 [dev trc ,00000] Assigning password to user session 6000000000c94250

4 ETW000 27 0.316689

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=6000000000c88328,srvhp=6000000000c8a7e8,usrhp=6000000000c94250)

4 ETW000 21 0.316710

4 ETW000 [dev trc ,00000] Assigning user session 6000000000c94250 to service context 6000000000c88328

4 ETW000 4634 0.321344

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 39 0.321383

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 35 0.321418

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

4 ETW000 425 0.321843

4 ETW000 [dev trc ,00000] Connected to session 80. 289 0.322132

4 ETW000 [dev trc ,00000] Now 'SAPSSI/<pwd>@SSI' is connected: con_hdl=0, nls_hdl=0, session_id=80.

4 ETW000 23 0.322155

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 23 0.322178

4 ETW000 [dev trc ,00000] SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER IN ('NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET')

ORDER BY PARAM

4 ETW000 262 0.322440

4 ETW000 [dev trc ,00000] ETER

4 ETW000 21 0.322461

4 ETW000 [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.WE8DEC 397 0.322858

4 ETW000 [dev trc ,00000] SELECT UPPER(INSTANCE_NAME),HOST_NAME,VERSION,TO_CHAR(STARTUP_TIME,'MON DD, YYYY, HH24:MI:SS') FROM V$INSTAN

CE

4 ETW000 58 0.322916

4 ETW000 [dev trc ,00000] DB instance SSI is running on sappre1 with ORACLE version 10.2.0.2.0 since MAR 31, 2010, 11:46:51

4 ETW000 521 0.323437

4 ETW000 [dev trc ,00000] SELECT SUBSTR(NAME,1,3), TO_CHAR(CREATED,'YYYYMMDDHHMMSS') FROM V$DATABASE

4 ETW000 36 0.323473

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 1524 0.324997

4 ETW000 [dev trc ,00000] SELECT VERSION FROM SVERS

4 ETW000 3582 0.328579

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 942 1397 0.329976

4 ETW000 [dblink ,01280] ***LOG BZA=>table SVERS does not exist on database [dblink#3 @ 1280]

4 ETW000 176 0.330152

4 ETW000 Connected to database.

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 28 0.330180

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 44 0.330224

4 ETW000 [dev trc ,00000] Rolling back transaction ... 45 0.330269

4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=6000000000c88328,usrhp=6000000000c94250)

4 ETW000 164 0.330433

4 ETW000 [dev trc ,00000] Deallocating user session handle 469 0.330902

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=6000000000c8a7e8)

4 ETW000 25 0.330927

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=6000000000c88328,srvhp=6000000000c8a7e8)

4 ETW000 24 0.330951

4 ETW000 [dev trc ,00000] Deallocating server context handle 6000000000c8a7e8

4 ETW000 600 0.331551

4 ETW000 [dev trc ,00000] Deallocating service context 6000000000c88328 17 0.331568

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 12 0.331580

4 ETW000 [dev trc ,00000] Disconnected from connection 0 12 0.331592

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=0, com_tx=0)

4 ETW000 18 0.331610

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 18 0.331628

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 31.03.2010 - 12:21:39

Show replies
Show replies
Former Member
‎03-31-2010 11:00 AM
0 Kudos

Yes Sachim is the system Copy, the production.

Show replies
Show replies
Former Member
‎03-31-2010 11:03 AM
0 Kudos

Hi,

Then check the dbs_ora_schema environment varriable & set it to SAP<SID> in your case SAPSSI.

Now try & let us know.

Thanks,

Sachin Sable

Former Member
‎03-31-2010 10:51 AM
0 Kudos

brtools -> 8 - Additional functions -->4 - Change password of database user

Regards.

Show replies
Show replies
Former Member
‎03-31-2010 10:57 AM
0 Kudos

hi,

is it system copy??

Sachin

Former Member
‎03-31-2010 10:45 AM
0 Kudos

hello colleagues,

4 ETW000 63 0.558173

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 942 423 0.558596

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT DBASE FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 25 0.558621

4 ETW000 [dbntab ,01285] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#10 @ 12859]

4 ETW000 22 0.558643

Regards.

Show replies
Show replies
Former Member
‎03-31-2010 10:42 AM
0 Kudos

sappre1:ssiadm 27> R3trans -x

This is R3trans version 6.13 (release 640 - 17.07.08 - 08:11:00).

R3trans finished (0000).

sappre1:ssiadm 28> R3trans -d

This is R3trans version 6.13 (release 640 - 17.07.08 - 08:11:00).

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

db call info -

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len: 5

2EETW000 key: TADIR

2EETW000 retcode: 2

R3trans finished (0012).

sappre1:ssiadm 29> tail -50 trans.log

4 ETW000 23 0.465278

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 942 25674 0.490952

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT, UNICODE_LG FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 29 0.490981

4 ETW000 [dev trc ,00000] SELECT VERSION FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000 52 0.491033

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 942 9771 0.500804

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 25 0.500829

4 ETW000 [dev trc ,00000] SELECT DBASE FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000 48 0.500877

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 942 448 0.501325

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT DBASE FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 27 0.501352

4 ETW000 [dbntab ,01285] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#10 @ 12859]

4 ETW000 24 0.501376

4 ETW000 [twdydbacc.c ,00570] i:0 33703 0.535079

4 ETW000 [twdydbacc.c ,00571] db_fd_p<i>.fname: PGMID 12 0.535091

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.is_key: 0 10 0.535101

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.offset: 0 11 0.535112

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.db_length: 0 10 0.535122

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.fixed_length:4 10 0.535132

4 ETW000 [dev trc ,00000] SELECT COMPCNT, UNICODELG FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000 59 0.535191

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 942 22380 0.557571

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT, UNICODE_LG FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 28 0.557599

4 ETW000 [dev trc ,00000] SELECT VERSION FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000 47 0.557646

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 942 441 0.558087

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 23 0.558110

4 ETW000 [dev trc ,00000] SELECT DBASE FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000 63 0.558173

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 942 423 0.558596

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT DBASE FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 25 0.558621

4 ETW000 [dbntab ,01285] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#10 @ 12859]

4 ETW000 22 0.558643

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

db call info -

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len: 5

2EETW000 key: TADIR

2EETW000 retcode: 2

4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0)

4 ETW000 3522 0.562165

4 ETW000 ROLLBACK (0).

sappre1:ssiadm 30>

Show replies
Show replies
Former Member
‎03-31-2010 10:47 AM
0 Kudos

Hi,

What changes did u done before this error?

Thanks,

Sachin

Former Member
‎03-31-2010 9:38 AM
0 Kudos

Hello colleagues,

sappre1:orassi 3> env | grep dbs_ora_schema

dbs_ora_schema=SAPSSI

sappre1:orassi 4> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Mar 31 10:35:56 2010

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

SQL> select username,account_status from dba_users;

USERNAME ACCOUNT_STATUS

-

-

SYSTEM OPEN

SYS OPEN

OPS$SAP_SSIADM OPEN

DIP EXPIRED & LOCKED

TSMSYS EXPIRED & LOCKED

SAPSSPDB OPEN

OUTLN OPEN

SAPSSI OPEN

DP_BACKUP OPEN

OPS$SAPSSIADM OPEN

SAPSSP OPEN

USERNAME ACCOUNT_STATUS

-

-

OPS$ORASSI OPEN

OPS$ORASSP OPEN

DBSNMP OPEN

OPS$SSIADM OPEN

15 rows selected.

SQL> conn sys/si

ERROR:

ORA-01017: invalid username/password; logon denied

Regards.

Show replies
Show replies
ashish_mishra2
Contributor
‎03-31-2010 9:46 AM
0 Kudos

>SQL> conn sys/si

>ERROR:

>ORA-01017: invalid username/password; logon denied

Oopsss ..here you go.

You need to reset the password of sys and system. use brtools and reset the password.

brtools -> 8 - Additional functions -->4 - Change password of database user

Former Member
‎03-31-2010 10:01 AM
0 Kudos

Hi,

This seems to be the password for user SAPSSI is wrong. 

Connecting as SAPSSI/@SSI on connection 0 (nls_hdl 0)
***LOG BY0=>ORA-01017: invalid username/password; logon denied

You can change the password of SAPSSI user using

DELETE FROM "OPS$<sid>ADM".SAPUSER;
INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');

OR You can use the brconnect command.

brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

Hope this will help.

Thanks,

Sachin Sable

Former Member
‎03-31-2010 9:20 AM
0 Kudos

When we look on schema owners for SSI database by executing brconnect

we found that the following listed owners are present:

BR0280I BRCONNECT time stamp: 2010-03-31 09.58.10

BR0813I Schema owners found in database SSI:

DBSNMP, DIP, DP_BACKUP, OPS$ORASSI, OPS$ORASSP, OPS$SAPSSIADM,

OPS$SAP_SSIADM, OPS$SSIADM, OUTLN, SAPSSI,

SAPSSP*, SAPSSPDB, SYS, SYSTEM, TSMSYS

We noticed that OPS$SAPSERVICESSI is not a schema owner in this

database. Is it necessary to be created?

Could you kindly recommend us how to proceed further?

Thanks in advance.

Best regards,

Show replies
Show replies
ashish_mishra2
Contributor
‎03-31-2010 9:43 AM
0 Kudos

.

.

ashish_mishra2
Contributor
‎03-31-2010 9:19 AM
0 Kudos

> 4 ETW000 [dev trc ,00000] Try to connect with default password 15 0.950279

> 4 ETW000 [dev trc ,00000] Connecting as SAPSSI/<pwd>@SSI on connection 0 (nls_hdl 0) ... (dbsl 640 070308)

> 4 ETW000 [dev trc ,00000] Assigning username to user session 6000000000c94250

> 4 ETW000 20 0.950443

> 4 ETW000 [dev trc ,00000] Assigning password to user session 6000000000c94250

> 4 ETW000 29 0.950472

> 4 ETW000 [dev trc ,00000] Starting user session > 4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

> 4 ETW000 23 0.986912

> 4 ETW000 [dblink ,00428] **LOG BY0=>ORA-01017: invalid username/password; logon denied* [dblink#3 @ 428]

1: System is trying to connect with SAPSSI user. check wehther this is correct.

<hostname>:orax12 1> env | grep dbs_ora_schema

dbs_ora_schema= ?

2: Check the user account status, sys, system, schema or OPS$ should not be locked.

SQL> select username,account_status from dba_users;

3: check and confirm the passwords of sys, system, schema and OPS$ too

SQL> conn <user>/password

Connected.

Cheers !!!

Ashish

Show replies
Show replies
JanStallkamp
Employee
Employee
‎03-31-2010 9:04 AM
0 Kudos

Hi.

I moved the thread to the 'SAP on Oracle' forum as it seems to be related to that DB platform and not to IBM i.

Best regards,

Jan Stallkamp

Show replies
Show replies
Former Member
‎03-30-2010 7:35 PM
0 Kudos

We have checked notes 50088,361641,134592 and no workaround was found. As it has a negative impact, could you kindly provide us any recommendation?

Regards.

Show replies
Show replies
markus_doehr2
Active Contributor
‎03-30-2010 11:31 PM
0 Kudos

Please follow

400241 - Problems with ops$ or sapr3 connect to Oracle

(as already mentioned by Eric).

Markus

former_member204746
Active Contributor
‎03-30-2010 6:10 PM
0 Kudos

you posted your question in the DB2 section, yet, your error refer to Oracle. Are you using Oracle or DB2?

if Oracle, it's time to review these SAP notes:

134592 - Importing the SAPDBA role (sapdba_role.sql)

400241 - Problems with ops$ or sapr3 connect to Oracle

403004 - Database connect using R3trans fails

361641 - Creating OPS$ users on UNIX

849141 - SAP NetWeaver 2004s Installation on Windows: Oracle

Show replies
Show replies
Ask a Question