cancel
Showing results for 
Search instead for 
Did you mean: 

DB-Error at login

ganimede_dignan
Contributor
0 Kudos

Hi forum,

during a system copy (we need to change HW of our dev system) we have a strange error at login

http://img225.imageshack.us/img225/9530/errorth2.gif

Source <SID> and Tagrget <SID> are the same.

Istance starts.... but we can't login.

It is a NW04s system on Windows 2003 Oracle 10.2

a cmd as "select * from T000;" works fine from sqlplus.

Regards.

Ganimede Dignan

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

Execute an R3trans -d as use <sid>adm and post the resulting trans.log

Markus

ganimede_dignan
Contributor
0 Kudos

Thank you for you post.

r3trans -d

This is r3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

r3trans finished (0000).

4 ETW000 r3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

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

4 ETW000

4 ETW000 date&time : 15.02.2008 - 08:29:36

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] Fri Feb 15 08:29:36 2008 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 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 4250 0.004250

4 ETW000 [dev trc ,00000] using "D:\usr\sap\<SID>\SYS\exe\nuc\NTI386\dboraslib.dll"

4 ETW000 18 0.004268

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 7 0.004275

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

4 ETW000 11 0.004286

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

4 ETW000 65 0.004351

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

4 ETW000 11 0.004362

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

4 ETW000 18 0.004380

4 ETW000 [dev trc ,00000] New connection 0 created 13 0.004393

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 17 0.004410

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

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

4 ETW000 11 0.004433

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

4 ETW000 14 0.004447

4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or

4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000 assuming using instant client with unspecified location.

4 ETW000 137 0.004584

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 21882 0.026466

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 1827 0.028312

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAP<SID>'s password 19 0.028331

4 ETW000 [dev trc ,00000] Connecting as /@<SID> on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 17 0.028348

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

4 ETW000 14 0.028362

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 02673F48 0267947C 02678D04

4 ETW000 77 0.028439

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

4 ETW000 [dev trc ,00000] Allocating server context handle 11 0.028471

4 ETW000 [dev trc ,00000] Attaching to DB Server <SID> (con_hdl=0,svchp=02678C50,srvhp=0267D6FC)

4 ETW000 31 0.028502

4 ETW000 [dev trc ,00000] Assigning server context 0267D6FC to service context 02678C50

4 ETW000 15578 0.044080

4 ETW000 [dev trc ,00000] Allocating user session handle 16 0.044096

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=02678C50,srvhp=0267D6FC,usrhp=026924A0)

4 ETW000 24 0.044120

4 ETW000 [dev trc ,00000] Assigning user session 026924A0 to service context 02678C50

4 ETW000 25026 0.069146

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

4 ETW000 30 0.069176

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

4 ETW000 37 0.069213

4 ETW000 [dev trc ,00000] Now '/@<SID>' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 430 0.069643

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

4 ETW000 26 0.069669

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

4 ETW000 245 0.069914

4 ETW000 [dev trc ,00000] Got SAP<SID>'s password from OPS$-user 441 0.070355

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 10 0.070365

4 ETW000 [dev trc ,00000] Rolling back transaction ... 13 0.070378

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=02678C50,usrhp=026924A0)

4 ETW000 122 0.070500

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 336 0.070836

4 ETW000 [dev trc ,00000] Connecting as SAP<SID>/<pwd>@<SID> on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 14 0.070850

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

4 ETW000 13 0.070863

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 02673F48 0267947C 02678D04

4 ETW000 13 0.070876

4 ETW000 [dev trc ,00000] Assigning username to user session 026924A0 8 0.070884

4 ETW000 [dev trc ,00000] Assigning password to user session 026924A0 10 0.070894

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=02678C50,srvhp=0267D6FC,usrhp=026924A0)

4 ETW000 12 0.070906

4 ETW000 [dev trc ,00000] Assigning user session 026924A0 to service context 02678C50

4 ETW000 3894 0.074800

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

4 ETW000 21 0.074821

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

4 ETW000 19 0.074840

4 ETW000 [dev trc ,00000] Now 'SAP<SID>/<pwd>@<SID>' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 396 0.075236

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

4 ETW000 26 0.075262

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 233 0.075495

4 ETW000 [dev trc ,00000] ETER

