No jobs in DB13 can't run after upgrade oracle up to 12

[Former Member]

Hello to all! After upgrading an Oracle on Solution Manager from 11 to 12 and enabling oracle secure store (ssfs)

I can't do any jobs in DB13 and from brtools:

SolMan is trying to connect with login SAPSR3DB instead of SAPSR3. What should I do ? Thanks!

rsecssfx list:

rsecssfx get DB_CONNECT/DEFAULT_DB_USER

Record Key   : DB_CONNECT/DEFAULT_DB_USER

Record Value : SAPSR3

rsecssfx get BR_TOOLS/DEFAULT_DB_USER

Record Key   : BR_TOOLS/DEFAULT_DB_USER

Record Value : BRT$ADM

Also I can't connect to sqlplus without "as sysdba" permitions:

SQL> connect SAPSR3

Enter password:

ERROR:

ORA-01017: invalid username/password; logon denied

SQL> connect SAPSR3DB

Enter password:

ERROR:

ORA-01017: invalid username/password; logon denied

SQL> connect SAPSR3 as sysdba

Enter password:

Connected.

SQL> connect SAPSR3DB as sysdba

Enter password:

Connected.

Backup from brtools:

BR0051I BRBACKUP 7.20 (42)

BR0055I Start of database backup: beqzqpyo.afd 2015-07-21 15.25.14

BR0484I BRBACKUP log file: /oracle/SM1/sapbackup/beqzqpyo.afd

BR0280I BRBACKUP time stamp: 2015-07-21 15.25.15

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

'CONNECT SAPSR3DB/********'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance SM1 failed

BR0280I BRBACKUP time stamp: 2015-07-21 15.25.17

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

'CONNECT SAPSR3DB/********'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance SM1 failed

BR0056I End of database backup: beqzqpyo.afd 2015-07-21 15.25.16

BR0280I BRBACKUP time stamp: 2015-07-21 15.25.17

BR0054I BRBACKUP terminated with errors

[former_member230159 · Accepted solution]

Hi Igor,

Please check note :

#1576837 - ORA-01017: invalid username/password;

#400241 - Problems with ops$ or sapr3 connect to Oracle

Let me know if the issue still persists.

Regards,

[Former Member · Accepted solution]

Hi Igor,

Just do a quick check for the schema mentioned in enviorment it should be SAPSR3.

As after upgrade to 12C, SAP only uses SSFS no more OPS$ mechanism.

Also do confirm the password set in your SSFS it should be for SAPSR3 only.

Just in case if the user is locked out you may need to unlock and put the password back again.

Also do check the below parameter is mentioend in your profiles:-

Profile parameter : rsdb/ssfs_connect = 1

And your able to perform the below command with your new password:-

brconnect -u / -c -f chpass -o BRT$ADM -p <password> -s brtools

Also you can do below command to force the new password for the SAPSR3 user

Setting up SSFS storage

1. sidadm

rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPSR3 -plain

rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD *****

After which you can get the R3trans working and brconnect check working.

Let us know the update once you perform this.

Also do refer below thread for any further reference.

Regards,

Ram

[Former Member]

Hello Igor,

Please check following sap discussion

Error: ORA-01017: invalid username/password whe... | SCN

Regards

Anand