Create Oracle Region and Cross-Region Databases Using Script Files

Important: Unlike other database types that will create the physical database in which the region and cross-region databases are to be stored if that database doesn't already exist, when using Oracle, the physical database must already have been created before these scripts are run.

To create a region database script file, on the command line, enter the following command:
```
dbfhadmin -script -type:region -provider:ora -name:<es-name> -file:<script-name.sql> 
```
where <es-name> is the name of the enterprise server region that will use the region database .

Note: If you omit the -file option, the default name is create_region_ora.sql.
To create a cross-region database script file, on the command line, enter the following command:
```
dbfhadmin -script -type:crossregion -provider:ora -file:<script-name.sql> 
```
Note: If you omit the -file option, the default name is create_crossregion_ora.sql.
Once you have created the script files, use the dbfhadmin utility to run them, and create the required databases.
Before you run the -createdb command, ensure that the sqlplus command is on the PATH. (SQL *Plus is Oracle's command line database utility.)
To create a region database, on the command line, enter the following command:
```
dbfhadmin -createdb -file:<script-name.sql> -type:region -provider:ora -existdb:<db-name> -user:<user-name> -password:<password>
```
where <script-name.sql> is the name of the script file that was created in an earlier step; <db-name> is the name of an existing database instance; and <user-name> and <password> are valid credentials for the instance.
To create a cross-region database, on the command line, enter the following command:
```
dbfhadmin -createdb -file:<script-name.sql> -type:crossregion -provider:ora -existdb:<db-name> -user:<user-name> -password:<password>
```
where <script-name.sql> is the name of the script file that was created in an earlier step; <db-name> is the name of a database reference in your tnsnames.ora file; and <user-name> and <password> are valid credentials for the instance.

Note: The database specified by -existdb cannot already contain a cross-region database.

Now that the region and cross-region databases have been created, you can configure the database configuration file to use them.