4 ETW000 13 0.075508

4 ETW000 [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.WE8DEC 274 0.075782

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

4 ETW000 21 0.075803

4 ETW000 [dev trc ,00000] DB instance <SID> is running on MNSUN004 with ORACLE version 10.2.0.2.0 since FEB 14, 2008, 22:33:53

4 ETW000 332 0.076135

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

4 ETW000 17 0.076152

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 16825 0.092977

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

4 ETW000 5212 0.098189

4 ETW000 [dev trc ,00000] SELECT COMPCNT FROM "DDNTT"

4 ETW000 568 0.098757

4 ETW000 [dev trc ,00000] NTAB: Structure of NTAB on DB is VERS_B 208 0.098965

4 ETW000 [dev trc ,00000] NTAB: standalone processing 23 0.098988

4 ETW000 [dev trc ,00000] NTAB: read profile 7 0.098995

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/entrycount 1000. 7 0.099002

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/ftabsize 500. 7 0.099009

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/irbdsize 100. 6 0.099015

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/sntabsize 100. 7 0.099022

4 ETW000 [dev trc ,00000] NTAB: compute_hash_card: 2003. 12 0.099034

4 ETW000 [dev trc ,00000] NTAB: maxcnt 1000. 15 0.099049

4 ETW000 [dev trc ,00000] NTAB: hfactor 2003. 13 0.099062

4 ETW000 [dev trc ,00000] NTAB: mem_protocol_size 104 7 0.099069

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_offset 0 6 0.099075

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_size 0 6 0.099081

4 ETW000 [dev trc ,00000] NTAB: FTAB: header_size 44. 7 0.099088

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_size 36. 6 0.099094

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_cnt 1000. 7 0.099101

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_size 4 9 0.099110

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_cnt 128000. 7 0.099117

4 ETW000 [dev trc ,00000] NTAB: FTAB: data_size 512000. 6 0.099123

4 ETW000 [dev trc ,00000] NTAB: IREC: header_size 44. 7 0.099130

4 ETW000 [dev trc ,00000] NTAB: IREC: item_size 36. 6 0.099136

4 ETW000 [dev trc ,00000] NTAB: IREC: item_cnt 250. 7 0.099143

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_size 8 6 0.099149

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_cnt 12800. 6 0.099155

4 ETW000 [dev trc ,00000] NTAB: IREC: data_size 102400. 7 0.099162

4 ETW000 [dev trc ,00000] NTAB: STAB: header_size 44. 6 0.099168

4 ETW000 [dev trc ,00000] NTAB: STAB: item_size 36. 7 0.099175

4 ETW000 [dev trc ,00000] NTAB: STAB: item_cnt 250. 6 0.099181

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_size 4 6 0.099187

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_cnt 25600. 7 0.099194

4 ETW000 [dev trc ,00000] NTAB: STAB: data_size 102400. 7 0.099201

4 ETW000 [dev trc ,00000] NTAB: TTAB: header_size 148. 6 0.099207

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_size 24. 7 0.099214

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_cnt 1000. 6 0.099220

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_size 152 6 0.099226

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_cnt 1000. 7 0.099233

4 ETW000 [dev trc ,00000] NTAB: TTAB: data_size 152000. 7 0.099240

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 2695d28, hh_len 44 585 0.099825

4 ETW000 [dev trc ,00000] NTAB: FTAB: aa_p 3ad6858, aa_len 8012 12 0.099837

4 ETW000 [dev trc ,00000] NTAB: FTAB: ia_p 3ad87b0, ia_len 36000 7 0.099844

4 ETW000 [dev trc ,00000] NTAB: FTAB: dat_p 3ae3008, dat_len 512000 8 0.099852

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 268cca0, hh_len 44 7 0.099859

4 ETW000 [dev trc ,00000] NTAB: IREC: aa_p 26ca790, aa_len 8012 7 0.099866

4 ETW000 [dev trc ,00000] NTAB: IREC: ia_p 26cc6e8, ia_len 9000 7 0.099873

4 ETW000 [dev trc ,00000] NTAB: IREC: dat_p 3b60010, dat_len 102400 7 0.099880

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 26b7aa8, hh_len 44 7 0.099887

4 ETW000 [dev trc ,00000] NTAB: STAB: aa_p 3b79018, aa_len 8012 8 0.099895

4 ETW000 [dev trc ,00000] NTAB: STAB: ia_p 3b7af70, ia_len 9000 7 0.099902

4 ETW000 [dev trc ,00000] NTAB: STAB: dat_p 3b7d2a0, dat_len 102400 7 0.099909

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 26b7b50, hh_len 148 7 0.099916

4 ETW000 [dev trc ,00000] NTAB: TTAB: aa_p 3b962a8, aa_len 8012 81 0.099997

4 ETW000 [dev trc ,00000] NTAB: TTAB: ia_p 3b98200, ia_len 24000 8 0.100005

4 ETW000 [dev trc ,00000] NTAB: TTAB: dat_p 3b9dfc8, dat_len 152000 7 0.100012

4 ETW000 [dev trc ,00000] NTAB: ntab_mem_protocol 26b7b50, ntab_mp_p 26b7b50, ntab_proc_id 0

4 ETW000 15 0.100027

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 2695d28, ha_list 3ad6858, hi_list 3ad87b0, buffer 3ae3008

4 ETW000 60 0.100087

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 268cca0, ha_list 26ca790, hi_list 26cc6e8, buffer 3b60010

4 ETW000 12 0.100099

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 26b7aa8, ha_list 3b79018, hi_list 3b7af70, buffer 3b7d2a0

4 ETW000 12 0.100111

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 26b7bb8, ha_list 3b962a8, hi_list 3b98200, buffer 3b9dfc8

4 ETW000 11 0.100122

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 0

4 ETW000 20 0.100142

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 1

4 ETW000 20 0.100162

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2

4 ETW000 18 0.100180

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3

4 ETW000 18 0.100198

4 ETW000 [dev trc ,00000] SELECT TABNAME, BLOCKNR, FIELDSLG, FIELDS FROM "DDNTF" WHERE TABNAME = :A0 ORDER BY TABNAME, BLOCKNR

4 ETW000 81 0.100279

4 ETW000 [twdydbacc.c ,00565] i:0 760 0.101039

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: PGMID 8 0.101047

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 1 5 0.101052

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 0 6 0.101058

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 4 5 0.101063

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:4 6 0.101069

4 ETW000 [twdydbacc.c ,00565] i:1 7 0.101076

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: OBJECT 6 0.101082

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 1 5 0.101087

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 4 6 0.101093

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 4 5 0.101098

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:4 5 0.101103

4 ETW000 [twdydbacc.c ,00565] i:2 6 0.101109

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: OBJ_NAME 6 0.101115

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 1 6 0.101121

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 8 5 0.101126

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 40 6 0.101132

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:40 8 0.101140

4 ETW000 [twdydbacc.c ,00565] i:3 6 0.101146

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: KORRNUM 6 0.101152

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 5 0.101157

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 48 6 0.101163

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 10 6 0.101169

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:10 5 0.101174

4 ETW000 [twdydbacc.c ,00565] i:4 6 0.101180

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: SRCSYSTEM 6 0.101186

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 5 0.101191

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 58 6 0.101197

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 10 5 0.101202

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:10 6 0.101208

4 ETW000 [twdydbacc.c ,00565] i:5 6 0.101214

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: AUTHOR 5 0.101219

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 6 0.101225

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 68 5 0.101230

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 12 6 0.101236

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:12 5 0.101241

4 ETW000 [twdydbacc.c ,00565] i:6 6 0.101247

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: SRCDEP 6 0.101253

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 7 0.101260

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 80 6 0.101266

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 1 5 0.101271

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:1 6 0.101277

4 ETW000 [twdydbacc.c ,00565] i:7 6 0.101283

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: DEVCLASS 6 0.101289

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 5 0.101294

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 81 6 0.101300

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 30 5 0.101305

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:30 6 0.101311

4 ETW000 [twdydbacc.c ,00565] i:8 6 0.101317

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: GENFLAG 5 0.101322

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 6 0.101328

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 111 6 0.101334

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 1 5 0.101339

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:1 6 0.101345

4 ETW000 [twdydbacc.c ,00565] i:9 5 0.101350

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: EDTFLAG 6 0.101356

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 6 0.101362

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 112 5 0.101367

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 1 7 0.101374

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:1 6 0.101380

4 ETW000 [twdydbacc.c ,00565] i:10 6 0.101386

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: CPROJECT 5 0.101391

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 6 0.101397

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 113 5 0.101402

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 8 6 0.101408

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:8 5 0.101413

4 ETW000 [twdydbacc.c ,00565] i:11 6 0.101419

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: MASTERLANG 6 0.101425

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 6 0.101431

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 121 5 0.101436

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 1 6 0.101442

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:1 5 0.101447

4 ETW000 [twdydbacc.c ,00565] i:12 6 0.101453

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: VERSID 6 0.101459

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 5 0.101464

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 122 6 0.101470

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 20 6 0.101476

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:20 5 0.101481

4 ETW000 [twdydbacc.c ,00565] i:13 6 0.101487

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: PAKNOCHECK 6 0.101493

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 5 0.101498

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 142 6 0.101504

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 1 6 0.101510

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:1 5 0.101515

4 ETW000 [twdydbacc.c ,00565] i:14 6 0.101521

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: OBJSTABLTY 6 0.101527

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 5 0.101532

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 143 6 0.101538

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 1 5 0.101543

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:1 6 0.101549

4 ETW000 [twdydbacc.c ,00565] i:15 6 0.101555

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: COMPONENT 6 0.101561

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 5 0.101566

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 144 6 0.101572

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 30 5 0.101577

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:30 6 0.101583

4 ETW000 [twdydbacc.c ,00565] i:16 6 0.101589

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: CRELEASE 5 0.101594

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 6 0.101600

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 174 7 0.101607

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 10 5 0.101612

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:10 6 0.101618

4 ETW000 [twdydbacc.c ,00565] i:17 6 0.101624

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: DELFLAG 6 0.101630

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 5 0.101635

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 184 6 0.101641

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 1 5 0.101646

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:1 6 0.101652

4 ETW000 [twdydbacc.c ,00565] i:18 6 0.101658

4 ETW000 [twdydbacc.c ,00566] db_fd_p<i>.fname: TRANSLTTXT 6 0.101664

4 ETW000 [twdydbacc.c ,00567] db_fd_p<i>.is_key: 0 5 0.101669

4 ETW000 [twdydbacc.c ,00568] db_fd_p<i>.offset: 185 6 0.101675

4 ETW000 [twdydbacc.c ,00569] db_fd_p<i>.db_length: 1 5 0.101680

4 ETW000 [twdydbacc.c ,00570] db_fd_p<i>.fixed_length:1 7 0.101687

4 ETW000 [dev trc ,00000] SELECT VERSION, UUID, CRTIMESTMP, ABTIMESTMP, DYTIMESTMP, FLDCNT, TABLENGTH, KEYCNT, KEYLENGTH, CLIENTPOS, TABTYPE, TABFOR

4 ETW000 30 0.101717

4 ETW000 [dev trc ,00000] M, REFNAME, HFLAG, BUFSTATE, BUFPARM, ALIGN, POINTERLG, UNICODELG, COMPCNT, LEAFCNT FROM "DDNTT" WHERE TABNAME = :A0

4 ETW000 13 0.101730

4 ETW000 [twdydbacc.c ,00713] buffer:'u00C0 7' 528 0.102258

4 ETW000 [twdydbacc.c ,00718] i:0 9 0.102267

4 ETW000 [twdydbacc.c ,00719] tw_fd_p<i>.offset:0 5 0.102272

4 ETW000 [twdydbacc.c ,00718] i:1 5 0.102277

4 ETW000 [twdydbacc.c ,00719] tw_fd_p<i>.offset:4 6 0.102283

4 ETW000 [twdydbacc.c ,00718] i:2 5 0.102288

4 ETW000 [twdydbacc.c ,00719] tw_fd_p<i>.offset:8 5 0.102293

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TADIR' ) {twdbcall.c:648}

4 ETW000 17 0.102310

4 ETW000 [dev trc ,00000] SELECT * FROM "TADIR" WHERE "PGMID" = :A0 AND "OBJECT" = :A1 AND "OBJ_NAME" = :A2

4 ETW000 82 0.102392

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_READ_ONLY', retcode = 0 )

4 ETW000 275 0.102667

4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = '<SID>' --- SYSTEM = '<SID>'.

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1251}

