BR0301E SQL error -1017 at location BrDbConnect-2

[Former Member]

Hi,

When we run brbackup as user brtadm and orabrt we get the error:

BR0051I BRBACKUP 7.00 (11)

BR0055I Start of database backup: bdujhhla.qub 2007-01-12 17.28.02

BR0280I BRBACKUP time stamp: 2007-01-12 17.28.02

BR0301E SQL error -1017 at location BrDbConnect-2

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance BRT failed

BR0280I BRBACKUP time stamp: 2007-01-12 17.28.03

BR0301E SQL error -1017 at location BrDbConnect-2

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance BRT failed

We try to create ops$orabrt user according to oss note 776505. But we get the error message:

create user ops$orabrt identified externally temporary tablespace psaptemp;

ERROR at line 1:

ORA-01920: user name 'OPS$ORABRT' conflicts with another user or role name

How can we solve this problem?

Best Regards...

[former_member185954]

Hi,

You are getting the error: ORA-01920: user name 'OPS$ORABRT' conflicts with another user or role name

because you already have that user, to check if the OPS$ user is present run this query:

SELECT * from dba_users;

you should be able to find the OPS$ user, its also possible that due to some configuration issue while installing oracle, the OPS$ user doesn't have the 'Externally' attribute to it.

You can grant the required attributes using 'ALTER USER'

Note 620540 - Authentication Troubleshooting Guide

The above mentioned SAP Note clearly describes the issue you are facing.

Regards,

Siddhesh

[Former Member]

Hi,

Given, that the ops$ user already exists -- why would you get that ORA-1017 error?

Can you post the command you run? Is it brbackup -u / ?

What does the following command run as the ora<SID> user show?

sqlplus /

[former_member185954]

Hi Somchit,

Check the troubleshooting note I have provided, it answers your question about OPS$, also the link that i have provided for brrestore, that page also has command line examples for brbackup.

Regards,

Siddhesh