2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'Q01'" R3trans finished (0012).

[Former Member]

Hello,

I am unable to start SAP on a server. The DB an listener are up and running.

SAPQAS:q01adm 3% R3trans -d

This is R3trans version 6.19 (release 720 - 06.04.10 - 16:31:00 with UA1430.1 / prepared for CSN 1287305).

unicode enabled version

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

R3trans finished (0012).

SAPQAS:q01adm 4%

the output of the trans log file is as follows:

4 ETW000                                                                                                  83  0.656578

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

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

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

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

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

4 ETW000                                                                                                  64  0.656856

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

4 ETW000                                                                                                  38  0.656894

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

4 ETW000                                                                                                  39  0.656933

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

4 ETW000                                                                                                  41  0.656974

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      102a8aec0 102a93098 102acd6d8

4 ETW000                                                                                                  40  0.657014

4 ETW000  [dev trc     ,00000]  Assigning username to user session: con=0, usrhp= 102b24c60               30  0.657044

4 ETW000  [dev trc     ,00000]  Assigning password to user session: con=0, usrhp=102b24c60                33  0.657077

4 ETW000  [dev trc     ,00000]  Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=102a92fc8, srv=102ad0d98, usr=102b24c60)

4 ETW000                                                                                                3101  0.660178

4 ETW000  [dev trc     ,00000]  Wed May 28 09:14:23 2014                                             10004448  10.664626

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

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

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

4 ETW000                                                                                                  55  10.664847

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

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

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

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

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

4 ETW000                                                                                                  38  10.665072

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

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

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

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

Please help

[janos_mucsi-besze]

Hi,

I suggest to delete all SAPUSER tables and recreate it via ORADBUSR.SQL attached as oradbusr10.ZIP to note below:

50088 - Creating OPS$ users on Windows NT/Oracle

Afterwards if you have to change the sap<sid> or sapsr3 users password use below command as it changes the password not only in SAPUSER table but on database level aslo!

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

Regards,
János

[Former Member]

Hi,

SAP is now started. No record was found on table ops$<SID>AMD.sapuser

I had to do the following:

SQL> select * from ops$P01ADM.sapuser;

USERID/PASSWD

SAPSR3-CRYPT / V01/0048ZctvSB67Wv1+HkGaolZv2HY3g1GYnp3qT3k=

SQL>  select * from ops$Q01ADM.sapuser;

no rows selected

SQL> insert into OPS$Q01ADM.sapuser values('SAPSR3','sap');

1 row created.

SQL> ALTER USER SAPSR3 IDENTIFIED BY sap;

User altered.

-- rerun script oradbusr.sql and sapdba_role.sql

-- start sap

Thanks to all.

Vikash.

[Former Member]

Hi,

Sounds good that your issue is resolved.

But why you have 3 different SID users in one datatabase? Is it a copied database?

If yes, why you are maintaining all these invalid entries? You can delete other 2 SID related entries/users from SAPUSER which avoids the conflict in future.

Delete 2nd SAPUSER table too (which is invalid).

Regards,

Nick Loy

[former_member182657]

Hi,

Please follow SCN links ORA-01017: invalid username/password; logon denied | SCN

and

Regards,

Gaurav

[Former Member]

before starting SAP, i ran  had executed the following sql script:

SAPQAS:oraq01 11% sqlplus /NOLOG @sapdba_role.sql sapp01;

Within the sapdba_role.sql script I ran the following sql below:

SQL> select username from sys.dba_users where username like 'OPS$%';

USERNAME

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

OPS$SAP_Q01ADM

OPS$SAPSERVICESAP_D01

OPS$SAPSERVICEP01

OPS$P01ADM

OPS$ORAQ01

OPS$SAPSERVICESAP_Q01

OPS$SAP_D01ADM

OPS$ORAP01

8 rows selected.

SQL>

There should have been users OPS$ORAQ01, OPS$Q01ADM, etc.. instead of P01.

How can i modify them?

[Former Member]

Hi,

Did you check SAP notes 400241 and 50088?

Regards,

Nick Loy