cancel
Showing results for 
Search instead for 
Did you mean: 

R3trans -d returning code 12

Former Member
0 Kudos

Hi,

I'm installing SAP NW 7.31 on HP UX 11.31 with Kernel 720_EXT .. but facing error in installation:

4 ETW000  [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=6000000002409420)16335  2.677891
4 ETW000  [ dev trc,00000]  Assigning username to user session: con=0, usrhp=6000000002409420     41  2.677932
4 ETW000  [ dev trc,00000]  Assigning password to user session: con=0, usrhp=6000000002409420   1723  2.679655
4 ETW000  [ dev trc,00000]  Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=600000000239e848, srv=60000000023a1790, usr=6000000002409420)
4 ETW000                                                                                           48998  2.728653
4 ETW000  [ dev trc,00000]  Tue Jan 21 10:42:59 2014                                         1247835  3.976488
4 ETW000  [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR              45  3.976533
4 ETW000  [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:         8058  3.984591
4 ETW000  [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000                                                                                           13293  3.997884
4 ETW000  [dbsloci.,00000]  *** ERROR => CONNECT failed with sql error '1017'                     45  3.997929
4 ETW000  [ dev trc,00000] set_ocica() -> SQL error code 1017                               2816  4.000745
4 ETW000  [ dev trc,00000]  -->oci_get_errmsg (con=0, rc=1017)                                   344  4.001089
4 ETW000  [ dev trc,00000] OCIErrorGet -> SQL error code: 1017                               123  4.001212
4 ETW000  [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000                                                                                              46  4.001258
4 ETW000  [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB                      4233  4.005491
4 ETW000  [dblink  ,00000]  ***LOG BY2=>sql error 1017   performing CON                        23287  4.028778
4 ETW000  [dblink  ,00000]  ***LOG BY0=>ORA-01017: invalid username/password; logon denied        41  4.028819
4 ETW000  [ dev trc,00000]  -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET)                  6534  4.035353
4 ETW000  [ dev trc,00000]  -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET)                    36  4.035389
4 ETW000  [ dev trc,00000]  -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO)                 34  4.035423
4 ETW000  [ dev trc,00000]  -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET)                83  4.035506
4 ETW000  [ dev trc,00000]  -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION)              35  4.035541
4 ETW000  [ dev trc,00000]             -> 'OCI_112, 11.2.0.3.0, V1, default build'            36  4.035577
2EETW169 no connect possible: "DBMS = ORACLE                       --- dbs_ora_tnsname = 'I09'"

please suggest ASAP.

Regards,

Siva

  • SAP Managed Tags:

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi, Trans.log...

4 ETW000 R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 21.01.2014 - 12:05:15

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 Jan 21 12:05:15 2014                                               27328  0.027328

4 ETW000  [     dev trc,00000]  db_con_init called                                                        27  0.027355

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): ssfs will be used to get connect information

4 ETW000                                                                                                6699  0.034054

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

4 ETW000                                                                                                  37  0.034091

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

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

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("/usr/sap/I09/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000                                                                                              334626  0.372147

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

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

4 ETW000                                                                                                  56  0.372240

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

4 ETW000                                                                                              100356  0.472596

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

4 ETW000                                                                                                  48  0.472644

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

4 ETW000                                                                                                 102  0.472746

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

4 ETW000                                                                                                 467  0.473213

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

4 ETW000                                                                                                  53  0.473266

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

4 ETW000                                                                                                  52  0.473318

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

4 ETW000                                                                                                  49  0.473367

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1

4 ETW000                                                                                               12774  0.486141

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK)                     33  0.486174

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)                       33  0.486207

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  27  0.486234

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , ti

meout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000                                                                                                 165  0.486399

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)                       34  0.486433

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

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

4 ETW000                                                                                                  36  0.486495

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

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , tim

eout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000                                                                                                  56  0.486574

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): reading connect info for connection R/3             26  0.486600

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0

4 ETW000                                                                                                 434  0.487034

4 ETW000  [     dev trc,00000]  con_info_ext_support(): DBSL supports extended connect protocol           37  0.487071

4 ETW000                          ==> connect info for default DB will be read from ssfs

4 ETW000  [     dev trc,00000]  con_info_ext_support(): auth/shadow_upgrade = undefined                   40  0.487111

4 ETW000                         ==> Using default key set to get connect info from ssfs

4 ETW000  [     dev trc,00000]  read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000                                                                                                  45  0.487156

4 ETW000  [     dev trc,00000]  RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858]       15664  0.502820

4 ETW000  [     dev trc,00000]  Tue Jan 21 12:05:16 2014                                               27997  0.530817

4 ETW000  [     dev trc,00000]  RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]

4 ETW000                                                                                                  37  0.530854

