Member Avatar for 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.

  • 2 Contributors
  • 22 Replies
  • 236 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Majestics
Member Avatar for debasisdas

What exactly you mean by startup is very slow ?

Member Avatar for 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?

Member Avatar for 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 ?

Member Avatar for 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

Member Avatar for debasisdas

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

Member Avatar for debasisdas

and how fast is the ping request

try using system / server name instead of IP.

Edited by debasisdas because: n/a
Member Avatar for debasisdas

what about tnsping ?

Member Avatar for Majestics

How i m supposed to do this? :)

Member Avatar for debasisdas

type tnsping <database_name> at command prompt and check the response time.


ex---- tnsping orcl

Edited by debasisdas because: n/a
Member Avatar for Majestics

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

Member Avatar for 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.

Member Avatar for 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.

Member Avatar for debasisdas

Find more connection stings here.

Member Avatar for 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?

Member Avatar for 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 ?

Edited by debasisdas because: n/a
Member Avatar for 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?

Edited by Majestics because: n/a
Member Avatar for debasisdas

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

Member Avatar for Majestics

No solution yet... app is still very slow.. I wonder is there any solution or not, tns ping takes 30msec

Edited by Majestics because: n/a
Member Avatar for debasisdas

Are you doing any other processing in application startup or only database connection ?

Member Avatar for Majestics

no processing, just the connection string at startup,
I have a seperate thread for it.

//class conn
jdbc:oracle:thin:@192.168.1.10:database:user:password

//main class
while(conn class is alive)
{
wait
}
fetch connection from conn class for executing query.
Edited by Majestics because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.