Brconnect Error

[Former Member]

Hi,

we are getting problem on Transacation code : db13 - > Check Database & Adapt next extents option

in OUr Server (Ecc6.0).

The error log shows "ORA-01031: insufficient privileges".

Already we implemented the SAP note - 839417(New database role SAPCONN)

but the same problem still persist to us.

Hereby furnished the log files.for your reference

Check Database ]

============

BR0280I BRCONNECT time stamp: 2009-06-19 18.36.18

BR0301E SQL error -1031 at location BrRsnspaceRead-1, SQL statement:

'PREPARE stmt_11 STATEMENT FROM'

'SELECT NAMESPACE, NSPACEGEN FROM "SAPD02".RSNSPACE ORDER BY NAMESPACE'

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: ceaviyng.chk 2009-06-19 18.36.18

BR0280I BRCONNECT time stamp: 2009-06-19 18.36.18

BR0804I BRCONNECT terminated with errors

Adapt next extents

==============

BR0301E SQL error -1031 at location BrDdicRead-1, SQL statement:

'PREPARE stmt_8 STATEMENT FROM'

'SELECT D9.TABNAME, D9.TABKAT, D9.TABART FROM "SAPD02".DD09L D9, "SAPD02".DD02L D2 WHERE D9.TABNAME LIKE '%' AND D9.TABNAME = D2.TABNAME AND D2.AS4LOCAL = 'A' AND D2.TABCLASS = 'TRANSP' ORDER BY TABNAME'

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: ceavizlj.nxt 2009-06-19 18.47.59

BR0280I BRCONNECT time stamp: 2009-06-19 18.47.59

BR0804I BRCONNECT terminated with errors

Kindly advice to us.

Regards,

S.senthil Kumar

[Former Member · Accepted solution]

It seems you will need the script sapdba_role.sql.

SAP note 134592.

And by the way, I suppose you were talking about SAP note 834917 (New database role SAPCONN),

not 839417.

hope this helps

[Former Member · Accepted solution]

Hi,

I`m applied note.but still now the problem occurs.

Regards,

S.Senthil Kumar

[Former Member · Accepted solution]

What is your operating system?

And does it work if you run brconnect from command prompt,

as user ora<sid> in case of Unix, or as user <sid>adm in case of windows?

[Former Member · Accepted solution]

Senthil,

Check SAP Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role

Hope it helps

Thanks

Sushil

[Former Member · Accepted solution]

Hi,

Thanks for your info.

My operating System is windows2003 Enterprise Edition 64 Bit.

Actually we are do all Brtools* related operations in <SID>adm on comd prompt.

Kindly advice to us.

Regards,

S.Senthil Kumar

[Former Member · Accepted solution]

Thanks,

but not sure if you fully answered my questions.

In your first post you pasted errors from brconnect in DB13.

This is not related to running brtools from command prompt.

Please clarify:

Do you get any error messages when running brtools from command prompt?

Or do you only get errors in DB13?

regards

[Former Member · Accepted solution]

Hi joe,

am doing operations in Db13 - > database check. the log shows terminated with error.

and another way i tried to logged in <sid>adm user then run - > command - > brtools - > select database check the same error occured.

Regards

S.Senthil Kumar

[Former Member · Accepted solution]

I suppose there might be a problem with OPS$-users in Oracle.

Was your system created by a system copy?

Is it ABAP and/or Java?

And what is the output of this query in sqlplus:

select username from all_users
where username like 'OPS$%'
/

regards

[Former Member · Accepted solution]

Hi joe,

Thanks.for ur immediate response.

In our development server created by system copy method.Bcoz we had taken copy datas

from production Server and import in development server client(222).We are using ABAP STACK only.

select username from all_users where username like 'OPS$%'

Output of the Query

USERNAME

-

---

OPS$PRIDEV\D02ADM

OPS$PRIDEV\SAPSERVICED02

[Former Member · Accepted solution]

Hi sushil,

am implemented the note.But still the problem persist to us.

[Former Member]

nice

[Former Member]

Senthil,

Oracle versio : 10.2.0.1.0

Please note that SAP does not support Oracle version : 10.2.0.1.0. You need to update the patch level either to Oracle versio : 10.2.0.2.0 or to Oracle version : 10.2.0.4.0

check

Thanks

Sushil

Edited by: Sushil Suryawanshi on Jun 25, 2009 4:49 PM

[Former Member]

DO u change password of SIDADM or oraadm user?

Thanks

Presu

[Former Member]

Hi,

Am not changed any password in my system.

[anindya_bose]

Hi Senthil

Please tell us your oracle version, Dev system SID( i guess its D02), Dev system hostname.

Thanks and Regards

Anindya

[Former Member]

Hi,

Hostname : PRIDEV

DB SID : D02

Oracle versio : 10.2.0.1.0

Regards

Senthil

[anindya_bose]

10.2.0.1 is not supported by SAP. Please upgrade to 10.2.0.2.

But still before upgrade oracle version you can try to use brtools from command prompt abd providing password for SYS explicitly. Before that check the validity of password for SYS

Anindya

[Former Member]

Back to my first post in this thread. You wrote you applied note 134592. Did you download the file sapdba_role_ora10.SAR attached to this note? Or did you use an older version of sapdba_role.sql?

And does your version of the script sapdba_role.sql contain a line with the word RSNSPACE ?

And yes, as others wrote above, Oracle 10.2.0.1 is not supported. I doubt that this is the root cause though.

regards

[Former Member]

Hi,

1. Download the script sapdba_role.sql file from the sapnote_0000134592.

2. Find the oracle10g version script .car file.

3. Extract .car the file. Copy the sapdba_role.sql and paste in <oralce home path>.

4. Login to cmd - > <oracle home path>\<SID>\<102>

5. enter oracle in sqlplus /nolog

6. Execute the sql in @ <location>sapdba_role.sql <SID>

7. Then problem solved

Regards

S.Senthil Kumar