Skip to Content
0
Dec 06, 2011 at 09:10 AM

Multiple database in single server

500 Views

Hi experts,

Please tell me how to configure multiple SID with single listener.

I configured the DR setup of two databases in single server. Now the problem is, if I start one listener from orapm1(CRM), my data is replicating only for CRM, and if I am going to start my listener from oraPE2 user (DBM), error is coming u201C listener is already startu201D but DBM is not replicating with DR site.

And when I stop the listener from oraPM1, and start listener from user oraPE2(DBM), my DBM is replicating properly, I want to start both in parallel with one listener.

Right now I have only one port for both database (1527) and only one LISTENER, should I need to change the port for one server e.g DBM (primary and standby), and then change in listener files. For both side (primary and standby)

If I am correct please let me know the steps, what precautions we need to take.

And what change I need to do in listener file.

2nd) Can I work on same port for both SIDs, if yes please tell me the steps.

My CRM is working properly so I need to change in DBM part.

I am attaching listener file from both users in same server (10.11.230.12)

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER_PE2 =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = PE2.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = PE2)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = 10.11.230.12)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PE2)

(ORACLE_HOME = /oracle/PE2/102_64)

)

)

pm1 listener file

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = PM1.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = PM1)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = 10.11.230.12)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PM1)

(ORACLE_HOME = /oracle/PM1/102_64)

)

)

Thanks in advance.