Re: How can I know my "Host:Port:Sid"

From: Mike Mountjoy <michael_at_london.virgin.net>
Date: Tue, 12 May 1998 09:06:48 -0700
Message-ID: <6j8vs4$t2i$1@nclient3-gui.server.virgin.net>

Hi there.

You don't say which platform you are using or which network protocol.

If I assume you are using either NT or a UNIX variant and SQL*NET v2.x then you should
have a file called tnsnames.ora located in the Oracle home of the server (on NT) or
/var/opt/oracle on a UNIX platform or Oracle home . The TNSNAMES file will tell you everything

shopdb =
  (DESCRIPTION =
   (ADDRESS_LIST =
    (ADDRESS =
(COMMUNITY = TCP.virgin.net )
(PROTOCOL = TCP )
(HOST = shop.acme.virgin.net)
(PORT = 1200)

    )
   )
   (CONNECT_DATA =
    (SID = shopdb_1 )
    (GLOBAL_NAME = shopdb_1.world)
   )
  )

In the above host = shop.acme.virgin.net

                      sid = shopdb_1
                      port 1200

Easy isn't it .

Regrds,
Mike

Huaping Luo wrote in message <6j7vhq$6s5$1_at_cronkite.cc.uga.edu>...

>I have a Oracle database.Recently, I want to connect to my Oracle database
>through JDBC thin driver (v7.34). However, if I use the JDBC thin driver,
>I must provide "Host:Port:Sid". How can I know my port number and sid

number
>because my current system administrator doesn't know them. The system administrator

>who installed ORACLE has left for other job.
>
>Please help.
>
>Thanks in anticipation.
>
>                                      Huaping Luo
>

Received on Tue May 12 1998 - 11:06:48 CDT