Homogeneous System/Copy Error - Creating Temp License

[Former Member]

Good Day,

I am building a TTT system from my PRD system using the homogeneous Database-Specific system/copy method for ORACLE.

The installation is failing at creating temp license phase on the ECC 6. 0 installation.

These are the steps performed so far

1. I am using these two manuals

a. System Copy for SAP Systems Based on SAP Netweaver 7.0 SR3 ABAP

b. SAP Netweaver 7.0 SR3 ABAP on Linux:Oracle

2. Environment of PRD is ECC 6.0 /Oracle 10.2.0.4.0 on Linux 4.6/ IA64.

3. TEST system is on a different IA64 system.

4. The restore of the database was successful using brrecover (note 1003028). The database is up and running.

5. I have received permanent license from OSS for <SID> "TTT", but cannot applied as I cannot logon to SAP.

6. Sample of sapinst.log with the errors

-

---

Output of /usr/sap/TTT/SYS/exe/run/saplicense -R3Setup TTT XXXXXX TRACE=2 is written to the logfile saplicense.log.

WARNING 2011-04-04 10:26:38.185

CJSlibModule::writeWarning_impl()

Execution of the command "/usr/sap/TTT/SYS/exe/run/saplicense -R3Setup TTT XXXXXX TRACE=2" finished with return code 254. Output:

Mon Apr 4 10:26:37 2011

MtxInit: 0 0 0

TRACE 2011-04-04 10:26:38.186

Function setMessageIdOfExceptionMessage: nw.processError

WARNING[E] 2011-04-04 10:26:38.187

CJSlibModule::writeError_impl()

CJS-30023 Process call '/usr/sap/TTT/SYS/exe/run/saplicense -R3Setup TTT XXXXXX TRACE=2' exits with error code 254. For details see log file(s) s

plicense.log, dev_slic.

TRACE 2011-04-04 10:26:38.188 [iaxxejsbas.hpp:483]

EJS_Base::dispatchFunctionCall()

JS Callback has thrown unknown exception. Rethrowing.

TRACE 2011-04-04 10:26:38.193 [syuxctask.cpp:1382]

CSyTaskImpl::start(bool)

A child process has been started. Pid = 31209

TRACE 2011-04-04 10:26:38.202 [syuxctask.cpp:1382]

CSyTaskImpl::start(bool)

A child process has been started. Pid = 31210

ERROR 2011-04-04 10:26:38.209 [sixxcstepexecute.cpp:950]

FCO-00011 The step createTempLicense with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateD

nd|ind|ind|ind|10|0|NW_Postload|ind|ind|ind|ind|10|0|NW_Postload_ORA|ind|ind|ind|ind|0|0|createTempLicense was executed with status ERROR

-

---

Will appreciate any assistance in resolving this issue.

Regards,

Vinood K. Maharaj

[Former Member]

Hi Vinod ,

When you trying to login into SAP what error message you are getting?

If you are able to open login page of SAP then you might be getting error in licnse check.To resolve this issue you need to disable SAP* with login/no_automatic_user_sapstar =0 in default profile and taking a restart of R3. Now login with SAP* user and apply license.

I hope this should resolve your issue.

Thanks..

Mohit

[Former Member]

Hi Mohit,

The installation has not reach the phase to build instance profiles. I know I can manually copy from PRD system and create in TTT system., but I prefer the installation to create them, hnece SAP is not started.

This license issue needs to be resolved 1st, before installation can continue.

Regards,

Vinood.

[Former Member]

Dear Vinood,

have you deleted the old licenses from the source system with saplikey?

[Former Member]

To All Who Responded,

I have resolved the license problem, by removing previous installation and starting from scratch. The installation is now successful.

Thanks again..

Regards

Vinood

[Former Member]

Hi,

similar thing happened to me, the reason was an empty table sapuser after sapinst program recreates the OPS$ users.

If this happens again, check if table sapuser has contents:

select * from OPS$<SID>ADM.sapuser;

if table is empty, just use brtools to update the password for database user, inside the additional functions, , this will correctly update the sapuser table, and license will be correctly installed.

[Former Member]

Ignacio,

  Excellent answer.  I followed those instructions and solved the exact same problem.  I was copying a database from Dev to QA (long story), and ran into the same issue with Oracle 11 and ECC 6.0 EHP5 system copy on AIX/Linux

