Homogeneous system copy - ORA-1403 when accessing table SAPUSER

[Former Member]

Hi great expert!

I'm doing a Homogeneous system copy from a BW system (NW2004s) with an Oracle DB (10g version, 10.2.0.4 patch level) with AIX ibm OS..

First of all, during the export I get the following error message:

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(EXP) ERROR: DbSlExeRead failed

rc = 103, table "/BIC/B0000920000"

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

I decided to skip this object and the export (apparenty!) was ok. This is the only error I get during the export process. I try to perform the export twice, but I have the same error message.

Now, during the import I get many (and several) error with the following error message:

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: sysname = "AIX"

(GSI) INFO: release = "3"

(GSI) INFO: version = "5"

(GSI) INFO: machine = "00CC00F14C00"

SQL) INFO: Trying to open /export/ABAP/DB/ORA/DFACT.SQL

(SQL) INFO: /export/ABAP/DB/ORA/DFACT.SQL opened

DbSl Trace: Error 922 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-922 occurred when executing SQL stmt (parse error offset=996)

(DB) ERROR: DDL statement failed

( CREATE TABLE "/BIC/FZHRCHPPB" ("KEY_ZHRCHPPBP" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_ZHRCHPPBT"

NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_ZHRCHPPBU" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_ZH

RCHPPB1" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_ZHRCHPPB2" NUMBER (000010) DEFAULT 0 NOT NULL,

"KEY_ZHRCHPPB3" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_ZHRCHPPB4" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_ZHRCHPPB5" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_ZHRCHPPB6" NUMBER (000010) DEFAULT

0 NOT NULL, "KEY_ZHRCHPPB7" NUMBER (000010) DEFAULT 0 NOT NULL, "KEY_ZHRCHPPB8" NUMBER (000010)

DEFAULT 0 NOT NULL, "KEY_ZHRCHPPB9" NUMBER (000010) DEFAULT 0 NOT NULL, "/BIC/ZHR_CAL" NUMBER (000017

, 000003) DEFAULT 0 NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE STORAGE (I

NITIAL 0000000016 K NEXT 0000000016 K MINEXTENTS 0000000001 MAXEXTEN

TS 2147483645 PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01) PAR

TITION BY RANGE ("KEY_ZHRCHPPBP") ( PARTITION "/BIC/FZHRCHPPB0" VALUES LESS THAN (0) TABLESPACE "",

PARTITION "/BIC/FZHRCHPPB0000000003" VALUES LESS THAN (0000000003) TABLESPACE "") )

DbSlExecute: rc = 99

(SQL error 922)

error message returned by DbSl:

ORA-00922: missing or invalid option

(DB) INFO: disconnected from DB

/usr/sap/BWP/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/BWP/SYS/exe/run/R3load: END OF LOG: 20100730122037

Before starting export I've executed the report SMIGR_CREATE_DDL, as described in sap note 888210, and I generated 4 *.SQL files that I copy into /export/ABAP/DB/ORA and into installation master directory.

Someone can help me?

Thanks a lot!

Marzia

[JPReyes · Accepted solution]

Lets see... SAP Note 50088 is for WINDOWS so does not apply to your case

OPS$ORABWP OPEN
OPS$SAPSERVICEBWP OPEN

You shouldn't have a OPS$SAPSERVICEBWP as synonyms are only used by Windows and as far as I can see you are using AIX.

ORA-01017: invalid username/password; logon denied

Delete and recreate OPS$<SID>ADM.SAPUSER table as described in SAP Note 400241

Regards

Juan

[Former Member · Accepted solution]

Solved! Thanks a lot!

Marzia