BR0602E No valid SAP license found

[Former Member]

Hello, we have severall standalone Oracle Databases and we use Brtools for backup and restore. It works very well a while but after adding a new datafile to a tablespace we get the following error: BR0602E No valid SAP license found - please contact SAP

It's not possible to use the brtools again. We checked all SAP Notes special 320457, use several versions of brtools but nothing works.

What can we do? Has anybody an idea?

Regards horst

[Former Member]

I met the same problem. Have you solved it ?

Thank  you

[Former Member]

Hi Ray,

Check the OSS note 320457 - Installing BR tools on a non-ABAP database

Best regards,

Orkun Gedik

[Former Member]

Thank you, Orkun. I'll check the notes and let you know the result.

[Former Member]

Hi Horst,

Sorry for the late reply.

I would like suggest the following.

1. Find out what user are performing the brtools?

2. As that user, check using command "saplicense -show"

3. The error may be useful for further analysis

Thanks

[Former Member]

HI,

I'm having same issue, was your issue resolved.

Please guide.

Kobby

[Former Member]

Is it possible that we have to set a new entry in the initSID.sap ?

regards

horst

[Former Member]

Hello Horst,

How did you add a datafile? Is there a log of that action?

For example, if you used brspace, there will be a log file with extension .tse.

And besides that:

The following is just a wild guess, and may be a silly idea, but for lack of other ideas:

Make sure Unix permissions and ownership for the new data file and its parent directory are exactly the same as for the old files.

regards

[Former Member]

Hello,

you only have standalone ORACLE DB without any SAP System on top - thats right ?? and you have no MLICHECK or SAPLIKEY tables inside your ORACLE DB - right ?

I think your problem is the version of your 10g ORACLE DB - '10.2.0.1.0 - this version never was released from SAP.

together with the statement in Note 320457

BR*Tools only usable for ORACLE DBs from SAP Components

I m not be sure but I think it is a possibility for your problem

Regards

Peter

[Former Member]

OK, this is the trace output.

I hope you can help us. Everything works fine before we added a new datafile to a tablespace. After adding the datafile we get this error:

BR0002I BRARCHIVE 7.00 (49)

BR0248I BR_TRACE: level 0, function main entry with 'brarchive -u / -sd -c'

BR0006I Start of offline redo log processing: aeedyjzn.svd 2010-09-20 15.08.27

BR0484I BRARCHIVE log file: /oracle/SZP/dbatools/saparch/aeedyjzn.svd

BR0280I BRARCHIVE time stamp: 2010-09-20 15.08.27

BR0644I BR_TRACE: location BrDbConnect-2, SQL statement:

'CONNECT /'

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

BR0644I BR_TRACE: location BrDbConnect-3, SQL statement:

'ALTER SESSION SET TRACEFILE_IDENTIFIER = "aeedyjzn_svd"'

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

BR0644I BR_TRACE: location BrDbConnect-4, SQL statement:

'ALTER SESSION SET SQL_TRACE = TRUE'

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

BR0644I BR_TRACE: location BrDbConnect-5, SQL statement:

'SELECT NAME, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CH

AR(CREATED, 'YYYYMMDDHH24MISS')), 0) FROM V$DATABASE WHERE ROWNUM = 1'

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

BR0645I BR_TRACE: location BrDbConnect-6, SQL output:

'SZP', '551299', '20070627100737', '20070627100733'

BR0644I BR_TRACE: location BrDbConnect-11, SQL statement:

'SELECT TO_NUMBER(VALUE) FROM V$PARAMETER WHERE NAME = 'db_block_size''

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

BR0645I BR_TRACE: location BrDbConnect-12, SQL output:

'8192'

BR0644I BR_TRACE: location BrDbConnect-13, SQL statement:

'SELECT BLOCK_SIZE FROM V$ARCHIVED_LOG WHERE ROWNUM = 1'

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

BR0645I BR_TRACE: location BrDbConnect-14, SQL output:

'512'

BR0644I BR_TRACE: location ora_vers_get-1, SQL statement:

'SELECT INSTANCE_NAME, INSTANCE_NUMBER, VERSION, HOST_NAME, ARCHIVER, NVL(PARALLEL, ' ') FROM V$INSTANCE WHERE ROWNUM = 1'

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

BR0645I BR_TRACE: location ora_vers_get-2, SQL output:

'SZP', '1', '10.2.0.1.0', 'szdemhgx5184', 'STARTED', 'NO'

BR0644I BR_TRACE: location ora_vers_get-3, SQL statement:

'SELECT RESETLOGS_ID FROM V$DATABASE_INCARNATION WHERE STATUS = 'CURRENT''

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

BR0645I BR_TRACE: location ora_vers_get-4, SQL output:

'626350057'

BR0280I BRARCHIVE time stamp: 2010-09-20 15.08.27

BR0644I BR_TRACE: location BrInitOraCreate-2, SQL statement:

'CONNECT / AT PROF_CONN IN SYSOPER MODE'

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

BR0644I BR_TRACE: location BrInitOraCreate-5, SQL statement:

'/* BRARCHIVE AT PROF_CONN */ CREATE PFILE = '/oracle/SZP/102/dbs/sapSZP.ora' FROM SPFILE = '/oracle/SZP/102/dbs/spfileSZP.o

ra''

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

BR0477I Oracle pfile /oracle/SZP/102/dbs/initSZP.ora created from spfile /oracle/SZP/102/dbs/spfileSZP.ora

BR0280I BRARCHIVE time stamp: 2010-09-20 15.08.27

BR0644I BR_TRACE: location BrInitOraCreate-9, SQL statement:

