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