oracle cdc 配置案例,创建和编辑 Oracle CDC 服务

创建和编辑 Oracle CDC 服务Create and Edit an Oracle CDC Service

03/20/2017

本文内容

适用于：Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions) Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory适用于：Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions) Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory

您从 CDC 服务配置控制台创建和编辑新的 Oracle CDC Windows 服务。You create and edit a new Oracle CDC Windows Service from the CDC Service Configuration Console.

若要创建新的 Oracle CDC Windows 服务，请从左侧窗格中选择 “本地 CDC 服务” ，然后从 “操作” 窗格中单击 “新建服务” 。To create a new Oracle CDC Windows service, select Local CDC Services from the left pane, then click New Service from the Actions pane. 还可以右键单击“本地 CDC 服务”，然后选择“新建服务”。You can also right-click Local CDC Services and select New Service. “新 Oracle CDC Windows 服务”对话框将打开。The New Oracle CDC Windows Service dialog box opens.

OROR

若要编辑 CDC 服务属性，请选择要编辑其属性的服务，然后从 “操作” 窗格中单击 “属性” 。To edit the CDC service properties, select the service that you want to edit the properties for and click Properties from the Actions pane. 还可以右键单击要使用的服务，然后选择“属性”。You can also right-click the service you are working with and select Properties. 此时将打开“CDC 服务属性”对话框。The CDC Service Properties dialog box opens.

在“新 Oracle CDC Windows 服务”对话框或“CDC 服务属性”对话框中输入以下信息。Enter the following information in the New Oracle CDC Windows Service dialog box or the CDC Service Properties dialog box.

服务名称Service Name

键入新的 Oracle CDC Windows 服务的名称。Type the name of the new Oracle CDC Windows Service. 如果可能，不应使用长名称。You should not use long names, if possible. 在服务名称中不能使用字符 / 和 \。The characters / and \ cannot be used in the service name.

备注

在编辑服务时，此选项不可用。This option is not available when editing the service. 不能更改已存在的 Windows 服务的名称。You cannot change the name of a Windows service that already exists.

说明Description

键入有助于标识该服务的说明。Type a description of the service to help identify it.

服务帐户Service Account

选择下列选项之一以便确定运行服务所基于的帐户：Select one of the following to determine under which account to run the service:

Local System 帐户Local System Account

该帐户不是建议的帐户，因为对服务提供了过多的权限。This is not recommended because it gives too many permissions to the service.

本帐户This Account

在 Windows Vista 或 Windows Server 2008 中，默认服务帐户是 NETWORK SERVICE 帐户。On Windows Vista or Windows Server 2008, the default service account is the NETWORK SERVICE account.

在 Windows 7、Windows Server 2008 R2 和更高版本中，默认服务帐户是 NT Service\。On Windows 7, Windows Server 2008 R2 and later, the default service account is NT Service\.

通过使用这些帐户，您可以在不使用密码的情况下工作，因为对于这些帐户不需要密码。Using these accounts lets you work without using passwords because a password is not necessary for these accounts. 此外，这些帐户仅提供运行 Oracle CDC 服务所需的必要权限。In addition these accounts provide only the necessary permissions required for the Oracle CDC Service to run.

可以将本地或域 Windows 帐户用于该服务帐户。You can use a local or domain Windows account for the service account. 在此情况下，必须为该帐户输入 “密码” 。In this case, you must enter the Password for that account. 该帐户可以用于本地主机或域帐户。This account can be for the local host or a domain account. 请确保在 Windows 控制面板中使用本地服务更改帐户时更新密码。Be sure to update the password when it is changed using Local Services in the Windows Control Panel.

服务器名称：选择要连接到的目标 SQL ServerSQL Server 实例(例如 \\\)。Server name: Select the target SQL ServerSQL Server instance to connect to (for example, \\\). 默认情况下，显示上次连接到的服务器实例。The server instance last connected to is displayed by default.

身份验证Authentication

选择以下方案之一：Select one of the following:

