Re: how to link to database

Avi Abrami wrote:

> Huaxin wrote:
>
> > 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.

sc Received on Thu Oct 12 2000 - 10:15:44 CDT