Hello Guys:

If I am connecting to a remote database unless I use the it will not connect. Can anyone please give me some clues..

On my local machine: tnsnames.ora
PCDW.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.242.27)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.242.27)(PORT = 1526))
)
(CONNECT_DATA =
(SID = pcdw)
)
)

SQLPLUS Session: (after removing the .world in tnsnames.ora)
SQL> connect pecdm/pecdm@pcdw
ERROR:
ORA-12154: TNS:could not resolve service name

Warning: You are no longer connected to ORACLE.
SQL> connect pecdm/pecdm@pcdw.world
Connected.

PCDW.world is a remote oracle 8i instance on an Win 2000 Adv Svr.

-----------

# SQLNET.ORA Network Configuration File: D:\Oracle\Ora8i\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = prenhall.com

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

-----------------------

# LISTENER.ORA Network Configuration File: D:\Oracle\Ora8i\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = unemana_nt)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = unemana_nt)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\Ora8i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = bits)
(ORACLE_HOME = D:\Oracle\Ora8i)
(SID_NAME = bits)
)
)

------------------------------------

The above attached tnsnames.ora, sqlnet.ora and listener.ora are the files from the local database instance i have on..

Thx, ST2000