Error while performing Oracle back up using Brtools

[Former Member]

Dear Team,

While performing a Oracle back up using BRtools, There is an error message.

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

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

ORA-01017: invalid username/password; logon denied

BR0303E Determination of Oracle version failed

Version: Oracle 11G

SAP: NW 7.0

Thanks and regards,

Rathish.S

[former_member182034 · Accepted solution]

hi Rathish,

Please have a look at below SAP NOTEs it might be helpful

1576837 - ORA-01017: invalid username/password

400241 - Problems with ops$ or sapr3 connect to Oracle

Regards,

[Former Member]

check the permission and the database connectivity . mention system/manager (DB user ) password in the default password in BR tools . check the oracle DB user is locked . and SARSR3 password as well .

[Former Member]

Thanks to all,

Since it's PRD system we contacted SAP followed the solution to fix. It's connection error.

Regards,

Rathish

[Former Member]

If you can update us all about what solution/fix you followed then it would help everybody else who might face the similar problem in future.

Thanks

Dev

[Former Member]

Hi,

Reset the password of system user (db user) and maintained the same the in the password instead of default password in the brtools .

[Former Member]

Hi Rathish

Let us know if there was any changes in your DB recently like System Refresh etc.

Looks like the issue is with your user ID passwords while connecting to the DB.

Please see the following note :

Note 480266 - Problems with the SYSDBA/SYSOPER/INTERNAL connect

Please ensure that  you sync the passwords using the brtools utility.

Thanks

Rishi

[Former Member]

Thanks Rishi,

Recently we did a Oracle upgrade,

Can you please elaborate how to SYN the password

Thanks,

Rathish.

[former_member188883]

Hi Rathish,

As you recently performed an oracle upgrade request you to perform the following

1) Check the account status of users

   SQL> select username, account_status from dba_users;

2) Unlock the Schema user ( if it is locked)

    SQL> alter user username account unlock;

3) Change the password of users for which account is expired using

  SQL> alter user username identified by new_password;

4) Check the results of R3trans -d  and brconnect commands . It should work fine.

Hope this helps.

Regards,

Deepak Kori