Thanks,

Phil

[Former Member]

Hi Vinood,

Please copy-paste splicense.log, & dev_slic files here.

Thanks

[Former Member]

Hi Shadowdancer,

Contents of saplicense.log

-

---

Mon Apr 4 10:26:37 2011

MtxInit: 0 0 0

-

---

Contents of dev_slic

========================================================================================

-

---

trc file: "dev_slic", trc level: 2, release: "701"

-

---

SlicIGetDate: <20110404>

SlicPwForR3Setup: calc password out of <TTT20110404FJAWFNLTL>

SlicIGetDate: <20110404>

SlicSapInstall: sysname: >TTT< connect: >1< rollback: >1<

SlicIDbLock: first call to SlicIDbLock: initialize Mutex

db_con_init called

create_con (con_name=R/3)

Loading DB library '/usr/sap/TTT/SYS/exe/run/dboraslib.so' ...

DlLoadLib() success: dlopen("/usr/sap/TTT/SYS/exe/run/dboraslib.so"), hdl 0

Library '/usr/sap/TTT/SYS/exe/run/dboraslib.so' loaded

function DbSlExpFuns loaded from library /usr/sap/TTT/SYS/exe/run/dboraslib.so

Version of '/usr/sap/TTT/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.79)

function dsql_db_init loaded from library /usr/sap/TTT/SYS/exe/run/dboraslib.so

function dbdd_exp_funs loaded from library /usr/sap/TTT/SYS/exe/run/dboraslib.so

New connection 0 created

000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

db_con_connect (con_name=R/3)

find_con_by_name found the following connection for reuse:

000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

-->oci_init1

Oracle Client Version: '10.2.0.4.0'

Default connection: tnsname ='TTT'

-->oci_initialize(con_hdl=0, char='', nchar='')

application info callback registered

OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrHp=0x60000000002a3fd0)

OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrBt=0x60000000002b46c8)

Client character set UTF16 -> UTF8

Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

charset='', chset='UTF8', UNI_ASC=FALSE/FALSE

Logon as OPS$-user to get SAPPRD's password

Connecting as /@TTT on connection 0 (nls_hdl 0) ... (dbsl 701 280110)

Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

0 UTF8 0x600000000029c530 0x60000000002a3fd0 0x60000000002b46c8

Allocating service context handle for con_hdl=0

Allocating server context handle

Attaching to DB Server TTT (con_hdl=0,svchp=0x60000000002b45f8,srvhp=0x60000000002b68d8)

Mon Apr 4 10:26:38 2011

Assigning server context 0x60000000002b68d8 to service context 0x60000000002b45f8

Allocating user session handle

Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x60000000002b45f8, srvhp=0x60000000002b68d8, usrhp=0x60000000002f6be0)

Assigning user session 0x60000000002f6be0 to service context 0x60000000002b45f8

-->oci_prepare_stmt(con_hdl=0, len=52, stmth_p=0x60000000002c0068)

BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1);END;

- oci_bind ( 0: SQLT_STR, l=600, con_hdl=0, stmth_p=0x60000000002c0068, vp=0x200000000163e144,ip=0x2000000001438d1c,rlp=(nil),rcp=(nil))

- oci_bind ( 1: SQLT_STR, l=600, con_hdl=0, stmth_p=0x60000000002c0068, vp=0x200000000163e39c,ip=0x2000000001438d1e,rlp=(nil),rcp=(nil))

CbApplInfoGet() failed (ignored 1).

-->oci_prepare_stmt(con_hdl=0, len=54, stmth_p=0x60000000002c10c0)

BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END;

- oci_bind ( 0: SQLT_STR, l= 40, con_hdl=0, stmth_p=0x60000000002c10c0, vp=0x2000000001439390,ip=(nil),rlp=(nil),rcp=(nil))

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c10c0, iters=1, rowoff=0, dml_batch_errors=0)

<--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,001s]

-->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x60000000002c10c0)

SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

-->oci_define ( 0: SQLT_INT, l= 4, con_hdl=0, stmth_p=0x60000000002c10c0, vp=0x60000fffffff9c54,ip=0x60000fffffff9c50,rlp=(nil),rcp=(nil))

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c10c0, iters=1, rowoff=0, dml_batch_errors=0)

