Archived discussions are read-only. Learn more about SAP Q&A

ORA-00959: tablespace 'PSAPSR370000D' does not exist

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question