Skip to Content

SQL error -1017 at location db_connect-2, SQL statement (ORA-01017: invalid username/password; logon denied)

Hello,

I´m facing one problem during the post-upgrade activities after an oracle database. I did an oracle database from 11.2.0.4 to 12.1.0.2 version (in Windows Server 2012 R2). I´m following the oracle database upgrade 12.1c guide from SAP (windows) and now I´m doing the "5 Post-Upgrade Steps" chapter.

When I try to run the following commands (Oracle database statistics) it show me an error!

brconnect -u / -c -f stats -t system_stats

brconnect -u / -c -f stats -t oradict_stats

brconnect -u / -c -f stats -t all -f collect -p 4

BR0801I BRCONNECT 7.20 (42)

BR0805I Start of BRCONNECT processing: cesflcrw.sta 2016-01-05 15.31.44

BR0484I BRCONNECT log file: C:\oracle\SWO\sapcheck\cesflcrw.sta

BR0280I BRCONNECT time stamp: 2016-01-05 15.31.46

BR0301E SQL error -1017 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance SWO failed

BR0280I BRCONNECT time stamp: 2016-01-05 15.31.48

BR0301E SQL error -1017 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance SWO failed

BR0806I End of BRCONNECT processing: cesflcrw.sta 2016-01-05 15.31.46

BR0280I BRCONNECT time stamp: 2016-01-05 15.31.48

BR0804I BRCONNECT terminated with errors

I searched for a solution and I read the sap note 1576837 - ORA-01017: invalid username/password; but unfortunately I can´t find a solution for this error!

I´m running the latest version of BR*Tools 7.21 (patch 600)... the SAP Kernel is the 7.21 EXT UC (X64) version (patch level 619).

I already updated the Oracle Instant Client (998004 - Update the Oracle Instant Client on Windows)... I´m running the OIC 12.1.0.2, the latest version of Oracle Instant Client.

I ran the following query with the goal to understand if some core oracle users are locked or not... but it seems to me ok, the main oracle users (SYS; SYSTEM; OPS$ users; SAPSR3):

select username, account_status from dba_users;

Can you help me please to understand how can I correct this...!?

Best regards,

JD

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 13, 2016 at 09:01 AM

    Hi,

         check your db schemas if match to your computer name

         select username from dba_users;

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2016 at 08:15 AM

    Refer 12c upgrade central note 1914631, also u can check it out by configuring SSFS as per note 1622837 also changing the Schema owner password using "brtools".

    Add comment
    10|10000 characters needed characters exceeded

    • Hi JD,

      You can simply reproduce this issue by execute below command with the user you ran brtools.

      sqlplus /nolog

      conn /

      We should make sure the os authorization works for the os user, as mentioned, this is a pure oracle database configuration issue, not brtools problem.

      Are you able to reproduce the error by following my steps?

      Best regards,
      James

  • avatar image
    Former Member
    Jan 05, 2016 at 04:27 PM

    The note you have mentioned has the scenarios for the ORA-01017. Please read through the note and you may need to change the password. the command to change the password also in the note.

    Add comment
    10|10000 characters needed characters exceeded