If you select the User Provided option, the Host Name, Port Number, and Database Name fields are replaced by the Custom JDBC URL field.

","nestedContent":{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"If you select the ","type":"text"},{"text":"User Provided ","type":"text","marks":[{"type":"em"}]},{"text":"option, the ","type":"text"},{"text":"Host Name","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Port Number","type":"text","marks":[{"type":"strong"}]},{"text":", and ","type":"text"},{"text":"Database Name","type":"text","marks":[{"type":"strong"}]},{"text":" fields are replaced by the ","type":"text"},{"text":"Custom JDBC URL","type":"text","marks":[{"type":"strong"}]},{"text":" field.","type":"text"}]}]}],"version":1},"reason":"A note macro in a list item can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#f0f0f0","rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Account properties","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":3,"background":"#f0f0f0","rowspan":1,"colwidth":[151.0,348.0,985.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text","marks":[{"type":"em"}]},{"text":". ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]},{"text":"Enter the information to create a connection to the database.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Hostname","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Default Value","type":"text","marks":[{"type":"strong"}]},{"text":": N/A","type":"text"},{"type":"hardBreak"},{"text":"Example: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"oracledb22.abcdefghijkl.us-west-5.rds.amazonaws.com","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"190.159.0.124","type":"text"}]}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"String/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Required if ","type":"text","marks":[{"type":"em"}]},{"text":"JDBC URL Source ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"is Snap Generated","type":"text","marks":[{"type":"em"}]},{"text":". ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]},{"text":"The server address to ","type":"text"},{"text":"which the application ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]},{"text":"must ","type":"text"},{"text":"connect.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"If you need to connect to an on-premise server, specify the domain name or the IP address. For example, ","type":"text"},{"text":"test.mydbserver.com","type":"text","marks":[{"type":"em"}]},{"text":" or ","type":"text"},{"text":"190.159.0.124","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Port number","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Default Value","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"},{"text":"1521","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"},{"text":"1521","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"String/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Required if ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"em"}]},{"text":"JDBC URL Source","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"},{"type":"em"}]},{"text":" is Snap Generated","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"em"}]},{"text":". The database ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]},{"text":"server's port number to which the application must connect.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Database name","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Default Value","type":"text","marks":[{"type":"strong"}]},{"text":": N/A","type":"text"},{"type":"hardBreak"},{"text":"Example","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"MYDB","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"String/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Required if ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"em"}]},{"text":"JDBC URL Source","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"},{"type":"em"}]},{"text":" is Snap Generated","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"em"}]},{"text":". ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]},{"text":"The database name to which the application must connect.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Custom JDBC URL","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"text":"Default Value","type":"text","marks":[{"type":"strong"}]},{"text":": N/A","type":"text"},{"type":"hardBreak"},{"text":"Example","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"Oracle123DB","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Required if ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"em"}]},{"text":"JDBC URL Source","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"strong"},{"type":"em"}]},{"text":" is User Provided","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}},{"type":"em"}]},{"text":". The JDBC URLs that you want to use to connect to your Oracle account.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"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:","type":"text"}]},{"type":"paragraph","content":[{"text":"jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(ADDRESS_LIST=(LOAD_BALANCE=on)(CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=OracleTest)))","type":"text","marks":[{"type":"code"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Username","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"N/A","type":"text"},{"type":"hardBreak"},{"text":"Example: ","type":"text","marks":[{"type":"strong"}]},{"text":"TECTONIC","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"String/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"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.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Password","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"N/A","type":"text"},{"type":"hardBreak"},{"text":"Example: ","type":"text","marks":[{"type":"strong"}]},{"text":"Oracle123DB","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"String/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"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.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#f0f0f0","rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"JDBC JARs","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":3,"background":"#f0f0f0","rowspan":1,"colwidth":[151.0,348.0,985.0]},"content":[{"type":"paragraph","content":[{"text":"List of JDBC JAR files to be loaded. ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]},{"text":"Click ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"","id":"b12d9e05-6136-4968-86af-320cf5593086","collection":"contentId-896369589","height":""}}},{"text":" to add a JDBC Driver; click ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"","id":"683ab582-6b1e-4628-afd1-adc748e2cb8c","collection":"contentId-896369589","height":""}}},{"text":" to remove a JDBC Driver.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"JDBC driver","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"N/A","type":"text"},{"type":"hardBreak"},{"text":"Example:","type":"text","marks":[{"type":"strong"}]},{"text":" N/A","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"multiexcerpt-include-macro","parameters":{"macroParams":{"_parentId":{"value":"896369589"},"name":{"value":"Oracle JDBC Driver Upgrade -Behavior Change"},"templateData":{"value":"eJyLjgUAARUAuQ=="},"page":{"value":"Oracle Thin Dynamic Account"},"addpanel":{"value":"false"}},"macroMetadata":{"macroId":{"value":"9c788998-1b2b-4a6a-b3a8-666a5e907c7b"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://raw.githubusercontent.com/fuegokit/appfire-design-systems-brand-svg/main/single-color-brand-icons/af-logo-multi-excerpt-24.svg"}}],"title":"MultiExcerpt Include"}},"localId":"fc8c0fb6-cb54-4092-89f1-c399112b7b47"}}]},{"type":"paragraph","content":[{"text":"Learn more: ","type":"text"},{"text":"Oracle Driver Upgrade from Oracle JDBC 11.2.0.4 Driver to 19.20.0.0 Driver","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Oracle JDBC Driver Upgrade from v11.2.0.4 to v19.20.0.0 and JOOQ Upgrade from v3.9.1 to 3.17.x","versionAtSave":"23"},"href":"https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2940534958"}}]}]},{"type":"paragraph","content":[{"text":"Enter the JDBC jar file to be loaded. Use ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"","id":"b6eb8027-d87d-4061-8b0b-bbdc6b67509b","collection":"contentId-896369589","height":""}}},{"text":" 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.","type":"text"}]},{"type":"panel","attrs":{"panelType":"error"},"content":[{"type":"paragraph","content":[{"text":"Only v11.2.0.4.0 or higher JDBC driver supports user-defined types.","type":"text"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"JDBC driver class","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"end"}}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"oracle.jdbc.OracleDriver","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example: ","type":"text","marks":[{"type":"strong"}]},{"text":"oracle.jdbc.OracleDriver","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Required.","type":"text","marks":[{"type":"em"}]},{"text":" The name of the JBDC driver to use.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Database specifier type","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"end"}}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"Service name","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"Service name","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"Dropdown List","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"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:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SID","type":"text","marks":[{"type":"em"}]},{"text":": Uses the ","type":"text"},{"text":"jdbc:oracle:thin@HOST:PORT:DBNAME","type":"text","marks":[{"type":"em"}]},{"text":" format.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Service name","type":"text","marks":[{"type":"em"}]},{"text":": Uses the ","type":"text"},{"text":"jdbc:oracle:thin@//HOST:PORT/DBNAME","type":"text","marks":[{"type":"em"}]},{"text":" format. ","type":"text"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"SSL/ TCPS","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"Deselected","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"Checkbox","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Opt for or against connecting through SSL to the Oracle instance.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]},{"type":"paragraph","content":[{"text":"If selected, the following format of URL is used internally:","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]},{"type":"paragraph","content":[{"text":"jdbc:oracle:thin@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=)(PORT=))(CONNECT_DATA=(=)))","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Authentication method","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"User ID and Password","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"Kerberos","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"Dropdown List","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":" None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Choose the authentication method to use when connecting to Oracle. The available options are:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"User ID and Password","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Kerberos","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Kerberos authentication for Oracle supports both Windows and Linux-based databases and also supports Service account and User impersonation Kerberos authentication.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"When the authentication method is ","type":"text"},{"text":"Kerberos, ","type":"text","marks":[{"type":"em"}]},{"text":"for the service account, you must leave the ","type":"text"},{"text":"Username","type":"text","marks":[{"type":"strong"}]},{"text":" and ","type":"text"},{"text":"Password","type":"text","marks":[{"type":"strong"}]},{"text":" fields empty and add the below property to the ","type":"text"},{"text":"URL Properties","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"}]},{"type":"paragraph","content":[{"text":"oracle.net.kerberos5_cc_name = ","type":"text","marks":[{"type":"code"}]}]}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Kerberos config path","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"N/A","type":"text"},{"type":"hardBreak"},{"text":"Example","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"/opt/app/oracle/dbhome/network/admin/krb5.conf","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"String/Expression","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"Appears when the ","type":"text","marks":[{"type":"em"}]},{"text":"Authentication method","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" is Kerberos.","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Specify the path to the Kerberos configuration file.","type":"text"}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"Kerberos authentication for Oracle supports both Windows and Linux-based databases and also supports Service account and User impersonation Kerberos authentication.","type":"text"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#f0f0f0","rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Advanced properties","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":3,"background":"#f0f0f0","rowspan":1,"colwidth":[151.0,348.0,985.0]},"content":[{"type":"paragraph","content":[{"text":"Specify advanced properties to connect to the database.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Auto commit","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"end"}}],"content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"Selected","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"Checkbox/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Opt for or against setting the auto-commit property for a database.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"When selected, each of the batches is committed immediately after it is executed. If the Snap fails, only the batch being executed at that moment is rolled back.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"When not selected, the Snap execution output is committed only after all the batches are executed. If the Snap fails, the entire transaction is rolled back, unless the Snap finds invalid input data before it sends the insert request to the server, and routes the error documents to the Error view.","type":"text"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Batch size","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"50","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example: ","type":"text","marks":[{"type":"strong"}]},{"text":"100","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"Integer/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Required.","type":"text","marks":[{"type":"em"}]},{"text":" Set the number of statements that the Snap must execute at a time.","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Select queries are not batched.","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"error"},"content":[{"type":"paragraph","content":[{"text":"Using a large batch size could use up the JDBC placeholder limit of 2100.","type":"text"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Fetch size","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"100","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example: ","type":"text","marks":[{"type":"strong"}]},{"text":"100","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"Integer/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Required.","type":"text","marks":[{"type":"em"}]},{"text":" Set the number of rows that the Snap must fetch at a time when executing a query.","type":"text"}]},{"type":"panel","attrs":{"panelType":"error"},"content":[{"type":"paragraph","content":[{"text":"Large values could cause the server to run out of memory.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Max pool size","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"50","type":"text"},{"type":"hardBreak"},{"text":"Example: ","type":"text","marks":[{"type":"strong"}]},{"text":"50","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"Integer/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Required.","type":"text","marks":[{"type":"em"}]},{"text":" Set the maximum number of connections that a pool must maintain at a time.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Max lifetime (minutes)*","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"30","type":"text"},{"type":"hardBreak"},{"text":"Example: ","type":"text","marks":[{"type":"strong"}]},{"text":"35","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"Integer/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Required.","type":"text","marks":[{"type":"em"}]},{"text":" Set the maximum ","type":"text"},{"text":"time (in minutes)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]},{"text":" 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.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Idle Timeout (minutes)*","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"5","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example: ","type":"text","marks":[{"type":"strong"}]},{"text":"5","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"Integer/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Required.","type":"text","marks":[{"type":"em"}]},{"text":" Set the maximum ","type":"text"},{"text":"time (","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]},{"text":"in minutes","type":"text"},{"text":")","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]},{"text":" 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.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"Checkout timeout (milliseconds)*","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"10000","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example: ","type":"text","marks":[{"type":"strong"}]},{"text":"10000","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"Integer/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Required.","type":"text","marks":[{"type":"em"}]},{"text":" Set the time in milliseconds to wait for a connection to be available when the pool is exhausted. ","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"If you provide ","type":"text"},{"text":"0","type":"text","marks":[{"type":"em"}]},{"text":", the Snap waits infinitely until the connection is available. Therefore, we recommend you not to specify ","type":"text"},{"text":"0","type":"text","marks":[{"type":"em"}]},{"text":" for ","type":"text"},{"text":"Checkout Timeout","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#f0f0f0","rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"URL properties","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":3,"background":"#f0f0f0","rowspan":1,"colwidth":[151.0,348.0,985.0]},"content":[{"type":"paragraph","content":[{"text":"Specify input regarding URL properties.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"URL property name","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"N/A","type":"text"},{"type":"hardBreak"},{"text":"Example: ","type":"text","marks":[{"type":"strong"}]},{"text":"Batch_Refresh_Time","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"String/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Name for the URL property.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[312.0]},"content":[{"type":"paragraph","content":[{"text":"URL property value","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Default Value","type":"text","marks":[{"type":"strong"}]},{"text":": N/A","type":"text"},{"type":"hardBreak"},{"text":"Example:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"10","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[151.0]},"content":[{"type":"paragraph","content":[{"text":"String/Expressions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[348.0]},"content":[{"type":"paragraph","content":[{"text":"None","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[985.0]},"content":[{"type":"paragraph","content":[{"text":"Value for the URL property.","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Troubleshooting","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"809d1d4d-f0d5-4e26-af6b-9a852d36389f"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[409.0]},"content":[{"type":"paragraph","content":[{"text":"Error","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[521.0]},"content":[{"type":"paragraph","content":[{"text":"Reason","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[867.0]},"content":[{"type":"paragraph","content":[{"text":"Resolution","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[409.0]},"content":[{"type":"paragraph","content":[{"text":"Failed to validate account: Failed to retrieve a database connection. ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[521.0]},"content":[{"type":"paragraph","content":[{"text":"ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[867.0]},"content":[{"type":"paragraph","content":[{"text":"Configuring your Windows Registry key value, ","type":"text"},{"text":"HKEY_CURRENT_USER\\Control Panel\\International\\LocaleName","type":"text","marks":[{"type":"code"}]},{"text":", in the environment to ","type":"text"},{"text":"true","type":"text","marks":[{"type":"code"}]},{"text":" or ","type":"text"},{"text":"en-US","type":"text","marks":[{"type":"code"}]},{"text":" has been observed to work for some Windows-based Groundplex instances. Additional probable solutions can be found ","type":"text"},{"text":"here","type":"text","marks":[{"type":"link","attrs":{"href":"https://stackoverflow.com/questions/7700330/ora-12705-cannot-access-nls-data-files-or-invalid-environment"}}]},{"text":". ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[409.0]},"content":[{"type":"paragraph","content":[{"text":"Unable to obtain Principal Name for authentication","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[521.0]},"content":[{"type":"paragraph","content":[{"text":"Caused by: javax.security.auth.login.LoginException.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[867.0]},"content":[{"type":"paragraph","content":[{"text":"Ensure that the ticket cache (","type":"text"},{"text":"/tmp/krb5cc_Administrator","type":"text","marks":[{"type":"code"}]},{"text":") has enough permissions.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[409.0]},"content":[{"type":"paragraph","content":[{"text":"The service in the process is not supported.","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[521.0]},"content":[{"type":"paragraph","content":[{"text":"Operation unavailable.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[867.0]},"content":[{"type":"paragraph","content":[{"text":" Ensure to create the Kerberos ticket for the user using ","type":"text"},{"text":"\"okinit -f\"","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[409.0]},"content":[{"type":"paragraph","content":[{"text":"Got minus one from the read call.","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[521.0]},"content":[{"type":"paragraph","content":[{"text":" Keytab is not valid.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[867.0]},"content":[{"type":"paragraph","content":[{"text":"Ensure to create a new keytab file and place it in ","type":"text"},{"text":"%ORACLE_HOME%/network/admin","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[409.0]},"content":[{"type":"paragraph","content":[{"text":"The service in the process is not supported.","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[521.0]},"content":[{"type":"paragraph","content":[{"text":"An Invalid name provided (Mechanism level: KrbException: Cannot locate default realm)","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[867.0]},"content":[{"type":"paragraph","content":[{"text":"Ensure to provide valid ","type":"text"},{"text":"krb5.conf","type":"text","marks":[{"type":"code"}]},{"text":" path in the account settings.","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[409.0]},"content":[{"type":"paragraph","content":[{"text":"TNS:listener does not currently know of the service requested in the connect descriptor","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[521.0]},"content":[{"type":"paragraph","content":[{"text":"Oracle service is down.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[867.0]},"content":[{"type":"paragraph","content":[{"text":"Ensure the Oracle service is up and running.","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[409.0]},"content":[{"type":"paragraph","content":[{"text":"Cause: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[521.0]},"content":[{"type":"paragraph","content":[{"text":"The Listener refused the connection with the following error:","type":"text"}]},{"type":"paragraph","content":[{"text":"ORA-12505, TNS: The listener does not currently know of the SID given in the connect descriptor.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[867.0]},"content":[{"type":"paragraph","content":[{"text":"For Linux environment:","type":"text"}]},{"type":"paragraph","content":[{"text":"USE_SID_AS_SERVICE_=on","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"For Windows environment:","type":"text"}]},{"type":"paragraph","content":[{"text":"USE_SID_AS_SERVICE_=on","type":"text","marks":[{"type":"code"}]}]}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Snap Pack History","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"Oracle Snap Pack"},"_parentId":{"value":"896369589"},"name":{"value":"Oracle SPH"},"_referencedContentId":{"value":"1438106"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"475ed396-a4f7-4af2-be6c-f949b96ff90a"},"schemaVersion":{"value":"1"},"title":"Insert excerpt"}},"localId":"9dd2c079-14cd-464b-bb4d-97d09a22ae05"}}]}],"version":1}

Browser not supported