Skip to Content
avatar image
Former Member

More than one SAP systems on same Windows Server 2003 - Oracle 10g

Hello Experts,

We have Windows Server 2003 with 32 GB RAM, 2 quadcore CPU, plenty of space. Already running with NW 700 AS Java on Oracle 10g.

Now we need to install a seperate NW 700 AS Java central instance - so please help me in clarifying following doubts - we don't want to use MCOD.

1. Do we need to install Oracle 10g software again or we can use the existing Oracle 10g installed files. If yes then will the Oracle Home for both the SAP instances will be same - any steps needs to be done for that.

2. Any other steps which needs to be taken care before and after the second instance installation.

3.SAP Note 98252 - speaks about changes in oraInst.loc before the second instance installation - Does it applicable for Windows - Oracle environment also. I am not able to find out this file.

Listener and Tnsnames file changes mentioned in this note seems to be applicable on windows platform also.

Pointers to related documentation would be highly appreciated.

Thanks

Davinder

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 19, 2009 at 11:55 AM

    Hello Davinder,

    > 1. Do we need to install Oracle 10g software again or we can use the existing Oracle 10g installed files. If yes then will the Oracle Home for both the SAP instances will be same - any steps needs to be done for that

    Theoretical you can use the same ORACLE_HOME, but i would really recommend to install the database software again in a different ORACLE_HOME. It will make a lot of things easier

    > 2. Any other steps which needs to be taken care before and after the second instance installation.

    The same as by the first installation, but keep in mind of the listener port - you will need to specify a different one.

    > Does it applicable for Windows - Oracle environment also. I am not able to find out this file.

    On windows it is a registry key (for more information please take a look at metalink note #564192.1)

    C:\>reg query HKLM\SOFTWARE\ORACLE /v inst_loc

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Davinder,

      > Can we have a common listener on windows platform and modify the listner.ora and tnsnames.ora file as per SAPNote 98252.

      Yes you can do that, but i also would not recommend this. You will have dependencies between the both databases, because of the listener binary belongs to one installation. My recommendation - install 2 listeners run them on different ports.

      > Do we need to take any steps for maintaing Oracle Inventory in windows system having multiple instances.

      SAP is not using one global oraInventory, it uses its own global inventory for each installation. That makes no sense to me and i have never understand why they want that (normally thats not the use of a global oraInventory). But as per Sapnote #350251 (Point G) you have to set the registry key value to the new <SID> location, before installing the database software.

      For more information about local and global oraInventory please read metalinknote #564192.1.

      Regards

      Stefan

  • avatar image
    Former Member
    May 20, 2009 at 12:26 PM

    Hi,

    Yes....you can install more than one SAP system with dedicated database.

    While installing SAP, in one of the screens it will ask listener port....for already existing system u would have given the port as 1527, so make sure that Name of the listener and port number are different.

    We have done this before...so don't worry..go ahead.....just be careful with instance numbers and ports.

    Regards,

    Siv

    Add comment
    10|10000 characters needed characters exceeded