ORA-01031: insufficient privileges

[former_member474881]

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

[Former Member]

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

[former_member474881]

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

[fidel_vales · Accepted solution]

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

[Former Member · Accepted solution]

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

Regards.

[fidel_vales]

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 😮

Please, use Sergo command and not mine.

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

[former_member474881]

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

[Former Member]

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

[former_member474881]

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

[Former Member]

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

[former_member474881]

Hi Ralph,

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

Thanks in advance.

BR,

Nancy

[Former Member]

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

[former_member474881]

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

[Former Member]

Hi Nancy,

yes it looks good.

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

Regards

Ralph

[fidel_vales]

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

[former_member474881]

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

[fidel_vales]

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

[former_member474881]

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

[fidel_vales]

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

[former_member474881]

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

[fidel_vales]

Hi,

Did you use the command I provided?

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

this seems to indicate that you have used a different one

[former_member474881]

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

[former_member474881]

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

[fidel_vales]

Hi,

can you give me the output of the command

id

at OS level?

Regarding to your question:

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

No, those users only exist if you have a java product installed. Probably in this one you have none.

[former_member474881]

Hi Fidel,

I had posted it before.

IAPR3DCI:oraid1 51> id

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

IAPR3DCI:id1adm 51> id

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

Thanks a lot.

BR,

Nancy

[Former Member]

Hi Nancy,

I believe that your privileges in Oracle was set correctly as I can observed from previous statement.

It might be due to permission of BR* executable file in exe directory which caused failed to call oracle via CCMS Agent (DB13).

Could you please check the following permission accordingly?

-rwsr-srw- 1 oraid1 dba 3203221 Jul 4 16:33 brarchive

-rwsr-srw- 1 oraid1 dba 3298276 Jul 4 16:33 brbackup

[https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bc_db/_{form/handler%7B5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d373736353035%7D|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bc_db/}form/handler%7B5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d373736353035%7D]

Please apply the following solution if there was mismatch of the exe file

su - root

cd /usr/sap/<SAPSID>/SYS/exe/run

chgrp dba brbackup brarchive

chmod 6756 brbackup brarchive

*The authorization **6 should prevent just anyone being able to start an offline backup, which could disrupt the availability of the SAP system. At the same time, make sure that the user <sapsid>adm can still overwrite the tools (during an upgrade for example).

The system must have the following: BRTools 6.40 Patch-Level 32 or higher.*

Please let me know if any concern.

Hope this would help.

BR,

Terry

[former_member474881]

Hi Tow,

Yes!!! Your solution solved my problem. I can now schedule job in DB13, no errors anymore.

Tow, you are great.

Thanks a lot.

BR,

Nancy

[Former Member]

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

[former_member474881]

Hi Stefasno,

I get the error message when I was trying to execute that file:

./sapdba_role.sql: line 1: syntax error near unexpected token `('

./sapdba_role.sql: line 1: `-- @(#) $Id: //bas/640_REL/src/ccm/rsbr/sapdba_role.sql#5 $ SAP'

Thanks a lot.

BR,

Nancy

[Former Member]

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

.

Regards.

[former_member474881]

Hi Sergo,

oracle = 9.2.0.7

OS = SUSE linux 9

This error appear whenever I run DB13 - redo log backup in SAP. This problem occur ha no relation with kernal right? Is permission problem right?

Thanks a lot.

BR,

Nancy

[Former Member]

Can you connect to Oracle with SQLPLUS? Under ora"sid" -->

sqlplus /nolog

connect /as sysdba

it's works or same ORA-01031: insufficient privileges ?

Regards.

[former_member474881]

Hi Sergo,

I can connect using SQLPLUS, no problem at all.

The error message changed again after I have changed the KERNEL to 196

Now the error message as below:

BR0002I BRARCHIVE 6.40 (39)

BR0006I Start of offline redo log processing: adyhdpvf.svd 2008-07-04 17.10.03

BR0280I BRARCHIVE time stamp: 2008-07-04 17.10.03

BR0301E SQL error -1031 at location BrInitOraCreate-2

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

BR0007I End of offline redo log processing: adyhdpvf.svd 2008-07-04 17.10.03

BR0280I BRARCHIVE time stamp: 2008-07-04 17.10.03

BR0005I BRARCHIVE terminated with errors

[Former Member]

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

Open this file from EDITOR and read header.

P.S. to check your SAP database user in SQLPLUS execute:

SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'T000';

Regards.

[Former Member]

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

[former_member474881]

Hi Scott,

Thanks for your info, but my system is version 6.40. So should be no problem rite?

Thanks.

BR,

Nancy