This section contains the specific database parameters for the Oracle DBMS: directory, SID, internal password, backup directory, etc.
If using the section in the Java version of the database management tool, only the "General settings" section below applies.
This section is not mandatory.
[Oracle]
database_directory = C:\Oracle\orodata
database_sid = ORACLE2
database_password = hardis
…
Parameter |
Type |
Mandat. |
Default |
Description |
General settings |
||||
UserUtil |
string |
no |
Used to impose a default connection profile if the profile is not specified in the tool's settings. |
|
PasswordUtil |
string |
no |
Used to impose the default user profile password. |
|
GrantedErrors |
string |
no |
List of SQL error codes (in an absolute value, i.e. unsigned), separated by commas. The listed error codes are ignored when interpreting a SQL script and do not stop processing. |
|
| GrantedSQLStates | string | no | List of SQLSTATE error codes, separated by commas. The listed error codes are ignored when interpreting a SQL script and do not stop processing. This parameter acts as a complement to the "GrantedErrors" parameter for DBMSs that do not return SQLCODE codes. |
|
Creation |
||||
database_sid |
string |
no |
calculated |
SID or service name of the database (depends on the Oracle version used). |
database_directory |
string |
no |
Directory for the database files. |
|
database_password |
string |
no |
'oracle' |
Database password. |
backup_directory |
string |
no |
Directory for backup files. |
|
database_init_file |
string |
no |
Database initialization file. |
|
CfgScript |
string |
no |
Name of the database configuration script. This script is executed after the base is created, but before the files (PDM) are created. This script can contain SQL commands and escape sequences. A typical application might be a user creation script for Oracle or SQL Server bases. |
|
Backup |
||||
database_password |
string |
no |
Database password. |
|
backup_directory |
string |
no |
Directory for backup files. |
|
database_init_file |
string |
no |
specified* |
Database initialization file. |
force_shutdown |
bool |
no |
0 |
Forces shutdown of the database. |
Restoration |
||||
database_sid |
string |
no |
calculated |
SID or service name of the database (depends on the Oracle version used). |
database_directory |
string |
no |
Directory for the database files. |
|
database_password |
string |
no |
Database password. |
|
backup_directory |
string |
no |
Directory for backup files. |
|
database_init_file |
string |
no |
specified * |
Database initialization file. |
force_shutdown |
bool |
no |
0 |
Forces shutdown of the database. |
force_overwrite |
bool |
no |
0 |
Overwrites an existing database without confirmation. |
Deletion |
||||
database_password |
string |
no |
Database password. |
|
database_init_file |
string |
no |
specified * |
Database initialization file. |
| * | If the base was created using the Database management tool |
Sections [Oracle7] and [Oracle8] are taken into account for script forwards compatibility:
The [Oracle8] section is taken into account by the "Oracle" driver (Oracle 8 and later); section [Oracle7] by the Oracle7 driver.
Note: The Oracle7 driver is not any more the default activated driver. It has to be referenced manually in the APICONF.INI file in order for scripts created for Oracle7 to operate correctly.