db13 Ended with warnings error-BR301W SQL error -1031

[Former Member]

Hi,

when I ran jobs from DB13(like offlineredo backup)the job is completing successfully with warnings.

The error is

BR801I BRCONNECT 6.20 (118)

BR280I Time stamp 2007-05-24 11.49.38

BR301W SQL error -1031 at location BrLicCheck-7

ORA-01031: insufficient privileges

BR805I Start of BRCONNECT processing: cdviehtq.sta 2007-05-24 11.49.38

BR101I Parameters

Please any one give good suggestion to avoid the error

Regards

Nani

[Former Member · Accepted solution]

Hi,

The first advice in this situation is to run the sapdba_role.sql

[Former Member · Accepted solution]

Please explain from where can i get that sapdba_role.sql file and what are the steps to aplly.

please kindly explain

Regards

Nani

[Former Member · Accepted solution]

Please explain from where can i get that sapdba_role.sql file and what are the steps to aplly.

please kindly explain

Regards

Nani

[Former Member · Accepted solution]

Easy,

You search for notes with "sapdba_role.sql" in the component BC-DB-ORA-DBA and you get the note:

<a href="http://service.sap.com/sap/support/notes/134592">134592: Importing the SAPDBA role ( sapdba_role.sql)</a>

You only have to read it, and follow the intructions ( very easy )

[Former Member · Accepted solution]

Hi

i have down loaded sapdba_role.sql file but i have a confussion how can I run this file.

1.we need to execute this file online or shutdown database?

2.what is the exact commant to run this file?

3.If run wrong will it effect on database ?

Regards

Nani.

[Former Member · Accepted solution]

<i>> Hi

> i have down loaded sapdba_role.sql file but

> i have a confussion how can I run this file.</i>

<b>???? o_O</b>

<i>>

> 1.we need to execute this file online or shutdown

> database?</i>

If you have the database stopped, how are you going to execute the script?

<i>> 2.what is the exact commant to run this file?</i>

Have you read the note? <b>(?_?)</b>

<note quote>

Unix Oracle 8.1: <b>sqlplus internal @sapdba_role <SAPSCHEMA_ID> UNIX</b>

Windows Oracle 8.1: <b>sqlplus internal @sapdba_role <SAPSCHEMA_ID> NT </b>

Oracle 9.2: <b>sqlplus /nolog @sapdba_role <SAPSCHEMA_ID></b>

Oracle 10g: <b>sqlplus /nolog @sapdba_role <SAPSCHEMA_ID></b>

</note quote>

<i>>

> 3.If run wrong will it effect on database ?</i>

No

[Former Member · Accepted solution]

Hi

If sap system sai is :p11 and db sid is :p11 and sapdba rolefile:sapdba_role_9

I have logged on system and with ora(sid) user

I have a confussion what is the command i need to execute and where can I upload the sapdba_role_9 file?

can I copy this file to which directory?

Regards

Nani