This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
integration:rdbms:oracle:databases [2011/03/17 18:14] doc created |
integration:rdbms:oracle:databases [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 9: | Line 9: | ||
| [[integration:rdbms:oracle:home|Overview]] | | [[integration:rdbms:oracle:home|Overview]] | | ||
| [[integration:rdbms:oracle:environments|Environments]] | | [[integration:rdbms:oracle:environments|Environments]] | | ||
| - | **[integration:rdbms:oracle:databases|Databases]]** | | + | **[[integration:rdbms:oracle:databases|Databases]]** | |
| [[integration:rdbms:oracle:tables|Tables]] | | [[integration:rdbms:oracle:tables|Tables]] | | ||
| + | [[integration:rdbms:oracle:constraints|Constraints]] | | ||
| + | [[integration:rdbms:oracle:datatypes|Datatypes]] | | ||
| [[integration:rdbms:oracle:queries|Queries]] | | [[integration:rdbms:oracle:queries|Queries]] | | ||
| [[integration:rdbms:oracle:updates|Updates]] | | [[integration:rdbms:oracle:updates|Updates]] | | ||
| - | [[integration:rdbms:oracle:storedproc|Stored Procedures]] | | ||
| [[integration:rdbms:oracle:example|Example]] | [[integration:rdbms:oracle:example|Example]] | ||
| Line 20: | Line 21: | ||
| ==== Databases ==== | ==== Databases ==== | ||
| + | The [[dev:sql:statements:create_database:home|CREATE DATABASE]] statement is used to declare an Oracle database within an Omnidex Environment File. This statement can either be issued directly, or it can be extracted from Oracle using the EXTRACT statement as discussed in the previous section. | ||
| + | |||
| + | The CREATE DATABASE statement must include the database name, the Oracle version, and the Oracle user and password. | ||
| + | |||
| + | <code> | ||
| + | create database "SIMPLE" | ||
| + | type oracle | ||
| + | version "11" | ||
| + | user "simple" | ||
| + | password "simple" | ||
| + | index_directory "idx" | ||
| + | in "simple.xml"; | ||
| + | </code> | ||
| + | |||
| + | === Using SQL*Net === | ||
| + | |||
| + | Omnidex is frequently installed on a separate server than the Oracle database. In fact, this is preferable since it allows both Omnidex and Oracle to operate at their best without competing for resources. This means that Omnidex often accesses the Oracle database through SQL*Net. When using SQL*Net, simply state the name of the SQL*Net service in the SERVICE clause. | ||
| + | |||
| + | <code> | ||
| + | create database "SIMPLE" | ||
| + | type oracle | ||
| + | version "11" | ||
| + | user "simple" | ||
| + | password "simple" | ||
| + | service "simple" | ||
| + | index_directory "idx" | ||
| + | in "simple.xml"; | ||
| + | </code> | ||
| + | |||
| + | === Oracle Security === | ||
| + | |||
| + | Omnidex provides two methods of supporting Oracle security. | ||
| + | |||
| + | * Administrators can register a user and password in the Omnidex Environment File. This user and password will always be used to access the Oracle database, and no users and passwords will be needed from the application. | ||
| + | * The application can pass a user and password in the [[dev:connections:home|Omnidex Connection String]]. This user and password is then passed directly to Oracle to access the database. | ||
| + | |||
| + | One of these approaches must be used to allow connections to the Oracle database. Administrators should insure that the user and password provides access to all of the database objects referenced in the Omnidex Environment Files. | ||
| ===== ===== | ===== ===== | ||