Installation error in SAP ECC 6.0

[former_member364077]

Hi Experts,

i got an error while installing SAP Ecc 6.0 version at 13th (Create Database) step.

DB : Oracle

OS : windows 2003 server.

Any suggestions to overcone this please.

Thanks in advance.

[Former Member]

Hi All,

I am getting the same error. I am using Windows 2008 & Oracle.

I have the following logs:

ora_sql_result.log

2011-09-01, 10:13:35 SAPINST ORACLE start logging for

@@ORADBUSR.SQL

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Sep 1 10:13:35 2011

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('STNW04S02');

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

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

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

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

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('STNW04S02');

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

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

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

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

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$STNW04S02\P01ADM

. SAP R/3 Serviceuser: OPS$STNW04S02\SAPSERVICEP01

. Domain/Host: STNW04S02

.

unable to assign default tablespace to user: SAPSR3

begin

*

ERROR at line 1:

ORA-00959: tablespace 'PSAPSR3USR' does not exist

ORA-06512: at line 126

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 F:\oracle\P01\102/bin/sqlplus.

SAPINST found errors.

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

2011-09-01, 10:13:37 SAPINST ORACLE stop logging

sapinst_ora_environment.log:

2011-09-01, 10:13:37 SAPINST Current process environment:

=C:=C:\Program Files\sapinst_instdir\NW701\LM\COPY\ORA\SYSTEM\CENTRAL\AS

=F:=F:\NW_701SR1\NW70_Master\IM_WINDOWS_X86_64

ALLUSERSPROFILE=C:\ProgramData

APPDATA=C:\Users\Administrator\AppData\Roaming

CLIENTNAME=5V0PB4J

CommonProgramFiles=C:\Program Files\Common Files

CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files

COMPUTERNAME=STNW04S02

ComSpec=C:\Windows\system32\cmd.exe

FP_NO_HOST_CHECK=NO

HOMEDRIVE=C:

HOMEPATH=\Users\Administrator

JAVA_HOME=C:\j2sdk

LOCALAPPDATA=C:\Users\Administrator\AppData\Local

LOGONSERVER=
STNW04S02

NUMBER_OF_PROCESSORS=2

ORACLE_HOME=F:\oracle\P01\102

ORACLE_SID=P01

OS=Windows_NT

Path=F:\oracle\P01\102\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\j2sdk\bin

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

PERL5LIB=F:\oracle\P01\102\perl\5.8.3\lib\MSWin32-x64;F:\oracle\P01\102\perl\5.8.3\lib;F:\oracle\P01\102\perl\5.8.3\lib\MSWin32-x64;F:\oracle\P01\102\perl\site\5.8.3;F:\oracle\P01\102\perl\site\5.8.3\lib;F:\oracle\P01\102\sysman\admin\scripts;F:\oracle\P01\102\perl\5.8.3\lib\MSWin32-x64;F:\oracle\P01\102\perl\5.8.3\lib;F:\oracle\P01\102\perl\5.8.3\lib\MSWin32-x64;F:\oracle\P01\102\perl\site\5.8.3;F:\oracle\P01\102\perl\site\5.8.3\lib;F:\oracle\P01\102\sysman\admin\scripts

PROCESSOR_ARCHITECTURE=AMD64

PROCESSOR_IDENTIFIER=AMD64 Family 16 Model 2 Stepping 3, AuthenticAMD

PROCESSOR_LEVEL=16

PROCESSOR_REVISION=0203

ProgramData=C:\ProgramData

ProgramFiles=C:\Program Files

ProgramFiles(x86)=C:\Program Files (x86)

PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\

PUBLIC=C:\Users\Public

SAPINST_EXEDIR_CD=F:/NW_701SR1/NW70_Master/IM_WINDOWS_X86_64

SAPINST_JRE_HOME=C:/Users/ADMINI~1/AppData/Local/Temp/2/sapinst_exe.2624.1314861828/jre

SESSIONNAME=RDP-Tcp#0

SystemDrive=C:

SystemRoot=C:\Windows

TEMP=C:\Users\ADMINI~1\AppData\Local\Temp\2

TMP=C:\Users\ADMINI~1\AppData\Local\Temp\2

USERDOMAIN=STNW04S02

USERNAME=Administrator

USERPROFILE=C:\Users\Administrator

windir=C:\Windows

SAPINST: End of current process environment.

Further environment variables that where set (possibly overwriting the previous ones):

ORACLE_HOME=F:\oracle\P01\102

ORACLE_SID=P01

SAPINST: End of environment log.

[former_member709110]

ORA-00959: tablespace 'PSAPSR3USR' does not exist

Check if the tablespace PSAPSR3USR has been created or not ? Was there any error reported during database creation, which was skipped manually ?

