Re: Still have not got "HOST.PORT.SID"

Dear Luo,

I saw your listener.ora file which you had posted earlier. Your listener is configured only for ipc protocol. You need to configure your listener for tcp/ip where you will have setting with port & sid.

Something like ...

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS =
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = 172.16.3.12)
          (Port = 1521)
        )

Good Luck

Biju Joseph

In article <6jb0jj$q30$1_at_cronkite.cc.uga.edu>,   huaping_at_pollux.cs.uga.edu (Huaping Luo) wrote:
>
> Thank all of you who has responded my request.
> Unfortuanately, I have not solved my problem.
>
> My situation: I am writing a program in JAVA. In this program I need to
connect to
> my Oracle database through JDBC thin driver (v7.34 design by Oracle). My
Oracle
> resides in UNIX. I have to put "HOST.PORT.SID" into the connection
statement.
>
> So far as suggested by respondents, I failed to find the file "tnsnames.ora"
> or "sqlnet.ora". I isssued the command "find . -name tnsnames(sqlnet).ora
-print".
> the search returned nothing, except showing a list of dirctories not
readable.
>
> Does each Oracle server has a port number?
> What is the port number of the default port?
>
> What is the easiest way to connect to an Oracle database?
>
> any help or hint will be appreciated.
>
> Huaping Luo
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 14 1998 - 04:32:46 CDT