4 ETW000  [     dev trc,00000]  RSecSSFs: Data file "/usr/sap/I09/SYS/global/security/rsecssfs/data/SSFS_I09.DAT" opened for read [rsecssfs.c 2359]

4 ETW000                                                                                                 227  0.531081

4 ETW000  [     dev trc,00000]  RSecSSFs: Key file "/usr/sap/I09/SYS/global/security/rsecssfs/key/SSFS_I09.KEY" not found, using default key [rsecssfs.c 1279]

4 ETW000                                                                                                3154  0.534235

4 ETW000  [     dev trc,00000]  RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 915]

4 ETW000                                                                                               30906  0.565141

4 ETW000  [     dev trc,00000]  read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs

4 ETW000                                                                                                  37  0.565178

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                    25  0.565203

4 ETW000  [     dev trc,00000]  read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000                                                                                                  34  0.565237

4 ETW000  [     dev trc,00000]  RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858]          99  0.565336

4 ETW000  [     dev trc,00000]  RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]

4 ETW000                                                                                                  87  0.565423

4 ETW000  [     dev trc,00000]  RSecSSFs: Data file "/usr/sap/I09/SYS/global/security/rsecssfs/data/SSFS_I09.DAT" opened for read [rsecssfs.c 2359]

4 ETW000                                                                                                 103  0.565526

4 ETW000  [     dev trc,00000]  RSecSSFs: Key file "/usr/sap/I09/SYS/global/security/rsecssfs/key/SSFS_I09.KEY" not found, using default key [rsecssfs.c 1279]

4 ETW000                                                                                                  69  0.565595

4 ETW000  [     dev trc,00000]  RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 915]

4 ETW000                                                                                                7015  0.572610

4 ETW000  [     dev trc,00000]  read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs

4 ETW000                                                                                                  37  0.572647

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                    24  0.572671

4 ETW000  [     dev trc,00000]  read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000                                                                                                  34  0.572705

4 ETW000  [     dev trc,00000]  RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858]          33  0.572738

trans.log (52%)

4 ETW000                                                                                                  85  0.572823

4 ETW000  [     dev trc,00000]  RSecSSFs: Data file "/usr/sap/I09/SYS/global/security/rsecssfs/data/SSFS_I09.DAT" opened for read [rsecssfs.c 2359]

4 ETW000                                                                                                 102  0.572925

4 ETW000  [     dev trc,00000]  RSecSSFs: Key file "/usr/sap/I09/SYS/global/security/rsecssfs/key/SSFS_I09.KEY" not found, using default key [rsecssfs.c 1279]

4 ETW000                                                                                                  68  0.572993

4 ETW000  [     dev trc,00000]  RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2381]

4 ETW000                                                                                                  87  0.573080

4 ETW000  [     dev trc,00000]  RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" no

t found in secure storage) [rsecssfs.c 915]

4 ETW000                                                                                                 154  0.573234

4 ETW000  [     dev trc,00000]  read_ssfs_record(): not found is accepted, RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_CON_ENV)=1 : Record with key "DB_CONNECT/DE

FAULT_DB_CON_ENV" not found in secure storage

4 ETW000                                                                                                  44  0.573278

4 ETW000  [     dev trc,00000]  read_ssfs_record(): deregister callback ssfs_dbi_trace                    24  0.573302

4 ETW000  [     dev trc,00000]  -->DbSlConnect(vers=0, type=0, env='[default env]', usr='SAPSR3', kernel dbsl='720')

4 ETW000                                                                                               16621  0.589923

4 ETW000  [     dev trc,00000]  Register application info.                                             39945  0.629868

4 ETW000  [     dev trc,00000]  Oracle client version: 11.2.0.3.0, V1, default build, (dbsl 720 291112, UNICODE[2])

4 ETW000                                                                                               23870  0.653738

4 ETW000  [     dev trc,00000]  Installed Oracle client patches:                                          46  0.653784

4 ETW000  [     dev trc,00000]  # Patch  13508485     : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT

4 ETW000                                                                                                  42  0.653826

4 ETW000  [     dev trc,00000]  # Patch Description: Created on  2 Jan 2012, 04:56:08 hrs PST8PDT         42  0.653868

4 ETW000  [     dev trc,00000]  # Patch  11742262     : Created on  7 Mar 2012, 12:22:41 hrs CET          49  0.653917

4 ETW000  [     dev trc,00000]    Default connection: tnsname ='I09'                                      35  0.653952

4 ETW000  [     dev trc,00000]  -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2

4 ETW000                                                                                                 350  0.654302

4 ETW000  [     dev trc,00000]  OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000                                                                                              805718  1.460020

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=600000000239d888)      11306  1.471326

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=600000000239e928)         45  1.471371

4 ETW000  [     dev trc,00000]  NLS env. settings: lang=0041004D00450052004900430041004E               26457  1.497828

4 ETW000  [     dev trc,00000]                     terr=0041004D00450052004900430041                      52  1.497880

