on 07-04-2008 8:06 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
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
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
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
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
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
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.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.