Monthly Backup Failed!

[Former Member]

Dear All,

We're running SAP on oracle 10.2.3 and have outsourced the backups.

this month the backup against the policy failed. while checking the logs I found the following:

BR0051I BRBACKUP 7.00 (36)

BR0055I Start of database backup: begftubc.anf 2011-07-02 10.45.32

BR0484I BRBACKUP log file: F:\oracle\P01\sapbackup\begftubc.anf

BR0280I BRBACKUP time stamp: 2011-07-02 10.45.35

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

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance P01 failed

BR0280I BRBACKUP time stamp: 2011-07-02 10.45.36

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

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance P01 failed

BR0056I End of database backup: begftubc.anf 2011-07-02 10.45.36

BR0280I BRBACKUP time stamp: 2011-07-02 10.45.36

BR0054I BRBACKUP terminated with errors

There has been no issues before this and I've not changed any user-id/passwords. Please help.

Regards.

Tejasav Kalra

[Former Member]

Dear Volker,

yes...it gave me those 3 users:

OPS$ACE\P01ADM

OPS$ACE\SAPSERVICEP01

OPS$ACE\SAPSERVICESR3

Dear Orkun,

we're running on MS Windows Server 2003 R2.

Regards,

Tejasav Kalra

[volker_borowski2]

Dear Volker,
> 
> yes...it gave me those 3 users:
> 
> OPS$ACE\P01ADM
> OPS$ACE\SAPSERVICEP01
> OPS$ACE\SAPSERVICESR3
> 
> Dear Orkun,
> we're running on MS Windows Server 2003 R2.
> 
> Regards,
> Tejasav Kalra

OK,

and which user executes the brbackup ?

ACE\P01ADM

or

ACE\SAPSERVICEP01

?

You can get this info from the logfile begftubc.anf

And what are the windows group memberships for this user?

Volker

Edited by: Volker Borowski on Jul 2, 2011 2:56 PM

[Former Member]

Dear Volker,
> 
> yes...it gave me those 3 users:
> 
> OPS$ACE\P01ADM
> OPS$ACE\SAPSERVICEP01
> OPS$ACE\SAPSERVICESR3
> 
> Dear Orkun,
> we're running on MS Windows Server 2003 R2.
> 
> Regards,
> Tejasav Kalra

Hi Tejasav,

It is ok, but I asked for is your system running on Microsoft Cluster Services(high availibility).

Best regards,

Orkun Gedik

[Former Member]

Hi Tajesav,

Is your ERP system running on MSCS services?

B est regards,

Orkun Gedik

[volker_borowski2]

Hello,

We're running SAP on oracle 10.2.3 and have outsourced the backups.

well, check the release, this one was never supported at all for SAP.

There has been no issues before this and I've not changed any user-id/passwords. Please help.

The OPS$ User does not authenticate with a password at all.

If you did not change anything, there are only a few things left that could have been changed.

First: check that the user still exists and is not locked: >> SELECT * FROM DBA_USERS

Second: check what OS-User is executing your backup command. It needs to fit the OPS$ User

Third: check the Windows group membership of this OS User. This defines, if it has DBA permissions.

Volker

BTW: And there are A LOT of older threads dealing with exactly this problem.

May be we should have a "Solve ORA-1017" thread made sticky in this forum?

[Former Member]

HI,

My bad...it is 10.0.2.4.0.

i've checked on these 3 levels as suggested by you. everything is ok.

what else can it be? can i help you with more logs?

FYI, we don't use BR* tools for backup...it is taken on DB and OS Level

and our OS is Windows NT.

Regards,

Tejasav Kalra

[volker_borowski2]

???? not using brtools ????

so what is that brbackup log from?

Ok,

so you are looged onto the DB Server as p01adm? (Local or Windows domain users?)

You open a cmd.exe

What message comes from

sqlplus /

Your above select did give you 2 OPS$ users?

One sidadm and one SAPServiceSID?

Those two had either hostname prefixes or domain prefixes matching the logged in session?

Volker