4 ETW000 188 0.102855

4 ETW000 [dev trc ,00000] INSERT INTO "PATCHHIST" VALUES( :A0 , :A1 , :A2 , :A3 , :A4 , :A5 , :A6 , :A7 )

4 ETW000 348 0.103203

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 375 0.103578

4 ETW000 [dev trc ,00000] dsql_open (con_da=(0,R/3),stmt="SELECT EXECUTABLE,SAPRELEASE,H ...",#binds=0,name=UNKNOWN,#input=0)

4 ETW000 91 0.103669

4 ETW000 [dev trc ,00000] SELECT EXECUTABLE,SAPRELEASE,HOSTNAME,PLATFORM,DBVENDOR,TIMESTAMP,PATCHNO,DBSLPATCHN FROM PATCHHIST WHERE EXECUTABLE = 'R3

4 ETW000 37 0.103706

4 ETW000 [dev trc ,00000] trans' AND TIMESTAMP = (SELECT MAX(TIMESTAMP) FROM PATCHHIST WHERE EXECUTABLE = 'R3trans' AND SAPRELEASE = '700' AND HOSTN

4 ETW000 13 0.103719

4 ETW000 [dev trc ,00000] AME = 'MNSUN004' AND PLATFORM = 'NT' AND DBVENDOR = 'ORA')

