on 04-02-2013 2:18 PM
Dear all,
I've finished the Export for OS migration of Non-Unicode Central instance SAP ECC6.0 NW70 SR2 Oracle 11.2.0.3 on HP-UX 11.31. to RedHat 6.
I've installed Oracle 11.2.0.3 with the latest bundel patches on RedHat 6.
Now I've started the SWPM 1.0 to install the target system and import. I've proceed with the installation of the target, and I've got new error in sapinst.log:
CJS-30022 Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.
In the import_monitor.log there was 4 Errors:
Loading of 'SAPSLEXC' import package is interrupted with R3load error.
Loading of 'SAPAPPL1' import package is interrupted with R3load error.
Loading of 'SAPSSEXC' import package is interrupted with R3load error.
Loading of 'SAP0000' import package is interrupted with R3load error.
In the logs SAPSLEXC.log, SAP0000.log, SAPSLEXC.log, the same errors:
ORA-00959: tablespace 'PSAPSR370000D' does not exist
DbSl Trace: ORA-1403 when accessing table SAPUSER
In SAPAPPL1.log just the error :
DbSl Trace: ORA-1403 when accessing table SAPUSER
This tablespace PSAPSR370000D does not exist on the source system.
TAORA from source system:
APPL0 PSAPSTABD
APPL1 PSAPBTABD
APPL2 PSAPPOOLD
CLUST PSAPCLUD
DDIM PSAPCLUD
DFACT PSAPCLUD
DODS PSAPCLUD
POOL PSAPPOOLD
SDIC PSAPDDICD
SDOCU PSAPDOCUD
SLDEF PSAPEL700D
SLEXC PSAPEL700D
SLOAD PSAPLOADD
SPROT PSAPPROTD
SSDEF PSAPES700D
SSEXC PSAPES700D
SSRC PSAPSOURCED
TEMP PSAPPROTD
USER PSAPUSER1D
USER1 PSAPUSER1D
Because of the schema on the source SAPR3 I've selected the new schema in the target SAPSR3.
I've also find the Note 1765619 - ORA-00922: missing or invalid option and Note 957917 - ORA: Conversion from old to new tablespace layout.
I was wondering if these notes can help, but in the DDLORA.TPL in the export directory there is no variable @SCHEMAID@ , just
TABLESPACE &tablespace&. That's why I don't know how these notes can help.
And the tablespace PSAPSR370000D is very stange because of the 5 zeros, I think it should be 3 zeros.
From the Note 957917, PSAP*<RELEASE>* ==> PSAP@SCHEMAID@<RELEASE>
For our tablespaces should be converted as:
PSAPEL700D ==> PSAPSR3700D
PSAPES700D ==> PSAPSR3700D
not PSAPSR370000D
I've also looked in the Notes 1689026 - Installation of NW 7.0x Systems with Oracle Client 11.2.0x and Note 1642058 - Adapt SAPInst Oracle Clien 11.2.0.x. Should I implement Method 1 from the above notes or not beacuse I'm using the SWPM tool and the last 720_EXT kernel and the link for Oracle client 10x_64 to 11x_64 was already prepared durring the installation? Or this is not the case.
How I can proceed with the import of the target?
Thank you in advance.
Thank you in advance.
BR,
Ruzica
Hi Ruzica,
Refer SAP Note 1677201 - Oracle 11g: Dictionary corruption / ORA-959 due to DROP TBS
SAP note talks about Latest bundle patch for 11.2.0.3 dated March 2013.
If this bundle patch is not applied , you may follow the workaround mentioned in this note.
DROP TABLESPACE PSAPSR370000D INCLUDING CONTENTS AND DATAFILES ;
Hope this helps.
PS: You have posted same query in following thread. http://scn.sap.com/thread/3334077
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak,
These are the new tablespaces created on the target. There is no tablespace PSAPSR370000D
Something is wrong with the mapping in the DDLORA.TPL
SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
SYSAUX
PSAPUNDO
PSAPTEMP
PSAPSR3
PSAPSR3700
PSAPSR3USR
7 rows selected.
SQL>
Thank you in advance,.
BR,
Ruzica
Hi Ruzica,
You are correct... Something is wrong in your DDLORA.TPL file.
Please check the following.
1. Please go to /export location/ABAP/DB/ORA and open the DDLORA.TPL check whether there is any tablespace like PSAPSR370000D ..
2. Please go to your /sapinst_instdir/*/*/*/*/*/* and open DDLORA.TPL and check the same.
If any of the above you can find PSAPSR370000D , then replace it accordingly in your sapinst_instdir location.
If not, you have to manually edit the DDLORA.TPL...
I have faced this issue before during one migration and I have manually edited the TPL file and restarted the import and it went well.
Can you please send me the DDLORA.TPL file to mjvimalan@gmail.com?
Secondly please execute the following commands in your source system and share the output also.
select name from v$tablespace;
Thanks and Regards,
Vimal
Hello Vimal,
There is no tablespace PSAPSR370000D in DDLORA.TPL in the export location just in the DDLORA.TPL in the /sapinst_instdir/*/*/*/*/*/*
DDLORA.TPL from the installation dir:
# cat DDLORA.TPL
prikey: AFTER_LOAD ORDER_BY_PKEY
seckey: AFTER_LOAD
cretab: CREATE TABLE &tab_name&
( /{ &fld_name& &fld_desc& /-, /} )
TABLESPACE &tablespace&
&compress&
&lob_cache&
STORAGE (INITIAL &init&
NEXT &next&
MINEXTENTS &minext&
MAXEXTENTS &maxext&
PCTINCREASE &pctinc& )
drptab: DROP TABLE &tab_name&
crepky: CREATE UNIQUE INDEX &pri_key&
ON &tab_name&
( &key_fld& /-, )
TABLESPACE &tablespace&
STORAGE (INITIAL &init&
NEXT &next&
MINEXTENTS &minext&
MAXEXTENTS &maxext&
PCTINCREASE &pctinc& )
NOLOGGING
COMPUTE STATISTICS ;
ALTER INDEX &pri_key& LOGGING
drppky: DROP INDEX &pri_key&
creind: CREATE &unique& INDEX &ind_name&
ON &tab_name&
( /{ &fld_name& /-, /} )
TABLESPACE &tablespace&
STORAGE (INITIAL &init&
NEXT &next&
MINEXTENTS &minext&
MAXEXTENTS &maxext&
PCTINCREASE &pctinc& )
NOLOGGING
COMPUTE STATISTICS ;
ALTER INDEX &ind_name& LOGGING
drpind: DROP INDEX &ind_name&
crevie: CREATE VIEW &view_name&
( /{ &fld_name& /-, /} )
AS &query&
drpvie: DROP VIEW &view_name&
trcdat: TRUNCATE TABLE &tab_name&
deldat: DELETE FROM &tab_name& &where&
negtab: LICHECK MLICHECK
negdat: LICHECK MLICHECK
negind: LICHECK~0 MLICHECK~0 LICHECK^0 MLICHECK^0
negvie:
negcpr: NRIV ARFCSSTATE ARFCSDATA ARFCRSTATE TRFCQDATA TRFCQIN TRFCQOUT TRFCQSTATE QRFCTRACE QRFCLOG
# table storage parameters
loc: APPL0 PSAPSR3 0000
APPL1 PSAPSR3 0000
APPL2 PSAPSR3 0000
CLUST PSAPSR3 0000
DDIM PSAPSR3 0000
DFACT PSAPSR3 0000
DODS PSAPSR3 0000
POOL PSAPSR3 0000
SDIC PSAPSR3 0
SDOCU PSAPSR3 0000
SLDEF PSAPSR370000D 0000
SLEXC PSAPSR370000D 0000
SLOAD PSAPSR3 0000
SPROT PSAPSR3 0000
SSDEF PSAPSR370000D 0000
SSEXC PSAPSR370000D 0000
SSRC PSAPSR3 0000
TEMP PSAPSR3 0000
USER PSAPSR3USR 0000
USER1 PSAPSR3USR 0000
sto: 0 0000000016K 0000000040K 0000000001 2147483645
1 0000000016K 0000000160K 0000000001 2147483645
10 0000000016K 0000655360K 0000000001 2147483645
11 0000000016K 0001310720K 0000000001 2147483645
12 0000000016K 0002621440K 0000000001 2147483645
13 0000000016K 0005242880K 0000000001 2147483645
14 0000000016K 0010485760K 0000000001 2147483645
2 0000000016K 0000000640K 0000000001 2147483645
3 0000000016K 0000002560K 0000000001 2147483645
4 0000000016K 0000010240K 0000000001 2147483645
5 0000000016K 0000020480K 0000000001 2147483645
6 0000000016K 0000040960K 0000000001 2147483645
7 0000000016K 0000081920K 0000000001 2147483645
8 0000000016K 0000163840K 0000000001 2147483645
9 0000000016K 0000327680K 0000000001 2147483645
# index storage parameters
loc: APPL0 PSAPSR3 0000
APPL1 PSAPSR3 0000
APPL2 PSAPSR3 0000
CLUST PSAPSR3 0000
DDIM PSAPSR3 0000
DFACT PSAPSR3 0000
DODS PSAPSR3 0000
POOL PSAPSR3 0000
SDIC PSAPSR3 0
SDOCU PSAPSR3 0000
SLDEF PSAPSR370000I 0000
SLEXC PSAPSR370000I 0000
SLOAD PSAPSR3 0000
SPROT PSAPSR3 0000
SSDEF PSAPSR370000I 0000
SSEXC PSAPSR370000I 0000
SSRC PSAPSR3 0000
TEMP PSAPSR3 0000
USER PSAPSR3USR 0000
USER1 PSAPSR3USR 0000
sto: 0 0000000016K 0000000040K 0000000001 2147483645
1 0000000016K 0000000080K 0000000001 2147483645
10 0000000016K 0000163840K 0000000001 2147483645
11 0000000016K 0000327680K 0000000001 2147483645
12 0000000016K 0000655360K 0000000001 2147483645
13 0000000016K 0001310720K 0000000001 2147483645
14 0000000016K 0002621440K 0000000001 2147483645
2 0000000016K 0000000160K 0000000001 2147483645
3 0000000016K 0000000640K 0000000001 2147483645
4 0000000016K 0000002560K 0000000001 2147483645
5 0000000016K 0000005120K 0000000001 2147483645
6 0000000016K 0000010240K 0000000001 2147483645
7 0000000016K 0000020480K 0000000001 2147483645
8 0000000016K 0000040960K 0000000001 2147483645
9 0000000016K 0000081920K 0000000001 2147483645
From the source system:
SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
SYSAUX
PSAPUNDO
PSAPSTABD
PSAPBTABD
PSAPBTABI
PSAPPOOLD
PSAPCLUD
PSAPDDICD
PSAPDDICI
PSAPDOCUD
NAME
------------------------------
PSAPEL46CD
PSAPLOADD
PSAPLOADI
PSAPPROTD
PSAPES46CD
PSAPSOURCED
PSAPSOURCEI
PSAPEL700D
PSAPUSER1D
PSAPES46CI
PSAPDOCUI
NAME
------------------------------
PSAPPOOLI
PSAPEL700I
PSAPSTABI
PSAPPROTI
PSAPCLUI
PSAPEL46CI
PSAPES700D
PSAPUSER1I
PSAPES700I
PSAPTEMP
32 rows selected.
SQL>
Thank you in advance.
BR,
Ruzica
Hi,
From the export dir from source:
#
cat DDLORA.TPL
prikey: AFTER_LOAD ORDER_BY_PKEY
seckey: AFTER_LOAD
cretab: CREATE TABLE &tab_name&
( /{ &fld_name& &fld_desc& /-, /} )
TABLESPACE &tablespace&
&compress&
&lob_cache&
STORAGE (INITIAL &init&
NEXT &next&
MINEXTENTS &minext&
MAXEXTENTS &maxext&
PCTINCREASE &pctinc& )
drptab: DROP TABLE &tab_name&
crepky: CREATE UNIQUE INDEX &pri_key&
ON &tab_name&
( &key_fld& /-, )
TABLESPACE &tablespace&
STORAGE (INITIAL &init&
NEXT &next&
MINEXTENTS &minext&
MAXEXTENTS &maxext&
PCTINCREASE &pctinc& )
NOLOGGING
COMPUTE STATISTICS ;
ALTER INDEX &pri_key& LOGGING
drppky: DROP INDEX &pri_key&
creind: CREATE &unique& INDEX &ind_name&
ON &tab_name&
( /{ &fld_name& /-, /} )
TABLESPACE &tablespace&
STORAGE (INITIAL &init&
NEXT &next&
MINEXTENTS &minext&
MAXEXTENTS &maxext&
PCTINCREASE &pctinc& )
NOLOGGING
COMPUTE STATISTICS ;
ALTER INDEX &ind_name& LOGGING
drpind: DROP INDEX &ind_name&
crevie: CREATE VIEW &view_name&
( /{ &fld_name& /-, /} )
AS &query&
drpvie: DROP VIEW &view_name&
trcdat: TRUNCATE TABLE &tab_name&
deldat: DELETE FROM &tab_name& &where&
negtab: LICHECK MLICHECK
negdat: LICHECK MLICHECK
negind: LICHECK~0 MLICHECK~0 LICHECK^0 MLICHECK^0
negvie:
negcpr: NRIV ARFCSSTATE ARFCSDATA ARFCRSTATE TRFCQDATA TRFCQIN TRFCQOUT TRFCQSTATE QRFCTRACE QRFCLOG
# table storage parameters
loc: APPL0 PSAPSTABD 0000
APPL1 PSAPBTABD 0000
APPL2 PSAPPOOLD 0000
CLUST PSAPCLUD 0000
DDIM PSAPCLUD 0000
DFACT PSAPCLUD 0000
DODS PSAPCLUD 0000
POOL PSAPPOOLD 0000
SDIC PSAPDDICD 0
SDOCU PSAPDOCUD 0000
SLDEF PSAPEL700D 0000
SLEXC PSAPEL700D 0000
SLOAD PSAPLOADD 0000
SPROT PSAPPROTD 0000
SSDEF PSAPES700D 0000
SSEXC PSAPES700D 0000
SSRC PSAPSOURCED 0000
TEMP PSAPPROTD 0000
USER PSAPUSER1D 0000
USER1 PSAPUSER1D 0000
sto: 0 0000000016K 0000000040K 0000000001 2147483645
1 0000000016K 0000000160K 0000000001 2147483645
10 0000000016K 0000655360K 0000000001 2147483645
11 0000000016K 0001310720K 0000000001 2147483645
12 0000000016K 0002621440K 0000000001 2147483645
13 0000000016K 0005242880K 0000000001 2147483645
14 0000000016K 0010485760K 0000000001 2147483645
2 0000000016K 0000000640K 0000000001 2147483645
3 0000000016K 0000002560K 0000000001 2147483645
4 0000000016K 0000010240K 0000000001 2147483645
5 0000000016K 0000020480K 0000000001 2147483645
6 0000000016K 0000040960K 0000000001 2147483645
7 0000000016K 0000081920K 0000000001 2147483645
8 0000000016K 0000163840K 0000000001 2147483645
9 0000000016K 0000327680K 0000000001 2147483645
# index storage parameters
loc: APPL0 PSAPSTABI 0000
APPL1 PSAPBTABI 0000
APPL2 PSAPPOOLI 0000
CLUST PSAPCLUI 0000
DDIM PSAPCLUI 0000
DFACT PSAPCLUI 0000
DODS PSAPCLUI 0000
POOL PSAPPOOLI 0000
SDIC PSAPDDICI 0
SDOCU PSAPDOCUI 0000
SLDEF PSAPEL700I 0000
SLEXC PSAPEL700I 0000
SLOAD PSAPLOADI 0000
SPROT PSAPPROTI 0000
SSDEF PSAPES700I 0000
SSEXC PSAPES700I 0000
SSRC PSAPSOURCEI 0000
TEMP PSAPPROTI 0000
USER PSAPUSER1I 0000
USER1 PSAPUSER1I 0000
sto: 0 0000000016K 0000000040K 0000000001 2147483645
1 0000000016K 0000000080K 0000000001 2147483645
10 0000000016K 0000163840K 0000000001 2147483645
11 0000000016K 0000327680K 0000000001 2147483645
12 0000000016K 0000655360K 0000000001 2147483645
13 0000000016K 0001310720K 0000000001 2147483645
14 0000000016K 0002621440K 0000000001 2147483645
2 0000000016K 0000000160K 0000000001 2147483645
3 0000000016K 0000000640K 0000000001 2147483645
4 0000000016K 0000002560K 0000000001 2147483645
5 0000000016K 0000005120K 0000000001 2147483645
6 0000000016K 0000010240K 0000000001 2147483645
7 0000000016K 0000020480K 0000000001 2147483645
8 0000000016K 0000040960K 0000000001 2147483645
9 0000000016K 0000081920K 0000000001 2147483645
BR,
Ruzica
Hi Marius,
From the target DB - there is no tablespace PSAPSR370000D:
SQL> select * from sapsr3.taora;
TABAR TABSPACE PCTI OFR OF OP OP
----- ------------------------------ ---- --- -- -- --
APPL0 PSAPSTABD 0000 001 01 10 40
APPL1 PSAPBTABD 0000 1 1 10 40
APPL2 PSAPPOOLD 0000 1 1 10 40
CLUST PSAPCLUD 0000 1 1 10 40
DDIM PSAPCLUD 0000 001 01 00 60
DFACT PSAPCLUD 0000 004 01 10 60
DODS PSAPCLUD 0000 004 01 00 60
POOL PSAPPOOLD 0000 1 1 10 40
SDIC PSAPDDICD 0 1 1 10 40
SDOCU PSAPDOCUD 0000 1 1 10 40
SLDEF PSAPEL700D 0000 1 1 10 40
TABAR TABSPACE PCTI OFR OF OP OP
----- ------------------------------ ---- --- -- -- --
SLEXC PSAPEL700D 0000 1 1 10 40
SLOAD PSAPLOADD 0000 1 1 10 40
SPROT PSAPPROTD 0000 1 1 10 40
SSDEF PSAPES700D 0000 1 1 10 40
SSEXC PSAPES700D 0000 1 1 10 40
SSRC PSAPSOURCED 0000 1 1 10 40
TEMP PSAPPROTD 0000 1 1 10 40
USER PSAPUSER1D 0000 1 1 10 40
USER1 PSAPUSER1D 0000 1 1 10 40
20 rows selected.
SQL> select * from sapsr3.iaora;
select * from sapsr3.iaora
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL>
Thank you in advance,
BR,
Ruzica
Hi,
Thanks .. Please try the following.
1. Stop the sapinst.
2. navigate to sapinst_instdir folder and rename the DDLORA.TPL file.
3. Copy the DDLORA.TPL file from the export location to sapinst_instdir location.
4.Start the sapinst and continue with old option
Please share your feedback.
Thanks and Regards,
Vimal
Hi,
You can try to rename the contents in the file DDLORA.TPL file which was copied to sapinst directory from the export location.
Example
Rename
# table storage parameters
loc: APPL0 PSAPSTABD 0000
to
# table storage parameters
loc: APPL0 PSAPSR3 0000
Likewise change for the others also .
Thanks and Regards,
Vimal
DDLORA.TPL on the target system change the PSAPSR370000D with PSAPSR3700
# table storage parameters
loc: APPL0 PSAPSR3 0000
APPL1 PSAPSR3 0000
APPL2 PSAPSR3 0000
CLUST PSAPSR3 0000
DDIM PSAPSR3 0000
DFACT PSAPSR3 0000
DODS PSAPSR3 0000
POOL PSAPSR3 0000
SDIC PSAPSR3 0
SDOCU PSAPSR3 0000
SLDEF PSAPSR3700 0000
SLEXC PSAPSR3700 0000
SLOAD PSAPSR3 0000
SPROT PSAPSR3 0000
SSDEF PSAPSR3700 0000
SSEXC PSAPSR3700 0000
SSRC PSAPSR3 0000
TEMP PSAPSR3 0000
USER PSAPSR3USR 0000
USER1 PSAPSR3USR 0000
# index storage parameters
loc: APPL0 PSAPSR3 0000
APPL1 PSAPSR3 0000
APPL2 PSAPSR3 0000
CLUST PSAPSR3 0000
DDIM PSAPSR3 0000
DFACT PSAPSR3 0000
DODS PSAPSR3 0000
POOL PSAPSR3 0000
SDIC PSAPSR3 0
SDOCU PSAPSR3 0000
SLDEF PSAPSR3700 0000
SLEXC PSAPSR3700 0000
SLOAD PSAPSR3 0000
SPROT PSAPSR3 0000
SSDEF PSAPSR3700 0000
SSEXC PSAPSR3700 0000
SSRC PSAPSR3 0000
TEMP PSAPSR3 0000
USER PSAPSR3USR 0000
USER1 PSAPSR3USR 0000
Hi Vimal,
I've changed the DDLORA.TPL and DDLORA_LRG.TPL like this and Import finished OK:
> cat "DDLORA.TPL"|grep PSAPSR3700
### SLDEF PSAPSR370000D 0000
SLDEF PSAPSR3700 0000
### SLEXC PSAPSR370000D 0000
SLEXC PSAPSR3700 0000
### SSDEF PSAPSR370000D 0000
SSDEF PSAPSR3700 0000
### SSEXC PSAPSR370000D 0000
SSEXC PSAPSR3700 0000
### SLDEF PSAPSR370000I 0000
SLDEF PSAPSR3700 0000
### SLEXC PSAPSR370000I 0000
SLEXC PSAPSR3700 0000
### SSDEF PSAPSR370000I 0000
SSDEF PSAPSR3700 0000
### SSEXC PSAPSR370000I 0000
SSEXC PSAPSR3700 0000
Thank you for all your help.
BR,
Ruzica
Thanks man.. It works FINE for me.
I changed
PSAPSR370000D with PSAPSR3700
PSAPSR370000I with PSAPSR3700
PSAPSR370000E with PSAPSR3700
And its done... Thanks again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi.
Which patch level of SWPM did you use? The lastest is PLV06.
I have the same issue using SWPM PL03, and I had to change manually the tablespace entries in DDLORA.TPL, DDLORA_LRG.TP and DBSIZE.XML.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ruzica
please try below from note 1317500
Error during export preparation with R3szchk
Symptom:
When preparing the export, R3szchk creates wrong tablespace entries PSAPES70I and PSAPES700 in DBSIZE.XML. Hence SAPinst creates the wrong tablespace name PSAP<SCHEMAID>70 instead of PSAP<SCHEMAID>700.
Solution:
Best Regards
Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marius,
First I can't open the Note 1317500 - The requested SAP Note is either in reworking or is released internally only .
Please send me the text from the note.
I've seen this error in Note Note 970518 - Hom./Het.System Copy SAP NetWeaver 7.0 (2004s) SR2, but ith was for BW systems. (BW only: Error during "Import ABAP" phase in step runMigrationMonitor" of BW specific packages SAPDDIM, SAPDFACT, SAPDODS).
Thank you
BR,
RUzica
hi ruzica,
please try the link below
http://www.stechno.net/sap-notes.html?view=sapnote&id=1317500
best regards
marius
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.