cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple SAP SIDs on single Physical machine. Windows with Oracle

Former Member
0 Kudos

Hi

I need bit information regarding this issue,

I am installing 3 SIDs on single machine

1. ECC 6.0 EHP4

2. Netweaver PI.

3. Netweaver MI.

Operating System : Wiindows 2008 Server.

Database: Oracleg 10.2.0.4 .

All done successfuly however i am not able to start all three servers at the same time, only one can be up at a single time.

As per you recomendation

1. I have 3 diffrent SIDs and unique instance number.

2. However only single Listner there on my machine.

2. Oracle Home is also a single.

Can you please advise what could be the exact Couse of my issue.

Regards

Gagan

Accepted Solutions (0)

Answers (2)

Answers (2)

volker_borowski2
Active Contributor
0 Kudos

HI,

did you restrict the memory amount for all Instances upon installation?

If not, you might hit memory shortage, because each installation gave

the entire memory to the just installed instance.

If all Instances are configured zero-administration-management, you

probably need to downsize PHYS_MEMSIZE in the sap profiles.

BTW: MCOD ? or not MCOD (not supported with a single ORACLE_HOME).

Volker

Former Member
0 Kudos

Yeah, you are correct Volkar.

Its cos of memory restriction... I made changes yesterday evening. Here is the SAP Note 88416 for this issue.

Thanks for your valuable suggestion.

Regards

Gagan

former_member311580
Active Participant
0 Kudos

Hello Gagan,

See note 562403:

13. Do I require a dedicated listener for each database instance?

If you operate several database instances on a single node, only one

listener is required, even if the individual instances have

different Oracle releases. You must simply make sure that you use

the listener for the highest Oracle version that was installed

(downward compatibility). You can then enter all existing instances

in the relevant listener.ora. See the example for listener.ora in

Note 98252.

If you nevertheless decide to use several listeners in specific

cases, refer to the procedure described in Note 153835.

You should create an Oracle_Home for each SID database.

Regards,

Rafa