Use > Database > Deploying the Oracle Server Database > Oracle Server Configuration and Sizing Guidelines > Connecting to an Oracle Database Using Service Name

Connecting to an Oracle Database Using Service Name

Starting with version 10.32, it is possible to connect UCMDB server to an Oracle database using Service Name.

Note  

  • This support only works with the Oracle native driver, and does not work with Data Direct drivers. By default it should be native driver. You can check the configuration in the wrapper.conf file, see the following line: wrapper.java.additional.47=-Doracle.native.driver=true.

    Starting with version 10.33, to use the Oracle native driver, you may need to perform additional steps. For details, see Configuring Oracle JDBC Driver.

  • Currently the connection between UCMDB and Oracle RAC environment works only with Oracle native drivers.

You can enable this support using either of the following approaches:

  • (Recommended) Provide a value for the Service Name field in the UCMDB Server Configuration Wizard

    When creating a new schema or connecting to an existing schema with the UCMDB Server Configuration Wizard, on the CMDB Schema Settings tab page, provide a value for the Service Name field.

    Note  

    • The Service Name field is mutually exclusive with the SID field, you can only provide a value for either Service Name or SID.
    • The Service Name field is only available when the Oracle native drivers are used.

  • Modify the dal.datamodel.service.name setting in the cmdb.conf file

    1. On the UCMDB server machine, open the <UCMDB_Server>\conf\cmdb.conf file using a text editor.

    2. Locate the new database context configuration dal.datamodel.service.name.

    3. Provide the service name.
    4. Save the file.
    5. Restart the UCMDB Server.

    Note The dal.datamodel.service.name setting in the cmdb.conf file has precedence over the dal.datamodel.sid setting. That is to say, if the Service Name setting is set, it will be used for database schema connection regardless of whether the SID setting is also set or not, therefore these two settings cannot be used simultaneously.

    For example, if a wrong Service Name is provided, the connection will fail, even if a correct SID is provided. To use the dal.datamodel.sid setting for connection, simply leave the dal.datamodel.service.name setting blank.

Send Help Center feedback