Question Re: SQL error -1017 at location db_connect-2, SQL statement (ORA-01017: invalid username/password; logon denied) in Technology Q&A

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

Former Member — Tue, 05 Jan 2016 15:57:46 GMT

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,

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

Former Member — Tue, 05 Jan 2016 16:27:04 GMT

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.

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

Former Member — Tue, 05 Jan 2016 17:09:47 GMT

Hello Sunil,

... yes... I know... and I already tried the solution described in that SAP note in Scenario A.

As <sid>adm I ran the following command but it still show me the same error when I run/call the brconnect (oracle statistics statement)!

Any other tip?

Kind regards,

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

Former Member — Wed, 06 Jan 2016 08:15:21 GMT

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".

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

Former Member — Wed, 06 Jan 2016 11:22:26 GMT

Hello Manoj,

Thank you for the information... but I believe that is not the correction for the error that I reported here!

Can you tell me some tips regarding my issue?

Best regards,

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

hemanth2 — Wed, 06 Jan 2016 12:38:02 GMT

Dear João,

Hope you are doing good.
This is basically more of an Oracle issue than a SAP issue. There is a good list of checks that are mentioned here:

Oracle ORA-01017 tips

Please try them first and let us know the results.

Hope this helps.

_ _ _ _ _ _ _ _ _

Kind Regards,

Hemanth SAP Active Global Support

_ _ _ _ _ _ _ _ _

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

Former Member — Wed, 06 Jan 2016 16:17:38 GMT

try to change the password using below command.

brconnect -c -u / -f chpass -o SYSTEM -p <NEWPASSWD>

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

JamesZ — Wed, 13 Jan 2016 05:20:45 GMT

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

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

former_member215439 — Wed, 13 Jan 2016 09:01:04 GMT

Hi,

check your db schemas if match to your computer name

select username from dba_users;

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

Former Member — Sun, 17 Jan 2016 17:25:57 GMT

Hello James,

Solved!

The problem was related to the specific OPS$ users in the oracle database... when I ran that select statement (select username from dba_users;) it show me the old OPS$ users, among others, that belongs to the source system... the reason for this is because before of this oracle upgrade activity I performed a SAP system copy to this system and some OPS$ users belongs to that old host, OPS$SAPWINORA\SAPSERVICESWO and OPS$SAPWINORA\SWOADM.

To correct this issues, first I ran the script ORADBUSR.sql attached to sap note 50088 - Creating OPS$ users on Windows NT/Oracle

Then you need to make sure that the owner of SAPUSER table is the user OPS$<HOSTNAME>\<SID>ADM

SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

If the output of this previous select still contains the old OPS$ user you need to delete it with the following command:

DROP TABLE “OPS$<OLD HOSTNAME>\<OLD SID>ADM”.SAPUSER;

At the end you need to get connection with the command "conn /" as it described James Zhang

Thank you,

João Dimas

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

former_member215439 — Mon, 18 Jan 2016 08:43:58 GMT

Hi JD and James Zhang,

I have followed your account; can you follow me back so that i can send message you guys? I want to ask a lot of questions regarding SAP on Oracle.

- James Hizon

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

JamesZ — Tue, 19 Jan 2016 00:41:44 GMT

okay, it is my pleasure