ORA-01017 invalid username/password logon denied in hp data protector

[former_member209962]

Hello Friends,

While taking online backup from hp data protector we are getting below

error

CONNECT system/********* AT PROF_CONN IN SYSOPER MODE'

ORA-01017: invalid username/password; logon denied

BR0303E Determination of Oracle version failed

I Can take backup using brtools from sap no issue with that, and also i

can connect to database using user (system) with same password which is

mention in HP Data protector, but when i am trying to run backup from

hp data protect i am getting error ORA 01017.

I have checked note 400241 - Problems with ops$ or sapr3 connect to Oracle

And verified all the steps as mention and everything seems to be fine.

SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

OWNER

OPS$HOSTNAME\SIDADM

SQL> SELECT OWNER, TABLE_OWNER, TABLE_NAME FROM DBA_SYNONYMS WHERE SYNONYM_NAME

= 'SAPUSER';

OWNER                          TABLE_OWNER

------------------------------ ------------------------------

TABLE_NAME

------------------------------

OPS$HOSTNAME\SAPSERVICESID    OPS$HOSTNAME\SIDADM

SAPUSER

Also updated the password with below command

brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

but I did not perform

Alternatively, change the password in the table SAPUSER:

DELETE FROM "OPS$<sid>ADM".SAPUSER;
INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');

Also in sqlnet.ora we have this enrty SQLNET.AUTHENTICATION_SERVICES = (NTS)

But in initsid.ora we do not have the parameter os_authent_prefix = ops$ do I need to maintain this?

OS: Win 2008

Db:oracle 11.2.0.4.0

From brtools I have no issues backup is running fine but in hp data protector I am getting this error ORA-01017: invalid username/password; logon denied

Kindly help to solve this issue.

Thanks

Tabrayz

[former_member209962 · Accepted solution]

Dear All,

Apologies for late reply issue is solved after running below commands.

Grant sysoper to system;

Grant sysdba to system:

Issue was with user system permissions, but HP dp was giving error as invalid user id and password which was misleading, actually it should give error as ORA 01031 but it was giving ORA-01017 which was wrong, luckily i tried giving permissions to user system and problem solved.

Thank you all for your support.

Thanks

Tabrayz

[former_member224542]

Is the DP server reaching the correct database service name? Maybe you can try tnsping <SID> from DP client server to verify that you are connecting to your target database. Also try creating a new database user for DP, then use this user instead of SYSTEM.

[former_member209962]

Hi Glenn,

From DP Client server tnsping command is not wokring, we also tried with user SAPSR3 in dp but same issue.

Thanks

Tabrayz

[former_member224542]

Hi Tabrayz,

Please check the service name in tnsnames.ora. I think the same service should exist in DP server in order for tnsping to work.

Also, can you elaborate how DP connects to the database? Should be something like sqlplus system/password@SID

Regards,

Glenn

[former_member209962]

Hi Glenn,

please find below screen shot of hp DP where we give user credentials

please find

[former_member224542]

Hi Tabrayz,

In your screenshot there is a field for services which you left blank. This is usually SID or SID.WORLD. You can verify the value from tnsnames.ora in the target database.

Regards,

Glenn

[Reagan]

There is no surprise here as you are updating the SAP schema user password but the backup is scheduled to run under the SYSTEM user.

You need to update the Oracle SYSTEM user password for the backup to run.

RB

[former_member209962]

Hi Reagan,

I have also tried changing password for system but same issue

alter user system identified by <newPW>;

then we tried

- brconnect -u system/<password> -f chpass -o sapsr3 -p
    <password>

We even restarted SAP after changing

But no luck.

Thanks

Tabrayz

[former_member207186]

Hi Tabrayz,

Regarding this issue/question, you can check the

   - Section "SYSTEM" in point 7 of  SAP Note 56286 - "FAQ: Logon mechanisms"

   - Section "HINT" in Scenario A of SAP KBA 1576837 - "ORA-01017: invalid username/password"

Regards,

Bíborka

[former_member209962]

Hi Biborka,

I have checked the note 1576837 and updated the password for user SYSTEM as per note

brconnect -u system/<password> -f chpass -o <sapowner> -p
    <password>

but hp dataprotecor is giving same issue i can successfully login with user system in database and also r3trans-d is 0000.

Thanks

Tabrayz

[former_member207186]

Hi Tabrayz,

Thank you for the update. Have you also checked the Section "SYSTEM" in point 7 of  SAP Note 56286 - "FAQ: Logon mechanisms" ?

Since you have changed the password of SYSTEM user, please check carefully

   - Section "SYSTEM" in point 7 of  SAP Note 56286 - "FAQ: Logon mechanisms"

   - Section "HINT" in Scenario A of SAP KBA 1576837 - "ORA-01017: invalid username/password"

Regards,

Bíborka