4 ETW000  [     dev trc,00000]                     char=00550054004600310036                              43  1.497923

4 ETW000  [     dev trc,00000]  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

4 ETW000                                                                                                  45  1.497968

4 ETW000  [     dev trc,00000]  charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE                      33  1.498001

4 ETW000  [     dev trc,00000]  Connecting as SAPSR3/<pwd>@I09 on connection 0 (nls 0) ... (dbsl 720 291112, UNICODE[2])

4 ETW000                                                                                                 653  1.498654

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=600000000239e848)      5205  1.503859

4 ETW000  [     dev trc,00000]  Allocating server context handle                                          36  1.503895

4 ETW000  [     dev trc,00000]  Attaching to database server I09 (con=0, svchp=600000000239e848, srvhp=60000000023a1790)

4 ETW000                                                                                                  60  1.503955

4 ETW000  [     dev trc,00000]  Tue Jan 21 12:05:18 2014                                             1205256  2.709211

4 ETW000  [     dev trc,00000]  Assigning server context 60000000023a1790 to service context 600000000239e848

trans.log (81%)

4 ETW000  [     dev trc,00000]  OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000                                                                                              805718  1.460020

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=600000000239d888)      11306  1.471326

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=600000000239e928)         45  1.471371

4 ETW000  [     dev trc,00000]  NLS env. settings: lang=0041004D00450052004900430041004E               26457  1.497828

4 ETW000  [     dev trc,00000]                     terr=0041004D00450052004900430041                      52  1.497880

4 ETW000  [     dev trc,00000]                     char=00550054004600310036                              43  1.497923

4 ETW000  [     dev trc,00000]  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

4 ETW000                                                                                                  45  1.497968

4 ETW000  [     dev trc,00000]  charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE                      33  1.498001

4 ETW000  [     dev trc,00000]  Connecting as SAPSR3/<pwd>@I09 on connection 0 (nls 0) ... (dbsl 720 291112, UNICODE[2])

4 ETW000                                                                                                 653  1.498654

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=600000000239e848)      5205  1.503859

4 ETW000  [     dev trc,00000]  Allocating server context handle                                          36  1.503895

4 ETW000  [     dev trc,00000]  Attaching to database server I09 (con=0, svchp=600000000239e848, srvhp=60000000023a1790)

4 ETW000                                                                                                  60  1.503955

4 ETW000  [     dev trc,00000]  Tue Jan 21 12:05:18 2014                                             1205256  2.709211

4 ETW000  [     dev trc,00000]  Assigning server context 60000000023a1790 to service context 600000000239e848

4 ETW000                                                                                                  54  2.709265

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=6000000002409420)    16328  2.725593

4 ETW000  [     dev trc,00000]  Assigning username to user session: con=0, usrhp=6000000002409420         41  2.725634

4 ETW000  [     dev trc,00000]  Assigning password to user session: con=0, usrhp=6000000002409420       1725  2.727359

4 ETW000  [     dev trc,00000]  Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=600000000239e848, srv=60000000023a1790, usr=6000000002409420)

4 ETW000                                                                                               48997  2.776356

4 ETW000  [     dev trc,00000]  Tue Jan 21 12:05:28 2014                                             10190202  12.966558

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

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

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

4 ETW000                                                                                                  67  12.966914

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

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

4 ETW000  [     dev trc,00000]  -->oci_get_errmsg (con=0, rc=1017)                                        42  12.967057

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

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

4 ETW000                                                                                                  46  12.967224

4 ETW000  [     dev trc,00000]     DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB                            47  12.967271

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

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

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET)                        53  12.972235

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET)                        36  12.972271

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO)                     35  12.972306

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET)                    87  12.972393

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION)                  35  12.972428

4 ETW000  [     dev trc,00000]                 -> 'OCI_112, 11.2.0.3.0, V1, default build'                36  12.972464

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

trans.log: END

former_member188883
Active Contributor
0 Kudos

Hi Sivakoti,

Can you reset the password for Schema user using the command below

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


Post this check the results using R3trans -d


Hope this helps.


Regards,

Deepak Kori

Former Member
0 Kudos

Hi Reddy,

Did you issue got resolved ? If yes please close the thread.

If no, can you delete your trans.log and try R3trans -d  or R3trans -x and get the logs.

Regards,

Deepanshu Sharma


Former Member
0 Kudos

username/password; logon denied      

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

Check SAP Note 400241 as mentioned by other Techie.

Regards,

Nick Loy

Former Member
0 Kudos

Hi Loy,

I'm bit confused, can you please brief the procedure in Snote 400241...

Regards,

Siva

sunny_pahuja2
Active Contributor
0 Kudos

Hello,

We are not able to see complete logs. Could you please attach log to this thread?

In mean time, please also check SAP note 400241.

Thanks,

Sunny