<--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,000s]

Connected to session 108.

Now '/@TTT' is connected: con_hdl=0, nls_hdl=0, session_id=108.

-->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x60000000002c10c0)

ALTER SESSION SET NLS_SORT = BINARY

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c10c0, iters=1, rowoff=0, dml_batch_errors=0)

<--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,000s]

-->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x60000000002c10c0)

SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0,:A1)

- oci_bind ( 0: SQLT_STR, l=256, con_hdl=0, stmth_p=0x60000000002c10c0, vp=0x20000000016937f6,ip=(nil),rlp=(nil),rcp=(nil))

- oci_bind ( 1: SQLT_STR, l=256, con_hdl=0, stmth_p=0x60000000002c10c0, vp=0x60000fffffffa080,ip=(nil),rlp=(nil),rcp=(nil))

-->oci_define ( 0: SQLT_STR, l=512, con_hdl=0, stmth_p=0x60000000002c10c0, vp=0x60000fffffffa280,ip=0x60000fffffff9e30,rlp=(nil),rcp=(nil))

-->oci_define ( 1: SQLT_AFC, l=512, con_hdl=0, stmth_p=0x60000000002c10c0, vp=0x60000fffffffa480,ip=0x60000fffffff9e32,rlp=(nil),rcp=(nil))

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c10c0, iters=1, rowoff=0, dml_batch_errors=0)

OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data

-> rc=1403=OCI_ERR_NOT_FOUND

<--oci_execute_stmt(rc=1403, iters-errors = 1-0) [time 0,000s]

• ERROR => ORA-1403 when accessing table SAPUSER [dbsloci.c 11813]

set_ocica() -> SQL code 1403

-->oci_get_errmsg (con_hdl=0, rc=1403)

OCIErrorGet -> SQL error code: 1403

ORA-01403: no data found

Disconnecting from connection 0 ...

Rolling back transaction ...

Closing user session (con_hdl=0,svchp=0x60000000002b45f8,usrhp=0x60000000002f6be0)

Now I'm disconnected from ORACLE

Info: 99=DBSL_ERR_DB, oerr=1403, try to connect with default password.

Connecting as SAPPRD/<pwd>@TTT on connection 0 (nls_hdl 0) ... (dbsl 701 280110)

Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

0 UTF8 0x600000000029c530 0x60000000002a3fd0 0x60000000002b46c8

Assigning username to user session: con_hdl=0, usrhp=0x60000000002f6be0

Assigning password to user session: con_hdl=0, usrhp=0x60000000002f6be0

Starting user session: OCISessionBegin(con_hdl=0, usr=SAPPRD/<pwd>, svchp=0x60000000002b45f8, srvhp=0x60000000002b68d8, usrhp=0x60000000002f6be0)

Assigning user session 0x60000000002f6be0 to service context 0x60000000002b45f8

-->oci_prepare_stmt(con_hdl=0, len=52, stmth_p=0x60000000002c10c0)

BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1);END;

- oci_bind ( 0: SQLT_STR, l=600, con_hdl=0, stmth_p=0x60000000002c10c0, vp=0x200000000163e144,ip=0x2000000001438d1c,rlp=(nil),rcp=(nil))

- oci_bind ( 1: SQLT_STR, l=600, con_hdl=0, stmth_p=0x60000000002c10c0, vp=0x200000000163e39c,ip=0x2000000001438d1e,rlp=(nil),rcp=(nil))

-->oci_prepare_stmt(con_hdl=0, len=54, stmth_p=0x60000000002c0068)

BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END;

- oci_bind ( 0: SQLT_STR, l= 40, con_hdl=0, stmth_p=0x60000000002c0068, vp=0x2000000001439390,ip=(nil),rlp=(nil),rcp=(nil))

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c0068, iters=1, rowoff=0, dml_batch_errors=0)

<--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,000s]

-->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x60000000002c0068)

SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

-->oci_define ( 0: SQLT_INT, l= 4, con_hdl=0, stmth_p=0x60000000002c0068, vp=0x60000fffffffa4a4,ip=0x60000fffffffa4a0,rlp=(nil),rcp=(nil))

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c0068, iters=1, rowoff=0, dml_batch_errors=0)

<--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,001s]

Connected to session 108.

