DBA_I

Connecting to Oracle

The Oracle client should be installed on the machine that will access the Oracle server. If the aim is to access the server only for applications then Oracle client will suffice, however for administration and management duties additional admin packages also need to be installed.

Exploring the Oracle DBMS Architecture

Above is an illustration of a database and an instance of an Oracle database server. (It’s possible to have more than one instance of a database on a server as they run in separate memory areas.)