Java oracle connection

[Majestics]

I have connected java with oracle over lan, in connection string i have provided the IP address, now the startup is very slow, how can i make it fast, i have already asked the same question in java forum but no responce, so i thought oracle expertise can answer this question.

[debasisdas]

What exactly you mean by startup is very slow ?

[Majestics]

when i double click application, it takes some time to connect with oracle server but that time is almost 15 sec, i want to make it 4 or 3 sec, i have also opened a port , tried both TCP AND UDp but nothing worked.... so is there any way to make connection with oracle database server faster?

[debasisdas]

How fast you are able to connect to oracle server form any client on the same machine as your application . Is is faster than your application connection time ?

[Majestics]

On same machine, when i use localhost rather then IP , it connect with in 2 sec. Even on same machine when i use its IP it connect faster, but over lan its very slower

[debasisdas]

Tell me first the database is on the same machine from which you are trying to connect or on another server over LAN ?

[Majestics]

Database server is on 192.168.1.10 and i m connecting from 192.168.1.50, simply different machines.

[debasisdas]

and how fast is the ping request

try using system / server name instead of IP.

[Majestics]

time<1mS

[debasisdas]

what about tnsping ?

[Majestics]

How i m supposed to do this? :)

[debasisdas]

type tnsping at command prompt and check the response time.

ex---- tnsping orcl

[Majestics]

tnsping only working on database server, not working from any other computer over lan

[debasisdas]

tnsping only working on database server

who told you ?

It will work from each and every system that has oracle client installed and has the TNS set, and can access the server over any network like LAN.

[Majestics]

Actually, its not oracle application, its completly created in java, i have connected it with connection string

jdbc:oracle:thin@192.168.1.10

There is no oracle client installed on any system over lan, if u suggest it will make it fast, then i will use it.

[debasisdas]

Find more connection stings here .

[Majestics]

Do u think, changing connection string make the connection faster? Have u tried it before.... I thought making multiple port opening can make app faster?

[debasisdas]

It is not the connection string but he driver that you are using to use the connection string internally makes all the difference.

Which port you are going to open ?

[Majestics]

1521-1540, yes indeed driver, but i m not understanding your point. Do u want to say that driver is slow to create connection at startup? I have to change driver?

[debasisdas]

Oracle works on 1521 and 1522 only, using other ports may not help.