cancel
Showing results for 
Search instead for 
Did you mean: 

Difference Between Oracle Client And Oracle Server

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

A database server is the Oracle software managing a database, and a client is an application that requests information from a server. Each computer in a network is a node that can host one or more databases. Each node in a distributed database system can act as a client, a server, or both, depending on the situation.

A client can connect directly or indirectly to a database server. A direct connection occurs when a client connects to a server and accesses information from a database contained on that server.

sapserver.cmd is the response files provided by SAP (start of installation via cd:\NT\I386\sapserver.cmd).

Instead of prompting you to select a series of installation options, Universal Installer installs the software using a predefined set of options. These options are stored in an Oracle Universal Installer response file.

Regards

Vinod

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

Oracle Client Software is a package of components such as SQLNet and ASO (Advanced Security Option). SQLNet is remote data access software that enables communication with Oracle databases in a distributed computing environment. Specifically, SQL*Net lets clients, such as Macintosh or Windows computers with database applications, communicate with servers containing Oracle databases.It also lets servers with Oracle databases communicate with other servers with Oracle databases.

Oracle Client Software is intended for applications that connect to Oracle databases.

Regards

Vinod