TNS:protocol adapter not loadable

[Former Member]

Hi,

currently we installed a new BIW system in an already existing BI older version system. After installing new system as separate instance ,when i tried restarting the os ..the older BI system is not able to operate.

when i try to start its showing the trace as TNS:protocol adapter not loadable.

thing is we got to deliver this system by this weekend..

kindly help us resolving the issue..

jag

[Former Member · Accepted solution]

Hi,

This problem because of over writing of TNS listner file.

While installing new system, you will get opting Keep listner.ora. I think you didn't select that option.

check configuration using LSNRCTL

Regards

Ben

[Former Member]

Here is listener.ora

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

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

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

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

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

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

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = BW3.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = BW3)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = mysapbw)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = BW3)

(ORACLE_HOME = D:\oracle\BW3\920)

)

)

[Former Member]

Hi,

Could you please check SAP Note 153835 - Starting Multiple tnslsnr on same server?

Good Luck

Regards

Ben

[Former Member]

Hi,

Could you please send the listner.ora and listner.ora.bak files?

path: /oracle/<Instance Name>/920_64/network/admin/

Regards

Ben

[Former Member]

ya i checked its comin like TNs:00527 protocol adapter not loadable..could u pls suggest me some valid steps to overcome this error..

[Former Member]

Thnx for ur answer..could you pls explain it in details