Oracle Thin Account
In this article
Overview
Use this account type to connect Oracle Snaps with data sources that use Oracle accounts.
Prerequisites
Kerberos authentication for Oracle setup in the Windows/Linux environment.
Known Issues
None.
Account Settings
Oracle Thin Account configuration with the Kerberos service account as the authentication method.
Asterisk ( * ): Indicates a mandatory field.
Suggestion icon ( ): Indicates a list that is dynamically populated based on the configuration.
Expression icon ( ): Indicates whether the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.
Add icon ( ): Indicates that you can add fields in the field set.
Remove icon ( ): Indicates that you can remove fields from the field set.
Field Name | Field Type | Field Dependency | Description |
---|---|---|---|
Label Default Value: N/A | String | None | Required. Specify a unique name for the account. |
JDBC URL Source Default Value:Â Snap Generated | String | None | Required. Select the source of the JDBC URL.Â
|
Account properties | Required. Enter the information to create a connection to the database. | ||
Hostname Default Value: N/A
| String | None | Required if JDBC URL Source is Snap Generated. The server address to which the application must connect. If you need to connect to an on-premise server, specify the domain name or the IP address. For example, test.mydbserver.com or 190.159.0.124. |
Port Number Default Value:1521 | String | None | Required if JDBC URL Source is Snap Generated. The database server's port number to which the application must connect. |
Database name Default Value: N/A | String | None | Required if JDBC URL Source is Snap Generated. The database name to which the application must connect. |
Custom JDBC URL
| String | None | Required if JDBC URL Source is User Provided. The JDBC URLs that you want to use to connect to your Oracle account. Use this option if you want to use complex JDBC URLs (involving multiple hosts and advanced options) to connect to your Oracle instance. For example, if you want to connect to Oracle DataGuard, you can enter a JDBC like the one below:
|
Username Default Value:Â N/A | String | None | The user name that is allowed to connect to the database. It is used as the default username when retrieving connections. The user name must be valid in order to set up the data source. |
Password Default Value:Â N/A | String | None | The password used to connect to the data source. It is used as the default password when retrieving connections. The password must be valid in order to set up the data source. |
JDBC JARs | List of JDBC JAR files to be loaded. Click  to add a JDBC Driver; click  to remove a JDBC Driver. | ||
JDBC Driver  Default Value: N/A | String | None | Learn more: Oracle Driver Upgrade from Oracle JDBC 11.2.0.4 Driver to 19.20.0.0 Driver Enter the JDBC jar file to be loaded. Use  to select an existing file. A different driver binary for a driver must have a different name, the same name can not be reused for a different driver. If this property is left blank, a default JDBC driver is loaded. |
JDBC Driver Class  Default Value:oracle.jdbc.OracleDriver | String | None | Required. The name of the JBDC driver to use. |
Database specifier type  Default Value: Service name | String | None | Specify the database specifier type to use. The selected option decides which format of URL for JDBC is to be used internally. The valid options are:
|
SSL/ TCPS Default Value:Â Deselected | String | Â | Opt for or against connecting through SSL to the Oracle instance. If selected, the following format of URL is used internally: jdbc:oracle:thin@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=<HOST>)(PORT=<PORT>))(CONNECT_DATA=(<SID/ SERVICE_NAME>=<DATABASE_NAME>))) |
Authentication method  Default Value: User ID and Password | Dropdown List |  None | Choose the authentication method to use when connecting to Oracle. The available options are:
|
Kerberos config path  Default Value: N/A | String/Expression | Appears when the Authentication method is Kerberos. | Specify the path to the Kerberos configuration file. |
Advanced properties | Specify advanced properties to connect to the database. | ||
Auto commit Default Value:Â Selected | String | None | Opt for or against setting the auto-commit property for a database.
|
Batch size Default Value: 50 | Integer | None | Required. Set the number of statements that the Snap must execute at a time. |
Fetch size
| Integer | None | Required. Set the number of rows that the Snap must fetch at a time when executing a query.  |
Max pool size
| Integer | None | Required. Set the maximum number of connections that a pool must maintain at a time. |
Max life time Default Value: 30 | Integer | None | Required. Set the maximum time (in minutes) of a connection in the pool. Ensure that the value you enter is a few seconds shorter than any database or infrastructure-imposed connection time limit. A value of 0 indicates an infinite lifetime, subject to the Idle Timeout value. An in-use connection is never retired. Connections are removed only after they are closed. |
Idle Timeout Default Value: 5 | Integer | None | Required. Set the maximum time (in minutes) that a connection is allowed to sit idle in the pool. A value of 0 indicates that idle connections are never removed from the pool. |
Checkout timeout Default Value: 10000 | Integer | None | Required. Set the time in milliseconds to wait for a connection to be available when the pool is exhausted. |
URL Properties | Specify input regarding URL properties. | ||
URL property name  Default Value: N/A | String | None | Name for the URL property. |
URL property value Default Value:Â N/A | N/A | None | Value for the URL property. |
Troubleshooting
Error | Reason | Resolution |
---|---|---|
Failed to validate account: Failed to retrieve a database connection. | ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified | Configuring your Windows Registry key value, |
| Caused by: javax.security.auth.login.LoginException. | Ensure that the ticket cache ( |
| Operation unavailable. | Â Ensure to create the Kerberos ticket for the user using |
|  Keytab is not valid. | Ensure to create a new keytab file and place it in  |
| An Invalid name provided (Mechanism level: KrbException: Cannot locate default realm)  | Ensure to provide valid  |
| Oracle service is down. | Ensure the Oracle service is up and running. Â |
| The Listener refused the connection with the following error: ORA-12505, TNS: The listener does not currently know of the SID given in the connect descriptor. | For Linux environment:
For Windows environment:
|
Snap Pack History
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.