Skip to Content
0
Former Member
Apr 01, 2010 at 11:09 AM

Problems with SAPUSER Table / ORA-1403 during PI 7.1 EHP1 Installation

85 Views

Hello,

as I have currently problems creating a customer message with the customer provided S-User and I need a solution after the easter weekend, I'll try my luck here...

We currently perform a SAP Netweaver PI 7.1 EHP1 installation on Windows 2008 (Enterprise)/ Oracle. The installation media were downloaded from SAPNet.

The Windows Server 2008 is completely udpated, no further patches are available.

The Windows system is patched according to note 1375494 (new SAP kernel does not work on Win2008 without).

Oracle 10.2.0.4 was installed previous to the installation.

During the installation the new independend and db-dependend kernel was provided.

First steps run smoth until Phase ABAP IMPORT. This one fails according to the logs because access to table SAPUSER is not possible:

Compiled Jan 15 2010 23:56:22

E:\usr\sap\PID\SYS\exe\uc\NTAMD64\R3load.exe -testconnect

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) ERROR: db_connect rc = 256

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) ERROR: DbSlErrorMsg rc = 99

I already checked the OPS$ mechanism. Starting SQLPlus /nolog and login with "connect /as sysdba" works as intended.

i.e. "select owner from dba_tables where table_name = 'SAPUSER';" shows:

OWNER

-


O$HERDER_DOMAIN\PIDADM

Which is ok, the Domainname and SID is correct.

"select * from "O$HERDER_DOMAIN\PIDADM".SAPUSER;" show:

no rows selected

Comparing this to another recently installed system there should be something like this:

USERID

-


PASSWD

-


SAPSR3-CRYPT

V01/0050ZctvSB67Wv2haiQTDrO5P5c7Ks/kyqpdQ7jDbQ==

But I'm not really sure, if this entry should be there at this installation phase.

If so, how is this entry created? Note 50088 describes how to handle this, but with other USERID and without encrypted PASSWD.

I have no idea, why this happens, I recently installed 2 ECC systems and 1 Solution Manager systems and had no problems installing them.

I already exchanged the control.xml according to note 1249469.

I cannot find any note for this situation, so please ... is there anyone out there with an idea?

Best regards

Christian Reitz