Now 'SAPPRD/<pwd>@TTT' is connected: con_hdl=0, nls_hdl=0, session_id=108.

-->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x60000000002c0068)

ALTER SESSION SET NLS_SORT = BINARY

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c0068, iters=1, rowoff=0, dml_batch_errors=0)

<--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,000s]

-->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x60000000002c0068)

SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER IN ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET') ORDER BY PARAMET

ER

-->oci_define ( 0: SQLT_STR, l=202, con_hdl=0, stmth_p=0x60000000002c0068, vp=0x60000fffffffab56,ip=0x60000fffffffa846,rlp=(nil),rcp=(nil))

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c0068, iters=3, rowoff=0, dml_batch_errors=0)

<--oci_execute_stmt(rc=0, iters-errors = 3-0) [time 0,000s]

Database NLS settings: AMERICAN_AMERICA.UTF8

-->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x60000000002c0068)

SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER='NLS_LENGTH_SEMANTICS'

-->oci_define ( 0: SQLT_STR, l=130, con_hdl=0, stmth_p=0x60000000002c0068, vp=0x60000fffffffa846,ip=0x60000fffffffa690,rlp=(nil),rcp=(nil))

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c0068, iters=1, rowoff=0, dml_batch_errors=0)

<--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,000s]

V$NLS_PARAMETERS: NLS_LENGTH_SEMANTICS='BYTE'

-->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x60000000002c0068)

SELECT UPPER(INSTANCE_NAME),HOST_NAME,VERSION,TO_CHAR(STARTUP_TIME,'MON DD, YYYY, HH24:MI:SS') FROM V$INSTANCE

-->oci_define ( 0: SQLT_STR, l= 66, con_hdl=0, stmth_p=0x60000000002c0068, vp=0x2000000001693630,ip=0x60000fffffffa340,rlp=(nil),rcp=(nil))

-->oci_define ( 1: SQLT_STR, l=130, con_hdl=0, stmth_p=0x60000000002c0068, vp=0x2000000001693878,ip=0x60000fffffffa340,rlp=(nil),rcp=(nil))

-->oci_define ( 2: SQLT_STR, l= 66, con_hdl=0, stmth_p=0x60000000002c0068, vp=0x20000000016935ee,ip=0x60000fffffffa340,rlp=(nil),rcp=(nil))

-->oci_define ( 3: SQLT_STR, l= 60, con_hdl=0, stmth_p=0x60000000002c0068, vp=0x60000fffffffa342,ip=0x60000fffffffa340,rlp=(nil),rcp=(nil))

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c0068, iters=1, rowoff=0, dml_batch_errors=0)

<--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,000s]

DB instance TTT is running on papblprd with ORACLE version 10.2.0.4.0 since APR 04, 2011, 06:07:57

-->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x60000000002c0068)

SELECT SUBSTR(NAME,1,3), TO_CHAR(CREATED,'YYYYMMDDHHMMSS') FROM V$DATABASE

-->oci_define ( 0: SQLT_CHR, l= 6, con_hdl=0, stmth_p=0x60000000002c0068, vp=0x60000fffffffa3f0,ip=0x60000fffffffa340,rlp=(nil),rcp=(nil))

-->oci_define ( 1: SQLT_STR, l= 30, con_hdl=0, stmth_p=0x60000000002c0068, vp=0x60000fffffffa342,ip=0x60000fffffffa340,rlp=(nil),rcp=(nil))

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c0068, iters=1, rowoff=0, dml_batch_errors=0)

<--oci_execute_stmt(rc=0, iters-errors = 1-0) [time 0,002s]

Connection 0 opened (DBSL handle 0)

build_stmt: reallocating stmt buffer: 256 -> 2000 characters

-->oci_prepare_stmt(con_hdl=0, len=20, stmth_p=0x60000000002c0068)

DROP INDEX MLICHECK0

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c0068, iters=1, rowoff=0, dml_batch_errors=0)

OCIStmtExecute() failed with -1=OCI_ERROR

SQL error 1418:

ORA-01418: specified index does not exist

<--oci_execute_stmt(rc=1418, rows processed 0, iters-errors = 1-0) [time 0,001s]

set_ocica() -> SQL error code 1418

-->oci_get_errmsg (con_hdl=0, rc=1418)

OCIErrorGet -> SQL error code: 1418

