GeeCON Prague 2014*
The moose likes JDBC and the fly likes Oracle Server & Client Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle Server & Client" Watch "Oracle Server & Client" New topic
Author

Oracle Server & Client

ankur rathi
Ranch Hand

Joined: Oct 11, 2004
Posts: 3830
Hi all ,

What is the difference b/w Oracle Server & Oracle Client .
Plz reply .

Thanks ,
Ankur
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
What is the difference between the server and the client.

And i think it is not the question, it is the answer. therefore i didn't put a question mark there in the end.

please ask if you have some other thing in your mind.
ankur rathi
Ranch Hand

Joined: Oct 11, 2004
Posts: 3830
It means Oracle Client raise the request in form of query .
Oracle Server respond with data .

They r 2 different software . We have to install both in order to create any database bcoz without client we cant request & server is the main who create database ?

This is my question bcoz has ? ( QM )
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
yes right.

we can install just the client alone. but just the server alone doesn't make sense to me. because you need some client always to interact with the server. in case of oracle sql plus is your default client. we have some third party good clients as well. like TOAD, AQUA DATA STUDIO, etc.
ankur rathi
Ranch Hand

Joined: Oct 11, 2004
Posts: 3830
What abt server. I mean who will create table . Who will receive request ( query ) . Who will respond .

Plz reply soon ..
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

The server is the actual database - its where the data is stored and where all the metadata is defined. The client is just a client - it connects to the server to make requests and receive replies. For example, if you want to run a query against an Oracle DB you would make it via the client - but the actual query runs on the server. The results of that query are returned to the client.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
ankur rathi
Ranch Hand

Joined: Oct 11, 2004
Posts: 3830
Server create database , means it should have the mechanism for that . But u told me that u can only install client & can create database . So without server how can we create database . who is there to listen client .

Plz reply clearly . I m confuse .

Thanks .
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

A client can't do anything without the server process it uses. A client is just a way of communicating with a server process, so the client doesn't actually do anything other than send and receive messages from the server. So if there isn't a server, there is nothing for the client to do.
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Luckily we have the ORACLE forum here. i think this discussion is nothing to do with JDBC. isn't it?

please dont mind.
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30580
    
154

Adeel,
I'm going to leave this here (JDBC) for now. It is more about servers and clients in general than Oracle specifically. If the conversation becomes specific to Oracle, I'll move it then.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
ankur rathi
Ranch Hand

Joined: Oct 11, 2004
Posts: 3830
So what would be the answer ?

we need to install both the software ( client & server ) or not ?
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30580
    
154

Rathi,
I think the answer was alluded to earlier. But to have it in one place:

If you have access to an Oracle server somewhere else, you just need to install the client. If not, you need to install both the client and server.
ankur rathi
Ranch Hand

Joined: Oct 11, 2004
Posts: 3830
If I have access of Oracle Server on other machine then we dont necessarily need Client installed on our machine. We can use 'thin driver'...
Am I right ?
Could some body give details on this ....
Thanks .
Sonny Gill
Ranch Hand

Joined: Feb 02, 2002
Posts: 1211

Yes.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Oracle Server & Client