brbackup with backint integration error username password

[Former Member]

Hello

I had integraton via Uti file for brtools backup on Data Protector. After every copy of system we have to run:
"ln -s /opt/omni/lbin/backint /usr/sap/<SID>/SYS/exe/run/backint " with root user. But even doing so backup finishes with error message(on DP gui):

"Normal] From: BSM@tlsgdns02.sap.ingrid.si
"CR2-ONL"  Time: 8/25/2013
4:43:08 PM

      Backup
session 2013/08/25-411 started.

[Normal] From: BSM@tlsgdns02.sap.ingrid.si
"CR2-ONL"  Time: 8/25/2013
4:43:10 PM

      OB2BAR
application on "crion2.sap.ingrid.si" successfully started.

BR0051I BRBACKUP 7.00 (32)

BR0055I Start of database backup:
belygpuj.anf 2013-08-25 16.43.09

BR0484I BRBACKUP log file: /oracle/CR2/sapbackup/belygpuj.anf

BR0280I BRBACKUP time stamp: 2013-08-25
16.43.09

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

'CONNECT /'

ORA-01017: invalid username/password; logon
denied

BR0310E Connect to database instance CR2
failed"

How to solve such an issue

Thank you in advance

Jan

[Former Member]

HI Jan,

production instance password was expired. Now you may have to re-enter password
in Standby DB in data protector integration as integration is failing with error:

ORA-01017 : Inavalid user name/password

 
  FOr checking the password validty in Oracle

  SQL> select username,ACCOUNT_STATUS,LOCK_DATE from dba_users;

ALTER USER SYSTEM IDENTIFIED BY <password>;

and then you need to update the password in Data prrotector.

[former_member188883]

Hi Jan,

Can you check the result using brtools.

brbackup -m full

Whether you can trigger a backup using this command.

Regards,

Deepak Kori

[Former Member]

Hi,

Please login in data protector and see that the user id and password provided for the database user is correct. Most of the time this is the error.

If you are using SAPSR3 user for sap databse. Please login with that and see if you can login.

If some other database user please cehck it has all the permission.

grant select_catalog_role to <user>;

grant create session to <user>;

grant alter session to <user>;

grant all  on <sap schema>.SDBAH to <user>;

grant all  on <sap schema>.SDBAD to <user>;

grant all  on <sap schema>.DBCHECKORA to <user>;

grant all  on <sap schema>.DBMSGORA to <user>;

But the error clearly states that the data protector has not got the correct user id and password.

Screenshot of dataprotector where you specify the password for sap system.

Do you have any special character in the database password?

One note

1576837 - ORA-01017: invalid username/password;

Thanks

Rishi Abrol