Error in Backup job scheduling in DB13

[Former Member]

Hi All

Backup job scheduled in DB13 kicks error ,I am using Oracle as database and ERP6.0

database and application are on diffrent servers.Before it was working fine,I didn't changed any password

I can run backupjob sucessfully directly from BRtools on database server.Please provide any hint

-

---

Job started

Step 001 started (program RSDBAJOB, variant &0000000000060, user )

No application server found on database host - rsh/gateway will be used

Execute logical command BRBACKUP On host DLcSapOraG08

Parameters:-u / -jid INLOG20090120204230 -c force -t online -m incr -p initerd.sap -w use_dbv -a -c force -p in

iterd.sap -cds -w use_rmv

BR0051I BRBACKUP 7.00 (31)

BR0128I Option 'use_dbv' ignored for 'incr'

BR0055I Start of database backup: bdztcorv.ind 2009-01-20 20.42.31

BR0484I BRBACKUP log file: D:\oracle\ERD\sapbackup\bdztcorv.ind

BR0280I BRBACKUP time stamp: 2009-01-20 20.42.32

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

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance ERD failed

BR0280I BRBACKUP time stamp: 2009-01-20 20.42.32

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

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance ERD failed

BR0056I End of database backup: bdztcorv.ind 2009-01-20 20.42.32

BR0280I BRBACKUP time stamp: 2009-01-20 20.42.32

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2009-01-20 20.42.32

BR0291I BRARCHIVE will be started with options '-U -jid INLOG20090120204230 -d disk -c force -p initerd.sap -cds -w use_rmv'

BR0002I BRARCHIVE 7.00 (31)

BR0181E Option '-cds' not supported for 'disk'

BR0280I BRARCHIVE time stamp: 2009-01-20 20.42.33

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

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310W Connect to database instance ERD failed

BR0007I End of offline redo log processing: adztcorw.log 2009-01-20 20.42.32

BR0280I BRARCHIVE time stamp: 2009-01-20 20.42.33

BR0005I BRARCHIVE terminated with errors

BR0280I BRBACKUP time stamp: 2009-01-20 20.42.33

BR0292I Execution of BRARCHIVE finished with return code 3

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished

[Former Member]

Problem was with OPS$ password, Fixed by going in BRtools

[fidel_vales]

Hi,

not sure if the recommendations given will address this issue.

You are getting this error:

BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied

the log file indicates:

> No application server found on database host - rsh/gateway will be used

This indicated that the user that is connecting from the AS to the DB server is not properly configured to perform the DB tasks on it.

So, first question would be to know if you have configured a gateway on the DB server and how, or if you are using remote shell.

Second question, you can do backups on the DB server.

> I can run backupjob sucessfully directly from BRtools on database server

How did you run exactly the backup job (what is the exact command line, what is the exact OS user that executed it)?

What is the OS of the DB server?

I have reread your post, your OS is windows therefore you fall in the "typical" error in Windows.

You have executed your backup as <sid>ADM and it works. Unfortunatelly, in windows, SAP is exectuted by SAPSERVICE<sid>, and this is the user who should be connecting to your DB server, and this is the user who cannot execute the backup.

The fact that you can run the backup with <sid>ADM in Windows does not means that you have SAPService<sid> properly configured.

For the error (see before) I think your ops$ user for this user is not properly configured in the DB server. take a look at the note mentioned by KT and pay attention to the SAPSERVICE<sid> configuration

Edited by: Fidel Vales on Jan 24, 2009 12:45 AM

[Former Member]

Hi Eric

I assigned the authorization.Then tried DB13 and it is still showing same messgage.

Thanks

Hardeep

[Former Member]

Hi

when I am running this commad under is the output

SQL> select * from dba_role_privs where grantee like 'OPS%';

GRANTEE GRANTED_ROLE ADM DEF

-

---

-

---

--- ---

OPS$AFSC\ERTADM SAPDBA NO YES

OPS$AFSC\SAPSERVICEERT SAPDBA NO YES

[former_member204746]

Deoraj told you what to do:

grant sapdba to ops$sidadm;

grant connect,resource to ops$sidadm with admin option;

so, in your case, it is:

grant sapdba to "OPS$AFSC\ERTADM";

grant connect,resource to "OPS$AFSC\ERTADM" with admin option;

grant sapdba to "OPS$AFSC\SAPSERVICEERT";

grant connect,resource to "OPS$AFSC\SAPSERVICEERT" with admin option;

[Former Member]

Hi Hardeep,

The problem lies with the OPS$SIDADM user. It doesn't has DBA priviledeges to trigger the DB backup.

You can check the same using the following query :

select * from dba_role_privs where grantee like u2018OPS%u2019;

Expected output :

GRANTEE GRANTED_ROLE ADM DEF

-

---

-

---

--- ---

OPS$SIDADM SAPDBA NO YES

OPS$SIDADM CONNECT YES YES

OPS$SIDADM RESOURCE YES YES

In order to fix this, you will have to grant the user OPS$SIDADM with SAPDBA role. You can use the SAPNOTE 361641to create the OPS$ user if its not present already (provided you are on UNIX environment).

You can grant the roles above by using the below query :

grant sapdba to ops$sidadm;

grant connect,resource to ops$sidadm with admin option;

After doing the above, please re-try running the backup from DB13.

Regards,

Deoraj Alok.

[Former Member]

Hi,

Check this users SAPSR3 or OPS$.

Refer SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Hope it helps

Regards

KT