on 09-12-2007 5:46 PM
Hi there,
I am trying to run brconnect stats and I get this error in SQL Query. Can you please tell me how to change the permission on the oracle side
BR0301W SQL error -1031 at location brc_dblog_write-5, SQL statement:
'INSERT INTO SAP_SDBAD (BEG, FUNCT, POS, LINE) VALUES ('20070912103654', 'sta', '0000', 'A 0000000000000000 00000000 00000000 0
ORA-01031: insufficient privileges
BR0325W Writing to database log failed
BR0280I BRCONNECT time stamp: 2007-09-12 10.38.21
BR0301W SQL error -1031 at location brc_dblog_open-1, SQL statement:
'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20070912103654', 'sta', 'PR2', 'ALL', '9999', '
ORA-01031: insufficient privileges
BR0324W Insertion of database log header failed
BR0806I End of BRCONNECT processing: cdwdgbnq.sta2007-09-12 10.38.20
BR0280I BRCONNECT time stamp: 2007-09-12 10.38.21
BR0803I BRCONNECT completed successfully with warnings
External program terminated with exit code 1
BRCONNECT returned error status E
Job finished
Thanks in Advance
Kumar
Hello,
SAP_SDBAD is a synonymous. Please check to which table is pointing.
That is the table you do not have authorizations. Please check table and owner.
Now, you mentioned that this is a system copy.
Regarding SAPDBA_ROLE,as mentioned on the note 134592:
<i>Oracle 9.2: sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>
Oracle 10g: sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>
Where <SAPSCHEMA_ID> is the schema ID of the SAP database user:
- for User SAPR3: R3
- for User SAP<SID>: <SID>
- for User SAP<SID>DB: <SID>DB
The log file sapdba_role.log is created in the current directory. </i>
But the error you mention is not related to passwords.
You do not <i>need</i> to change teh password after refresh, but you will have the password from your original system, if you are "aware" of that, then no problem.
<i><b>what does external means?</b></i>
it means that the two users do not need a password to connect to the database as they are authentificated by the OS ( ifall other configuration is correct ) you can check notes
562863 FAQ: Logon mechanisms
700548 FAQ: Oracle authorizations
Hope it helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Two things:
Make sure that you have run the sapdba_role script or sapconnect script if you are in Oracle 10
As orasid from /sapmnt/SID/exe run , say that your SID is PRD
sqlplus "/ as sysdba" @sapdba_role PRD
and/or
Run the saproot.sh script as root from /sapmnt/SID/exe
./saproot.sh PRD
This will make sure that your brtools have the correct ownership and permissions
Let me know how you get on .
If not solved, tell us OS you are running on, database and brtools version
Andreas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thansk for quick reponse.
I forgot to mention that this system is database referesh of our Production system .
I did run this command at the end:
sqlplus /NOLOG @sapdba_role R3
you're telling to run this
sqlplus "/ as sysdba" @sapdba_role PRD
Do I put the SID or R3?
Note as per note: 361461
I ran this script first:
sqlplus /NOLOG @oradbusr. sql SAPR3 UNIX PR2 x
after that I ran
sqlplus /NOLOG @sapdba_role R3
thats about it:
I NEVER change or set the SAPR3 user password as on the note: 361641
[code]
The SCHEMAOWNER is either SAPR3 or has to start with SAP followed by the three digit schema id (example: SAPPRD).
On Unix x is a dummy parameter and may e. g. be set to X.
To change the password for the SAPR3 or SAP<SID> user you have to use the following command:
brconnect -u system/<syst_pwd> -f chpass -o SAPR3 -p <new_sap_pwd>
or
brconnect -u system/<syst_pwd> -f chpass -o sap< sid> -p <new_sap_pwd>
Do I need chaneg the password after refresh?
I am using SunOS 5.8, Oracle 10g, SAP ECC 5.0.
User name in SQL:
SQL> select username , password from dba_users;
USERNAME PASSWORD
-
-
OPS$PR2ADM EXTERNAL
OPS$ORAPR2 EXTERNAL
what does external means?
try these:
grant ALL on sapr3.SDBAH to sapdba;
grant ALL on sapr3.SDBAD to sapdba;
grant ALL on sapr3.DBAML to sapdba;
grant ALL on sapr3.DBARCL to sapdba;
grant ALL on sapr3.DBAFID to sapdba;
grant ALL on sapr3.DBAEXTL to sapdba;
grant ALL on sapr3.DBAREOL to sapdba;
grant ALL on sapr3.DBABARL to sapdba;
grant ALL on sapr3.DBADFL to sapdba;
grant ALL on sapr3.DBAOPTL to sapdba;
grant ALL on sapr3.DBASPAL to sapdba;
grant ALL on sapr3.DBABD to sapdba;
grant ALL on sapr3.DBABL to sapdba;
grant ALL on sapr3.DBATL to sapdba;
grant ALL on sapr3.DBAOBJL to sapdba;
grant ALL on sapr3.DBAPHAL to sapdba;
grant ALL on sapr3.DBAGRP to sapdba;
grant ALL on sapr3.DBAERR to sapdba;
grant ALL on sapr3.DBATRIAL to sapdba;
grant ALL on sapr3.DBSTATC to sapdba;
grant ALL on sapr3.DBSTATTORA to sapdba;
grant ALL on sapr3.DBSTATIORA to sapdba;
grant ALL on sapr3.DBSTATHORA to sapdba;
grant ALL on sapr3.DBSTAIHORA to sapdba;
grant ALL on sapr3.DBMSGORA to sapdba;
grant ALL on sapr3.DBCHECKORA to sapdba;
grant ALL on sapr3.MLICHECK to sapdba;
grant SELECT on sapr3.TGORA to sapdba;
grant SELECT on sapr3.IGORA to sapdba;
grant SELECT on sapr3.TSORA to sapdba;
grant SELECT on sapr3.TAORA to sapdba;
grant SELECT on sapr3.IAORA to sapdba;
grant SELECT on sapr3.SVERS to sapdba;
grant SELECT on sapr3.DD02L to sapdba;
grant SELECT on sapr3.DD09L to sapdba;
grant SELECT on sapr3.DDNTT to sapdba;
grant SELECT on sapr3.DDART to sapdba;
grant SELECT on sapr3.DARTT to sapdba;
grant SELECT on sapr3.DBCHK to sapdba;
grant SELECT on sapr3.DBDIFF to sapdba;
Message was edited by:
Eric Brunelle
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.