failed for installing SAP ERP2005 SR2

[Former Member]

Hello Expert,

i am facing a problem with installing ERP2005 SR2 in WIndows 2003 Server 32bit with Chinese OS.

the step of create database in installing SAP is failed.

i pasted the log, who please kindly help me to find out what's the exactly reason.

thanks in advace

><<<<<<<<<<<<<<<<<<<<<<

Dump file f:\oracle\e60\saptrace\usertrace\e60_ora_3628.trc

Wed Jan 09 13:17:03 2019

ORACLE V10.2.0.2.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

Windows Server 2003 Version V5.2 Service Pack 2

CPU : 8 - type 586, 2 Physical Cores

Process Affinity : 0x00000000

Memory (Avail/Total): Ph:15459M/16381M, Ph+PgF:16083M/18176M, VA:467M/2047M

Instance name: e60

Redo thread mounted by this instance: 0 <none>

Oracle process number: 13

Windows thread id: 3628, image: ORACLE.EXE (SHAD)

• SERVICE NAME:() 2019-01-09 13:17:03.671

• SESSION ID:(85.3) 2019-01-09 13:17:03.671

ORA-00200: control file could not be created

ORA-00202: control file: 'F:\ORACLE\E60\ORIGLOGA\CNTRL\CNTLRE60.DBF'

ORA-27040: file create error, unable to create file

OSD-04002: unable to open file

O/S-Error: (OS 3) 系统找不到指定的路径。

Thanks again

Kevin Gao

[Former Member]

the reason is that i userd E60 as SID name.

but according to the installation manual,

the 60 port is used by iSCSI.

so i changed another SID, it works.

Sorry for that caused

[Former Member]

Hi,

It seems that installation is unable to create "files"...

Please check if E60ADM, ORAE60 and SapServiceE60 users are member of the Administrators group.

Then retry the installation.

If it doesn't help you, just post the fresh installation logs.

Regards.

Rajesh Narkhede

[Former Member]

Hello Rajesh,

i did as you said to assign user E60ADM and SAPserviceE60 to adminstrator group.

but i can't find the user ORAE60.

please let me describe the error message .

now i execute the 'startup' command to start oracle, system will altert the log

'ORA-00205: error in identifying control file, check alert log for more info'

and i also reviewd the sap installation log file , same log exists.

Sat Jan 12 10:02:17 2019
Errors in file f:\oracle\e60\saptrace\usertrace\e60_ora_2044.trc:
ORA-00200: control file could not be created
ORA-00202: control file: 'F:\ORACLE\E60\ORIGLOGA\CNTRL\CNTLRE60.DBF'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) system can't find pathu3002

Sat Jan 12 10:02:17 2019
ORA-1501 signalled during: CREATE DATABASE E60 CONTROLFILE REUSE  MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXLOGHISTORY 1000 MAXDATAFILES 254 MAXINSTANCES 50 NOARCHIVELOG CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 DATAFILE 'F:\oracle\E60\sapdata1\system_1\system.data1' SIZE 1000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE 'F:\oracle\E60\sapdata1\temp_1\temp.data1' SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M UNDO TABLESPACE PSAPUNDO DATAFILE 'F:\oracle\E60\sapdata1\undo_1\undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M SYSAUX DATAFILE 'F:\oracle\E60\sapdata1\sysaux_1\sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
LOGFILE GROUP 1 ('D:\oracle\E60/origlogA/log_g11m1.dbf',
'C:\oracle\E60/mirrlogA/log_g11m2.dbf') SIZE 50M  REUSE ,
GROUP 2 ('D:\oracle\E60/origlogB/log_g12m1.dbf',
'C:\oracle\E60/mirrlogB/log_g12m2.dbf') SIZE 50M  REUSE ,
GROUP 3 ('D:\oracle\E60/origlogA/log_g13m1.dbf',
'C:\oracle\E60/mirrlogA/log_g13m2.dbf') SIZE 50M  REUSE ,
GROUP 4 ('D:\oracle\E60/origlogB/log_g14m1.dbf',
'C:\oracle\E60/mirrlogB/log_g14m2.dbf') SIZE 50M  REUSE
...

