Installation Guide › Planning Your Installation › Before You Begin › Installation Worksheets › Oracle Database Worksheet

Previous Topic: Microsoft SQL Server Worksheet

Next Topic: Installing a Windows Implementation
Oracle Database Worksheet

A database server must already be configured and working with a supported RDBMS. Record the following database information you need during installation against an existing Oracle Database Server:

Field

Description

Your Response

Oracle Server Host

Defines the host name or IP address of the database server computer or cluster.

 

Select Service Name

Specifies the name that identifies your RDBMS on the system.

Default: ORCL—the default service name for Oracle Database 10g.

 

Specify Oracle Server port

Specifies the port used by the RDBMS you specified.

Default: 1521—the default port for Oracle Database.

 

Important! We strongly recommend that you use the default database names. CA RCM database names cannot contain the hyphen (-) character.

RCM Database Schema Name

Defines the name of the schema for imported user, role, and resource information, CA RCM portal settings, and other data.

Default: eurekify_sdb

 

RCM Database Schema Password

Defines the password of the CA RCM schema user with CONNECT and RESOURCE roles.

 

RCM Ticket Database Schema Name

Defines the name of the schema for business processes data such as review and approval campaigns.

Default: eurekify_ticketdb

 

RCM Ticket Database Schema Password

Defines the password of the CA RCM ticket schema user with CONNECT and RESOURCE roles.

 

Workpoint Database Schema Name

Defines the name of the schema for the Workpoint work flows.

Default: WPDS

 

Workpoint Database Schema Password

Defines the password of the Workpoint schema user with CONNECT and RESOURCE roles.

 

Note: We recommend that your database administrator creates the empty schemas for you before you install CA RCM. If you do not prepare empty schemas for the CA RCM databases, the installation requires the credentials of an Oracle Database user with DBA privileges. The installation program then creates the schemas using the information you provide.

Note: when you install CA RCM on an AIX/WebSphere application server, you create two additional databases for CA RCM and Workpoint cluster bus queues. See the AIX installation chapter.

Oracle DBA username

Defines the name of a DBA user you want to use to create the required CA RCM schemas you supplied.

Note: If you prepare the CA RCM schemas in advance of running the installation program, you do not need to supply Oracle DBA credentials.

Default: system

 

Password

Defines the password of a DBA user you want to use to create the required CA RCM schemas you supplied.

 

Note: Oracle Database does not support the CA RCM external reporting database. You can use the DBUtil tool to create and configure the reporting database on a Microsoft SQL Server after you complete the CA RCM installation against Oracle Database.