Question:
Hi All,
I am executing arhive log backup thru BRARCHIVE. Tho it is running fine, the log says this at many places:
E:\oracle\PLC\920\scripts>E:\usr\sap\PLC\SYS\exe\run\brarchive.exe -p initPLC.sap -save_delete -d util_file -r initPLC.utl -n 10000 -k no -l E -u /
BR0002I BRARCHIVE 6.40 (15)
BR0006I Start of offline redo log processing: adukatmy.svd 2007-01-16 08.29.48
BR0477I Oracle pfile E:\oracle\PLC\920\database\initPLC.ora created from spfile E:\oracle\PLC\920\database\spfilePLC.ora
BR0280I BRARCHIVE time stamp: 2007-01-16 08.29.49
BR0301W SQL error -1031 at location BraDbLogOpen-1
ORA-01031: insufficient privileges
BR0324W Insertion of database log header failed
BR0280I BRARCHIVE time stamp: 2007-01-16 08.29.49
BR0301W SQL error -1031 at location BraDbLogOpen-2
ORA-01031: insufficient privileges
BR0324W Insertion of database log header failed
BR0280I BRARCHIVE time stamp: 2007-01-16 08.29.49
BR0008I Offline redo log processing for database instance: PLC
BR0009I BRARCHIVE action ID: adukatmy
BR0010I BRARCHIVE function ID: svd
BR0048I Archive function: save_delete
BR0011I 2 offline redo log files found for processing, total size 0.212 MB
BR0130I Backup device type: util_file
BR0109I Files will be saved by backup utility
BR0280I BRARCHIVE time stamp: 2007-01-16 08.29.49
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRARCHIVE:
....
I have imported latest sapdba_role.sql in the kernel.
Any ideas y am i gettin these errors ?
_________________
cheers,
Kunal.
Basis Administrator.
Answer:
how did you run SAPDBA_ROLE.SQL? which option?
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
sqlplus /nolog @sapdba_role (SAPSCHEMA) ..
_________________
cheers,
Kunal.
Basis Administrator.
Answer:
did you use SAPR3 or SAP[SID] ?
did you try to update BRTOOLS to a more recent version?
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
I updated BRTOOLS to the latest.
I used SAP[SID]. The sapdba_role.log says :
Connected.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
old 1: grant ALL on &User..SDBAH to sapdba
new 1: grant ALL on SAPR3.SDBAH to sapdba
grant ALL on SAPR3.SDBAH to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..SDBAD to sapdba
new 1: grant ALL on SAPR3.SDBAD to sapdba
grant ALL on SAPR3.SDBAD to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAML to sapdba
new 1: grant ALL on SAPR3.DBAML to sapdba
grant ALL on SAPR3.DBAML to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBARCL to sapdba
new 1: grant ALL on SAPR3.DBARCL to sapdba
grant ALL on SAPR3.DBARCL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAFID to sapdba
new 1: grant ALL on SAPR3.DBAFID to sapdba
grant ALL on SAPR3.DBAFID to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAEXTL to sapdba
new 1: grant ALL on SAPR3.DBAEXTL to sapdba
grant ALL on SAPR3.DBAEXTL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAREOL to sapdba
new 1: grant ALL on SAPR3.DBAREOL to sapdba
grant ALL on SAPR3.DBAREOL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBABARL to sapdba
new 1: grant ALL on SAPR3.DBABARL to sapdba
grant ALL on SAPR3.DBABARL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBADFL to sapdba
new 1: grant ALL on SAPR3.DBADFL to sapdba
grant ALL on SAPR3.DBADFL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAOPTL to sapdba
new 1: grant ALL on SAPR3.DBAOPTL to sapdba
grant ALL on SAPR3.DBAOPTL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBASPAL to sapdba
new 1: grant ALL on SAPR3.DBASPAL to sapdba
grant ALL on SAPR3.DBASPAL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBABD to sapdba
new 1: grant ALL on SAPR3.DBABD to sapdba
grant ALL on SAPR3.DBABD to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBABL to sapdba
new 1: grant ALL on SAPR3.DBABL to sapdba
grant ALL on SAPR3.DBABL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBATL to sapdba
new 1: grant ALL on SAPR3.DBATL to sapdba
grant ALL on SAPR3.DBATL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAOBJL to sapdba
new 1: grant ALL on SAPR3.DBAOBJL to sapdba
grant ALL on SAPR3.DBAOBJL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAPHAL to sapdba
new 1: grant ALL on SAPR3.DBAPHAL to sapdba
grant ALL on SAPR3.DBAPHAL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAGRP to sapdba
new 1: grant ALL on SAPR3.DBAGRP to sapdba
grant ALL on SAPR3.DBAGRP to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBAERR to sapdba
new 1: grant ALL on SAPR3.DBAERR to sapdba
grant ALL on SAPR3.DBAERR to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBATRIAL to sapdba
new 1: grant ALL on SAPR3.DBATRIAL to sapdba
grant ALL on SAPR3.DBATRIAL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBSTATC to sapdba
new 1: grant ALL on SAPR3.DBSTATC to sapdba
grant ALL on SAPR3.DBSTATC to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBSTATTORA to sapdba
new 1: grant ALL on SAPR3.DBSTATTORA to sapdba
grant ALL on SAPR3.DBSTATTORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBSTATIORA to sapdba
new 1: grant ALL on SAPR3.DBSTATIORA to sapdba
grant ALL on SAPR3.DBSTATIORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBSTATHORA to sapdba
new 1: grant ALL on SAPR3.DBSTATHORA to sapdba
grant ALL on SAPR3.DBSTATHORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBSTAIHORA to sapdba
new 1: grant ALL on SAPR3.DBSTAIHORA to sapdba
grant ALL on SAPR3.DBSTAIHORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBMSGORA to sapdba
new 1: grant ALL on SAPR3.DBMSGORA to sapdba
grant ALL on SAPR3.DBMSGORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..DBCHECKORA to sapdba
new 1: grant ALL on SAPR3.DBCHECKORA to sapdba
grant ALL on SAPR3.DBCHECKORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant ALL on &User..MLICHECK to sapdba
new 1: grant ALL on SAPR3.MLICHECK to sapdba
grant ALL on SAPR3.MLICHECK to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..TGORA to sapdba
new 1: grant SELECT on SAPR3.TGORA to sapdba
grant SELECT on SAPR3.TGORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..IGORA to sapdba
new 1: grant SELECT on SAPR3.IGORA to sapdba
grant SELECT on SAPR3.IGORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..TSORA to sapdba
new 1: grant SELECT on SAPR3.TSORA to sapdba
grant SELECT on SAPR3.TSORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..TAORA to sapdba
new 1: grant SELECT on SAPR3.TAORA to sapdba
grant SELECT on SAPR3.TAORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..IAORA to sapdba
new 1: grant SELECT on SAPR3.IAORA to sapdba
grant SELECT on SAPR3.IAORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..SVERS to sapdba
new 1: grant SELECT on SAPR3.SVERS to sapdba
grant SELECT on SAPR3.SVERS to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DD02L to sapdba
new 1: grant SELECT on SAPR3.DD02L to sapdba
grant SELECT on SAPR3.DD02L to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DD09L to sapdba
new 1: grant SELECT on SAPR3.DD09L to sapdba
grant SELECT on SAPR3.DD09L to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DDNTT to sapdba
new 1: grant SELECT on SAPR3.DDNTT to sapdba
grant SELECT on SAPR3.DDNTT to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DDART to sapdba
new 1: grant SELECT on SAPR3.DDART to sapdba
grant SELECT on SAPR3.DDART to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DARTT to sapdba
new 1: grant SELECT on SAPR3.DARTT to sapdba
grant SELECT on SAPR3.DARTT to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DBCHK to sapdba
new 1: grant SELECT on SAPR3.DBCHK to sapdba
grant SELECT on SAPR3.DBCHK to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 1: grant SELECT on &User..DBDIFF to sapdba
new 1: grant SELECT on SAPR3.DBDIFF to sapdba
grant SELECT on SAPR3.DBDIFF to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist
old 12: Statement := 'grant SELECT on &User..RSNSPACE to sapdba';
new 12: Statement := 'grant SELECT on SAPR3.RSNSPACE to sapdba';
old 21: Statement := 'grant SELECT on &User..RSPSPACE to sapdba';
new 21: Statement := 'grant SELECT on SAPR3.RSPSPACE to sapdba';
PL/SQL procedure successfully completed.
_________________
cheers,
Kunal.
Basis Administrator.
Answer:
ALSO - BRARCHIVE runs fine if i execute it wid "-u system/***" option.. but if i execute with "-u /" .. then it given the "insufficient privileges" error..
_________________
cheers,
Kunal.
Basis Administrator.
Answer:
by sap[SID], I meant SAPR3 if your system was originally built with SAP BAsis 4.6D or below.
if it was installed with WAS 6.x and above, use SAPPLC
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
Can you also post the first 20 lines for your sapdba_role.sql script?
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
-- @(#) $Id: //bas/640_REL/src/ccm/rsbr/sapdba_role.sql#12 $ SAP
-- Create/update sapdba role
-- This script can only be run on Oracle 9i or higher
-- Calling syntax (sapdba_role.sql in current directory):
-- sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>
-- <SAPSCHEMA_ID>: for owner SAPR3: R3, SAP<SID>: <SID>, SAP<SID>DB: <SID>DB
-- Log file sapdba_role.log will be created in current directory
set echo off;
set termout off;
spool sapdba_role.log
whenever sqlerror exit sql.sqlcode
connect / as sysdba;
whenever sqlerror continue
define User = ' '
variable Owner VARCHAR2(30)
variable Prefix VARCHAR2(30)
execute :Owner := 'SAP&&1'
declare
Curs INTEGER;
Statement VARCHAR2(128);
RetWert INTEGER;
V_User VARCHAR2(30);
cursor Curs_1 is select username from sys.dba_users where username like :Prefix;
begin
Curs := dbms_sql.open_cursor;
begin
Statement := 'create role sapdba';
dbms_sql.parse(Curs, Statement, DBMS_SQL.NATIVE);
RetWert := dbms_sql.execute(Curs);
exception
when others then
NULL;
end;
begin
select upper(value) || '%' into :Prefix from v$parameter where name = 'os_authent_prefix';
exception
when others then
:Prefix := 'OPS$%';
end;
begin
open curs_1;
loop
fetch curs_1 into V_User;
exit when curs_1%notfound;
begin
Statement := 'grant sapdba to "' || V_User || '"';
dbms_sql.parse(Curs, Statement, DBMS_SQL.NATIVE);
RetWert := dbms_sql.execute(Curs);
exception
when others then
NULL;
end;
end loop;
close curs_1;
end;
begin
select username into V_User from sys.dba_users where username = :Owner;
exception
when others then
:Owner := 'SAPR3';
end;
dbms_sql.close_cursor(Curs);
end; -- procedure
/
................ followed by the GRANT commands...
_________________
cheers,
Kunal.
Basis Administrator.
Answer:
So,
you ran?
sqlplus /nolog @sapdba_role PLC
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
Nope .. I ran ...
sqlplus /nolog @sapdba_role SAPPLCDB
(PLC has only java instance.. no abap.. oracle is 9.2)
_________________
cheers,
Kunal.
Basis Administrator.
Answer:
Nope .. I ran ...
sqlplus /nolog @sapdba_role SAPPLCDB
(PLC has only java instance.. no abap.. oracle is 9.2)
it's about time you supply that important information!
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
yup. i'm sorry i missed tht earlier...
_________________
cheers,
Kunal.
Basis Administrator.
Answer:
I think it's described in SAP Note 320457 - Installing BR tools on a non-R/3 Basis database
Answer:
This note does not apply to SAP J2EE and Enterprise Portal Oracle databases.
ALSO - if instead of writing just "-u /" in the command - E:\usr\sap\PLC\SYS\exe\run\brarchive.exe -p initPLC.sap -save_delete -d util_file -r initPLC.utl -n 10000 -k no -l E -u /
if i specify "-u system/***" there itself.. it runs fine..
_________________
cheers,
Kunal.
Basis Administrator.