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

[JPReyes]

System copy guide suggest to change the DB system user password to default prior the export, did you change it?

ORA-1403 when accessing table SAPUSER

Thats typical of an OPS$user... check note 400421

Regards

Juan

Edited by: Juan Reyes on Jul 30, 2010 12:31 PM

[Former Member]

Hi Juan!

I didn't reset the password before export. The source system is a new installation. I know exactly the password.

You think that this could be a problem?

Now I check the note 400421.

Marzia.

Edited by: kobelli2 on Jul 30, 2010 1:36 PM

[Former Member]

I've checked the notes 400421 but I think that it could be ok for the older version (from 30 to 46c)... this is a BW 7.0

M.

[JPReyes]

Is the same for new versions, go through the general checks suggested in the note.

I recommend you to read the system copy guide in detail.

Regards

Juan

[Former Member]

AH! Is a wrong sap note! The correct number is 400241! Now I check it!

Thanks!

[JPReyes]

Sorry typo

[Former Member]

OK. Now i'm checking the sap note 400241.

First of all I've reset the SAPSR3 user password with the following command

brconnect -u system/<PWD> -f chpass -o SAPSR3 -p <PWD>

I checked the oracle user status

All the oracle users have the folling status

USERNAME ACCOUNT_STATUS

-

---

-

---

SCHEMAOWNER OPEN

OPS$ORABWP OPEN

OPS$SAPSERVICEBWP OPEN

OPS$BWPADM OPEN

SYS OPEN

SYSTEM OPEN

SAPSR3 OPEN

OUTLN LOCKED

TSMSYS EXPIRED & LOCKED

DIP EXPIRED & LOCKED

ORACLE_OCM EXPIRED & LOCKED

USERNAME ACCOUNT_STATUS

-

---

-

---

DBSNMP EXPIRED & LOCKED

Now, as described in first step in "Reason and Prerequisites" chapter I try to connect via OPS$ user with the following command

connect /@<sid>

is ok. Now I try to logon as sapr3 using the password I specified

connect sapr3/<password>@<sid>

I have the following error message:

ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

I'm sorry, but I not a Oracle DBA.

Thanks.

Marzia

[Former Member]

...after I try to execute the script ORADBUSR.SQL as desribed in note 50088 and, correctly, I have the following message:

using following Parameters:

.

. Oracle Version: 10.2.0.4.0

. Parametervalue os_authent_prefix: OPS$

. Schema Id: SR3

. Database User (Schema): SAPSR3

. SAP R/3 Administrator: OPS$BWPADM

. SAP R/3 Serviceuser: OPS$SAPSERVICEBWP

.

User OPS$ORABWPdoes already exist.

O/S Message: Permission denied

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options