BR*tools Error ORA-01017

[Former Member]

Dear Expert,

I had performed the Homogeneous system copy of my server.

My system configuration is

OS:- Solaris

Database :- Oracle 10.2.0.2

SAP:- ECC 6.0 SR1

Aster creating the OPS$<SID>adm user my system is up & running. Now I am facing the problem while running BR*tools for taking backups. It gives following error

BR0002I BRARCHIVE 7.00 (11)

BR0006I Start of offline redo log processing: adyjovvf.svd 2008-07-17 11.22.27

BR0280I BRARCHIVE time stamp: 2008-07-17 11.22.27

BR0301W SQL error -1017 at location BrDbConnect-2

ORA-01017: invalid username/password; logon denied

BR0310W Connect to database instance UBQ failed

BR0280I BRARCHIVE time stamp: 2008-07-17 11.22.27

BR0301W SQL error -1017 at location BrDbConnect-2

ORA-01017: invalid username/password; logon denied

BR0310W Connect to database instance UBQ failed

BR0545W Database reset logs ID not found

BR0013W No offline redo log files found for processing

BR0280I BRARCHIVE time stamp: 2008-07-17 11.22.28

BR0301W SQL error -1017 at location BrDbConnect-2

ORA-01017: invalid username/password; logon denied

BR0310W Connect to database instance UBQ failed

What I understand from error is one of the OPS$ user id is not available in the databse, So I refer SAP Note 400241 but it is not specific to Solaris. In my database following are users

CLUADMIN

OPS$SAPSERVICE<OLD SID>

OPS$ORA<OLD SID>

OPS$<NEW SID>DM

SYS

SYSTEM

SAPSR3

OUTLN

TSMSYS

DIP

DBSNMP

Please suggest me any SAP note to resolve this problem.

Thanks,

Sachin

[Former Member]

Hi,

sapconn_role.sql only affects the SAP database user, not the OPS$ users. However, if you executed the script (which you lust have if it's Oracle 10.2), then the following commands are better than the ones I gave you in my previous reply:

create user OPS$ORA<SID> identified externally;
grant sapconn, unlimited tablespace to OPS$ORA<SID>

Rgds,

Mark

[Former Member]

Hi Sachin,

I don't see the user OPS$ORA<SID> in the list of users that you sent. Can you try the following:

- in SQLPLUS

create user OPS$ORA<SID> identified externally;
grant sapdba,connect,resource to OPS$ORA<SID>;

- then try again

Rgds,

Mark

[Former Member]

Hi,

Can you specify how you run BRBACKUP: out of the DB13 scheduler or directly in UNIX (command line or crontab). If you run the command from UNIX, as which user do you run the command (orasid or sidadm)? And with which command-line parameters (notably the "-u")?

Mark M

[Former Member]

Hi Mark,

I run BRBACKUP through BR*tools menu by login as ORA<SID> user.

Thanks,

Sachin

[JPReyes]

This problem will be sorted after running sapconn_role.sql that will update all necesary right for the OPS$ users and BRTOOLS should work again.

Regards

Juan

[Former Member]

Hi Juan,

Should I have to create the users OPS$SAPService<NEW_SID> & OPS$ORA<NEW_SID> ?

Thanks & Regards,

Sachin

[JPReyes]

Yes, follow SAP note 400241 and 361641

[Former Member]

The note you mentioned says that you may refer to SAP note 361641, and create new OPS$ users.

(As you probably know, Solaris is one of the many flavours of Unix.)

hope this helps