Use this screen to specify the connection credentials to the database in which you will be creating or dropping your schemas.
Select one of these procedures depending on your database:
Specifying Connection Credentials for Oracle MySQL Databases
Specifying Connection Credentials for Microsoft SQL Server Databases
Click Next when you are finished entering the connection credentials for your database. A screen indicating the progress of the installer establishing the connection with the specified database will appear. If an error occurs while the connection is being established, the error message(s) appear in the Messages field on the Database Connection Details screen.
Specific database requirements for the various schemas can be found in the Oracle Fusion Middleware System Requirements and Specifications document.
For certified database versions, see the System Requirements and Supported Platforms for Oracle Fusion Middleware 11gR1 document, which is available on the Oracle Fusion Middleware Supported System Configurations page.
Note:
If you are running the RCU for Oracle Business Analytics Applications Suite, see the Oracle Business Intelligence Applications Installation Guide for information about this screen.
For Oracle databases and Oracle databases enabled for edition-based redefinition, specify these connection credentials.
Field | Description |
---|---|
Host Name |
Enter the name of the server where your database is running. Use this format: examplehost.exampledomain.comFor Oracle RAC databases, specify the VIP name or one of the node names in this field. |
Port |
Enter the port number for your database. The default port number for Oracle databases is 1521. |
Service Name |
Specify the service name for the database. Typically, the service name is the same as the global database name. If you are unsure what the service name for your database is, you can obtain it from the For Oracle RAC databases, specify the service name of one of the nodes in this field. For example: examplehost.exampledomain.com |
Username |
Enter the user name for your database. The default user name is |
Password |
Enter the password for your database user. |
Role |
Select the database user's role from the drop-down list:
All schemas installed on an Oracle database require the SYSDBA role. If you are creating schemas for Oracle Internet Directory (OID), you must use the user |
For MySQL databases, specify these connection credentials.
Field | Description |
---|---|
Host Name |
Enter the host name, IP address, or complete server name in host\server format of the server where your database is running. For Oracle RAC databases, specify the VIP name or one of the node names in this field. |
Port |
Enter the port number for your database. |
Database Name |
Specify the name of your database. |
Username |
Specify the name of a user with DBA or SYSDBA privileges. |
Password |
Enter the password for your database user. |
For Microsoft SQL Server databases, specify these connection credentials.
Field | Description |
---|---|
Unicode Support |
Select Yes or No from the drop-down list. Oracle SOA Infrastructure schemas are created with Unicode support (database tables created with NVARCHAR) only, regardless of the option selected in this field. |
Server Name |
Enter the host name, IP address, or complete server name in host\server format of the server where your database is running. |
Port |
Enter the port number for your database. |
Database Name |
Specify the name of your database. |
Username |
Enter the user name for your database. The user must have SYSDBA or DBA privileges. |
Password |
Enter the password for your database user. |
For IBM DB2 databases, specify these connection credentials.
Field | Description |
---|---|
Server Name |
Enter the host name, IP address, or complete server name in host\server format of the server where your database is running. |
Port |
Enter the port number for your database. |
Database Name |
Specify the name of your database. |
Username |
Specify the name of a user with DB Owner privileges. The default user name for IBM DB2 databases is |
Password |
Enter the password for your database user. |