SAP R/3 4.6C Installation in HPUX /oracle 10g - Error ORADBUSR_IND_ORA

[Former Member]

Hi all

While installing 4.6C in Oracle 10g/HPUX, I get the below error towards the end.

Can some help me to over come this error

Regards

Senthil

.

. Oracle Version: 10.2.0.2.0

. Parametervalue os_authent_prefix: OPS$

. Schema Id: R3

. Database User (Schema): SAPR3

. SAP R/3 Administrator: OPS$SUPADM

.

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

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

With the Partitioning and Data Mining options

ERROR 2008-03-11 20:15:46 ORADBUSR_IND_ORA ExecuteCheck:0

Exit code from /oracle/SUP/102_64/bin/sqlplus: 191.

ERROR 2008-03-11 20:15:46 ORADBUSR_IND_ORA InternalInstallationDo:0

Phase failed.

ERROR 2008-03-11 20:15:46 ORADBUSR_IND_ORA InstallationDo:0

Phase failed.

ERROR 2008-03-11 20:15:47 Main

Installation aborted.

[Former Member]

Hi

Please see Note 425079 - Tablespace configuration for reduced tablespace set

Hope this solves your issue

Regards

Shaji

Edited by: Shaji Jacob on Mar 13, 2008 11:26 PM

[Former Member]

Hi. Read this Note 573042,

This error occurs when an SAP product is being installed on Oracle, for which a system name starting with 'R3' (for example, R34) was selected.

Regards. Award if helpful.

[Former Member]

Thank you for your reply, as per the note you have suggested I have tried editing the file and ran the script but still I face the error.

When it prompts for database installation details

Requesting Database Installation Details

R3Setup needs database-specific information about the configuration of the SAP

System you want to install. The following screens prompt you to enter the

required data.

For further information see HTML documentation:

step: DBCOMMONDBENV46CSR2_HPIA64_ORA and key: SCHEMAID

-

---

Please enter the parameter or confirm default [SR3]: R3

I give the input as R3, hence it gives me the error message.

Is give the input as R3 is correct? to avoid the error what should I do?

Please advise

Regards

Senthil

[Former Member]

After editing the sql script

Edit the oradbusr.sql file in the installation directory and change

the row

if substr(upper('&&1'),1,5) = 'SAPR3' then

to

if substr(upper('&&1'),1,5) = 'SAPR3notCorrect' then

-

---

not supported:

Schemaowner has to be SAPR3 or SAP<SID> where <SID>

has to be a three digit Identifier starting with a character

-

---

-

-

begin

*

ERROR at line 1:

ORA-06510: PL/SQL: unhandled user-defined exception

ORA-06512: at line 32

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

With the Partitioning and Data Mining options

ERROR 2008-03-12 09:32:34 ORADBUSR_IND_ORA ExecuteCheck:0

Exit code from /oracle/SUP/102_64/bin/sqlplus: 110.

ERROR 2008-03-12 09:32:34 ORADBUSR_IND_ORA InternalInstallationDo:0

Phase failed.

ERROR 2008-03-12 09:32:34 ORADBUSR_IND_ORA InstallationDo:0

Phase failed.

ERROR 2008-03-12 09:32:34 Main

Installation aborted.

Can you help

Regards

Senthil

[Former Member]

Hi. As of note first backup the file oradbusr.sql, and replace the file oradbusr.sql in the installation directory with the version provided in the attachment to this note. How you have named the system?

Regards.

[Former Member]

Hi,

Senthil just wanted to check did you download the oradbusr.sql from the note and replace the existing one with new one.

You can try this out, may be it helps...

Also if nothing works out, create the tablespace...

Regards,

Suhas

[Former Member]

Hi all,

I tried both the options mentioned in the note.

1. I edited the file

2. I downloaded the new file mentioned in the note and replaced it with the old one. But still I face the error.

My have a doubt, during the database installation process it prompts me with the below questions

Please enter the parameter or confirm default SR3: R3

I gave the input as R3, hence it gives me the error message.

Is give the input as R3 is correct? to avoid the error what should I do?

Please advise

Regards

Senthil

[Former Member]

Hi J. Senthil Murugan. I am not assured on the invoice of your case, but in Note 598708 -->

"Installing SAP systems based on SAP Web AS 6.20 on UNIX: Oracle - Additional information"

you can read this :

"In the SAPinst dialog 'Database System Common Paramters' --> 'Database Instance Parameters', do NOT enter SAPR3 as database schema name! Otherwise, the following errors occur and you have to restart the installation from the beginning:

ORA-00959: tablespace 'PSAPUSER1D' does not exist

ORA-06512: at line 90"

If there is an opportunity, it is better to open the " Report a Product Error - Customer Message"

on service.sap.com, they should know what to do in that case.

If cannot open, then try to create different database schema with "SAPR3"

Regards.

[Former Member]

Hi,

Senthil, just check whether the tablespace is created during the installation. In which phase are you getting this error ?

Has the import_abap phase completed ??

If not you can create a tablespace manually and take the installation ahead.

Regards,

Suhas