BRTOOLS & Backup

[Former Member]

Hi Experts,

I install Oracle 10g on Windows 2003 , I'm going to run BRTools to make an offline backup,I go through these steps:

1 = Database backup

5 - Database user/password (user) .... [/]

c..c.. and start then I get this error

BR0051I BRBACKUP 7.00 (32)

BR0055I Start of database backup: bdzanfnk.afd 2008-10-14 15.52.24

BR0484I BRBACKUP log file: P:\oracle\PIQ\sapbackup\bdzanfnk.afd

BR0280I BRBACKUP time stamp: 2008-10-14 15.52.25

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

'CONNECT nwpiq/********'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance PIQ failed

BR0280I BRBACKUP time stamp: 2008-10-14 15.52.26

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

'CONNECT nwpiq/********'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance PIQ failed

BR0056I End of database backup: bdzanfnk.afd 2008-10-14 15.52.25

BR0280I BRBACKUP time stamp: 2008-10-14 15.52.26

BR0054I BRBACKUP terminated with errors

But I try to connect with the same userid and password to sqlplus and it connceted successfully,

I try "sys" and "system" users as well, but I've got the same error

Do you have any idea what should I do?

Thanks,

[debasissahoo · Accepted solution]

Hi Maryam,

Similar kind of error in another thread,

Check also the notes, 480266 & 620540

you can run this query to see if any user is locked or not..

SQL> select username, account_status from dba_users;

If you leave the user field, then Brtool's default user SYSTEM would be used. but not sure why your log shows a different user!

Regards,

Debasis

Edited by: Debasis Sahoo on Oct 15, 2008 3:32 AM

[lbreddemann]

Just to clarify...

this

> 5 - Database user/password (user) .... [/]

won't lead to this:

> 'CONNECT nwpiq/********'

so it looks like you made up this "logfile"... not very helpful.

What's necessary is that you put the OS-user you are using to run the brtools into the OS-Groups ORA_OPER and ORA_DBA.

BRBACKUP really tries to perform a "connect <user>/<password> AS SYSOPER" here.

I did not look them up, but probably the notes mentioned by AC will help you.

In any case: reading the documentation before using the tools and looking up notes with the error message will help a lot here.

> I try "sys" and "system" users as well, but I've got the same error

Of course you get the same error - because it's just not about the database user you use here, but about the SYSOPER privilege.

regards,

Lars

[Former Member]

Hi,

Please take a look at this notes:

400241

717677

good luck