ORA-01017 with RMAN

[Former Member]

Hi, I've been dealing with this error since the oracle backups from tx DB13 have been scheduled with the option to verify with RMAN or DBVERIFY:

I've already followed the instructions in SAP Note 776505 - ORA-01017/ORA-01031 in BR*Tools on Linux and Solaris 11 but with the same outcome.  Could it be some missing authorisations with the OPS$ORA<SID> user??

Any help would be greatly appreciated.

Thanks & Regards,

Jesus Rodriguez

[Former Member · Accepted solution]

Please check the following note once:

1576837 - ORA-01017: invalid username/password

[former_member182657]

Hi Jesus,

Could you share result for command

sqlplus /nolog
connect username/password@service as sysdba

Also share on which device you're taking the backup with parameter values for

REMOTE_LOGIN_PASSWORD & REMOTE_OS_AUTHENT

Regards,

[Former Member]

Hello Jesus,

Please check SAP note :-717677 - BRCONNECT call of SAPInst fails with ORA-01017

regards

anand

[Former Member]

Hi Jesus,

check your OPS$<SID>adm has connect resouce,dba & sapdba permission on the database.

select privilege from dba_sys_privs  where grantee='SAMPLE'  order by 1;

SELECT username, privilege FROM USER_SYS_PRIVS;

also do verify the permissions for the below folders too.

/oracle/<SID>/102_64/dbs/

/oracle/<SID>/102_64/sapcheck * /sapbackup

Also to check are you using orapwd file for the RMAN or a seperate user has been created for the backup configuration.

Let us know the details.

regards,

Ram

[Former Member]

Hi Ram,

I tried what you suggested but everything seems in order regarding the permissions.

Thanks & Regards,

Jesus Rodriguez

[Former Member]

Hi Jesus.

Which user your using for the DB Backups is it OPS$ORA<SID> or some special user you have created.

If a different user you need to give the read catlog permissions for same. Use below command for same.

SQL> grant SELECT_CATALOG_ROLE to username;

Let us know the details if its still failing.

regards,

Ram

[Former Member]

Hi Ram,

I would assume that the connection is made with the user OPS$ORA<SID> since the job is scheduled  directly from the tx DB13...

Thanks & Regards,

Jesus Rodriguez

[Former Member]

hi Jesus,

I can see the below from the error which you post earlier.

It is not able to connect and do a catlog read. So once check for the OPS$<SID>adm.

Also do check the permission of below file should be as below :-

chmod 6751 /oracle/ERS/112_64/bin/oracle

Also check permission for RMAN exe too.

Then do below :-

grant SELECT_CATALOG_ROLE to OPS$ERSADM;

grant SELECT_CATALOG_ROLE to OPS$ORAERS;

Just in case try to create SAPUSER.OPS$ORAERS table too.

And Let us know the latest error for the backup failure.

Regards,

Ram

[Former Member]

Hi Ram,

The backup ran yesterday with your recommendation of the roles but the outcome is the same:

Any other recommendation?

Thanks & Regards,

Jesus Rodriguez

[Former Member]

Hello,

By now you might have tried multiple solutions.

1. Have you checked ORADBUSER.sql

2.Run this command at sql prompt and check if any user is locked on expired

     select USERNAME,ACCOUNT_STATUS from dba_users;

3.you might have to cinsider changing pin assword for SAPSR3 dba_user , SAPUSR table

4.400241 - Problems with ops$ or sapr3 connect to Oracle.

5. Is your system copy of another system. check SAPService user is from source of the    system copy. if yes change it target system user.

Please check following links where multiple solutions for similar issue have been suggested.

http://scn.sap.com/thread/3598770

https://scn.sap.com/thread/1663344

Regards

Anand