Skip to Content
avatar image
Former Member

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

Hello All,

I started clearing logs via db13, but the program finished with errors.

I checked R3trans;

4 ETW000 C:\usr\sap\ET1\DVEBMGS00\exe\R3trans.exe version 6.19 (release 720 - 06.04.10 - 16:31:00 with UA1430.1 / prepared for CSN 1287305).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 07.07.2013 - 21:25:25

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: C:\usr\sap\ET1\DVEBMGS00\exe\R3trans.exe -d

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

4 ETW000  [dev trc     ,00000]  Sun Jul 07 21:25:25 2013                                               16928  0.016928

4 ETW000  [dev trc     ,00000]  db_con_init called                                                       535  0.017463

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

4 ETW000                                                                                                 651  0.018114

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

4 ETW000  [dev trc     ,00000]  Loading DB library 'dboraslib.dll' ...                                   548  0.018699

4 ETW000  [dev trc     ,00000]  Sun Jul 07 21:25:26 2013                                               28408  0.047107

4 ETW000  [dev trc     ,00000]  DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 0000000187B90000

4 ETW000                                                                                                  65  0.047172

4 ETW000  [dev trc     ,00000]      using "C:\usr\sap\ET1\DVEBMGS00\exe\dboraslib.dll"                    18  0.047190

4 ETW000  [dev trc     ,00000]  Library 'dboraslib.dll' loaded                                            22  0.047212

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

4 ETW000  [dev trc     ,00000]  Version of 'dboraslib.dll' is "720.00", patchlevel (0.34)                582  0.047820

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

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

4 ETW000  [dev trc     ,00000]  New connection 0 created                                                 286  0.048181

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 , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                 307  0.048488

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

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

4 ETW000                                                                                                  28  0.048540

4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection:                          16  0.048556

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 , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  40  0.048596

4 ETW000  [dev trc     ,00000]  DIR_CLIENT_ORAHOME is not set as profile nor env. parameter.             621  0.049217

4 ETW000                        Assuming using instant client with unspecified location.

4 ETW000  [dev trc     ,00000]     oci_init1(ArrayBufSize=130000)                                         52  0.049269

4 ETW000  [dev trc     ,00000]  Oracle Client Version: 10.2.0.5.0                                      93641  0.142910

4 ETW000  [dev trc     ,00000]  Detailed Oracle client and patch info not available.                      58  0.142968

4 ETW000  [dev trc     ,00000]    Default connection: tnsname ='ET1'                                     100  0.143068

4 ETW000  [dev trc     ,00000]  -->oci_initialize(con=0, char='', nchar='')                              201  0.143269

4 ETW000  [dev trc     ,00000]  application info callback registered                                      28  0.143297

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

4 ETW000                                                                                                4083  0.147380

4 ETW000  [dev trc     ,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=0000000005C13738)         67  0.147447

4 ETW000  [dev trc     ,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=0000000005C167C8)         50  0.147497

4 ETW000  [dev trc     ,00000]  Client character set UTF16 -> UTF8                                       148  0.147645

4 ETW000  [dev trc     ,00000]  Client NLS setting (OCINlsGetInfo): connection handle 0, 'AMERICAN_AMERICA.UTF8'

4 ETW000                                                                                                  50  0.147695

4 ETW000  [dev trc     ,00000]  charset='', chset='UTF8', UNI_ASC=FALSE/FALSE                             27  0.147722

4 ETW000  [dev trc     ,00000]  Logon as OPS$-user to get SAPET1's password                               26  0.147748

4 ETW000  [dev trc     ,00000]  Connecting as /@ET1 on connection 0 (nls_hdl 0) ... (dbsl 720 280110)

4 ETW000                                                                                                  38  0.147786

4 ETW000  [dev trc     ,00000]  Nls CharacterSet                 NationalCharSet              Env        Err        ErrBt    

4 ETW000                                                                                                  44  0.147830

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      0000000005C0AE20 0000000005C13738 0000000005C167C8

4 ETW000                                                                                                  49  0.147879

4 ETW000  [dev trc     ,00000]     OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=0000000005C135F8)     13499  0.161378

4 ETW000  [dev trc     ,00000]  Allocating server context handle                                          35  0.161413

4 ETW000  [dev trc     ,00000]  Attaching to database server ET1 (con=0, svchp=0000000005C135F8, srvhp=0000000005C16F08)

4 ETW000                                                                                                  73  0.161486

4 ETW000  [dev trc     ,00000]  Assigning server context 0000000005C16F08 to service context 0000000005C135F8

