saplicense.exe -R3Setup SID XXXXXX TRACE=2' exits with error code -2. For details see log file(s) saplicense.log, dev_slic.).

-
Situation:
- A R3load based system copy.
- Source SID = ECP
- Target SID = ECC
- During Database instance installation, hit error while creating temp license.
- snippets in sapinst_dev.log file:

saplicense.exe -R3Setup ECC XXXXXX TRACE=2' exits with error code -2. For details see log file(s) saplicense.log, dev_slic.).

- snipets from dev_slic file:

-->oci_get_errmsg (con=0, rc=959)
   OCIErrorGet -> SQL error code: 959
   ORA-00959: tablespace 'PSAPECP' does not exist                                                                            
   exec_immediate() -> orc=959, 99=DBSL_ERR_DB
   DbSlExecute() -> 99=DBSL_ERR_DB
*** ERROR => DBSL statement where error happend:
   CREATE TABLE MLICHECK (SYSTEMNAME      varchar2(3)  NOT NULL, HARDWAREKEY     varchar2(11) NOT NULL, PRODUCTID       varchar2(20) NOT NULL, CUSTOMERINST    varchar2(10) NOT NULL, SYSID           varchar2(18) NOT NULL, USERLIMIT       number(10)   NOT NULL, CREATION_DATE   varchar2(8)  NOT NULL, EXPIRATION_DATE varchar2(8)  NOT NULL, LCHECK_DATE     varchar2(8)  NOT NULL, LKEY            varchar2(24) NOT NULL, FPRINT          varchar2(24) NOT NULL) STORAGE(initial 16K next 16K pctincrease 0) TABLESPACE PSAPECP                        [slicdb.c     2748]
-->DbSlErrorMsg(con=0, ca=7FEEB23DE60) -> 0=DBSL_ERR_OK

*****************************************************************************
*
*  ERROR       Creation of license table failed
*
*  TIME        Fri Apr 19 01:51:26 2013
*  RELEASE     720
*  COMPONENT   SLIC
*  VERSION     302
*  RC          99
*  MODULE      slicdb.c
*  LINE        1175
*  DETAIL      DbSlExecute failed with return code 99
*              ORA-00959: tablespace 'PSAPECP' does not exist
*  COUNTER     1
*
*****************************************************************************

The issue:

While creating table and index MLICHECK, SAP is putting it in PSAPECP table space, which is my OLD SID. it should be PSAPECC instead, which is my new SID.

So how do we tell SAP to use PSAPECC instead of PSAPECP?
looking in dev_slic file, i found this query:

SELECT T1.TABSPACE, T2.TABSPACE FROM TAORA T1, IAORA T2 WHERE T1.TABART = T2.TABART AND T1.TABART = 'SDIC';

So i queried:

SQL> SELECT T1.TABSPACE, T2.TABSPACE FROM SAPSR3.TAORA T1, SAPSR3.IAORA T2 WHERE
 T1.TABART = T2.TABART AND T1.TABART = 'SDIC';

TABSPACE                       TABSPACE
------------------------------ ------------------------------
PSAPECP                        PSAPECP

SQL>

So the result shows PSAPECP which is my old SID. Further query:

SQL> SELECT TABART, TABSPACE FROM SAPSR3.TAORA
  2  ;

TABAR TABSPACE
----- ------------------------------
APPL0 PSAPSR3
APPL1 PSAPSR3
APPL2 PSAPSR3
CLUST PSAPSR3
DDIM  PSAPDIMD
DFACT PSAPFACTD
DODS  PSAPODSD
POOL  PSAPECP
SDIC  PSAPECP
SDOCU PSAPECP
SLDEF PSAPECP731

TABAR TABSPACE
----- ------------------------------
SLEXC PSAPECP731
SLOAD PSAPECP
SPROT PSAPECP
SSDEF PSAPECP731
SSEXC PSAPECP731
SSRC  PSAPECP
TEMP  PSAPECP
USER  PSAPECPUSR
USER1 PSAPECPUSR

20 rows selected.

SQL>

So hmmmm.. a lot of ECP which is my old SID. i need it to be ECC or SR3.. how do i change it?

Well, update statement will do:

UPDATE SAPSR3.TAORA SET TABSPACE = 'PSAPECC' WHERE TABART='SDIC';

And the error gone. but some other error 1034 database not available, some username/password thingy happened.
but anyway, you got the diea.

chiow.

//alak

Comments

Post a Comment

Popular posts from this blog

SAP: Segregate Different SMTP Mail Server Based on Sender Domain

-
Image
  Requirement : An SAP server, with a single Productive client shared by multiple company codes. Each CoCode would have their own domain (FQDN), and any email send out, for example PO to vendors, are to be sent using each individual CoCode SMTP mail server. Solution Steps: 1. Configure multiple SMTP nodes in Tx SCOT, limiting each node with a Sender Group 2. Set different Sender Group (CDG) parameters for each user of each CoCode (Tx SU01 > Parameters) 3. Test using SCOT's Routing Test feature 4. Profit Detail Step: Logon to SAP system and configure multiple SMTP Node, can use  Continue with SCOT Wizard. Once you get multiple Nodes (as per below screenshot), double click any of them,  In this example, we double click on the "SECOND" node. And then click on "Set" button for the address type you want to configure (that would most probably be for INT type) And click the Pencil icon for setting the Sender Group Here we can set based on FQDN or any string. We are ...
Read more

SAP Client Copy Error: Errors occurred during export of container object FINB-TR-DERIVATION

-
 Reference from: https://www.consultoria-sap.com/2010/03/client-copy-derivation-rule-tables-are.html TL;DR - Execute report ABADRCHECK with selected 'DELSTEPS' //alak ==== Client copy is completed with status "Post-Processing Required". There is an error in log for object FINB-TR-DERIVATION: DA300 "No active nametab exists for *some db table*" Name of db table is usually with naming convention: xxyyyysssmmmnnnn (xx - application class, yyyy - strategy ID, sss - system indicator, mmm - client, nnnn - sequence number) These db tables are part of some instance of derivation tool in your system and are used to store Derivation Rule Values. Other terms ABADR, FINB_TR_CC_EXIT, FINB_TR_CC_EXIT_TARGET, DA 300, DA300, CC, SCC9, SCCL, SCC3 Reason and Prerequisites During processing CC there was huge workload into your system. CC processcreates new tables to store copied derivation rules. This is done in parallel asynchronous process. But due to workload into system, t...
Read more

Quick Dirty Script for Checking Oracle Data Gurad Gap and Emailing it

-
 Situation: primary DB: prd_CCC standby DB: prd_WWW file 1: gap-check.bat @echo off cls echo. echo. echo This script checks for Archive Logs at prd_ccc and Applied Logs at prd_www echo. echo Querying prd_ccc (Primary) echo select max(sequence#) "Primary" from v$archived_log where archived='YES';|sqlplus -s / as sysdba echo Querying prd_www (Standby) echo select max(sequence#) "Standby" from v$archived_log where applied='YES';|sqlplus -s / as sysdba echo. DGMGRL / "show configuration" date /t && time /t && hostname && whoami file 2: emailer.ps1 $Username      = "username" $EmailPassword = "password" $today = Get-Date $Username = $Username $EmailTo = "adam@jasabyte.com"  $EmailFrom = "server@jasabyte.com" $Body = Get-Content .\status.log -Raw $Subject = "PRIMARY/STANDBY DB GAP - $today" $SMTPServer = "mail.smtp2go.com"  $SMTPMessage = New-Object System.Net.Mai...
Read more