ORA-01017: invalid username/password; logon denied

[former_member362299]

Hi ,

Server is down and getting this error "ORA-01017: invalid username/password; logon denied"
in R3trans.log, I found this note 400241, but not clear about the solution given. also I found that when i execute this "SELECT username,account_status FROM dba_users;" SAPSR3 user is missing. kindly help me to fix it.

regards

Manjappa

[Asha_Pillai]

Hello,

Can you please refer to the note

1602004 - J2EE System fails with "exitcode = 66"

Regards,

Asha

[Former Member]

Hi Manjappa,

Login into your Operating system with your SIDADM/Password and then execute "sqlplus / as sysdba". it works.

[Reagan]

If you have a J2EE stack then the schema name should be SAPSR3DB.

Do NOT change the password as suggested above using BRTools. The Java schema password is stored in the securestore as well. You should check if the database is up and running.

SQL> connect /as sysdba

SQL> select status from v$instance;

If the database is up and running then check if the configtool works.

R3trans cannot be used for connectivity check for Java only stacks.

Check if the schema user SAPSR3DB is locked.

If the Java fails to start then supply the logs.

[Brindavan_M]

HI,

check the user account has been locked or expired.   if you want change the password then try the below option and the check.

#brconnect -u / -f chpass -o SAPSR3 (Database Username) -p sap (New Password)

Thanks,

Brindavan

[Former Member]

Hallo Manjappa

want command are you running when you get the error? Just R3trans -x??

Which user are you using to run the command?

Is this a Java or an ABAP stack?

Regards

Thomas

[former_member362299]

Hi Dierkes,

I used R3trans -d.  user is SIDadm.  It is java stack. Now i am not able use sqldba "/as sysdba"; also check DB status. don't Know what went wrong.

regards

Manjappa

[former_member185239]

Hi Manjappa,

In java stack , you will always get a error.

R3trans -d does not work in java stack.

open the configtool and check the connectivity with the database.

With Regards

Ashutosh Chaturvedi

[Former Member]

Hallo,

as indicated by Ashutosh R3trans doesn't have to work for JAVA stacks. DB connection is done via JDBC.

Refer to note 867176 which also has a testing tool attached.

Is the listener running (tnsping <SID>?

Which Oracle version?

Are you able to connect (sqlplus) to the database as user ora<sid>?

Regards

Thomas

[former_member362299]

Hi Dierkes,

Tq, Listerner is running and able to connect sqlplus. But when i test for db status i am getting below error.

Connected.

SQL> select status from v$instance;

select status from v$instance

*

ERROR at line 1:

ORA-01012: not logged on

Process ID: 0

Session ID: 0 Serial number: 0

SQL>

regards

Manjappa

[former_member185239]

Hi Manjappa,

Can you paste the trans.log file.

With Regards

Ashutosh Chaturvedi

[former_member362299]

Now i am getting below log

31> more trans.log

4 ETW000 R3trans version 6.23 (release 720 - 15.05.12 - 20:12:03).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 03.03.2016 - 00:28:51

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]  Thu Mar  3 00:28:51 2016                                                 123  0.000123

4 ETW000  [     dev trc,00000]  db_con_init called                                                        28  0.000151

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0)

4 ETW000                                                                                                  38  0.000189

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

4 ETW000                                                                                                  28  0.000217

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

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/P73/SYS/exe/run/dboraslib.so' ...            89  0.000319

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

4 ETW000                                                                                               10778  0.011097

4 ETW000  [     dev trc,00000]  Library '/usr/sap/P73/SYS/exe/run/dboraslib.so' loaded                    29  0.011126

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

4 ETW000                                                                                                  29  0.011155

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

4 ETW000                                                                                                  72  0.011227

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

4 ETW000                                                                                                  23  0.011250

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

4 ETW000                                                                                                  51  0.011301

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

4 ETW000                                                                                                  26  0.011327

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

4 ETW000                                                                                                  22  0.011349

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

4 ETW000                                                                                                  22  0.011371

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

4 ETW000                                                                                                  21  0.011392

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  18  0.011410

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

o = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000                                                                                                  31  0.011441

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

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

4 ETW000                                                                                                  30  0.011512

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          13  0.011525

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                                                                                                  28  0.011553

4 ETW000  [     dev trc,00000]  -->DbSlConnect(vers=-1, type=0, env='[default env]', userid='[default usr]')

4 ETW000                                                                                                  84  0.011637

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

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

4 ETW000                                                                                                 200  0.012088

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

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

4 ETW000                                                                                                  23  0.012157

4 ETW000  [     dev trc,00000]  # Patch Description: Created on  3 Jan 2012, 02:50:27 hrs PST8PDT         29  0.012186

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

4 ETW000  [     dev trc,00000]    Default connection: tnsname ='P73'                                      22  0.012245

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

4 ETW000                                                                                                  41  0.012286

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

4 ETW000                                                                                                4609  0.016895

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=4c290d8)                  47  0.016942

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=4c2a368)                  25  0.016967

4 ETW000  [     dev trc,00000]  NLS env. settings: lang=41004D00450052004900430041004E00                  93  0.017060

4 ETW000  [     dev trc,00000]                     terr=41004D0045005200490043004100                      42  0.017102

4 ETW000  [     dev trc,00000]                     char=55005400460031003600                              28  0.017130

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

4 ETW000                                                                                                  33  0.017163

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

4 ETW000  [     dev trc,00000]  Logon as OPS$-user to get SAPR3's password                                25  0.017207

4 ETW000  [     dev trc,00000]  Connecting as /@P73 on connection 0 (nls 0) ... (dbsl 720 220612, UNICODE[2])

4 ETW000                                                                                                  29  0.017236

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=4c2a288)                 28  0.017264

4 ETW000  [     dev trc,00000]  Allocating server context handle                                          21  0.017285

4 ETW000  [     dev trc,00000]  Attaching to database server P73 (con=0, svchp=4c2a288, srvhp=4c2d750)

4 ETW000                                                                                                  55  0.017340

4 ETW000  [     dev trc,00000]  Thu Mar  3 00:29:01 2016                                             10189150  10.206490

4 ETW000  [     dev trc,00000]     OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR                  25  10.206515

4 ETW000  [     dev trc,00000]     OCIServerAttach(OCI_DEFAULT) failed with SQL error 12537:             129  10.206644

4 ETW000  [     dev trc,00000]     ORA-12537: TNS:connection closed

4 ETW000                                                                                                  31  10.206675

4 ETW000  [    dbsloci.,00000]  *** ERROR => CONNECT failed with sql error '12537'                        29  10.206704

4 ETW000  [     dev trc,00000]     set_ocica() -> SQL error code 12537                                    22  10.206726

4 ETW000  [     dev trc,00000]  -->oci_get_errmsg (con=0, rc=12537)                                       17  10.206743

4 ETW000  [     dev trc,00000]     OCIErrorGet -> SQL error code: 12537                                  117  10.206860

4 ETW000  [     dev trc,00000]     ORA-12537: TNS:connection closed

4 ETW000                                                                                                  26  10.206886

4 ETW000  [     dev trc,00000]  SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=12537.                19  10.206905

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

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

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>ORA-12537: TNS:connection closed                              18  10.206983

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