4 ETW000                                                                                               98742  0.260228

4 ETW000  [dev trc     ,00000]     OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=0000000005C25860)      113  0.260341

4 ETW000  [dev trc     ,00000]  Starting user session: OCISessionBegin(con=0, usr='/',svc=0000000005C135F8, srv=0000000005C16F08, usr=0000000005C25860)

4 ETW000                                                                                                  57  0.260398

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

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

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

4 ETW000                                                                                                  34  0.307032

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

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

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

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

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

4 ETW000                                                                                                  57  0.338557

4 ETW000  [dev trc     ,00000]  Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.

4 ETW000                                                                                                  46  0.338603

4 ETW000  [dev trc     ,00000]  Connecting as SAPET1/<pwd>@ET1 on connection 0 (nls_hdl 0) ... (dbsl 720 280110)

4 ETW000                                                                                                  45  0.338648

4 ETW000  [dev trc     ,00000]  Nls CharacterSet                 NationalCharSet              Env        Err        ErrBt    

4 ETW000                                                                                                  51  0.338699

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      0000000005C0AE20 0000000005C13738 0000000005C167C8

4 ETW000                                                                                                  56  0.338755

4 ETW000  [dev trc     ,00000]  Assigning username to user session: con=0, usrhp= 0000000005C25860        34  0.338789

4 ETW000  [dev trc     ,00000]  Assigning password to user session: con=0, usrhp=0000000005C25860         61  0.338850

4 ETW000  [dev trc     ,00000]  Starting user session: OCISessionBegin(con=0, usr='SAPET1', svc=0000000005C135F8, srv=0000000005C16F08, usr=0000000005C25860)

4 ETW000                                                                                                 235  0.339085

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

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

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

4 ETW000                                                                                                  73  0.343882

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

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

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

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

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

4 ETW000                                                                                                  94  0.344225

4 ETW000  [dev trc     ,00000]     DbSlConnect(con=-1) -> orc=0, 99=DBSL_ERR_DB                          220  0.344445

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

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

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

And also i checked users in Oracle:


OPS$SAP-EDU\SAPSERVICEET1         OPEN

OPS$SAP-EDU\ET1ADM                       OPEN

SYS                                                     OPEN

SYSTEM                                              OPEN

SAPSR3                                              OPEN

OUTLN                                                 LOCKED

TSMSYS                                              EXPIRED & LOCKED

DIP                                                      EXPIRED & LOCKED

ORACLE_OCM                                     EXPIRED & LOCKED

DBSNMP                                             EXPIRED & LOCKED

Thanks for any help


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jul 13, 2013 at 12:37 AM

    CIErrorGet -> SQL error code: 1017                                   152  0.344131

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

    Hi

    For ORA-01017: invalid username/password; logon denied#.                                            

    Check the note 400241 - Problems with ops$ or sapr3 connect to      

    Oracle.    

    Regards,

    Surojit

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 15, 2013 at 04:42 PM

    Hello Rishat,

    Check my note 1627312.

    Regards,

    Eduardo Rezende

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 19, 2013 at 09:44 AM

    Hello

    Thank you all for answering my questions. I solved the problem by changing Environment Variable dba_ora_schema from SAPET1 to SAPSR3. Also I reset password to initial position ("sap").

    But I have another problem.

    When I'm starting brbackup.exe the program writes error: ORA-01031: insufficient privileges.

    I granted all necessary roles to SAPSR3 and checked the note 400241, but it didn't solve the problem.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello

      What did you mean when you said about environment variables? Environment variables are the same for all local users.

      My list of environment variables:

      DBMS_TYPE                     ORA

      DBS_ORA_SCHEME         SAPSR3

      dbs_ora_tnsname               ET1

      JAVA_HOME                     C:\j2sdk1.4.2_22-x64

      ORACLE_HOME                C:\oracle\ET102

      ORACLE_SID                    ET1

      SAPDATA_HOME              C:\oracle\ET1

      SAPLOCALHOST               HOST

  • avatar image
    Former Member
    Jul 21, 2013 at 04:26 PM

    Hello Rishat Minikaev,

    Kindly grant <SID>adm access to all oracle folder and check.

    Thanks

    Ramesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2015 at 09:48 PM

    We had same issue while starting the listener and it has been resolved by doing the changes in tnsnames.ora and listener.ora files.


    check the hostnames in the file.


    Regards,

    Shaik Maideen

    Add comment
    10|10000 characters needed characters exceeded