ORA-01418: specified index does not exist

License index MLICHECK0 not found( - ok)

-->oci_prepare_stmt(con_hdl=0, len=22, stmth_p=0x60000000002c0068)

DROP INDEX MLICHECK__0

-->oci_execute_stmt(con_hdl=0, stmth_p=0x60000000002c0068, iters=1, rowoff=0, dml_batch_errors=0)

OCIStmtExecute() failed with -1=OCI_ERROR

SQL error 1418:

ORA-01418: specified index does not exist

<--oci_execute_stmt(rc=1418, rows processed 0, iters-errors = 1-0) [time 0,000s]

set_ocica() -> SQL error code 1418

-->oci_get_errmsg (con_hdl=0, rc=1418)

OCIErrorGet -> SQL error code: 1418

ORA-01418: specified index does not exist

========================================================================================

Regards,

Vinood

[Former Member]

Hi Vinood,

I found sapnote: 88886 which explains ORA-1408 during saplicense installation.

Here is the excerpt:

The index MLICHECK__0 must be deleted before you call saplicense or restart the phase in the R3INST with database tools.

To do this delete the index with sqlplus, sqldba or svrmgrl: drop index sapr3.mlicheck__0;

The problem can no longer occur as of 3.1H since index MLICHECK__0 is used for table MLICHECK as of 3.1H.

The index name corresponds to the SAP naming conventions.

Kindly try and inform us what is the result.

Thanks

[Former Member]

Hi Shadowdancer,

I see you indicate ORA-1408 in your response, however the log refers to ORA-01418. Are you saying that applying this note will correct also error ORA-01418 ?

Regards,

Vinood.

[Former Member]

Hi Vinood,

Sorry. The case wa the same, but your case seem to be the opposite of the sapnote.

On the sapnote, the index already exists, but in your case, the index does not exists during the deletion.

Could you please check table MLICHECK from your source and target system, and check the index for that table both in source and target system?

Can you perform brtools in your source system using ora<SID>?

Currently I don't have access to SAP system, I will update you soon.

Thank you.

Edited by: Shadowdancer on Apr 5, 2011 3:21 PM

[Former Member]

Dear Vinood,

First, we need to check whether an index for table MLICHECK really exists.

Run the following command, then choose 3 then 2 (I put star on the option given).

 
xxxxxx:orasdb 1> brspace -f dbshow -t mlicheck
BR1001I BRSPACE 7.00 (40)
BR1002I Start of BRSPACE processing: sefpevln.dbw 2011-04-05 20.17.03

BR0101I Parameters

Name                           Value

oracle_sid                     SDB
oracle_home                    /oracle/SDB/102_64
oracle_profile                 /oracle/SDB/102_64/dbs/initSDB.ora
sapdata_home                   /oracle/SDB
sap_profile                    /oracle/SDB/102_64/dbs/initSDB.sap
space_function                 dbshow
space_copy_dir                 /oracle/SDB/sapreorg
scroll_lines                   20
system_info                    orasdb/orasdb abyor01 Linux 2.6.18-128.el5 #1 SMP Wed Dec 17 11:41:38 EST 2008 x86_64
oracle_info                    SDB 10.2.0.4.0 8192 278 2910281 abyor01  
sap_info                       701 SAPSR3 SSX TEMPLICENSE R3_ORA INITIAL
make_info                      linuxx86_64 OCI_102 Feb 20 2009
command_line                   brspace -f dbshow -t mlicheck

BR0280I BRSPACE time stamp: 2011-04-05 20.17.04
BR1009I Name of database instance: SDB
BR1010I BRSPACE action ID: sefpevln
BR1011I BRSPACE function ID: dbw
BR1012I BRSPACE function: dbshow

BR0280I BRSPACE time stamp: 2011-04-05 20.17.04
BR0656I Choice menu 251 - please make a selection
-------------------------------------------------------------------------------
Show database information main menu

 1 = Show database instance information
 2 - Show database space information
 3 - Show database segment information
 4 - Exit program                                                                                
Standard keys: c - cont, b - back, s - stop, r - refr, h - help                                                                                
-------------------------------------------------------------------------------                                                                                
BR0662I Enter your choice:
*3*
BR0280I BRSPACE time stamp: 2011-04-05 20.17.09
BR0663I Your choice: '3'