Windows 身份验证：如果您选择此选项，则 Oracle CDC 服务将使用服务帐户标识连接到目标 SQL ServerSQL Server 实例。Windows Authentication: If you select this option, the Oracle CDC service connects to the target SQL ServerSQL Server instance using the service account identity. 如果 SQL ServerSQL Server 实例正在不同的计算机上运行，则必须将 Windows 身份验证用于域帐户。If the SQL ServerSQL Server instance is running on a different computer, Windows Authentication must be used with domain accounts.

SQL Server 身份验证：如果选择此选项，则必须为您要使用的 登录名键入 “用户名” 和 “密码” SQL ServerSQL Server 。SQL Server Authentication: If you select this option, you must type the User Name and Password for the SQL ServerSQL Server login you want to use. Oracle CDC 服务在连接到目标 SQL ServerSQL Server 实例时使用这些凭据。The Oracle CDC service uses these credentials when connecting to the target SQL ServerSQL Server instance.

Oracle CDC 服务使用的 SQL ServerSQL Server 登录名仅需是公共固定服务器角色的成员，无需其他权限。The SQL ServerSQL Server login used by the Oracle CDC Service only needs to be a member of the public fixed-server role, no other privileges are needed. 在添加了新的 Oracle CDC 实例后，该登录名将获取对关联的 CDC 数据库的 db_owner SQL ServerSQL Server 访问权限。Once new Oracle CDC Instances are added, that login will gain db_owner access to the associated SQL ServerSQL Server CDC databases.

若要创建 Oracle CDC Windows 服务定义，程序需要对关联的 SQL ServerSQL Server 实例中的 MSXDBCDC 数据库具有更新访问权限。To create the Oracle CDC Windows Service definition, the program needs update access to the MSXDBCDC database in the associated SQL ServerSQL Server instance. 在单击 “确定” 后，将出现一个对话框，提示用户输入具有对 MSXDBCDC 数据库的更新访问权限的 SQL ServerSQL Server 登录名。When you click OK, a dialog box prompts the user to enter a SQL ServerSQL Server login with an update access to the MSXDBCDC database.

有关必须在“连接到 SQL Server”对话框中键入的数据的信息，请参阅 Connection to SQL Server。For information about the data you must type into the Connect to SQL Server dialog box, see Connection to SQL Server.

选项Options

单击箭头可以查看要配置的可用选项。Click the arrow to view available options to be configured. 您可以选择保留这些选项不变，使用其默认值。You can choose to leave these options with their default value. 可用选项是：The available options are:

连接超时值：键入一个时间(秒钟)，未超过该时间，Oracle CDC 服务将等待与 SQL ServerSQL Server 的连接，超过该时间后即超时。默认值为 15。Connection Timeout: Type the time (in seconds) that the CDC Service for Oracle waits for a connection to the SQL ServerSQL Server before timing out. The default value is 15.

执行超时值：键入一个时间(秒钟)，未超过该时间，Oracle CDC Windows 服务将等待命令执行，超过该时间后即超时。默认值为 30。Execution Timeout: Type the time (in seconds) that the Oracle CDC Windows Service waits for a command to execute before timing out. The default value is 30.

加密连接：选择 “加密连接” 将使用加密连接进行 Oracle CDC 服务和目标 SQL ServerSQL Server 实例之间的通信。Encrypt Connection: Select Encrypt Connection for communication between the Oracle CDC Service and the target SQL ServerSQL Server instance using an encrypted connection.

高级：根据需要键入任何其他连接属性。Advanced: Type any additional connection properties, if necessary.

主密码Master Password

输入 Oracle CDC Windows 服务用来保护 Oracle 日志挖掘凭据的密码。Enter a password to be used by the Oracle CDC Windows Service to protect the Oracle log-mining credentials.

在高可用性配置中，如果在群集中的其他节点上配置了相同服务的其他实例，则也必须使用相同的主密码。The same master password must also be used when other instances of the same service are configured on other nodes on a cluster in high-availability configuration. 如果您丢失或修改了该主密码，则必须使用 CDC 设计器控制台重新输入在 Oracle CDC 实例数据库中存储的所有日志挖掘密码。If you lose or modify the master password, all log mining passwords stored in Oracle CDC Instance databases must be re-entered using the CDC Designer console.

另请参阅See Also