Solved! Go to Solution.
The role of ???Oracle Database Instance??? of the client side,
I couldn???t figure out why it is required to have ???Oracle Database Instance??? on the machine of the client.
What role does it play?
There is no role for a database instance on a client-only host. It is not required.
Can you provide a link to the documentation that led you to believe it was?
- V
The role of ???Oracle Database Instance??? of the client side,
I couldn???t figure out why it is required to have ???Oracle Database Instance??? on the machine of the client.
What role does it play?
Jamal, you also seem to be confusing the name of the Oracle client software on your local machine - "Oracle Instant Client" - with the term used to more or less define an Oracle database - "Instance" - on the database server.
For some more information of what an "Instance" is: from this webpage by Rene Nyffenegger:
"The terms instance and database are closely related, but don't refer to the same thing.
The database is the set of files where application data (the reason for a database) and meta data is stored.
An instance is the software (and memory) that Oracle uses to manipulate the data in the database. In order for the instance to be able to manipulate that data, the instance must open the database. A database can be opened (or mounted) by more than one instance, however, an instance can open at most one database."
And from the Oracle Help pages:
"A database instance is a set of memory structures that manage database files. A database is a set of physical files on disk created by the CREATE DATABASE statement. The instance manages its associated data and serves the users of the database.
Every running Oracle database is associated with at least one Oracle database instance. Because an instance exists in memory and a database exists on disk, an instance can exist without a database and a database can exist without an instance."