BR0280I BRSPACE time stamp: 2011-04-05 20.17.09
BR0656I Choice menu 254 - please make a selection
-------------------------------------------------------------------------------
Show database segment information

 1 = Show tables
 2 - Show indexes
 3 - Show table partitions
 4 - Show index partitions
 5 - Show segments
 6 - Show segment extents
 7 - Show free extents
 8 - Back to previous menu
 9 - Reset segment info

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
*2*
BR0280I BRSPACE time stamp: 2011-04-05 20.17.13
BR0663I Your choice: '2'

BR0280I BRSPACE time stamp: 2011-04-05 20.17.14
BR0692I Display menu 272 # no input possible
-------------------------------------------------------------------------------
Information about index SAPSR3.MLICHECK~0

 1 - Unique index (unique) ............... YES
 2 - Bitmap index (bitmap) ............... NO
 3 - Partitioned index (partitioned) ..... NO
 4 - Number of partitions (partitions) ... 
 5 - Parallel degree (degree) ............ 1
 6 - Table name (table) .................. MLICHECK
 7 - Tablespace name (tablespace) ........ PSAPSR3
 8 - Last analyzed (analyzed) ............ 2011-03-31 22.18.24
 9 - Sample size (sample) ................ 1
10 - Number of rows (rows) ............... 1
11 - Allocated space in KB (space) ....... 0
12 - Used space in KB / % (used) ......... 0 / 0.00
13 - Pure data in KB / % (data) .......... 0 / 0.00
14 - Next extend size in KB (next) ....... 
15 - Maximum number of extents (maxexts) . 2147483645

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:

If your result same with my screen above, than the index is exists, other than that, the index probably doesn't exists.

If your index doesn't exists try rebuild it by the following command, then put 1 then c as option.

brspace -f idrebuild -t mlicheck

If your index generation is success, then retry the sapinst.

If not, please inform us what the error message is.

Hope this help.

Thank you

Edited by: Shadowdancer on Apr 6, 2011 9:51 AM

[Former Member]

Hi Shadowdancer,

The results exist similar to yours, thus indicating that the index does exist.

BR0692I Display menu 272 # no input possible

-

---

Information about index SAPPRD.MLICHECK~0

1 - Unique index (unique) ............... YES

2 - Bitmap index (bitmap) ............... NO

3 - Partitioned index (partitioned) ..... NO

4 - Number of partitions (partitions) ...

5 - Parallel degree (degree) ............ 1

6 - Table name (table) .................. MLICHECK

7 - Tablespace name (tablespace) ........ PSAPPRD

8 - Last analyzed (analyzed) ............ 2010-11-20 06.04.27

9 - Sample size (sample) ................ 1

10 - Number of rows (rows) ............... 1

11 - Allocated space in KB (space) ....... 64

12 - Used space in KB / % (used) ......... 8 / 12.50

13 - Pure data in KB / % (data) .......... 0 / 0.00

14 - Next extend size in KB (next) .......

15 - Maximum number of extents (maxexts) . 2147483645

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

Here are the last few lines of sapinst.log

INFO 2011-04-07 20:50:50.990

Creating file /tmp/sapinst_instdir/ERPEhP4/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/saplicense.log.

INFO 2011-04-07 20:50:51.010

Output of /usr/sap/TTT/SYS/exe/run/saplicense -R3Setup TTT XXXXXX TRACE=2 is written to the logfile saplicense.log.

WARNING 2011-04-07 20:50:51.601

Execution of the command "/usr/sap/TTT/SYS/exe/run/saplicense -R3Setup TTT XXXXXX TRACE=2" finished with return code

254. Output:

Thu Apr 7 20:50:51 2011

MtxInit: 0 0 0

WARNING[E] 2011-04-07 20:50:51.603

CJS-30023 Process call '/usr/sap/TTT/SYS/exe/run/saplicense -R3Setup TTT XXXXXX TRACE=2' exits with error code 254.

For details see log file(s) saplicense.log, dev_slic.

ERROR 2011-04-07 20:50:51.631

FCO-00011 The step createTempLicense with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|i

nd|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_Postload|ind|ind|ind|ind|10|0|NW_Postload_ORA|ind|ind|ind|ind|

0|0|createTempLicense was executed with status ERROR .

Regards,

Vinood.