Only when using the standard listener, called listener.
For named listeneres, that would be
lsnrctl <listener_name> services
> > > Hi, I am using JDBC thin driver to query my Oracle 8i personal
> > > edition installed on NT box.
> > > Now I just wonder which values to insert for the URL for the driver
> > > It says to be the form "host:port:sid"
> > > Suppose my workstation is "carvel.srv.blahblah"
> > > how can I get the sid of my database (I am newbie, really),
> > > and what is the port number?
> > > Thanks a lot!
> > To find out the SID:
> > If you can connect to the database via SQL*Plus, the following
> > query will give you the SID:
> > select name from v$database
> > To find out the port
> > On the database server host machine, type the following command:
> > lsnrctl services
> > Somewhere in the output of that command, you should be able
> > to get the port number.
> > HTH,
> > Avi.
> You may not able to get the right port number by merely type command as
> 'lsnrctl services'.
> And you may want to specify the service name along with this command as
> 'lsnrctl services <the service name>'
> The service name can be found in the tnsnames.ora. It is the string
> left to the first = sign of the entry of your SID.
> You oracle DBA should be able to tell it.