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
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;
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.