4 ETW000 12 0.103731

4 ETW000 [dev trc ,00000] dsql_fetch (con_da=(0,R/3),cu_id=0,#output=8) 19 0.103750

4 ETW000 [dev trc ,00000] dsql_close (con_da=(0,R/3),cu_id=0) 312 0.104062

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1359}

4 ETW000 16 0.104078

4 ETW000 [dev trc ,00000] DELETE FROM "PATCHHIST" WHERE "EXECUTABLE" = :A0 AND "SAPRELEASE" = :A1 AND "HOSTNAME" = :A2 AND "PLATFORM" = :A3 AND "DBV

4 ETW000 32 0.104110

4 ETW000 [dev trc ,00000] ENDOR" = :A4 AND "TIMESTAMP" = :A5

4 ETW000 13 0.104123

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_DELETE', retcode = 0 ) 215 0.104338

4 ETW690 COMMIT "0" "0"

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

4 ETW000 41 0.104379

4 ETW000 trace to file pointer closed

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

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time : 15.02.2008 - 08:29:36

4 ETW000 function : CONNECT

4 ETW000 buffersync : YES

4 ETW000 clients : default

4 ETW000 l.s.m. : VECTOR

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 84 0.000084

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 11 0.000095

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=02678C50,usrhp=026924A0)

