These sections contain the specific database parameters for the Oracle DBMS: directory, SID, internal password, backup directory, etc.
These sections are 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. |
|
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.