Re: Problem connecting to host.

From: arshad <arshadanisNOarSPAM_at_usa.net.invalid>
Date: 2000/04/16
Message-ID: <0615c12f.2e2e94e4@usw-ex0109-070.remarq.com>#1/1

I feel that your listener is not running or running with mismatch host addresses.
or the addresses in tnsnames.ora at client and addresses in listener.ora don not match. your listener.ora file residing at server in $ORACLE_HOME/network directory will look something as below .

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL= TCP)

          (Host= <your host name>) REM------try ping

with this hostname from client at os level.if it works then problem is with mismatch in above said .ora files.

(Port= 1521)

        )
       )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
       (SID_NAME = ORCL)
    )
   )

• I tried to give you a hint ,please inform me if it works at my email -- arshadanis_at_usa.net.
• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

Received on Sun Apr 16 2000 - 00:00:00 CDT