4 ETW000 171 0.000266

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=02678C50,srvhp=0267D6FC)

4 ETW000 382 0.000648

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 397 0.001045

4 ETW000 [dev trc ,00000] Disconnected from connection 0 9 0.001054

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

4 ETW000 10 0.001064

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

4 ETW000 10 0.001074

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 15.02.2008 - 08:29:36

Former Member
0 Kudos

Hello Ganimede Dignan. I'm fink the Note 760175 help You.

Award if helpful.

Edited by: Sergo Beradze on Feb 15, 2008 9:00 AM

Edited by: Sergo Beradze on Feb 15, 2008 9:01 AM

Former Member
0 Kudos

Hi,

r3trans return with 0 seems everything ok

try to login with SAP* in client 000,

run SICK, SM21 and also check SAP license using slicense

regards,

kaushal

Former Member
0 Kudos

Compare versions of kernels to that system with which were copied, make as in that.

Answers (2)

Answers (2)

Former Member
0 Kudos

I just found this SAP Note: 1152171.

Edited by: Mustafa Sehic on Apr 9, 2008 3:49 PM

Former Member
0 Kudos

Hi Dignan ,

What is the status of license?

Have you applied the new license because you have migrate your SAP to new Hardware the Hardware key will be changed, so you have to go for new license.

For testing you can apply the temp license and try to login.

Best Wishes

Kumar

ganimede_dignan
Contributor
0 Kudos

Hi,

during installation (mine is a systemcopy based on backup/restore) SAPins create e templicense... you do not need to create one. So you can login anywhere into the system, not only as SAP* user account.

When SAPinst ends you can install new SAPlicense.