How to install two instance on one server

[Former Member]

Dear Guru,

I want to install two instance on one server.

I have installed IDES server ( win 2k3 64 bit with SQL 2005 ECC 6.0)

Drive is

c: 20 GB for os

d: 5 gb swap

e: 5 gb swap

f: 450 GB database.

The same server i want to installed SOLMAN 4.0 with sql 2005.

Please suggest me how to installed without affcting IDES server.

Amol

[Former Member]

Hi,

You only have to consider 2 things :

1. SAPTRANSHOST entry in hosts file will be the same for both systems

this mean that both systems will share the same transport directory

2. system numbers must be different

Regards,

Wojtek

[Former Member]

Thankx for reply,

Please tell me shall i againg install SQL 2005 .vbs script( sql installed ) or using same databse shall i start from solman master.......

Amol

[Former Member]

Hi Amol,

If you have installed the unicode system then there is no need of installing the sql server again.

Regards,

Vamshi.

[Former Member]

Hi amol,

using the same database u can install another instance through MCOD.

u need to give different SID for the new system.

when u run sapinst it will give u an option whether u go for MCOD or install another database. Go for MCOD.

award points if helpful.

-sandeep

[Former Member]

HI,

If i will satrt througt sapinst using same databse with using option MCOD.(diff SID & system No)

is there any problem after installation with SQL service.will it be over right sql service.

Please advise.

Regards

Amol

[Former Member]

Hi,

You only have to consider 2 things :

1. SAPTRANSHOST entry in hosts file will be the same for both systems

this mean that both systems will share the same transport directory

Regards,

Wojtek

***

This is not true. Your SAPTRANSHOST will remain the same, but you can (and should) specify independent trans directories with the DIR_TRANS and and EPS profile parameters to designate where the instance trans files should be located (i.e. /usr/sap/trans_SID). I recommend you make this change in the existing host first, and then clear out the trans directory. Let the 2nd instance install into it and then alter that one too (thereby moving the files to the new /usr/sap/trans_SID2).

Edited by: David Ingersoll on Jan 31, 2008 3:12 PM