Oracle DB Link issues

[Oranewbie]

Hi Guys,
I am having some issues trying to setup a DB Link for an Oracle 9i to 8i Database.

I suspect my TNSNAMES entry on the 9i box, as i cannot connect from the 9i box to the target system using SLQ*PLUS.

I have tried many different combinations on the TNSNAMES entry on the 9i box, but had no luck.

I am trying to connect to the WDEV.COMPANY.COM instance, can anyone advise on an appropriate TNS entry for this DB?

Here is the Listener file for the target DB:

################
# Filename......: listener.ora
# Name..........: ESLAM.COMPANY.COM
# Date..........: 06-MAY-99
################
SQLNET.AUTHENTICATION_SERVICES = (NONE)

USE_PLUG_AND_PLAY_LSNR1527 = OFF
USE_CKPFILE_LSNR1527 = OFF
LSNR1527 =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= WDEV.COMPANY.COM)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= WDEV)
)
(ADDRESS =
(COMMUNITY = DBUSER.COMPANY.COM)
(PROTOCOL = TCP)
(Host = <ip address>)
(Port = 1527)
)
)
STARTUP_WAIT_TIME_LSNR1527 = 0
# CONNECT_TIMEOUT_LSNR1527 = 10
CONNECT_TIMEOUT_LSNR1527 = 0
TRACE_LEVEL_LSNR1527 = OFF
#SID_LIST_LSNR1527 =
# (SID_DESC =
# (GLOBAL_DBNAME = WDEV.COMPANY.COM)
# (SID_NAME = WDEV)
# (ORACLE_HOME = /SLAM/oracle8i)
# (PRESPAWN_MAX = 0)
# )

SID_LIST_LSNR1527 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = WDEV.COMPANY.COM)
(SID_NAME = WDEV)
(ORACLE_HOME = /SLAM/oracle8i)
(PRESPAWN_MAX = 0)
)
(SID_DESC =
(GLOBAL_DBNAME = WILD2.COMPANY.COM)
(SID_NAME = WILD2)
(ORACLE_HOME = /SLAM/oracle8i)
(PRESPAWN_MAX = 0)
)
)

[Oranewbie]

Hi Everyone,

I have fixed the issue, it was the TNSNAMES entry as I suspected.

Someone had copied and pasted from windows/outlook resulting in bad charachters in the file. Removing all spaces and carriage returns fixed it.

:)