on 08-22-2005 5:28 PM
I have an NW4 test drive running on linux/db2. It used to run well, and I don't remember changing anything.
However, I can no longer start SAP. The database is running , and I can connect using the CLP "db2" as sapsi4 and si4adm, and select from SAP tables.
However, running the <b>usr/sap/SI4/SYS/exe/run/startdb</b> script, specifically the line <b>R3trans -d -w xx.log</b> produces an error indicating a bad password.
Does anyone have an idea of how to fix this, and what I could have done to cause the problem? Below is the output. Sorry if it isn't very readable.
I have an NW4 test drive running on linux/db2. It used to run well, and I don't remember changing anything.
However, I can no longer start SAP. The database is running , and I can connect using the CLP "db2" as sapsi4 and si4adm, and select from SAP tables.
However, running the <b>usr/sap/SI4/SYS/exe/run/startdb</b> script, specifically the line <b>R3trans -d -w xx.log</b> produces an error indicating a bad password.
Does anyone have an idea of how to fix this, and what I could have done to cause the problem? Below is the output. Sorry if it isn't very readable.
[code]
si4host:si4adm 78> R3trans -d -w xx.log
This is R3trans version 6.09 (release 640 - 28.04.04 - 16:14:00).
2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'SI4'"
R3trans finished (0012).
si4host:si4adm 79> cat xx.log
4 ETW000 R3trans version 6.09 (release 640 - 28.04.04 - 16:14:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 22.08.2005 - 08:00:58
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d -w xx.log
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Mon Aug 22 08:00:58 2005 175 0.000175
4 ETW000 [dev trc ,00000] db_con_init called 32 0.000207
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 62 0.000269
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SI4/SYS/exe/run/dbdb6slib.so' ...
4 ETW000 58 0.000327
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/SI4/SYS/exe/run/dbdb6slib.so), hdl 0
4 ETW000 27893 0.028220
4 ETW000 [dev trc ,00000] Library '/usr/sap/SI4/SYS/exe/run/dbdb6slib.so' loaded
4 ETW000 46 0.028266
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/SI4/SYS/exe/run/dbdb6slib.so
4 ETW000 62 0.028328
4 ETW000 [dev trc ,00000] Version of '/usr/sap/SI4/SYS/exe/run/dbdb6slib.so' is "640.00", patchlevel (0.7)
4 ETW000 141 0.028469
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/SI4/SYS/exe/run/dbdb6slib.so
4 ETW000 41 0.028510
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/SI4/SYS/exe/run/dbdb6slib.so
4 ETW000 42 0.028552
4 ETW000 [dev trc ,00000] New connection 0 created 35 0.028587
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , con_max = 255, con_opt = 255, occ = NO
4 ETW000 46 0.028633
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 31 0.028664
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 38 0.028702
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , con_max = 255, con_opt = 255, occ = NO
4 ETW000 39 0.028741
4 ETW000 [dev trc ,00000] RLIMIT_STACK: current=-1, max=-1 337 0.029078
4 ETW000 [dev trc ,00000] DB6 (DB2 UDB) database interface 640.00 [opt] 35 0.029113
4 ETW000 [dev trc ,00000] DB6 shared library (dbdb6slib) patchlevels 27 0.029140
4 ETW000 [dev trc ,00000] (0.6) DB6: Schema setting for remote monitoring (note 711477)
4 ETW000 37 0.029177
4 ETW000 [dev trc ,00000] (0.7) DB6: support DB6_DB_TYPE=DB2/400 (note 663756)
4 ETW000 35 0.029212
4 ETW000 [dev trc ,00000] (0.7) DB6: CTE on UNICODE (note 717357) 23 0.029235
4 ETW000 [dev trc ,00000] Supported features: 23 0.029258
4 ETW000 [dev trc ,00000] - smart optlevel handling (non-UR, FAE) 23 0.029281
4 ETW000 [dev trc ,00000] - SQLExtendedBind for LOBs and Unicode (V8 or higher)
4 ETW000 35 0.029316
4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 83 0.029399
4 ETW000 [dev trc ,00000] ..done 136 0.029535
4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1497] (BEGIN) 255654 0.285189
4 ETW000 [dev trc ,00000] &+*** DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security re
4 ETW000 95 0.285284
4 ETW000 [dev trc ,00000] &+*** ason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
4 ETW000 40 0.285324
4 ETW000 [dev trc ,00000] &+***
4 ETW000 38 0.285362
4 ETW000 [dev trc ,00000] &+***
4 ETW000 39 0.285401
4 ETW000 [dev trc ,00000] &+*** ABAP location info '', 0
4 ETW000 52 0.285453
4 ETW000 [dev trc ,00000] &+***
4 ETW000 37 0.285490
4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1497] (END) 24 0.285514
4 ETW000 [dbdb6.c ,00000] *** ERROR => DbSlConnect to 'SI4' as 'sapsi4' failed
4 ETW000 133 0.285647
2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'SI4'"
Hi Jerry,
Maybe your SAP License expired, try getting a new license from http://www.sap.com/solutions/netweaver/minisap.epx.
Cheers,
Sanjeev
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Someone else pointed out to me that it could be password related.
I did change the password for user sapsi4, since it comes delivered with password sapsi4.
That apparently got it out of sync with an encrypted IBM password for the database. Once it changed the password back to sapsi4, it works!
Thanks for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
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.