cancel
Showing results for 
Search instead for 
Did you mean: 

Error during sap r/3 installation at update databse statistics

Former Member
0 Kudos

Hi friends,

I am getting an error during sap r/3 installation almost at the last stage.

the error is at update database statistics.

my configuration is

os: windows 2000 server.

d/b: oracle 9i.

erp: sap 4.7 ee

During oracle installation stage the oui is asking for create a database, i am chechking it ok. Is that a problem ?.

I am sending the log file. Please can anybody help me, where i am going wrong-

-


The log file----

Click Browse and give location of export1, as shown in the bellow figure

INFO 2007-02-04 21:46:32

Creating directory D:\oracle\DRS\sapdata4\drs620_5.

INFO 2007-02-04 21:46:32

Creating file system node D:\oracle\DRS/sapdata4\drs620_5 with type DIRECTORY succeeded.

INFO 2007-02-04 21:46:32

Creating directory D:\oracle\DRS\sapdata5\drs620_6.

INFO 2007-02-04 21:46:32

Creating file system node D:\oracle\DRS/sapdata5\drs620_6 with type DIRECTORY succeeded.

INFO 2007-02-04 21:46:32

Creating directory D:\oracle\DRS\sapdata5\drs620_7.

INFO 2007-02-04 21:46:32

Creating file system node D:\oracle\DRS/sapdata5\drs620_7 with type DIRECTORY succeeded.

INFO 2007-02-04 21:46:32

Creating directory D:\oracle\DRS\sapdata6\drs620_8.

INFO 2007-02-04 21:46:32

Creating file system node D:\oracle\DRS/sapdata6\drs620_8 with type DIRECTORY succeeded.

INFO 2007-02-04 21:46:32

Creating directory D:\oracle\DRS\sapdata6\drs620_9.

INFO 2007-02-04 21:46:32

Creating file system node D:\oracle\DRS/sapdata6\drs620_9 with type DIRECTORY succeeded.

INFO 2007-02-04 21:46:32

Creating directory D:\oracle\DRS\sapdata6\drsusr_1.

INFO 2007-02-04 21:46:32

Creating file system node D:\oracle\DRS/sapdata6\drsusr_1 with type DIRECTORY succeeded.

INFO 2007-02-04 21:46:32

Creating directory D:\oracle\DRS\sapdata2\roll_1.

INFO 2007-02-04 21:46:32

Creating file system node D:\oracle\DRS/sapdata2\roll_1 with type DIRECTORY succeeded.

INFO 2007-02-04 21:46:32

Creating directory D:\oracle\DRS\sapdata3\temp_1.

INFO 2007-02-04 21:46:32

Creating file system node D:\oracle\DRS/sapdata3\temp_1 with type DIRECTORY succeeded.

INFO 2007-02-04 21:46:32

Creating directory D:\oracle\DRS\sapdata1\system_1.

INFO 2007-02-04 21:46:32

Creating file system node D:\oracle\DRS/sapdata1\system_1 with type DIRECTORY succeeded.

INFO 2007-02-04 21:46:32

Processing of all file system node operations of table tORA_SapdataNodes succeeded.

INFO 2007-02-04 21:46:33

Processing of all file system node operations of table tORA_DatabaseServerNodes succeeded.

INFO 2007-02-04 21:46:34

Processing of all file system node operations of table tORA_SapdataNodes succeeded.

INFO 2007-02-04 21:46:35

Creating file c:\oracle\ora90\database\initDRS.ora.

INFO 2007-02-04 21:46:36

Creating file C:\oracle\ora90\database\initDRS.sap.

INFO 2007-02-04 21:46:37

Copying file F:/sap4.7/ker/NT/COMMON/INSTALL/INITSID.DBA to: c:\oracle\ora90/database/initDRS.dba.

INFO 2007-02-04 21:46:37

Creating file c:\oracle\ora90\database\initDRS.dba.

INFO 2007-02-04 21:46:38

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 21:46:39

Moving file c:/oracle/ora90/database/initDRS.ora to: orig_init_ora_tmp.txt.

INFO 2007-02-04 21:46:39

