Skip to Content
0
Former Member
Jul 29, 2008 at 02:54 AM

Problem with R3 4.6C Installation on RHEL4 x86_64

81 Views

Hello Experts,

We currently have the 4.6C system on Solaris (64 Bit) and the plan is to migrate to RHEL4 x86_64. I am trying to do a vanilla install of 4.6C SR2 (4.6D EXT kernel) with Oracle 10.2.0.2 on the Linux box as the first step.

I have gone through notes 946141 and 816145 and adapted the changes mentioned there. The installation has progressed smoothly until the database creation step.

What I've completed so far:

SAP Binaries extracted successfully

Oracle Database Software installed successfully

Oracle 10.2.0.2 Patchset installed successfully

I then continue the installation with R3setup and it creates the database successfully BUT I've noticed that its creating an older version of the tablespace which causes my installation to fail at the ORADBUSR_IND_ORA phase.

I have replaced the oradbusr.sql file from the one in note 573042. I have also confirmed that the DBSIZE.TPL and DDLORA.TPL in the installation directory are copied from the Export CD and have the latest tablespace names.

The last couple of lines from the oradbusr.log are:

. Oracle Version: 10.2.0.2.0

. Parametervalue os_authent_prefix: OPS$

. Schema Id: R3

. Database User (Schema): SAPR3

. SAP R/3 Administrator: OPS$DW1ADM

.

unable to assign default tablespace to user: SAPR3

begin

*

ERROR at line 1:

ORA-00959: tablespace 'PSAPUSER1D' does not exist

ORA-06512: at line 90

The tablespaces created in the database so far are:

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME

-


SYSTEM

PSAPUNDO

SYSAUX

PSAPTEMP

PSAPR3

PSAPR346C

PSAPR3USR

The last three tablespaces (PSAPR3*) are really old and do not exist in my current environment.

Any ideas on how I could get over this problem? I could create the PSAPUSER1D manually but would prefer not to do it this way.

Thanks,

Cheng