TNS-12533: TNS:illegal ADDRESS parameters

[vijay_kumar133]

Hi

I need to connect from BI system to external Oracle system by using DBCONNECT For this i am trying establish a connection while doing this TNSPING is giving error. as

TNS-12533: TNS:illegal ADDRESS parameters

entry in the file is

DB0.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = relmetrodev)

(PORT = 1523)

)

)

(CONNECT_DATA =

(SID = DB0)

(GLOBAL_NAME = DB0.WORLD)

)

)

DBCON.WORLD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = 10.125.10.213)

(PORT = 1521)

)

)

(CONNECT_DATA =

(SID = METRODB)

(GLOBAL_NAME = DBCON.WORLD)

)

)

Kindly help i need to do nay change in SQLNET.ORA file or not required.

where exactly the TNS entry is wrong.

error shows while pinging is

tnsping DBCON

TNS Ping Utility for Solaris: Version 10.2.0.4.0 - Production on 19-MAY-2010 15:53:46

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:

/oracle/DB0/102_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact

TNS-12533: TNS:illegal ADDRESS parameters

Regards

Vijay

[Former Member]

You have to enter the settings for your external system into the tnsnames.ora on your BI system.

On the external system, you should check if tcp.invited_nodes is set. If so, add your BI system to it and reinitialize your listener.

Kind regards,

Mark

[vijay_kumar133]

hi

got resolved need to make tns entry in sapmnt/oracle as welll as in application too..