Moving file C:/SAPinst ORACLE KERNEL/changed_init_ora_tmp.txt to: c:\oracle\ora90\database\initDRS.ora.

INFO 2007-02-04 21:46:39

Removing file C:/SAPinst ORACLE KERNEL/orig_init_ora_tmp.txt.

INFO 2007-02-04 21:46:40

Creating file C:\SAPinst ORACLE KERNEL\oradim.log.

INFO 2007-02-04 21:46:45

See 'c:\oracle\ora90/bin/oradim -new -sid DRS -STARTMODE auto' output in 'C:\SAPinst ORACLE KERNEL\oradim.log'.

INFO 2007-02-04 21:46:45

'c:\oracle\ora90/bin/oradim -new -sid DRS -STARTMODE auto' returned with '0'.

INFO 2007-02-04 21:46:46

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 21:46:49

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 21:59:57

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:00:00

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:00:44

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:00:46

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:01:31

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:01:34

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:02:18

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:02:20

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:03:06

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:03:09

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:03:55

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:03:57

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:04:44

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:04:46

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:05:32

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:05:35

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:06:21

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:06:23

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:07:10

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:07:12

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:07:58

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:08:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:08:48

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:08:50

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:09:38

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:09:40

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:09:44

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:09:46

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:10:06

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:10:09

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:10:39

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:10:41

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:10:44

Moving file c:/oracle/ora90/database/initDRS.ora to: orig_init_ora_tmp.txt.

INFO 2007-02-04 22:10:44

Moving file C:/SAPinst ORACLE KERNEL/changed_init_ora_tmp.txt to: c:\oracle\ora90\database\initDRS.ora.

INFO 2007-02-04 22:10:44

Removing file C:/SAPinst ORACLE KERNEL/orig_init_ora_tmp.txt.

INFO 2007-02-04 22:10:45

Creating file C:\SAPinst ORACLE KERNEL\lsnrctl.log.

INFO 2007-02-04 22:10:46

See 'c:\oracle\ora90/bin/lsnrctl stat' output in 'C:\SAPinst ORACLE KERNEL\lsnrctl.log'.

INFO 2007-02-04 22:10:46

'c:\oracle\ora90/bin/lsnrctl stat' returned with '3'.

INFO 2007-02-04 22:10:46

Creating file C:\SAPinst ORACLE KERNEL\lsnrctl.log.

INFO 2007-02-04 22:10:48

See 'c:\oracle\ora90/bin/lsnrctl start' output in 'C:\SAPinst ORACLE KERNEL\lsnrctl.log'.

INFO 2007-02-04 22:10:48

'c:\oracle\ora90/bin/lsnrctl start' returned with '0'.

INFO 2007-02-04 22:10:48

Copying file F:/sap4.7/ker/NT/COMMON/INSTALL/ORADBUSR.SQL to: ./oradbusr.sql.

INFO 2007-02-04 22:10:48

Creating file C:\SAPinst ORACLE KERNEL\oradbusr.sql.

INFO 2007-02-04 22:10:49

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:10:52

Changed working directory to C:\SAPinst ORACLE KERNEL.

PHASE 2007-02-04 22:10:54

Database Load

INFO 2007-02-04 22:10:58

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:10:59

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:00

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:01

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:02

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:02

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:02

Task files created

INFO 2007-02-04 22:11:03

Command files created

INFO 2007-02-04 22:11:05

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:05

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-04 22:11:05

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 00:06:44

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 03:43:19

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 04:55:23

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 05:17:24

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 05:39:25

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 05:45:25

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 05:57:26

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:00:26

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:03:26

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:05:26

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:07:26

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:08:27

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:09:28

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:24:46

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:24:46

Processes finished successfully

INFO 2007-02-05 06:26:23

Creating file C:\SAPinst ORACLE KERNEL\ddicora.sql.

INFO 2007-02-05 06:26:25

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:26:30

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:26:32

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:26:43

Moving file c:/oracle/ora90/database/initDRS.ora to: orig_init_ora_tmp.txt.

INFO 2007-02-05 06:26:43

Moving file C:/SAPinst ORACLE KERNEL/changed_init_ora_tmp.txt to: c:\oracle\ora90\database\initDRS.ora.

INFO 2007-02-05 06:26:43

