listener error

[Former Member]

Hi All,

We have the BI 7.0 and EP 7.0 systems installed on the same server. Although, the systems are working fine, sometimes after the restart we are not able to connect to the BI system. Sometimes after killing and restarting the listener, the system works fine.

Please find below the Listener file. Can you please confirm the following:

1) Can we have 2 BID and EPD databases configured to access the database at the sape port (1527)?

2) Although there are no EPD entries in the Listerer.ora file, I am able to access the URL? Why?

3) What should be the most efficient way to configure 2 databases on same server?

Thanks In Advance.

Regards,

Antarpreet

[Former Member]

Here is the listener.ora file:

bidadm> cat listener.ora

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

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

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

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

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

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = BID.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = BID)

)

(ADDRESS =

(PROTOCOL = IPC)

(KEY = EPD.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = EPD)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = sapbid)

(PORT = 1527)

)

)

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = BID)

(ORACLE_HOME = /oracle/BID/102_64)

)

(SID_DESC =

(SID_NAME = EPD)

(ORACLE_HOME = /oracle/EPD/102_64)

)

)

Regards,

Antarpreet

[former_member524429]

Hi,

Have you referred [SAP Note 153835 - Starting Multiple tnslsnr on same server|https://service.sap.com/sap/support/notes/153835] ? It will server your most of answers.

Regards,

Bhavik G. Shroff