Difference Between Oracle Client And Oracle Server

[Former Member]

Hello Gurus,

Can somebody tell me the diiference between oracle client and oracle server

and why at the time of database installation we choose the sapserver.cmd from the oracle cd -1

if you have any document or link the please mention

[Former Member]

As vinod already worked out:

Oracle Server Software is the part of the Oracle Software which runs the database itself

Oracle Client Software is the part of the Oracle Software needed by Oracle Clients (that are programs accessing the database) to communicate with the Oracle database server.

On Windows every Oracle Server Software did also contain an Oracle Client. So there is initialy no need to install the Oracle Client there. On computers where you only install programs that connect to an Oracle Database you had to install (up to Oracle 9i) a subset of the Oracle Server named Oracle Client.

With Oracle10 Oracle introduces an so called Instant Client which needs no installation with the Oracle Universal Installer. It is sufficient to copy it into the path of the user.

In order of having uniform configurations (Oracle Clients are using the same interface), the Instant Client is also installed on Oracle Servers on SAP on Windows.

Peter