actually the file should be created when installing SAP automatically rather than manually.

the machine hardware is Windows 2003 Server 32bit, and RAM 16G , Hard Disk 1TB disk array.

i changed the "db_cache_size= 177371824" and "sga_max_size=177371824" parameter in INITE60.ora

it likes OS error. but this is my first installation experince, who would help to find out what 's exactly reason

thanks

Kevin

Edited by: nakashima1 on Jan 12, 2010 3:14 AM

Edited by: nakashima1 on Jan 12, 2010 3:19 AM

Edited by: nakashima1 on Jan 12, 2010 3:26 AM

Edited by: nakashima1 on Jan 12, 2010 3:33 AM

Edited by: nakashima1 on Jan 12, 2010 3:34 AM

[Former Member]

Hi ,

As this is your first instaIlation i would like to recomend you these points.I am not sure if you are following installation guide before starting the installation.Also you have checked OS & DB combination which supported by SAP ECC2005 SR2.Please check these combinations at service.sap.com/pam.

If you are sure that you have choosen the OS DB which supported by ERP2005 SR2 then please follow installation guide to start with installation.

I hope before starting the installation you have set JAVA_HOME & page memory .After that you have installaed oracle s/w also.Please check with these points if you have done all.If yes then there is no doubt that sapinst will not create your DB.

Thanks..

Mohit

[Former Member]

Hello,

when the 'CREATE DATABASE' command is executed by sapinst, the controlfiles are created according to the value of the Oracle parameter control_files. Therefore, is F:\ORACLE\E60\ORIGLOGA\CNTRL a valid path at all?

Best Regards,

Michael

[Former Member]

Hello Michael,

thanks for your answer,

that path doesn't exit, but sapinstall create database, it will creat path and control file, isn't it.

i don't what 's the reason. please kindly give me more detail description

Thanks

Kevin

[Former Member]

Hello,

you are right, at least on windows, those directories are supposted to be created by sapinst.

When you are doing the installation from scratch, you should find the following entries in sapinst_dev.log (these are the entries from one of my previous installations, so you would have to replace sid and drive).

TRACE      2009-10-25 22:36:10.491 
Oracle cntrlfile: D:/oracle/BOQ\origlogA\cntrl\cntrlBOQ.dbf

TRACE      2009-10-25 22:36:10.491 
Oracle cntrlfile: D:/oracle/BOQ\origlogB\cntrl\cntrlBOQ.dbf

TRACE      2009-10-25 22:36:10.491 
Oracle cntrlfile: D:/oracle/BOQ\sapdata1\cntrl\cntrlBOQ.dbf

INFO       2009-10-25 22:36:10.663 [synxcpath.cpp:807]
           CSyPath::createDirectory() 
Creating directory D:\oracle\BOQ\origlogA\cntrl.

INFO       2009-10-25 22:36:10.679 [synxcpath.cpp:807]
           CSyPath::createDirectory() 
Creating directory D:\oracle\BOQ\origlogB\cntrl.

INFO       2009-10-25 22:36:10.679 [synxcpath.cpp:807]
           CSyPath::createDirectory() 
Creating directory D:\oracle\BOQ\sapdata1\cntrl.

Do you have those entries as well? Please copy them into the post. Of course, in case you have manually changed the control_files parameter after this particular installation step, this change would not be recognised by sapinst and consequently the path will not be created.

Best Regards,

Michael

[Former Member]

Hello, Michael,

yes, these folder have been created,

but no control file folder created.

what control file paramter, where?

i just chagned the parameter of INITSID.ora.

is it effected?

Kevin

sga_max_size = 1610612736

db_cache_size = 177371824

Edited by: nakashima1 on Jan 9, 2010 9:36 AM

[peter_dzurov]

Are you sure you haven't changed any other parameter like control_files?