topic The role of ???Oracle Database Instance??? of the client side, in Data Management Questions

The role of ???Oracle Database Instance??? of the client side,

JamalNUMAN — Fri, 11 Jan 2013 06:15:35 GMT

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?

At the end of the day, all what we are recommended to do is to copy the folder of the ???istanceclinet??? to particular location on the C drive and then to include its path on the environment system/variable system.

[ATTACH=CONFIG]20640[/ATTACH]

Thank you very much

Best

Jamal

Re: The role of �??Oracle Database Instance�?� of the client side,

VinceAngelo — Fri, 11 Jan 2013 13:20:46 GMT

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

Re: The role of �??Oracle Database Instance�?� of the client side,

JamalNUMAN — Fri, 11 Jan 2013 17:59:09 GMT

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

Many thanks Vince for the answer.

The attached document includes the �??proper�?� approach for the installation of the Oracle database on both server/client side.

Do you agree with it?

Aren�??t we required to install the oracle database client side?

Best

Jamal

Re: The role of �??Oracle Database Instance�?� of the client side,

MarcoBoeringa — Wed, 16 Jan 2013 19:15:53 GMT

Hi Jamal,

Can't answer all of your questions at this moment, but I did notice in your PDF with screenshots, that you seem to be confusing tables, tablespaces and the fysical datafiles they are made up off. These are three different entities in Oracle.

A table resides in a tablespace, multiple tables can be in one tablespace.
A tablespace has one or more datafiles (fysical on disk) associated with it, that make up the true storage of the data.

I recommend you to view the following Oracle links:

Tablespaces and Datafiles
http://docs.oracle.com/cd/A87860_01/doc/server.817/a76965/c03space.htm

Managing Tablespaces
http://docs.oracle.com/cd/B19306_01/server.102/b14231/tspaces.htm

Re: The role of �??Oracle Database Instance�?� of the client side,

MarcoBoeringa — Thu, 17 Jan 2013 08:33:15 GMT

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."

Re: The role of �??Oracle Database Instance�?� of the client side,

JamalNUMAN — Sun, 20 Jan 2013 10:11:08 GMT

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."

Thank you Marco for the very useful answer. Now it is much more obvious.

Best

Jamal