error in creating database

[Former Member]

hai i am installing sap netweaver 2004s with a IBM DB2 as database.I got an error in Create database phase.

INFO 2011-11-28 02:22:06

Copied file 'C:/Program Files/sapinst_instdir/NW04S/SYSTEM/DB6/CENTRAL/AS/createDatabase.clp' to 'C:/Program Files/sapinst_instdir/NW04S/SYSTEM/DB6/CENTRAL/AS/createDatabase.2.clp'.

INFO 2011-11-28 02:22:06

Removing file C:\Program Files\sapinst_instdir\NW04S\SYSTEM\DB6\CENTRAL\AS\createDatabase.clp.

INFO 2011-11-28 02:22:06

Creating file C:\Program Files\sapinst_instdir\NW04S\SYSTEM\DB6\CENTRAL\AS\createDatabase.clp.

ERROR 2011-11-28 02:22:07

MDB-01016 SQL0294N The container is already in use. SQLSTATE=42730

ERROR 2011-11-28 02:22:07

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|9|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_DB6_DB|ind|ind|ind|ind|1|0|NW_DB6_CreateDb|ind|ind|ind|ind|16|0|CreateDatabase was executed with status ERROR

Please help me in solving this problem.....

Thanks in advance......

Dinesh.

[Former Member · Accepted solution]

Hello,

Please open a CSN message in the SAP support portal and they can help you.

Thanks,

Elise

[Former Member]

This worked excellently for me.

removing sapdata1, sapdata2, sapdata3, sapdata4, log_dir and recreating them

Ravi Kiran

[Former Member]

Hello,

<b>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|9|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_MSS_DB|ind|ind|ind|ind|2|0|MssSchemaCreate|ind|ind|ind|ind|9|0|CreateDatabase was executed with status ERROR.</b>

This Error occurs because the <b><SID>DATA1,<SID>DATA2,<SID>DATA3,<SID>DATA<X></b> and <b><SID>LOG1,<SID>DATA<x></b> are already containing the .mdf,.ndf and .ldf files.

So rename those directories to someother(Do not delete, just rename, as it might be used to attach the database incase you have detached it) and just create the above directories "<b><SID>DATA1,<SID>DATA2,<SID>DATA3,<SID>DATA<X></b> and <b><SID>LOG1,<SID>DATA<x></b>".

This should solve the problem.

Any questions, do post it back, will try to resolve it.

Many Thanks.

[Former Member]

Hi,

Is there any another DB running on a same host? if not then uninstall the DB S/W and install it again, then proceed with sapinst.

Best Regards,

Sachin.

[Former Member]

Hai Elise,

Thanks for the reply.

Dinesh.