Sapinst , Create database schema Error "qlplus returns 959."

[Former Member]

Hello ,

I am trying to install SAP ERP 6.0 EHP4 and i get the above error. Can You please help me.

-------------------------------------------------------

      An error occurred while processing option SAP ERP 6.0 EHP4 Ready - Support Release 1 > SAP Application Server ABAP > Oracle > Central System > Central System( Last error reported by the step :SQL statement or script failed. DIAGNOSIS: Error message: Executable E:\oracle\ETD\102/bin/sqlplus returns 959.. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.). You can now:

• Choose Retry to repeat the current step.
• Choose View Log to get more information about the error.
• Stop the option and continue with it later.

Log files are written to C:\Program Files/sapinst_instdir/ERPEhP4/AS-ABAP/ORA/CENTRAL/.    

---------------------------------------------------

Also my log

2012-12-13, 14:36:52 SAPINST ORACLE start logging for

  set newpage 0

set space 0

set pagesize 0

set linesize 32767

set markup HTML off

set heading off

set verify off

set feedback off

set trimspool on

set sqlprompt SQL>

set termout on

set verify off

set echo off

spool ora_query3_tmp0_1.res

SELECT STATUS FROM V$INSTANCE;

spool off

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Dec 13 14:36:52 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SELECT STATUS FROM V$INSTANCE

*

ERROR at line 1:

ORA-01034: ORACLE not available

Disconnected

SAPINST: End of output of SQL executing program E:\oracle\ETD\102/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2012-12-13, 14:36:53 SAPINST ORACLE stop logging

[Former Member]

Well i restart the server and i begin the procedure from the beginning. I choose to drop database and recreate it and it seems now that the procedure is continuing.

Thank you for you replies ...

[Former Member]

Hi Arvanitis,

>> ORA-01034: ORACLE not available

It seems that the database has not been started successfully. Check the alert_<SID>.log why the database has not been started up successfully.

Best regards,

Orkun Gedik

[Former Member]

My database is started but i was post you worng log.

Here is the new one

-----------------

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Dec 13 17:34:37 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Connected.

old   6:   if length('&&1') = 5 then

new   6:   if length('SAPSR3') = 5 then

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

new   7:     if substr(upper('SAPSR3'),1,5) = 'SAPR3' then

old  11:       if upper('&&2') = 'NT' then

new  11:       if upper('NT') = 'NT' then

old  18:           :sDomain := upper('&&3');

new  18:           :sDomain := upper('VIONET');

old  19:           :sSapSid := upper('&&4');

new  19:           :sSapSid := upper('ETD');

old  21:           :sSapSid := upper('&&3');

new  21:           :sSapSid := upper('VIONET');

old  37:     :sSchema := upper('&&1');

new  37:     :sSchema := upper('SAPSR3');

old  39:     if upper('&&2') = 'NT' then

new  39:     if upper('NT') = 'NT' then

old  46:       :sDomain := upper('&&3');

new  46:       :sDomain := upper('VIONET');

old  47:       :sSapSid := upper('&&4');

new  47:       :sSapSid := upper('ETD');

old  49:       :sSapSid := upper('&&3');

new  49:       :sSapSid := upper('VIONET');

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$VIONET\ETDADM

.  SAP R/3 Serviceuser:                  OPS$VIONET\SAPSERVICEETD

.  Domain/Host:                            VIONET

.

unable to create user: OPS$VIONET\ETDADM

begin

*

ERROR at line 1:

ORA-00959: tablespace 'PSAPTEMP' does not exist

ORA-06512: at line 79

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SAPINST: End of output of SQL executing program E:\oracle\ETD\102/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2012-12-13, 17:34:40 SAPINST ORACLE stop logging

[Former Member]

Because of a reason, tablespaces have not been created successfully. You should identify why the tablespace could not been created successfully.

As a first step, apply latest "sapinst" and start the installation from the scratch

Best regards,

Orkun Gedik

[Former Member]

Hi iilias,

Problem in environment variable.

If windows you can login with Administrator and export Register file then login with sidadm and import the register file.

All environment variables overwriting from Administrator user.

[Former Member]

@Srinivasan

>> Problem in environment variable.

It should not be the issue with the standart installation.

Best regards,

Orkun Gedik

[Former Member]

Hi Orkun,

But Windows 2008 and 2008 R2  more secure OS compare to other windows OS. The users do not have enough permission to set env some times.

[Former Member]

Hi Srinivasan,

>> But Windows 2008 and 2008 R2  more secure OS compare to other windows OS. The users do not have enough permission to set env some times.

It is correct but this issue should be solved by latest sapinst, environment should not be modified manually.

Best regards,

Orkun Gedik