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 -d error

Former Member

on ‎06-04-2016 6:22 PM

0 Kudos

Hello,

trans.log error as below:

4 ETW000 R3trans version 6.24 (release 721 - 31.07.15 - 14:39:42).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 03.06.2016 - 15:26:06

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000  [     dev trc,00000]  Fri Jun  3 15:26:06 2016

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

4 ETW000  [     dev trc,00000]  Library '/usr/sap/MBD/SYS/exe/uc/hpia64/dboraslib.so' loaded

4 ETW000  [     dev trc,00000]  Version of '/usr/sap/MBD/SYS/exe/uc/hpia64/dboraslib.so' is "721.02", patchlevel (0.600)

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

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

4 ETW000  [     dev trc,00000]  dbs/ora/stmt_cache_size = 250

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

4 ETW000  [     dev trc,00000]  Oracle client version: 12.1.0.2.0, V2, default build, (dbsl 721 180915, UNICODE[2])

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

4 ETW000  [     dev trc,00000]  # Patch  20988771     : Created on 11 May 2015, 07:55:14 hrs PST8PDT

4 ETW000  [     dev trc,00000]  # Patch  19594959     : Created on 17 Feb 2015, 07:14:51 hrs PST8PDT

4 ETW000  [     dev trc,00000]  # Patch  11799748     : Created on 29 Sep 2014, 12:28:11 hrs CEST

4 ETW000  [     dev trc,00000]  # Patch  11742262     : Created on 29 Sep 2014, 12:28:17 hrs CEST

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

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

4 ETW000  [     dev trc,00000]  OCIHandleAlloc(con=0): Service svc=6Z131e038 created, rc=0

4 ETW000  [     dev trc,00000]  OCIServerAttach(con=0, svc=6Z131e038): New server hdl. srv=6Z1320710 attached to 'MBD'

4 ETW000  [     dev trc,00000]  Fri Jun  3 15:26:07 2016

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

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

4 ETW000  [     dev trc,00000]  OCISessionBegin(con=0, svc=6Z131e038, srv=6Z1320710='MBD'): start session usr=6Z1394520='SAPSR3', rc=1017

4 ETW000  [     dev trc,00000]  OCIHandleFree(con=0, svc=6Z131e038): Free session hdl usr=6Z1394520

4 ETW000  [     dev trc,00000]  OCIServerDetach(stale2 con=0, svc=6Z131e038, srv=6Z1320710='MBD') successfully detached

4 ETW000  [     dev trc,00000]  OCIHandleFree(con=0, svc=6Z131e038): Server handle srv=6Z1320710 freed

4 ETW000  [     dev trc,00000]  OCIHandleFree(con=0): Service svc=6Z131e038 freed (i=0).

4 ETW000  [     dev trc,00000]  rc=1017 -> Trying to reattach to server 'MBD'

4 ETW000  [     dev trc,00000]  OCIHandleAlloc(con=0): Service svc=6Z131e038 created, rc=0

4 ETW000  [     dev trc,00000]  OCIServerAttach(con=0, svc=6Z131e038): New server hdl. srv=6Z1320710 attached to 'MBD'

4 ETW000  [     dev trc,00000]  Fri Jun  3 15:26:09 2016

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

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

4 ETW000  [     dev trc,00000]  OCISessionBegin(con=0, svc=6Z131e038, srv=6Z1320710='MBD'): start session usr=6Z13330c8='SAPSR3', rc=1017

4 ETW000  [     dev trc,00000]  OCIHandleFree(con=0, svc=6Z131e038): Free session hdl usr=6Z13330c8

4 ETW000  [     dev trc,00000]  OCIServerDetach(stale2 con=0, svc=6Z131e038, srv=6Z1320710='MBD') successfully detached

4 ETW000  [     dev trc,00000]  OCIHandleFree(con=0, svc=6Z131e038): Server handle srv=6Z1320710 freed

4 ETW000  [     dev trc,00000]  OCIHandleFree(con=0): Service svc=6Z131e038 freed (i=1).

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

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

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

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

SQL> SELECT username, account_status FROM dba_users;

USERNAME

--------------------------------------------------------------------------------

ACCOUNT_STATUS

--------------------------------

SAPSR3

OPEN

ANONYMOUS

EXPIRED & LOCKED

DBSNMP

EXPIRED & LOCKED

USERNAME

--------------------------------------------------------------------------------

ACCOUNT_STATUS

--------------------------------

XDB

EXPIRED & LOCKED

APPQOSSYS

EXPIRED & LOCKED

GSMADMIN_INTERNAL

EXPIRED & LOCKED

USERNAME

--------------------------------------------------------------------------------

ACCOUNT_STATUS

--------------------------------

GSMCATUSER

EXPIRED & LOCKED

SYSBACKUP

EXPIRED & LOCKED

OPS$ORAMBD

OPEN

USERNAME

--------------------------------------------------------------------------------

ACCOUNT_STATUS

--------------------------------

OUTLN

LOCKED

DIP

EXPIRED & LOCKED

SYSDG

EXPIRED & LOCKED

Displaying image.png

USERNAME

--------------------------------------------------------------------------------

ACCOUNT_STATUS

--------------------------------

OPS$MBDADM

OPEN

ORACLE_OCM

EXPIRED & LOCKED

OPS$SAPSERVICEMBD

OPEN

USERNAME

--------------------------------------------------------------------------------

ACCOUNT_STATUS

--------------------------------

SYSKM

EXPIRED & LOCKED

XS$NULL

EXPIRED & LOCKED

GSMUSER

EXPIRED & LOCKED

USERNAME

--------------------------------------------------------------------------------

ACCOUNT_STATUS

--------------------------------

AUDSYS

EXPIRED & LOCKED

SYS

OPEN

SYSTEM

OPEN

21 rows selected.

SQL>

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

raviraj_sap
Participant
‎06-07-2016 12:04 PM
0 Kudos

Hi Kavish

Please check the links below:

Thanks

Ravi

Show replies
Show replies
Sriram2009
Active Contributor
‎06-04-2016 8:14 PM
0 Kudos

Hi Kavish.

1. Are you executing the r3trans -d using SIDADM user id?

2. Could you refer the SAP KBA for the error message " ORA=01017 "

1576837 - ORA-01017: invalid username/password;

BR

SS

Show replies
Show replies
former_member235680
Active Participant
‎06-04-2016 6:29 PM
0 Kudos

hi Kavish,

Did you see this note 400241 - Problems with ops$ or sapr3 connect to Oracle?

Check whether you are able to login with SAPSR3 credrntials on DB?


Check CONNECT failed with sql error '1017' | SCN



Thanks

Abhi

Show replies
Show replies
Ask a Question