Backup Fails when using BrTools

[Former Member]

Hi,

I'm using BrTools for taking backup of SAP System

It gives me the following error:

BR0051I BRBACKUP 6.40 (15)

BR0055I Start of database backup: <Bkp File name> < Time >

BR0280I BRBACKUP time stamp: < Time >

BR0301E SQL error -1017 at location BrDbConnect-2

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance <SID> failed

BR0280I BRBACKUP time stamp: < Time >

BR0301E SQL error -1017 at location BrDbConnect-2

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance <SID> failed

My OS is Win2003. Oracle is 9.2.0.6.0

SAP Basis release is 640 and pkg level is 14.

Please do suggest.

Thanks & Regards,

Bob.

[Former Member]

Give the password for userid : SYSTEM and its password. Then try the backup again.

With regards

Sudha

[andreas_herzog]

what does

> R3trans -d

say? any problems?

does the OPS$ mechanism function? check by trying

> sqlplus /nolog

> connect /

as user ora<sid> (unix) oder <sid>adm (windows)...if not, plz follow sapnotes 50088 and 400421...

GreetZ, AH

[Former Member]

Hi,

When I run

R3trans -d

it gives me the following output.

This is R3trans version 6.13 (release 640 - <TIME>).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = '<SID>'"

R3trans finished (0012).

And when I run

connect /

it gives me the following output:

SQL> connect /

ERROR:

ORA-01017: invalid username/password; logon denied

Thanks & Regards,

Bob.

[Former Member]

hello Bob,

The problem appears to be stemming from the fact that the OPS$ user (the windows user) is not able to coonect any more to the OPS$ schema at Oracle level. This user needs to retrieve the SAP<Schema ID> password from the table SAPUSER so that it can connect to the SAP schema.

Can you please check if 2 parameters in the Oracle initialisation are set to "true"

os_authent_prefix=ops$

remote_os_authent=true

Please check these parameters in the initSID.ora or spfile(if created).

These values help the OPS$ to be a trusted user in Oracle.

In the command "connect /"

"/" refers to the OPS$ user. Since this is returning "invalid user / password), i am asking you to check the above two parameters.

Regards,

Prashant

[Former Member]

Hi Prashant,

There is only one parameter in the init<SID>.ora file and also SPFile, from the two you mentioned, it is *.remote_os_authent=true

the other parameter

os_authent_prefix=ops$

is not present in my files.

Is this parameter also required?

Thanks & Regards,

Bob

[Former Member]

Hello Bob,

I suggest you look at the file init<DBSID>.ora as oppsoed to init.ora.

Because init.ora is a file created for Oracle installation (for standard installation).

When Oracle is installed for SAP, init<DBSID>.ora (where SID will be the system name) is created. Please check this file for the twp parameters.

By the way, Your OPS$ user represents the <SID>adm that you use to login at Windows level

Regards,

Prashant

[Former Member]

Hi Prashant,

I looked at the file init<DBSID>.ora, it also has the same parameter as init.ora.

the other parameter

os_authent_prefix=ops$

is not present in init<DBSID>.ora.

Thanks & Regards,

Bob.

[Former Member]

Bob,

Please add the second parameter to the init<DBSID> file. and generate the SPfile again from this.

Afetr that try logging in.

Regards,

Prashant

[Former Member]

Hi,

Do you run brtools as <sid>adm ?

If not - run it as this user.

regards,

Wojtek

[Former Member]

Hi,

I use BrTools with user <SID>adm.

Thanks,

Bob.