Re: port number of ORACLE for JDBC

As the ORACLE account, type 'lsnrctl stat'. This will tell you the state of the listener.

To test the state of SQL*Net, type 'tnsping <service name>', where <service name> is the name of a valid service, i.e., an entry in tnsnames.ora.

hth -

Regards,
jh

Anne Hanson wrote:

> Charles Clavadetscher wrote:
> >
> > Port Nr. 1521 is OK. I used the same and it works. The problem must be
> > somewhere else. Did you install Sql*Net and start the Listener service?
> > Luck.
> > Charles
>
> This may be pushing the limits of my Oracle knowledge. How can I verify
> that Sql*Net and the Listener service are started? Also do I need these
> if I am always on the same machine as my server?
>
> Thanks for your reply.
>
> Jeff

--
Jared Hecker
jared_at_hwai.com
***
*****LEGAL NOTICE TO ALL BULK E-MAILERS*****
NOTICE TO BULK EMAILERS: Pursuant to US Code, Title 47, Chapter 5,
Subchapter II, page 227, any and all non solicited commercial E-mail sent to
this address is subject to a download and archival fee in the amount of $500
US. E-mailing denotes acceptance of these terms and this kind of email is
being collected and will be reported to authorities and agency for
collection.