Problem in brbackup

[ganesh_borase2]

Hello everybody,

when i execute the brbackup -p initHRQ.sap, then

it display the following error message

BR0051I BRBACKUP 7.00 (32)

BR0055I Start of database backup: bedmwbpd.afd 2010-06-22 09.21.25

BR0484I BRBACKUP log file: /oracle/HRQ/sapbackup/bedmwbpd.afd

BR0280I BRBACKUP time stamp: 2010-06-22 09.21.25

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

'CONNECT system/*******'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance HRQ failed

BR0280I BRBACKUP time stamp: 2010-06-22 09.21.25

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

'CONNECT system/*******'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance HRQ failed

BR0056I End of database backup: bedmwbpd.afd 2010-06-22 09.21.25

BR0280I BRBACKUP time stamp: 2010-06-22 09.21.25

BR0054I BRBACKUP terminated with errors

so please suggest me, How to solve the same

Thanks

[Former Member · Accepted solution]

Hi,

Is it the first time you are taking the backup after fresh installation or have you done any restore or copy. Kindy refer the below links for same problem with different solution and suggestions which might help to resolve the issue and also have a look in to Notes suggested above.

Regards,

Sharath

[ganesh_borase2 · Accepted solution]

Thanks for reply

but i want to know which user name and password is required.

I have execute the command by <SID>adm

brbackup -u /

is working

but following is not working

BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT system/*******'
ORA-01017: invalid username/password; logon denied 

Please suggest me

Thanks

[Former Member · Accepted solution]

Hi,

When you are able to take the backup through "brbackup -u /" then what is the need for giving system user name and password in the command. Let us know how is the backup being fired i.e. at OS level, or from DB13 or through any third party software on remote server.

Regards,

Sharath

[Former Member · Accepted solution]

Hi Ganesh,

First, Just check if OPS$ORAHRQ user is there in DBA_USERS table. If it is missing create it again.

Also grant the user connect, resource access for the database.

SQL> GRANT CONNECT, RESOURCE TO OPS$ORAHRQ;
SQL> COMMIT;

Second, also check if SAPSR3 user is in LOCKED status. If it is locked just unlock it...

SQL> SELECT USERNAME,STATUS FROM DBA_USERS;

To unlock SAPSR3 user:

SQL>ALTER USER SAPSR3 ACCOUNT UNLOCK;
SQL> COMMIT;

Finally You can change the password of SAPSR3 user using "brconnect".

Then check the backup again.

Hope, it will solve your problem.

Regards

Rajesh Narkhede

[Former Member]

Note 134592 - Importing the SAPDBA role (sapdba_role.sql)

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

Regards.