Hi what listener errors does it give?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Victor Tan" <victan_ca_at_hotmail.com> wrote in message
news:973350079.29755.0.nnrp-03.c2de12a0_at_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 Mon Nov 06 2000 - 04:20:44 CST
