Please Help - DB13 All Jobs Are Failed

[Former Member]

Hello Gurus,

My Qurey Was

In T-Code DB-13, I created some Jobs example like checkdb, update stats, etc etc

while running this jobs giving me this error can anybody tell me what is the rectification or what is a needful to solve this problem

Job started

Step 001 started (program RSDBAJOB, variant &0000000000099, user ID CSCADMIN)

Execute logical command BRCONNECT On host bascop26

Parameters: -u / -jid CHECK20070608095728 -c -f check

BR0801I BRCONNECT 7.00 (11)

BR0477I Oracle pfile /oracle/QBW/102_64/dbs/initQBW.ora created from spfile /oracle/QBW/102_64/dbs/spfileQBW.ora

BR0280I BRCONNECT time stamp: 2007-06-08 09.57.33

BR0301E SQL error -942 at location BrLicCheck-32

ORA-00942: table or view does not exist

BR0806I End of BRCONNECT processing: cdvlajpr.log2007-06-08 09.57.33

BR0280I BRCONNECT time stamp: 2007-06-08 09.57.33

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

As Per SAP Note - Note 134592 - Importing the SAPDBA role ( sapdba_role.sql)

I have uncar the file - sapdba_role_ora9.SAR (9i is my database)

but in which way i am going to to execute this script in my database

Please help ASAP

[Former Member]

Thanks

[Former Member]

My Operating System is Windows - 2003 Server

So Please guide me the steps

[markus_doehr2]

All steps are there - what are you missing?

- open a cmd.exe

- cd to the directory where you stored the sql file

- execute as given in the note

--

Markus

[Former Member]

Hi,

log on to unix as ora<sid> user

sqlplus "/as sysdba"

Execute the script

@<path>/<filename>.sql

ex: @/tmp/<filename.sql>

Regards

Ben

[markus_doehr2]

Check the note again, it´s listed there:

Download the SQL script for creating the SAPDBA role from the attachment to this note (for Oracle 8.1: sapdba_role_ora8, for Oracle 9.2: sapdba_role_ora9, for Oracle 10g: sapdba_role_ora10). Execute this script as follows (sapdba_role.sql in the current directory).

Oracle 9.2: sqlplus /nolog @sapdba_role DB

What´s your problem?

--

Markus