Database Connection Details

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 Databases and Oracle Databases Enabled for Edition-Based Redefinition

• Specifying Connection Credentials for Oracle MySQL Databases

• Specifying Connection Credentials for Microsoft SQL Server Databases

• Specifying Connection Credentials for IBM DB2 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.

Specifying Connection Credentials for Oracle Databases and Oracle Databases Enabled for Edition-Based Redefinition

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.com 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. 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 SERVICE_NAMES parameter in the database's initialization parameter file. If the initialization parameter file does not contain the SERVICE_NAMES parameter, then the service name is the same as the global database name, which is specified in the DB_NAME and DB_DOMAIN parameters. 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 SYS.
Password	Enter the password for your database user.
Role	Select the database user's role from the drop-down list: Normal SYSDBA 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 SYS and the SYSDBA role. For more information, see RCU Requirements for Oracle Databases in the System Requirements and Specification.

Specifying Connection Credentials for Oracle MySQL Databases

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.

Specifying Connection Credentials for Microsoft SQL Server Databases

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.

Specifying Connection Credentials for IBM DB2 Databases

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 db2admin.
Password	Enter the password for your database user.