2 sap instance in one server

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[former_member204746]

have you set environement variable TNS_ADMIN ?

if so, it is set to what?

[fidel_vales]

>

> 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