Oracle data source configuration

Use this information to create an Oracle data source.

Table 1. General settings for Oracle data source window
Window element	Description
Data Source Name	Enter a unique name to identify the data source. You can use only letters, numbers, and the underscore character in the data source name. If you use UTF-8 characters, make sure that the locale on the Impact Server where the data source is saved is set to the UTF-8 character encoding.
User name	Type a user name that with which you can access to the database.
Password	Type a password that with which you can access to the database. As you type, the characters are replaced with asterisks (*).
Maximum SQL Connection	For maximum performance set the size of the connection pool as greater than or equal to the maximum number of threads that are running in the event processor. Important: Changing the maximum connections setting in an SQL data source requires a restart of the Impact Server. For information about viewing existing thread and connection pool information, see the information in the Netcool/Impact Administration in the section Command-Line tools, Event Processor commands. See the Select PoolConfig from Service where Name='EventProcessor'; Important: In a clustered environment, the event processor configuration is not replicated between servers. You must run the Select PoolConfig from Service where Name='EventProcessor'; command on the primary and the secondary servers. Limiting the number of concurrent connections manages performance. Type the maximum number of connections that are allowed to the database at one time. That number must be greater than or equal to the number of threads that are running in the Event Processor. See Configuring the Event processor service.
Connection Options	Type of connection to an Oracle data source. Select one of the following options: General Settings - default settings. Customized URL - integration with an Oracle RAC cluster is supported. For more information, see Connecting to an Oracle data source using a custom URL. LDAP Data Source - connect to data source bound in a Naming Service using LDAP. For more information, see Connecting to an Oracle data source using LDAP. LDAP URL - use a JDBC LDAP URL to connect to an LDAP data source. For more information, see Connecting to an Oracle data source using a JDBC LDAP URL.
Connection Method	Method that you want to use to connect to the Oracle database. Select one of the following options: SID - select this option if you want to connect to the Oracle database using a service identifier. Service Name - select this option if you want to connect to the Oracle database using a service name.
Context Factory	The class name to initialize the context. It is dependent on which Naming Service is used. For example, `com.sun.jndi.ldap.LdapCtxFactory`. This option is displayed only if you choose LDAP Data Source in the Connection Options.
Provider URL	The URL used to connect to the Naming service. For example, `ldap://localhost:389/dc=abc`. This option is displayed only if you choose LDAP Data Source in the Connection Options.
Binding Name	The name to which the Oracle Data Source object is bound. For information about the binding name, refer the docs of the Naming Service provider. For example, `cn=myDataSource`. This option is displayed only if you choose LDAP Data Source in the Connection Options.
Database Failure Policy	Select the failover option. Available options are Fail over, Fail back, and Disable Backup. For more information about failover options, see SQL database DSA failover modes.

Table 2. Primary source settings for Oracle data source window
Window element	Description
Host Name	Type a primary host name. The default value is `localhost`.
Port	Select a primary port number. The default value is set to a common port number: `1521`.
SID / Service Name	Type a primary Oracle service identifier or service name. The default value is `ORCL`. For more information, see your Oracle documentation.
Test Connection	Click to test the connection to the host to ensure that you entered the correct information. Success or failure is reported in a message box. If the host is not available at the time you create the data source, you can test it later. To test the connection at any time, from the data source list, right-click the data source and select Test Connections from the list of options. Important: If you see an error message stating that the data source cannot establish a connection to a database because a JDBC driver was not found, it means that a required JDBC driver is missing in the shared library directory. To fix this, place a licensed JDBC driver in the shared library directory and restart the server. For more information see, the SQL database DSAs chapter in the Netcool/Impact DSA Reference Guide.

Table 3. Backup source settings for Oracle data source window
Window element	Description
Host Name	Type a backup host name. The default value is `localhost`. Backup host name is optional.
Port	Select a secondary port number. The default value is set to a common port number: `1521`. Backup port number is optional.
SID / Service Name	Type a backup SID or service name. The default value is `ORCL`. For more information, see your Oracle documentation. Backup SID is optional.
Test Connection	Click to test the connection to the host to ensure that you entered the correct information. Success or failure is reported in a message box. If the host is not available at the time you create the data source, you can test it later. To test the connection at any time, from the data source list, right-click the data source and select Test Connections from the list of options. This button is disabled when the backup source information is left blank.