35 Replies Latest reply: Jul 15, 2008 6:07 AM by Nancy Tan RSS

ORA-01031: insufficient privileges

Nancy Tan
Currently Being Moderated

Hi to all experts,

 

Whenever I run redo log backup in DB13, i will get the error message as below:

 

BR0002I BRARCHIVE 6.40 (15)

BR0006I Start of offline redo log processing: adyhdcwk.svd 2008-07-04 14.44.06

BR0280I BRARCHIVE time stamp: 2008-07-04 14.44.06

BR0301E SQL error -1031 at location BrInitOraCreate-2

ORA-01031: insufficient privileges

BR0303E Determination of RDBMS version failed

BR0007I End of offline redo log processing: adyhdcwk.svd 2008-07-04 14.44.06

BR0280I BRARCHIVE time stamp: 2008-07-04 14.44.06

BR0005I BRARCHIVE terminated with errors

 

Does anyone can help me?

 

Thanks a lot.

 

BR,

Nancy

  • Re: ORA-01031: insufficient privileges
    Scott Butler
    Currently Being Moderated

    Have you even tried to search for this on OSS ?

     

     

     

    Try:      

    https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=900525

  • Re: ORA-01031: insufficient privileges
    Sergo Beradze
    Currently Being Moderated

    Hello. Can you say your Oracle version, patch level , OS, Brtools version,  and from wich tool you create backup ? One time i'm has collided to same problem...

    Data protector backup failed.... .

    Regards.

  • Re: ORA-01031: insufficient privileges
    Stefano Mattavelli
    Currently Being Moderated

    Hi,

    try to (re)execute the sql script SAPDBA_ROLE.SQL.

     

    You can find it on kernel directory ed if you read the content of file you can find how to launch it.

     

    Bye

    Stefano

  • Re: ORA-01031: insufficient privileges
    Stefano Mattavelli
    Currently Being Moderated

    Hi Nancy,

    SAPDBA_ROLE.SQL is an oracle script.

    To start is, you have to logon to the system ad ora<SID> user, change directory where the sql script is located,

    then execute:

    sqlplus /nolog @sapdba_role <SAPSCHEMA_ID> UNIX

     

    where <SAPSCHEMA_ID> is probably the SID of your system. It depend on the Oracle schema owner of SAP objects.

     

    Stefano

    • Re: ORA-01031: insufficient privileges
      Nancy Tan
      Currently Being Moderated

      Hi Sergo

       

      Sorry for the late reply. I have tried out your command, please see this link --> http://img2.freeimagehosting.net/uploads/c2b2773c85.jpg

      I guess I had set the wrong schema id for database instance. I guess I had set SAPIAP in central instance but set SAPID1 in database instance. So is it possible to change in SQLPLUS, so that the schema is match? If possible, what is the commancd?

      Kindly please look at this as well --> http://img2.freeimagehosting.net/image.php?86e01049b0.jpg

      Thanks in advance.

       

       

      Hi Stefano,

       

      Sorry for the late reply, I had tried out your command, the result as below:

       

      *SQLPlus: Release 9.2.0.7.0 - Production on Wed Jul 9 15:12:20 2008**

       

      *Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.*

       

      *Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production*

      *With the Partitioning option*

      *JServer Release 9.2.0.7.0 - Production*

       

      Thanks in advance.

       

      BR,

      Nancy

      • Re: ORA-01031: insufficient privileges
        Fidel Vales
        Currently Being Moderated

        Hello,

         

        unfortunately there is no simple command to change the schema name.

        It would be necessary to export/import the DB and that is not worth.

         

        The script is on the note 134592, the name is sapdba_role_ora9.SAR

         

        On the header you can see how to use it:

         

         

        -- 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

         

         

        so you should do

        sqlplus /nolog @sapdba_role SAPID1

        • Re: ORA-01031: insufficient privileges
          Sergo Beradze
          Currently Being Moderated

          Hello Fidel, will  correct you sqlplus /nolog @sapdba_role ID1  .

          Regards.

          • Re: ORA-01031: insufficient privileges
            Fidel Vales
            Currently Being Moderated

            Ups,

            My apologizes, too fast typing.

            Correcting it

            Ups,

            second mistake, should have corrected it before replying it, now I cannot edit it

             

            It is not my day, better stay out :O

             

            Please, use Sergo command and not mine.

             

            Edited by: Fidel Vales on Jul 9, 2008 11:37 AM

            • Re: ORA-01031: insufficient privileges
              Nancy Tan
              Currently Being Moderated

              Thanks Sergo & Fidel.

               

              I have tried out the command, but still get this error:

               

              IAPR3DCI:oraid1 58> sqlplus /nolog @sapdba_role ID1

               

              SQL*Plus: Release 9.2.0.7.0 - Production on Wed Jul 9 17:42:18 2008

               

              Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

               

              Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production

              With the Partitioning option

              JServer Release 9.2.0.7.0 - Production

               

              I have executed the command at cd /sapmnt/ID1/exe. Thanks for the reply.

               

              BR,

              Nancy

              • Re: ORA-01031: insufficient privileges
                Sergo Beradze
                Currently Being Moderated

                Hello. It's not error. Read Log in same directory. Like sapdba_role.log i cant check rigth name now(out of work)... Regards.

                • Re: ORA-01031: insufficient privileges
                  Nancy Tan
                  Currently Being Moderated

                  Hi Sergo,

                   

                  I had run "sqlplus /nolog @sapdba_role ID1" at /oracle/ID1/920_32/dbs/, then i checked sapdba_role.log at the same directory, it shows:

                   

                  old   1: grant SELECT on &User..DBCHK to sapdba

                  new   1: grant SELECT on SAPID1.DBCHK to sapdba

                   

                  Grant succeeded.

                   

                  old   1: grant SELECT on &User..DBDIFF to sapdba

                  new   1: grant SELECT on SAPID1.DBDIFF to sapdba

                   

                  Grant succeeded.

                   

                  old  12:  Statement := 'grant SELECT on &User..RSNSPACE to sapdba';

                  new  12:  Statement := 'grant SELECT on SAPID1.RSNSPACE to sapdba';

                  old  21:  Statement := 'grant SELECT on &User..RSPSPACE to sapdba';

                  new  21:  Statement := 'grant SELECT on SAPID1.RSPSPACE to sapdba';

                   

                  PL/SQL procedure successfully completed.

                   

                  But I still get an error while scheduling a BRARCHIVE in DB13.

                   

                  Is it because of i had set wrong schema ID between central instance & database instance?

                   

                  Thanks a lot.

                   

                  BR,

                  Nancy

                  • Re: ORA-01031: insufficient privileges
                    Ralph Ganszky
                    Currently Being Moderated

                    Hi Nancy,

                     

                    check the output of "id" command for users ora<sid> and  <sid>adm on your database server. Both users should be member of the oper group. If not you should fix this.

                     

                    Regards

                    Ralph

                    • Re: ORA-01031: insufficient privileges
                      Nancy Tan
                      Currently Being Moderated

                      Hi Ralph,

                       

                      Could you kindly please explain more how to check orasid & sidadm in database server?

                       

                      Thanks in advance.

                       

                      BR,

                      Nancy

                      • Re: ORA-01031: insufficient privileges
                        Ralph Ganszky
                        Currently Being Moderated

                        Hi Nancy,

                         

                        just execute the command: id

                        on the command line. It list all groups you are member of. In an SAP oracle environment you should be member of a dba and an oper group. They may be don't called dba and oper, but they contain these strings in the group name. brtools are using the "as sysoper" to connect. Therefore you need the oper group membership.

                         

                        An example of the id output for abcadm could looks like:

                        uid=4711(abcadm) gid=200(sapsys) groups=1000(sapinst),201(oper)

                         

                        Regards

                        Ralph

                        • Re: ORA-01031: insufficient privileges
                          Nancy Tan
                          Currently Being Moderated

                          Hi Raplh,

                           

                          Thanks for your clear explanation.

                           

                          orasid:

                          uid=203(oraid1) gid=55(dba) groups=55(dba),201(oper)

                           

                          sidadm:

                          uid=202(id1adm) gid=200(sapsys) groups=55(dba),200(sapsys),201(oper)

                           

                          Is that correct?

                           

                          Thanks a lot.

                           

                          BR,

                          Nancy

                          • Re: ORA-01031: insufficient privileges
                            Ralph Ganszky
                            Currently Being Moderated

                            Hi Nancy,

                             

                            yes it looks good.

                             

                            May be it is time to open a ticket at SAP support.

                             

                            Regards

                            Ralph

                          • Re: ORA-01031: insufficient privileges
                            Fidel Vales
                            Currently Being Moderated

                            Hello Nancy,

                             

                            Can you reproduce the issue at OS level?

                            If so, increase the trace to 15 so we can see the exact command that fails with the error.

                             

                            to increase the trace level you only have to add -TRC 15 at the end of the command:

                             

                            brbackup <all the options> -TRC 15

                            • Re: ORA-01031: insufficient privileges
                              Nancy Tan
                              Currently Being Moderated

                              Hi Fidel,

                               

                              My error as below:

                               

                              BR0300I BR_TRACE: SQL code: -1017, number of processed rows: 0

                              BR0280I BRBACKUP time stamp: 2008-07-14 14.39.23

                              BR0301E SQL error -1017 at location BrDbConnect-2

                              ORA-01017: invalid username/password; logon denied

                              BR0280I BRBACKUP time stamp: 2008-07-14 14.39.23

                              BR0200I BR_TRACE: location BrDbConnect-14, SQL command:

                              'COMMIT RELEASE;'

                              BR0300I BR_TRACE: SQL code: -1012, number of processed rows: 0

                              BR0310E Connect to database instance ID1 failed

                              BR0248I BR_TRACE: level 3, function BrZombieKill entry with 'void'

                              BR0250I BR_TRACE: level 3, function BrZombieKill exit with 'void'

                              BR0249I BR_TRACE: level 2, function BrDbConnect exit with -1

                               

                              BR0056I End of database backup: bdyjagoh.log 2008-07-14 14.39.23

                              BR0280I BRBACKUP time stamp: 2008-07-14 14.39.23

                              BR0054I BRBACKUP terminated with errors

                               

                              Thanks a lot.

                               

                              BR,

                              Nancy

                              • Re: ORA-01031: insufficient privileges
                                Fidel Vales
                                Currently Being Moderated

                                Hi,

                                The error is different (1017 instead of 1031)

                                1) what is the command line you executed?

                                2) as which user have you tried this?

                                3) would need 4 or 5 lines before the error to "see" the command that fails

                                • Re: ORA-01031: insufficient privileges
                                  Nancy Tan
                                  Currently Being Moderated

                                  Hi Fidel,

                                   

                                  1) brbackup -f -TRC 15

                                  2) su oraid1

                                  3)  BR0248I BR_TRACE: level 1, function global_set entry with 'dummy'

                                  BR0248I BR_TRACE: level 2, function BrbParCheck entry with 'dummy'

                                  BR0191E Value 'online_cons' of parameter/option 'backup_type/-t' not supported for '-f'

                                  BR0248I BR_TRACE: level 3, function BrOraReplace entry with '/oracle_origlog/oracle/ID1/sapbackup'

                                  BR0250I BR_TRACE: level 3, function BrOraReplace exit with 'void'

                                  BR0248I BR_TRACE: level 3, function BrFileStatGet entry with '/oracle_origlog/oracle/ID1/sapbackup'

                                  BR0250I BR_TRACE: level 3, function BrFileStatGet exit with '1757627347 8192'

                                  BR0248I BR_TRACE: level 3, function BrOraReplace entry with '/oracle_origlog/oracle/ID1/sapbackup'

                                  BR0250I BR_TRACE: level 3, function BrOraReplace exit with 'void'

                                  BR0248I BR_TRACE: level 3, function BrOraReplace entry with '/oracle_origlog/oracle/ID1/sapreorg'

                                  BR0250I BR_TRACE: level 3, function BrOraReplace exit with 'void'

                                  BR0248I BR_TRACE: level 3, function BrFileStatGet entry with '/oracle_origlog/oracle/ID1/sapreorg'

                                  BR0250I BR_TRACE: level 3, function BrFileStatGet exit with '97317 4096'

                                  BR0249I BR_TRACE: level 2, function BrbParCheck exit with -1

                                  BR0249I BR_TRACE: level 1, function global_set exit with -1

                                  BR0248I BR_TRACE: level 1, function BrCleanup entry with 3

                                  BR0248I BR_TRACE: level 2, function BrDbConnect entry with 'ID1'

                                  BR0248I BR_TRACE: level 3, function BrOraSrvControl entry with 'TRUE'

                                  BR0249I BR_TRACE: level 3, function BrOraSrvControl exit with 0

                                  BR0280I BRBACKUP time stamp: 2008-07-14 15.24.03

                                  BR0200I BR_TRACE: location BrDbConnect-2, SQL command:

                                  'CONNECT system/*******;'

                                  BR0300I BR_TRACE: SQL code: -1017, number of processed rows: 0

                                  BR0280I BRBACKUP time stamp: 2008-07-14 15.24.03

                                  BR0301E SQL error -1017 at location BrDbConnect-2

                                  ORA-01017: invalid username/password; logon denied

                                   

                                   

                                  I have tried "SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'SAPID1';"

                                   

                                  result as below:

                                  GRANTED_ROLE

                                  -


                                  CONNECT

                                  RESOURCE

                                  SELECT_CATALOG_ROLE

                                   

                                  How to make sure that an appropriate OPS$ user is set up?

                                   

                                  Thanks a lot.

                                   

                                  BR,

                                  Nancy

                                  • Re: ORA-01031: insufficient privileges
                                    Fidel Vales
                                    Currently Being Moderated

                                    Hi,

                                     

                                    2) don't use oraid1 for the test, but id1adm, that way we can "simulate" what DB13 does (DB13 uses <sid>adm)

                                    1) the command to be used should be

                                    > brbackup -u / -c force -t online -m all -TRC 15

                                    it will use the OPS$ user and not the system

                                     

                                    This is the one that should fail with ORA1031. Try it

                                    • Re: ORA-01031: insufficient privileges
                                      Nancy Tan
                                      Currently Being Moderated

                                      Hi Fidel,

                                       

                                      Here's the parameters setting:

                                      'dbms_type=ORA'

                                      'dbs_ora_tnsname=ID1'

                                      'dbs_ora_schema=SAPID1'

                                      'ORACLE_PSRV=ID1'

                                      'ORACLE_SID=ID1'

                                      'DB_SID=ID1'

                                      'ORACLE_HOME=/oracle/ID1/920_32'

                                      'ORACLE_BASE=/oracle'

                                      'ORA_NLS33=/oracle/client/92x_32/ocommon/nls/admin/data'

                                      'NLS_LANG=AMERICAN_AMERICA.UTF8'

                                      'SAPDATA_HOME=/oracle/ID1'

                                       

                                      For error, please see below:

                                      BR0280I BRBACKUP time stamp: 2008-07-14 16.26.08

                                      BR0200I BR_TRACE: location BrDbConnect-2, SQL command:

                                      'CONNECT SAPID1/**************************;'

                                      BR0300I BR_TRACE: SQL code: -1017, number of processed rows: 0

                                      BR0280I BRBACKUP time stamp: 2008-07-14 16.26.08

                                      BR0301E SQL error -1017 at location BrDbConnect-2

                                      ORA-01017: invalid username/password; logon denied

                                      BR0280I BRBACKUP time stamp: 2008-07-14 16.26.08

                                      BR0200I BR_TRACE: location BrDbConnect-14, SQL command:

                                      'COMMIT RELEASE;'

                                      BR0300I BR_TRACE: SQL code: -1012, number of processed rows: 0

                                      BR0310E Connect to database instance ID1 failed

                                      BR0248I BR_TRACE: level 2, function BrZombieKill entry with 'void'

                                      BR0250I BR_TRACE: level 2, function BrZombieKill exit with 'void'

                                      BR0249I BR_TRACE: level 1, function BrDbConnect exit with -1

                                      BR0248I BR_TRACE: level 1, function BrCleanup entry with 3

                                      BR0248I BR_TRACE: level 2, function BrDbConnect entry with 'ID1'

                                      BR0280I BRBACKUP time stamp: 2008-07-14 16.26.08

                                      BR0200I BR_TRACE: location BrDbConnect-2, SQL command:

                                      'CONNECT SAPID1/**************************;'

                                      BR0300I BR_TRACE: SQL code: -1017, number of processed rows: 0

                                      BR0280I BRBACKUP time stamp: 2008-07-14 16.26.08

                                      BR0301E SQL error -1017 at location BrDbConnect-2

                                      ORA-01017: invalid username/password; logon denied

                                      BR0280I BRBACKUP time stamp: 2008-07-14 16.26.08

                                      BR0200I BR_TRACE: location BrDbConnect-14, SQL command:

                                      'COMMIT RELEASE;'

                                      BR0300I BR_TRACE: SQL code: -1012, number of processed rows: 0

                                      BR0310E Connect to database instance ID1 failed

                                      BR0248I BR_TRACE: level 3, function BrZombieKill entry with 'void'

                                      BR0250I BR_TRACE: level 3, function BrZombieKill exit with 'void'

                                      BR0249I BR_TRACE: level 2, function BrDbConnect exit with -1

                                       

                                      BR0056I End of database backup: bdyjapzb.and 2008-07-14 16.26.08

                                      BR0280I BRBACKUP time stamp: 2008-07-14 16.26.08

                                      BR0054I BRBACKUP terminated with errors

                                      BR0249I BR_TRACE: level 1, function BrCleanup exit with 3

                                      BR0248I BR_TRACE: level 2, function BrExit entry with 3

                                       

                                      Thanks in advance.

                                       

                                      BR,

                                      Nancy

                                      • Re: ORA-01031: insufficient privileges
                                        Fidel Vales
                                        Currently Being Moderated

                                        Hi,

                                         

                                        Did you use the command I provided?

                                         

                                        > 'CONNECT SAPID1/**************************;'

                                         

                                        this seems to indicate that you have used a different one

                                        • Re: ORA-01031: insufficient privileges
                                          Nancy Tan
                                          Currently Being Moderated

                                          Hi Fidel,

                                           

                                          Sorry,misunderstood your meaning.

                                           

                                          Here's the error:

                                          'CONNECT / AT PROF_CONN IN SYSOPER MODE;'

                                          BR0300I BR_TRACE: SQL code: -1031, number of processed rows: 0

                                          BR0280I BRBACKUP time stamp: 2008-07-14 16.58.03

                                          BR0301E SQL error -1031 at location BrInitOraCreate-2

                                          ORA-01031: insufficient privileges

                                          BR0249I BR_TRACE: level 3, function BrInitOraCreate exit with -1

                                          BR0303E Determination of Oracle version failed

                                          BR0249I BR_TRACE: level 2, function ora_vers_get exit with -1

                                          BR0249I BR_TRACE: level 1, function BrSqlInitiate exit with -1

                                          BR0248I BR_TRACE: level 1, function BrCleanup entry with 3

                                          BR0248I BR_TRACE: level 2, function BrDbConnect entry with 'ID1'

                                          BR0249I BR_TRACE: level 2, function BrDbConnect exit with 0

                                          BR0248I BR_TRACE: level 2, function BrbDbLogClose entry with '20080714165802 and bdyjaswg 20080714165803 3'

                                          BR0248I BR_TRACE: level 3, function BrbDbLogOpen entry with 'bdyjaswg and 20080714165802'

                                          BR0200I BR_TRACE: location BrbDbLogOpen-1, SQL command:

                                          'SELECT TABLE_OWNER FROM DBA_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'SAP_SDBAH';'

                                          BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

                                          BR0200I BR_TRACE: location BrbDbLogOpen-2, SQL command output:

                                          'SAPID1'

                                          BR0200I BR_TRACE: location BrbDbLogOpen-3, SQL command:

                                          'SELECT DATA_LENGTH FROM DBA_TAB_COLUMNS WHERE OWNER = 'SAPID1' AND TABLE_NAME = 'DBABD' AND COLUMN_NAME = 'REDO_BEG';'

                                          BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

                                          BR0200I BR_TRACE: location BrbDbLogOpen-4, SQL command output:

                                          '18'

                                          BR0200I BR_TRACE: location BrbDbLogOpen-5, SQL command:

                                          'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20080714165802', 'and', 'ID1', ' ', '9999', ' ', 'bdyjaswg', ' ');'

                                          BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

                                          BR0248I BR_TRACE: level 4, function BrBackIdBuild entry with 'bdyjaswg and'

                                          BR0250I BR_TRACE: level 4, function BrBackIdBuild exit with 'bdyjaswg.and'

                                          BR0248I BR_TRACE: level 4, function BrNameBuild entry with '1 bdyjaswg.and /oracle/ID1/sapbackup'

                                          BR0250I BR_TRACE: level 4, function BrNameBuild exit with '/oracle/ID1/sapbackup/bdyjaswg.and'

                                          BR0200I BR_TRACE: location BrbDbLogOpen-13, SQL command:

                                          'INSERT INTO SAP_DBATL (SYS_ID, OPER_ID, TASKNAME, JOB_NR, UPD_OP, TLOGNAME, STATUS, BEGIN_OP, END_OP, RC, INTERNAL) VALUES ('ID1', '20080714165802', 'Database backup', '0000000000', '20080714165803', '/oracle/ID1/sapbackup/bdyjaswg.and', 'STARTED', '20080714165802', ' ', '0000', ' ');'

                                          BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

                                          BR0248I BR_TRACE: level 4, function BrBackIdBuild entry with 'bdyjaswg and'

                                          BR0250I BR_TRACE: level 4, function BrBackIdBuild exit with 'bdyjaswg.and'

                                          BR0248I BR_TRACE: level 4, function BrNameBuild entry with '1 bdyjaswg.and /oracle/ID1/sapbackup'

                                          BR0250I BR_TRACE: level 4, function BrNameBuild exit with '/oracle/ID1/sapbackup/bdyjaswg.and'

                                          BR0200I BR_TRACE: location BrbDbLogOpen-14, SQL command:

                                          'INSERT INTO SAP_DBAML (SYS_ID, OPER_ID, TASKNAME, JOB_NR, TRIAL, UTIL_NR, FUNC_ID, UPD_OP, TOOLSET, PROGNAME, LOG_NAME, STATUS, BEGIN_OP, END_OP, RC, INTERNAL) VALUES ('ID1', '20080714165802', 'Database backup', '0000000000', '1', '0000000000', 'and', '20080714165803', 'SAP CCMS', 'BRBACKUP', '/oracle/ID1/sapbackup/bdyjaswg.and', 'STARTED', '20080714165802', ' ', '0000', 'bdyjaswg');'

                                          BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

                                          BR0200I BR_TRACE: location BrbDbLogOpen-17, SQL command:

                                          'INSERT INTO SAP_DBABARL (SYS_ID, OPER_ID, TASKNAME, JOB_NR, TRIAL, UTIL_NR, FUNC_ID, UPD_OP, OBJ_TYPE, BU_TYPE, BU_METHOD) VALUES ('ID1', '20080714165802', 'Database backup', '0000000000', '1', '0000000000', 'and', '20080714165803', 'DATABASE', 'ONLINE', 'NORMAL');'

                                          BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

                                          BR0249I BR_TRACE: level 3, function BrbDbLogOpen exit with 0

                                          BR0200I BR_TRACE: location BrbDbLogClose-1, SQL command:

                                          'UPDATE SAP_SDBAH SET RC = '0003', ENDE = '20080714165803', OBJ = ' ', LINE = ' ' WHERE BEG = '20080714165802' AND FUNCT = 'and' AND SYSID = 'ID1';'

                                          BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

                                          BR0200I BR_TRACE: location BrbDbLogClose-5, SQL command:

                                          'UPDATE SAP_DBATL SET UPD_OP = '20080714165803', STATUS = 'COMPLETED', END_OP = '20080714165803', RC = '0003' WHERE SYS_ID = 'ID1' AND OPER_ID = '20080714165802' AND TASKNAME = 'Database backup' AND JOB_NR = '0000000000';'

                                          BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

                                          BR0200I BR_TRACE: location BrbDbLogClose-6, SQL command:

                                          'UPDATE SAP_DBAML SET UPD_OP = '20080714165803', STATUS = 'COMPLETED', END_OP = '20080714165803', RC = '0003', INTERNAL = 'bdyjaswg' WHERE SYS_ID = 'ID1' AND OPER_ID = '20080714165802' AND TASKNAME = 'Database backup' AND JOB_NR = '0000000000' AND TRIAL = '1' AND UTIL_NR = '0000000000' AND FUNCT_ID = 'and';'

                                          BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

                                          BR0249I BR_TRACE: level 2, function BrbDbLogClose exit with 0

                                          BR0248I BR_TRACE: level 2, function BrDbDisconnect entry with 'void'

                                          BR0280I BRBACKUP time stamp: 2008-07-14 16.58.03

                                          BR0200I BR_TRACE: location BrDbDisconnect-1, SQL command:

                                          'COMMIT RELEASE;'

                                          BR0300I BR_TRACE: SQL code: 0, number of processed rows: 0

                                          BR0248I BR_TRACE: level 3, function BrZombieKill entry with 'void'

                                          BR0250I BR_TRACE: level 3, function BrZombieKill exit with 'void'

                                          BR0249I BR_TRACE: level 2, function BrDbDisconnect exit with 0

                                           

                                          BR0056I End of database backup: bdyjaswg.and 2008-07-14 16.58.03

                                          BR0280I BRBACKUP time stamp: 2008-07-14 16.58.03

                                          BR0054I BRBACKUP terminated with errors

                                          BR0249I BR_TRACE: level 1, function BrCleanup exit with 3

                                          BR0248I BR_TRACE: level 2, function BrExit entry with 3

                                           

                                          Thanks a lot.

                                           

                                          BR,

                                          Nancy

                                          • Re: ORA-01031: insufficient privileges
                                            Nancy Tan
                                            Currently Being Moderated

                                            Hi,

                                             

                                            SQL> SELECT * FROM DBA_ROLE_PRIVS;

                                             

                                            DBA                            EXP_FULL_DATABASE              NO  YES

                                            DBA                            IMP_FULL_DATABASE              NO  YES

                                            DBA                            DELETE_CATALOG_ROLE            YES YES

                                            DBA                            SELECT_CATALOG_ROLE            YES YES

                                            DBA                            EXECUTE_CATALOG_ROLE           YES YES

                                            DBA                            GATHER_SYSTEM_STATISTICS       NO  YES

                                            SYS                            DBA                            YES YES

                                            SYS                            SAPDBA                         YES YES

                                            SYS                            CONNECT                        YES YES

                                            SYS                            RESOURCE                       YES YES

                                            SYS                            OEM_MONITOR                    YES YES

                                             

                                            SYS                            AQ_USER_ROLE                   YES YES

                                            SYS                            HS_ADMIN_ROLE                  YES YES

                                            SYS                            EXP_FULL_DATABASE              YES YES

                                            SYS                            IMP_FULL_DATABASE              YES YES

                                            SYS                            DELETE_CATALOG_ROLE            YES YES

                                            SYS                            SELECT_CATALOG_ROLE            YES YES

                                            SYS                            EXECUTE_CATALOG_ROLE           YES YES

                                            SYS                            AQ_ADMINISTRATOR_ROLE          YES YES

                                            SYS                            LOGSTDBY_ADMINISTRATOR         YES YES

                                            SYS                            RECOVERY_CATALOG_OWNER         YES YES

                                            SYS                            GATHER_SYSTEM_STATISTICS       YES YES

                                             

                                            OUTLN                          CONNECT                        NO  YES

                                            OUTLN                          RESOURCE                       NO  YES

                                            DBSNMP                         CONNECT                        NO  YES

                                            SAPDBA                         SELECT_CATALOG_ROLE            NO  YES

                                            SAPID1                         CONNECT                        NO  YES

                                            SAPID1                         RESOURCE                       NO  YES

                                            SAPID1                         SELECT_CATALOG_ROLE            NO  YES

                                            SYSTEM                         DBA                            YES YES

                                            SYSTEM                         SAPDBA                         NO  YES

                                            SYSTEM                         AQ_ADMINISTRATOR_ROLE          YES YES

                                            OPS$ID1ADM                     SAPDBA                         NO  YES

                                             

                                            OPS$ID1ADM                     CONNECT                        NO  YES

                                            OPS$ID1ADM                     RESOURCE                       NO  YES

                                            OPS$ORAID1                     SAPDBA                         NO  YES

                                            OPS$ORAID1                     CONNECT                        NO  YES

                                            OPS$ORAID1                     RESOURCE                       NO  YES

                                            OEM_MONITOR                    CONNECT                        NO  YES

                                            OEM_MONITOR                    RESOURCE                       NO  YES

                                            EXP_FULL_DATABASE              SELECT_CATALOG_ROLE            NO  YES

                                            EXP_FULL_DATABASE              EXECUTE_CATALOG_ROLE           NO  YES

                                            IMP_FULL_DATABASE              SELECT_CATALOG_ROLE            NO  YES

                                            IMP_FULL_DATABASE              EXECUTE_CATALOG_ROLE           NO  YES

                                             

                                            SELECT_CATALOG_ROLE            HS_ADMIN_ROLE                  NO  YES

                                            EXECUTE_CATALOG_ROLE           HS_ADMIN_ROLE                  NO  YES

                                            LOGSTDBY_ADMINISTRATOR         CONNECT                        NO  YES

                                            LOGSTDBY_ADMINISTRATOR         RESOURCE                       NO  YES

                                             

                                             

                                            I have compared with other system, i found out that SAP<SID>DB, SAP<SID>DB & SAP<SID>DB are missing. Is this the reason I get the error?

                                             

                                            BR,

                                            Nancy

                                             

                                            Edited by: Nancy Tan on Jul 14, 2008 11:25 AM

Actions