Skip to content

Oracle 数据库凭据#

¥Oracle Database credentials

你可以使用以下凭据验证以下节点：

¥You can use these credentials to authenticate the following nodes:

¥Agent

Note

这些节点不支持 SSH 隧道。它们需要 Oracle 数据库 19c 或更高版本。对于透明应用连续性 (TAC) 和分片等高级 Oracle 数据库功能，还需要 Oracle 客户端库 19c 或更高版本。

¥These nodes do not support SSH tunnels. They require Oracle Database 19c or later. For advanced Oracle Database features like Transparent Application Continuity (TAC) and Sharding, they also require Oracle Client Libraries 19c or later.

先决条件#

¥Prerequisites

在 Oracle 数据库 服务器上创建用户账户。

¥Create a user account on an Oracle Database server.

支持的身份验证方法#

¥Supported authentication methods

  • 数据库连接

¥Database connection

相关资源#

¥Related resources

有关服务的更多信息，请参阅 Oracle 数据库文档。

¥Refer to Oracle Database documentation for more information about the service.

使用数据库连接#

¥Using database connection

要配置此凭据，你需要：

¥To configure this credential, you'll need:

  • 用户名

¥A User name.

  • 该用户的密码。

¥A Password for that user.

  • 连接字符串：要连接的 Oracle 数据库实例。该字符串可以是 Easy Connect 字符串、tnsnames.ora 文件中的 TNS 别名，或 Oracle 数据库实例。

¥Connection String: The Oracle Database instance to connect to. The string can be an Easy Connect string, or a TNS Alias from a tnsnames.ora file, or the Oracle Database instance.

  • 使用可选的 Oracle 客户端库：如果你想使用 Oracle 数据库的高级功能，请启用此功能。此选项内部使用 node-oracledb 厚模式。需要进行其他设置以启用 node-oracledb 厚模式。有关更多信息，请参阅 启用厚模式文档。此选项在官方 n8n Docker 镜像中不可用。

¥Use Optional Oracle Client Libraries: If you want to work with Oracle Database advanced features, turn this on. This option internally uses node-oracledb Thick mode. Additional settings to enable node-oracledb Thick mode are required. Refer to Enabling Thick mode documentation for more information. This option is not available in the official n8n docker images.

  • 使用 SSL：如果你的连接字符串使用 SSL，请启用它并配置 SSL 身份验证的其他详细信息。

¥Use SSL: If your Connection String is using SSL, turn this on and configure additional details for the SSL Authentication.

  • 钱包密码：用于解密隐私增强邮件 (PEM) 编码的私有证书的密码（如果已加密）。

¥Wallet Password: The password to decrypt the Privacy Enhanced Mail (PEM)-encoded private certificate, if it is encrypted.

  • 钱包内容：建立与 Oracle 数据库的双向 TLS (mTLS) 连接所需的安全凭证。

¥Wallet Content: The security credentials required to establish a mutual TLS (mTLS) connection to Oracle Database.

  • 可分辨名称：应与证书 DN 匹配的专有名称 (DN)。

¥Distinguished Name: The distinguished name (DN) that should be matched with the certificate DN.

  • 匹配专有名称：除了常规的证书验证之外，是否还应匹配服务器证书 DN。

¥Match Distinguished Name: Whether the server certificate DN should be matched in addition to the regular certificate verification that is performed.

  • 允许弱可分辨名称匹配：是否执行安全 DN 匹配行为（同时检查监听器和服务器证书）。

¥Allow Weak Distinguished Name Match: Whether the secure DN matching behavior which checks both the listener and server certificates has to be performed.

  • 连接池最小值：创建连接池时与数据库建立的连接数。

¥Pool Min: The number of connections established to the database when a pool is created.

  • 连接池最大值：连接池可以增长到的最大连接数。

¥Pool Max: The maximum number of connections to which a connection pool can grow.

  • 连接池增量：当连接请求超过当前已打开连接数时，打开的连接数。

¥Pool Increment: The number of connections that are opened whenever a connection request exceeds the number of currently open connections.

  • 会话池最大生命周期：当连接请求超过当前已打开连接数时，打开的连接数。

¥Pool Maximum Session Life Time: The number of connections that are opened whenever a connection request exceeds the number of currently open connections.

  • 连接池空闲超时：当连接请求超过当前已打开连接数时，打开的连接数。

¥Pool Connection Idle Timeout: The number of connections that are opened whenever a connection request exceeds the number of currently open connections.

  • 连接类名：DRCP/PRCP 连接类有关更多信息，请参阅 启用 DRCP。

¥Connection Class Name: DRCP/PRCP Connection Class. Refer to Enabling DRCP for more information.

  • 连接超时：应用建立 Oracle Net 连接的超时时间（以秒为单位）。

¥Connection Timeout: The timeout duration in seconds for an application to establish an Oracle Net connection.

  • 传输连接超时：等待建立与数据库主机连接的最大秒数。

¥Transport Connection Timeout: The maximum number of seconds to wait to establish a connection to the database host.

  • 保持连接探测间隔：发送 keepalive 探测包的间隔分钟数。

¥Keepalive Probe Interval: The number of minutes between the sending of keepalive probes.

要设置数据库连接凭据：

¥To set up your database connection credential:

  1. 在你的 n8n 凭据中，将数据库用户名作为“用户”输入。

¥Enter your database's username as the User in your n8n credential.

  1. 请输入用户密码。

¥Enter the user's Password.

  1. 在你的 n8n 凭据中，将数据库连接字符串作为“连接字符串”输入。

¥Enter your database's connection string as the Connection String in your n8n credential.

  1. 如果你的数据库使用 SSL，并且你希望为连接配置 SSL，请在凭据中启用此选项。如果启用 Oracle 数据库 SSL 证书，请在以下字段中输入 Oracle 数据库 SSL 证书信息：

¥If your database uses SSL and you'd like to configure SSL for the connection, turn this option on in the credential. If you turn it on, enter the information of your Oracle Database SSL certificate in these fields: 1. 如有钱包密码，请在“钱包密码”字段中输入。

1
  ¥Enter the wallet password, if any, in the **Wallet Password** field.

  1. 在“钱包内容”字段的 '已展开' 布局中输入 PEM 编码的钱包文件 ewallet.pem 的内容。这将确保保留 PEM 编码钱包文件中的所有空格。直接复制粘贴到“钱包内容”字段会移除空格，导致连接错误。

    ¥Enter PEM-encoded wallet file, ewallet.pem contents in the 'Expanded' layout of the Wallet Content field. This will ensure that all the whitespaces from the PEM-encoded wallet file are retained. Direct copy-paste into the Wallet Content field will strip out the whitespaces and lead to connection errors.

有关使用 TLS 连接的更多信息，请参阅 node-oracledb。

¥Refer to node-oracledb for more information on working with TLS connections.