'/* AT PROF_CONN */ COMMIT RELEASE'

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

BR0644I BR_TRACE: location BrDbaSynCheck-1, SQL statement:

'SELECT COUNT(*) FROM SAP_SDBAH WHERE BEG = '00000000000000''

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

BR0645I BR_TRACE: location BrDbaSynCheck-2, SQL output:

'0'

BR0644I BR_TRACE: location BrLicCheck-1, SQL statement:

'SELECT VERSION FROM SAP_SVERS WHERE ROWNUM = 1'

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

BR0644I BR_TRACE: location BrLicCheck-3, SQL statement:

'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

BR0645I BR_TRACE: location BrLicCheck-4, SQL output:

'SAPR3'

BR1304E Checking SAP license failed at location BrLicCheck-103

BR0602E No valid SAP license found - please contact SAP

BR0644I BR_TRACE: location BraDbLogOpen-1, SQL statement:

'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

BR0645I BR_TRACE: location BraDbLogOpen-2, SQL output:

'SAPR3'

BR0644I BR_TRACE: location BraDbLogOpen-3, SQL statement:

'SELECT DATA_LENGTH FROM DBA_TAB_COLUMNS WHERE OWNER = 'SAPR3' AND TABLE_NAME = 'DBABL' AND COLUMN_NAME = 'ARCH_NR''

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

BR0644I BR_TRACE: location BraDbLogOpen-5, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20100920150827', 'svd', 'SZP', 'util_file',

'9999', ' ', 'aeedyjzn', '7.00 (49)')'

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

BR0644I BR_TRACE: location BraDbLogOpen-13, SQL statement:

'INSERT INTO SAP_DBATL (SYS_ID, OPER_ID, TASKNAME, JOB_NR, UPD_OP, TLOGNAME, STATUS, BEGIN_OP, END_OP, RC, INTERNAL) VALUES

('SZP', '20100920150827', 'Archivelog backup', '0000000000', '20100920150828', '/oracle/SZP/dbatools/saparch/aeedyjzn.svd',

'STARTED', '20100920150827', ' ', '0000', ' ')'

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

BR0644I BR_TRACE: location BraDbLogOpen-15, SQL statement:

'INSERT INTO SAP_DBAML (OPER_ID, FUNC_ID, UPD_OP, LOG_NAME, PROGNAME, STATUS, BEGIN_OP, END_OP, RC, INTERNAL) VALUES ('20100

920150827', 'svd', '20100920150828', '/oracle/SZP/dbatools/saparch/aeedyjzn.svd', 'BRARCHIVE', 'STARTED', '20100920150827',

' ', '0000', 'aeedyjzn util_file 7.00 (49)')'

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

BR0644I BR_TRACE: location BrLicCheck-3, SQL statement:

'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

BR0645I BR_TRACE: location BrLicCheck-4, SQL output:

'SAPR3'

BR1304E Checking SAP license failed at location BrLicCheck-103

BR0602E No valid SAP license found - please contact SAP

BR0644I BR_TRACE: location BraDbLogOpen-1, SQL statement:

'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

BR0645I BR_TRACE: location BraDbLogOpen-2, SQL output:

'SAPR3'

BR0644I BR_TRACE: location BraDbLogOpen-3, SQL statement:

'SELECT DATA_LENGTH FROM DBA_TAB_COLUMNS WHERE OWNER = 'SAPR3' AND TABLE_NAME = 'DBABL' AND COLUMN_NAME = 'ARCH_NR''

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

BR0644I BR_TRACE: location BraDbLogOpen-5, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20100920150827', 'svd', 'SZP', 'util_file',

'9999', ' ', 'aeedyjzn', '7.00 (49)')'

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

BR0644I BR_TRACE: location BraDbLogOpen-13, SQL statement:

'INSERT INTO SAP_DBATL (SYS_ID, OPER_ID, TASKNAME, JOB_NR, UPD_OP, TLOGNAME, STATUS, BEGIN_OP, END_OP, RC, INTERNAL) VALUES

('SZP', '20100920150827', 'Archivelog backup', '0000000000', '20100920150828', '/oracle/SZP/dbatools/saparch/aeedyjzn.svd',

'STARTED', '20100920150827', ' ', '0000', ' ')'

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

BR0644I BR_TRACE: location BraDbLogOpen-15, SQL statement:

'INSERT INTO SAP_DBAML (OPER_ID, FUNC_ID, UPD_OP, LOG_NAME, PROGNAME, STATUS, BEGIN_OP, END_OP, RC, INTERNAL) VALUES ('20100

920150827', 'svd', '20100920150828', '/oracle/SZP/dbatools/saparch/aeedyjzn.svd', 'BRARCHIVE', 'STARTED', '20100920150827',

' ', '0000', 'aeedyjzn util_file 7.00 (49)')'

[Former Member]

Hi, it's not working, we checked all but we get the same error message:

BR1304E Checking SAP license failed at location BrLicCheck-103

BR0602E No valid SAP license found - please contact SAP

Any other idea?

regrads

Horst

[former_member204746]

what is the version and patch level or BRTOOLS? use the latest package to fix your problem.

[Former Member]

Hello,

Just try to activate trace for BRTOOLS and then check the logs.

You can activate a trace of the BR Tools by setting environment variable BR_TRACE = or by setting the parameter "-TRC ".

Regards,

Yoganand.V

[Former Member]

Hi,

As per the [SAP Note 912969 - BRTools 7.00 fails due to license problems|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=912969], this issue is caused by a program error and the resolution steps are also available in the note itself.

If u have not come across the note, please go through the same and implement the corrections.

Hope this resolves ur issue.

Regards,

Varadharajan M