Skip to Content
0
May 19, 2010 at 10:30 AM

TNS-12533: TNS:illegal ADDRESS parameters

928 Views

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