Hi,
I should use an Oracle Wallet Connection.
Is there anyone has already done? I need help. Thank you
Hi,
I should use an Oracle Wallet Connection.
Is there anyone has already done? I need help. Thank you
Hi,
if you have setup Oracle Wallet corretly it should work with KNIME just do not enter any user name and password in the Database Connector node.
Bye
Tobias
thanks :)
Hi Tobias,
I'have tried the wallet connection but it seems doesn't work.
In attachement my configuration in DATABASE Connector (I'm using knime 3.2.1)
Have you an example for correct configuration?
Thanks
Hi,
have a look at the follwoing post about hwo to setup a java client such as KNIME to use Oracle wallet.
To register all the jars (step 2) in KNIME copy them into a single directory and register it in KNIME via File->Preferences KNIME->Database by clicking on the Add directory button.
Add the system properties (step 3) via the knime.ini file which is located in the KNIME installation directory.
Bye
Tobias
Thanks Tobia! :)
Bye
Hi,
I should set up the wallet using knime 4.3 version but I can’t make it work.
These are the details of the error. Could you help me?
Thank you
TSNAMES.ORA
ISOS1_KNIME = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxx.xxxxxxxx.xxxxx )(PORT = ???))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ISOS1 )))
SQLNET.ORA
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = *:\***********\12.2.0\client_1\NETWORK\ADMIN)
)
)
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0
KNIME.INI
-Doracle.net.tns_admin= :**********\12.2.0\client_1\NETWORK\ADMIN
-Doracle.net.wallet_location= :**********\12.2.0\client_1\NETWORK\ADMIN
Hello romarra,
did you also register the additional library files that are necessary for Oracle wallet:
oraclepki.jar
, osdt_core.jar
, and osdt_cert.jar
?
To do so either copy all the jars into a directory and register the directory or add all files separately as described in the db documentation. More details about the configuration can be also found in the Oracle documentation.
If you still have problems connecting please also post the error message here but make sure that it does not contain any sensitive information.
Bye
Tobias
Hi Tobias, I added libraries in CLASSPATH and also in knime. The error is as follows:
ERROR DB Connector 0:7 Execute failed: ORA-01005: null password given; logon denied
Hello romarra,
sorry for the long silence. Can you please try to use a Credential Input node with no user name and password as in the attached workflow. Even if you select none as authentication method the DB framework will add an empty password property to the connection string which seems to cause problems with Oracle wallet. This is a bug and I have opened a ticket to fix this.
Bye
Tobias
OracleWallet.knwf (9.4 KB)
Hi Tobias, I just tried the example but it still goes wrong:
DEBUG Oracle Connector 3:1180 New database session: DefaultDBSessionInformation(id=6b8129d6-1d2c-4fcc-89d3-3e6b48ad1ac5, dbType=DBType(id=oracle, name=Oracle, description=null), driverDefinition=DBDriverDefinition(id=ORACLE_OCI, name=ORACLE_OCI, version=12.2.0, driverClass=oracle.jdbc.OracleDriver, dbType=DBType(id=oracle, name=Oracle, description=null), description=, origin=USER), connectionController=org.knime.database.connection.UserDBConnectionController=(url=jdbc:oracle:oci:@xxx_KNIME, authenticationType=CREDENTIALS, credential=emptyCredential), dialectId=oracle, attributeValues={})
INFO Oracle Connector 3:1180 Could not create connection to database using URL: jdbc:oracle:oci:@xxx_KNIME and parameters: [user, password]. Exception: ORA-01017: nome utente/password non validi; connessione rifiutata
DEBUG Oracle Connector 3:1180 reset
ERROR Oracle Connector 3:1180 Execute failed: ORA-01017: nome utente/password non validi; connessione rifiutata
Hello romarra,
I’m sorry to hear that. We will have a bug fix release soon and we will try to fix the problem until then. Unfortunately we do not have an Oracle DB with Wallet based authentication for testing. So it would be great if you could help us with the testing once the problem is fixed by trying it with the nightly build.
Bye
Tobias
Thank you Tobias, I will gladly be a tester for the new release.
Super. I will get back to you beginning of next week for the testing.
Thanks a lot for your help.
Tobias
Hello romarra,
we have changed the behavior of the Oracle Connector node in the nightly build of the KNIME Analytics Platform. Can you please download it from here.
Once downloaded please perform an update via File->Update KNIME… to be sure that you have the latest version of the database extension.
After that please install the Oracle driver with all the companion files as before. By the way it should be enough if you register the files without the folders:
In the Oracle Connector select None as authentication type.
Thanks for your help and patience to get this working.
Bye
Tobias
Hi Tobias,
Sorry for the delay in answering. The test I did on the wallet went well.
The fix seems to work correctly. Can you tell me when it will be released permanently?
Hi romarra,
thanks for testing. We are performing some final tests on the release. If no big problems come up during the tests we will release KNIME Analytics Platform 4.3.2 with the Oracle Wallet fix this week. I will post an update here once it is released.
Bye
Tobias
Hi romarra,
KNIME Analytics Platform 4.3.2. is released which addresses this problem. You can find further information in the change log.
Bye
Tobias