user shema-id sapsr4db

[Former Member]

Hello experts,

when i started db task "clean up logs" i received error message:

<b>BR0301E SQL error -1031 at location dblog_cleanup-5, SQL statement:

'DELETE FROM "SAPSR4DB".SDBAH WHERE BEG > '10000000000000' AND BEG < '20080203000000''

ORA-01031: insufficient privileges

</b>

then i checked the users of oracle db:

<b>

TSMSYS

OPS$<domain>\<sid>ADM

OPS$<domain>\SAPSERVICE<sid>

OUTLN

DIP

OPS$<domain>\SAPSERVICESR4

DBSNMP

SAPSR3

SAPSR4DB

SYS

SYSTEM

</b>

why i have user sapsr4db? is it java schema-id?

user sapservicesr4 for what?

what can i do for this problem.

regards,

Denis

Edited by: Denis Yugay on May 12, 2008 7:54 AM

Edited by: Denis Yugay on May 12, 2008 7:55 AM

[fidel_vales · Accepted solution]

>

> Hello experts,
> 
> when i started db task "clean up logs" i received error message:
> <b>BR0301E SQL error -1031 at location dblog_cleanup-5, SQL statement:
> 'DELETE FROM "SAPSR4DB".SDBAH WHERE BEG > '10000000000000' AND BEG < '20080203000000''
> ORA-01031: insufficient privileges
> </b>
> 
> Edited by: Denis Yugay on May 12, 2008 7:55 AM

Hi,

I'd like to know

1) how did you executed sapdba_role.sql and the exact output you got

2) how exactly are you executing the "DB task" (I assume that via DB13)

[Former Member · Accepted solution]

Hi Fidel,

1) <b> sqlplus /nolog @sapdba_role SLDDB</b>

<sid> - SLD

would you like the whole output log?

2) i planned db task "Cleanup logs" in db13.

regards,

Denis

[fidel_vales · Accepted solution]

>

> Hi Fidel,
> 
> 1)  <b> sqlplus /nolog @sapdba_role SLDDB</b>
>      <sid> - SLD
> Denis

Hi,

Why have you used SLDDB?

That is the SAP SID but I do not think it is the DB SID. On the list of users you wrote:

TSMSYS
OPS$<domain>\<sid>ADM
OPS$<domain>\SAPSERVICE<sid>
OUTLN
DIP
OPS$<domain>\SAPSERVICESR4
DBSNMP
SAPSR3
SAPSR4DB
SYS
SYSTEM

No SAPSLDDB user there (and some not very normal users, are you using Windows?)

Also you are having problems here:

BR0301E SQL error -1031 at location dblog_cleanup-5, SQL statement:
'DELETE FROM "SAPSR4DB".SDBAH WHERE BEG > '10000000000000' AND BEG < ''
ORA-01031: insufficient privileges

then you have to try

sqlplus /nolog @sapdba_role SR4DB

[Former Member · Accepted solution]

Hi Fidel.

Thank you for help.

I started sqlplus /nolog @sapdba_role SR4DB. It works and brconnect started without errors.

we use NWs, sid SLD, users - sapsr3, <b>sapsr4db</b>.

one more question - why sapsr4db, not <b>sapsr3db</b>?

regards,

Denis

Edited by: Denis Yugay on May 13, 2008 11:41 AM

[fidel_vales · Accepted solution]

Hi,

I cannot answer that.

Perhaps first was installed the ABAP and later on the Java part with a different ID

[Former Member]

hi,

why i have user sapsr4db? is it java schema-id?

-> I think you have ABAP+JAVA system. sapsr4db associate with java instance.

check Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role

Note 834917 - Oracle Database 10g: New database role SAPCONN

Note 700548 - FAQ: Oracle authorizations

regards,

kaushal

[Former Member]

hello kaushal,

thank you for reply.

i checked all recomended notes.

the situations is the same.

regards,

Denis

[Former Member]

Hi,

check Note 900525 - BRCONNECT fails with ORA-01031 at location BrDdartRead-1

and apply

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

regards,

kaushal

[Former Member]

HI kaushal.

i applyed the note 134592.

errrors is the same.

regards,

Denis