RMAN backup reporting not working after Oracle 12c Upgrade

[Former Member]

Hi All,

We have recently upgraded our Netweaver 7.4 system to Oracle 12c version.

We are still using SAP classic approach for Oracle database user and softwares,datfiles are owned by orasid.

Since after the upgrade our RMAN backup reporting is not working, Our backup reporting tool use "oracle" OS user to connect to database and provide us backup status but since after the upgrade this user is facing issue while connecting to database.

This tool uses (sqlplus / ) command to connect to database  -

>sqlplus /

SQL*Plus: Release 12.1.0.2.0 Production on Thu Feb 25 11:12:05 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ERROR:

ORA-01017: invalid username/password; logon denied

(sqlplus / as sysdba) is working with oracle user and it is able to connect but (sqlplus / ) is not working.

With sidadm and orasid, (sqlplus / ) is working.

We have OPS$ORACLE user also existing at database level and tried with setting SSFS environment variables with Oracle user but still same issue.

I know Oracle has introduced "oracle" OS user also with 12c for SAP installation, Not sure if somehow that concept is creating issue with our already existing oracle os user which we use only for RMAN backup reporting.

Please suggest what could be reason of this issue,

Regards,

Shivam

[JamesZ]

Hi Shivam,

Please check the permission for ops$oracle user:

select privilege from dba_sys_privs where grantee='OPS$ORACLE';

Best regards,
James