on 01-05-2016 3:57 PM
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
Hi,
check your db schemas if match to your computer name
select username from dba_users;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
Please try them first and let us know the results.
Hope this helps.
_ _ _ _ _ _ _ _ _
Kind Regards,
Hemanth SAP Active Global Support
_ _ _ _ _ _ _ _ _
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.