Newbie! Listener problems

From: Victor Tan <victan_ca_at_hotmail.com>
Date: Sat, 4 Nov 2000 15:10:08 -0000
Message-ID: <973350079.29755.0.nnrp-03.c2de12a0@news.demon.co.uk>

Hi,

I'm a new user to Personal Oracle8i running Windows 98. I'm currently trying to set up a JDBC connection using JDK1.3 but I'm always getting a connection error: "The Network Adapter could not establish the connection". After playing around with my system for a couple of days I've come to the conclusion that it is my own system, specifically a listener problem.

I try "tnsping 127.0.0.1" to ping my own computer but get an error: tns-1254: tns:no listener
when I try "lsnrctl"," status" it also gives me another list of errors...

Here is my listener.ora file:

# LISTENER.ORA Network Configuration File: c:\Oracle\Ora81\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))     (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\Oracle\Ora81)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = chee.project)
(ORACLE_HOME = c:\Oracle\Ora81)
(SID_NAME = chee)

    )
  )

*If anyone can help me to set up a proper listener I would much appreciate it thanks!!!*

Chee Received on Sat Nov 04 2000 - 09:10:08 CST