Skip to Content
avatar image
Former Member

2 sap instance in one server

Hi,

I just did a R3Copy from PRD to DEV server. Later after that I've installed a new instance with normal installations ( export data are from the cd's ) in the same server. Questions :

1 - Do I need to change to owner for each database (since I've noticed both instance are using SAPR3 as default user )

2 - What about the listener configurations ? (e.g C11 - port 1527 & C12 - port 1528 )

FYI, This server are running on Windows Server 2003 and Oracle 9.2.0.7 (upgrade - old system files) and 4.6D

Regards,

Hazrienne

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 25, 2009 at 11:49 PM

    >

    > Questions :

    >

    > 1 - Do I need to change to owner for each database (since I've noticed both instance are using SAPR3 as default user )

    You cant. you mentioned that you use 4.6D, I assume that is the your kernel version and your product is SAP R/3 4.6C.

    This version does not allow for different owners (no MCOD)

    >

    >

    > 2 - What about the listener configurations ? (e.g C11 - port 1527 & C12 - port 1528 )

    It looks like you are using two differnt listeners, in that case the only thing you have to worry about is the port. In your case it seems that you are using a different port, so it is OK.

    >

    >

    > FYI, This server are running on Windows Server 2003 and Oracle 9.2.0.7 (upgrade - old system files) and 4.6D

    Oracle 9.2.0.7 is quite old. Remember that Oracle customer care support for 9i ended a while ago, and the free year of extended maintenance is also finished. I'd upgrade the oracle version

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 26, 2009 at 04:11 AM

    Getting error ora-12541 No listener after changed the C11 listener port, but the second instance (C12) worked.Here the current listener settings :

    ################

    1. Filename......: listener.ora

    2. Created.......: created by SAP AG, R/3 Rel. >= 4.0A

    3. Name..........:

    4. Date..........:

    ################

    LISTENER =

    (ADDRESS_LIST =

    (ADDRESS=

    (PROTOCOL=IPC)

    (KEY= C11.WORLD)

    )

    (ADDRESS=

    (PROTOCOL=IPC)

    (KEY= C11)

    )

    (ADDRESS=

    (PROTOCOL=IPC)

    (KEY= C12.WORLD)

    )

    (ADDRESS=

    (PROTOCOL=IPC)

    (KEY= C12)

    )

    (ADDRESS =

    (COMMUNITY = SAP.WORLD)

    (PROTOCOL = TCP)

    (HOST = ksbdev)

    (PORT = 1528)

    )

    )

    STARTUP_WAIT_TIME_LISTENER = 0

    CONNECT_TIMEOUT_LISTENER = 10

    TRACE_LEVEL_LISTENER = OFF

    SID_LIST_LISTENER =

    (SID_LIST =

    (SID_DESC =

    (SDU = 32768)

    (SID_NAME = C11)

    (ORACLE_HOME = D:\oracle\C11\ora92)

    )

    (SID_DESC =

    (SDU = 32768)

    (SID_NAME = C12)

    (ORACLE_HOME = D:\oracle\C12\ora92)

    )

    )

    and tnsnames.ora :

    ################

    1. Filename......: tnsnames.ora

    2. Created.......: created by SAP AG, R/3 Rel. >= 4.0A

    3. Name..........:

    4. Date..........:

    ################

    C11.WORLD=

    (DESCRIPTION =

    (SDU = 32768)

    (ADDRESS_LIST =

    (ADDRESS =

    (COMMUNITY = SAP.WORLD)

    (PROTOCOL = TCP)

    (HOST = ksbdev)

    (PORT = 1527)

    )

    )

    (CONNECT_DATA =

    (SID = C11)

    (GLOBAL_NAME = C11.WORLD)

    )

    )

    C12.WORLD=

    (DESCRIPTION =

    (SDU = 32768)

    (ADDRESS_LIST =

    (ADDRESS =

    (COMMUNITY = SAP.WORLD)

    (PROTOCOL = TCP)

    (HOST = ksbdev)

    (PORT = 1528)

    )

    )

    (CONNECT_DATA =

    (SID = C12)

    (GLOBAL_NAME = C12.WORLD)

    )

    )

    Any Ideas?

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 26, 2009 at 05:27 PM

    Solved!

    I just need to enter another entry for the 2nd instance port in listener.ora.So the parameter would be :

    (ADDRESS =

    (COMMUNITY = SAP.WORLD)

    (PROTOCOL = TCP)

    (HOST = ksbdev)

    (PORT = 1527)

    )

    (ADDRESS =

    (COMMUNITY = SAP.WORLD)

    (PROTOCOL = TCP)

    (HOST = ksbdev)

    (PORT = 1528)

    )

    and restart the listener again. 😊

    Add comment
    10|10000 characters needed characters exceeded