Removing file C:/SAPinst ORACLE KERNEL/orig_init_ora_tmp.txt.

INFO 2007-02-05 06:26:43

Moving file c:/oracle/ora90/database/initDRS.ora to: orig_init_ora_tmp.txt.

INFO 2007-02-05 06:26:43

Moving file C:/SAPinst ORACLE KERNEL/changed_init_ora_tmp.txt to: c:\oracle\ora90\database\initDRS.ora.

INFO 2007-02-05 06:26:43

Removing file C:/SAPinst ORACLE KERNEL/orig_init_ora_tmp.txt.

INFO 2007-02-05 06:26:43

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:26:45

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:26:48

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:26:52

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:26:55

Creating file C:\SAPinst ORACLE KERNEL\brconnect.log.

INFO 2007-02-05 06:26:55

Changed working directory to C:\SAPinst ORACLE KERNEL.

INFO 2007-02-05 06:26:55

See 'D:\usr\sap\DRS\SYS\exe\run/brconnect -c -f crsyn -o SAPDRS' output in 'C:\SAPinst ORACLE KERNEL\brconnect.log'.

ERROR 2007-02-05 06:26:55

MOS-01012 PROBLEM: 'D:\usr\sap\DRS\SYS\exe\run/brconnect -c -f crsyn -o SAPDRS' returned with '128' which is not a defined as a success code.

ERROR 2007-02-05 06:26:55

FJS-00012 Error when executing script.

_____________________________

kindly help me where i am going wrong.

Yours friendly,

Bharath.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi bharath--

ur mistacke was -- when the system prompts for the creation of new databse u should have selected no. but u have selected yes -- so it has created complete database rather than a database table structure which is required.

feel free to revert back

cheers.

shabbir khan

Answers (3)

Answers (3)

Former Member
0 Kudos

Great thanks to all of you dear friends, you have given great support. SAP installation task was successfully completed.

Your friend,

Bharath.

Former Member
0 Kudos

Hi Andreas,

many thanks to you for the timely help.

a.)I want to know why there is an error at brconnect ? why is it returning an error code (128) at UPDATE DATABASE STATISTICS stage.

I have read in this forum itself that the UPDATE STATISTICS need not be suceesfully completed and we can edit database.r3s

" ..on the other hand you can easily invoke the update statistics after the installation has ended (succesfully!)...edit DATABASE.R3S (or the appropriate template file you are using) by changing the status=ERROR to status=OK...this will let you finish the installation..-GreetZ, AH."

I have searched for this file (database.r3s) in my system in vain Where can i find this file database.r3s?.

Have i done any configuration mistake at the pre-installation stage. I have installed Oracle 9.0 using setup.exe of oracle. should i use sapserver.cmd to install oracle?.I havent applied any patch for Oracle 9.0

Should I apply any patch just the same way we do for Oracle 8.1.x ?. If so, where can i get the patch for Oracle 9.0 .?.

b.) You said there should not be any spaces in file path (ex: C:/SAPinst ORACLE KERNEL/) . But I havent specified file path, the r/3 setup itself has created the directory path.

c.) I want to know one thing- should we create a database before installing r/3. When we are installing Oracle 8/9. x what are the components that we are installing?

Your friend,

Bharath.

andreas_herzog
Active Contributor
0 Kudos

a) sorry...my fault! *.r3s come with sap r/3 4.x...you run on kernel 6.20/6.40...so you'd have to edit the corresponding *.xml file...

b) this can't be true, as you have the choice to name all your installation sources ... i presume you did not specify a valid tmp/temp directory where sapinst will put all relevant files, such as temporary installation logs

c) NO...do NOT create a database - even if oracle installer asks you to! but this is also stated in the installation guide...which one do you use??? the sapinst routine will create an oracle instance, all relevant tablespaces, logs, control files etc.

GreetZ, AH

andreas_herzog
Active Contributor
0 Kudos

a) usually NO database must be created...this will be done after the oracle software installation by oradim (oracle instance manager)

b) you should avoid path names with blanks (like in 'C:\SAPinst ORACLE KERNEL\')

c) any more information? for example from the brconnect error log?

GreetZ, AH