OS/DB Migration - DATABASEINSTANCE_IND_ORA

[Former Member]

Hello,

we are migrating a SAP R/3 4.6C SUN Solaris with oracle to a cheaper solution with RedHat Linux and oracle 10G.

At this moment we have a problem when get the DATABASEINSTANCE_IND_ORA phase.

ERROR 2011-12-03 23:25:07 DBCREATEDB_IND_ORA InternalInstallationDo:0

Create Database failed errorcode = 13504.

ERROR at line 1:

ORA-13504: No SYSAUX datafile clause specified

The problem is when the "R3SETUP -f DBMIG.R3S" wants to create the database.

Where can a include the SYSAUX creation statement?

Edited by: Carlos Biscaia - PTPRO on Dec 4, 2011 1:42 AM

Edited by: Carlos Biscaia - PTPRO on Dec 4, 2011 1:43 AM

[former_member189725]

What best you can do is edit the DBMIG.R3S(take a copy before you edit), check the database creation syntax , add the sysaux datafile clause.

An example is

CREATE DATABASE WIP CONTROLFILE REUSE MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXLOGHISTORY 1000 MAXDATAFILES 254 MAXINSTANCES 50 NOARCHIVELOG CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 DATAFILE '/oracle/WIP/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE '/oracle/WIP/sapdata1/temp_1/temp.data1' SIZE 4096M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/WIP/sapdata1/undo_1/undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M SYSAUX DATAFILE '/oracle/WIP/sapdata1/sysaux_1/sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

LOGFILE GROUP 1 ('/oracle/WIP/origlogA/log_g11m1.dbf',

'/oracle/WIP/mirrlogA/log_g11m2.dbf') SIZE 50M REUSE ,

GROUP 2 ('/oracle/WIP/origlogB/log_g12m1.dbf',

'/oracle/WIP/mirrlogB/log_g12m2.dbf') SIZE 50M REUSE ,

GROUP 3 ('/oracle/WIP/origlogA/log_g13m1.dbf',

'/oracle/WIP/mirrlogA/log_g13m2.dbf') SIZE 50M REUSE ,

GROUP 4 ('/oracle/WIP/origlogB/log_g14m1.dbf',

'/oracle/WIP/mirrlogB/log_g14m2.dbf') SIZE 50M REUSE

;

Edited by: Ratnajit Dey on Dec 4, 2011 10:06 PM

[Former Member]

Hi,

do you know how the orascr.sql file is created? every time I start the R3SETUP -F DBMIG.R3S the file orascr.sql is recreated...so I just need to change on the original file.

connect / AS SYSDBA;

SET ECHO ON;

SET TERMOUT ON;

SHUTDOWN ABORT;

STARTUP NOMOUNT PFILE=init.ora;

CREATE DATABASE UND

CONTROLFILE REUSE

MAXDATAFILES 254

MAXLOGFILES 255

MAXLOGHISTORY 1000

MAXLOGMEMBERS 3

MAXINSTANCES 50

CHARACTER SET "WE8DEC"

DATAFILE

'/oracle/UND/sapdata1/system_1/system.data1' SIZE 350M REUSE

NOARCHIVELOG

LOGFILE

GROUP 11 (

'/oracle/UND/origlogA/log_g11m1.dbf',

'/oracle/UND/mirrlogA/log_g11m2.dbf'

) SIZE 20M REUSE

,GROUP 13 (

'/oracle/UND/origlogA/log_g13m1.dbf',

'/oracle/UND/mirrlogA/log_g13m2.dbf'

) SIZE 20M REUSE

,GROUP 12 (

'/oracle/UND/origlogB/log_g12m1.dbf',

'/oracle/UND/mirrlogB/log_g12m2.dbf'

) SIZE 20M REUSE

,GROUP 14 (

'/oracle/UND/origlogB/log_g14m1.dbf',

'/oracle/UND/mirrlogB/log_g14m2.dbf'

) SIZE 20M REUSE

;

EXIT

exit

[former_member188883]

Hi,

Refer the thread below. They had similar problems like yours. Problem got resolved by using the updated installation Master DVD.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hello,

I guess you are facing this problem during IMPORT ?

Normally this happens only if we miss sysaux datafile statement when creating database manually. But here in this case the SAPinst should take care of it automatically.

Just to be sure, please verify the SAP media you are using for IMPORT, for e.g. sapinst, kernel, client etc.

Thanks

[Former Member]

Hi,

this is an old version...not sapinst but R3SETUP

Edited by: Carlos Biscaia - PTPRO on Dec 4, 2011 11:56 PM

[former_member189725]

can you paste the steps in DBMIG.R3S . I do not have a sample DBMIG.R3S . Also paste the content of the section DATABASEINSTANCE_IND_ORA.

[Former Member]

[DBCREATEDB_IND_ORA]

ACTION=

CLASS=COraCreateDb

CONFIRMATION=

CONFIRMED=

MIRRLOGGROUP=YES

MSGID=RI_GIST_DBCREATEDB_IND_IND

ORIGLOGGROUP=2

STATUS=ERROR

STEP_ENV=DB_ENV

[former_member188883]

Hi Carlos,

Have you tried using updated Installation Master DVD ?

Regards,

Deepak Kori

[former_member189725]

Please refer to this thread [;.

There are some notes mentioned ,please check if you need to switch to new tablespace layout .