Regards,

Neel

[Former Member]

Error message :-

ERROR 2010-03-07 05:21:36

CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: Executable D:\oracle\product\10.2.0\db_1/bin/sqlplus returns 959..<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

ERROR 2010-03-07 05:21:36

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2010-03-07 05:21:36

FCO-00011 The step createABAPSchemaUser with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBMCOD|ind|ind|ind|ind|2|0|NW_OraDbSchema|ind|ind|ind|ind|5|0|createABAPSchemaUser was executed with status ERROR .

Please help me resolve this.

Thanks

[markus_doehr2]

> CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: Executable D:\oracle\product\10.2.0\db_1/bin/sqlplus returns 959..<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

You should do as advised and check that logfile.

Markus

[Former Member]

Hello,

I am getting the same error whille DB installation . Solaris 10 , oracle 10.2 .

Real group id set to 502.

INFO 2010-03-13 18:37:53 [syuxccuren.cpp:264]

CSyCurrentProcessEnvironmentImpl::setGroup(PSyGroup)

Real group id set to 502.

ERROR 2010-03-13 18:37:55 [iaxxinscbk.cpp:282]

abortInstallation

CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: Executable /oracle/SID/102_64/bin/sqlplus returns 191..<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

ERROR 2010-03-13 18:37:55

CJSlibModule::writeError_impl()

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2010-03-13 18:37:55

FCO-00011 The step createABAPSchemaUser with step key |NW_Doublestack_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbSchema|ind|ind|ind|ind|9|0|createABAPSchemaUser was executed with status ERROR .

Please if u can help me.

Thanks

Dharmendra

[Former Member]

Hi,

Paste the ora_sql_results.log here

Regards,

Joel.

[Former Member]

Please find log.

ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/SID/sapdata3/sr3_4/sr3.data4' SIZE 2000M REUSE AUTOEXTEND ON NEXT

200M MAXSIZE 10000M;

exit;

Executed successfully.

ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/SID/sapdata3/sr3_5/sr3.data5' SIZE 2000M REUSE AUTOEXTEND ON NEXT

200M MAXSIZE 10000M;

exit;

Executed with error.

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;

Executed successfully.

@@ORADBUSR.SQL

exit;

Executed with error.

Thanks .

[markus_doehr2]

> CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: Executable D:\oracle\product\10.2.0\db_1/bin/sqlplus returns 959.

Additional note:

According to your installation path you apparently did not do as advised in the documentation and installed Oracle using "sapserver.cmd" but you used setup.exe - this is wrong for a SAP system.

Markus

[markus_doehr2]

> I am getting the same error whille DB installation . Solaris 10 , oracle 10.2 .

Did you

- install the database using the capital script RUNINSTALLER in the SAP subdirectory of the installation DVD?

- set up /etc/project and /etc/user_attr?

Markus

[Former Member]

I am getting the same error. Someone help!

I have more that 17gb free space in C: drive. Also I am installing SAP in a 250 gb hard disk drive.

Thanks

[Former Member]

Whats the Error ?

[former_member364077]

These are the messages i saw in error log

ERROR 2010-02-02 15:30:26

CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: ORA-01501: CREATE DATABASE failedORA-00301: error in adding log file 'C:\oracle\ORA/mirrlogB/log_g12m2.dbf' -file cannot be createdORA-27044: unable to write the header block of fileOSD-04008: WriteFile() failure, unable to write to fileO/S-Error: (OS 112) There is not enough space on the disk.

ERROR 2010-02-02 15:30:26

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2010-02-02 15:30:26

FCO-00011 The step createDatabase with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|createDatabase was executed with status ERROR .

Thanks,

[Former Member]

There is no space in your C Drive thats the problem..

[Former Member]

Increase Space in C Drive or if you have space in an alternate drive put in your redologs there..

Basically you need to distribute the Files accordingly to the space you have.

During the installation you can go to "Advanced DB Configuration" in the SAPINST screen and you have more control there to distribute the tablespaces and redlogs .

Basically you can place them according to your available space.

Hope it helps ,

All the best,

Gerard

[former_member364077]

Hi Gera,

CAN i have idea how to advanced DB configuration?

Thanks,

Surendra...

[Former Member]

Usually its available in the "Define parameter section" , Just lookout for a checkbox called "Advanced DB configuration- For Oracle experts only "

I think the title of the screen is "Advanced configuration"

Gerard

[markus_doehr2]

BTW: your SID name ORA is unsupported and must not be used. Read the installation guides!

Markus

[former_member204746]

you should not put your database on the C drive. Read the installation guide for guidelines.

Installing SAP is not like installing Microsoft Word....

and, you must own a SAP license in order to install it.