Questions tagged [oracle-wallet]

44 questions
6
votes
4 answers

JDBC Oracle wallet based connection: Wallet folder in memory

I want to connect to an Oracle database using a wallet stored in memory instead of having the wallet stored on disk. I tried using Apache Common VFS to read/write files in memory. The wallet is written to memory (to be sure I even wrote the wallet…
Nabila
  • 191
  • 4
  • 19
4
votes
0 answers

How to Use Oracle Wallet with Sqoop Developer API

When using Sqoop from the command line, I can use Oracle Wallet as described in the ASF Blog like: export HADOOP_OPTS= "-Doracle.net.tns_admin=$PWD/wallet -Doracle.net.wallet_location=$PWD/wallet" sqoop import -D mapred.map.child.java.opts=…
3
votes
3 answers

Not able to connect my application to Amazon RDS oracle db over TCPS

Hi All I am trying to connect Oracle Db from my dot net application but I am getting error: Network Transport: SSL failure in parsing wallet location I have all the required certificates in my windows certificate store. my connection string is : …
Vivek Mishra
  • 1,772
  • 1
  • 17
  • 37
3
votes
3 answers

C# connect to Oracle database using Wallet

I am building an app that connects to several Oracle databases. I have no problem connecting to databases on our internal network, but I need to connect to one on that is hosted on the Oracle Cloud. In SQL Developer the connection is made using an…
SkinnyPete63
  • 597
  • 1
  • 5
  • 20
3
votes
2 answers

Not able to connect Oracle with Apache Spark using SSO Wallet

We are trying to connect to a remote Oracle database running as AmazonRDS using SSO wallet configured at our end and Apache Spark. We are able to load the data using the spark-shell utility as mentioned below Start the spark shell with jdbc and…
user2720864
  • 8,015
  • 5
  • 48
  • 60
3
votes
3 answers

JDBC oracle wallet connection

I am facing a problem connecting my java application to an oracle database using oracle wallet as password store. To isolate the problem I made a small Main class as follow: public static void main(String[] args) { Connection conn; try…
3
votes
1 answer

Connecting to a database in Pro C using Oracle Wallet

I have an Oracle Wallet configured and tested. I have an application written with Pro C which needs to connect using the wallet. I have been unable to find documentation on this. Looking for any information I can get on how to connect with Pro C…
ScottF
  • 49
  • 4
2
votes
0 answers

Compilation variables declaration and usage in .net core

How to write compilation variable for oracle and oracle wallet in .Net Core? Example: if (oracle) { oracle namespace } else if (oracle wallet) { oracle wallet namespace }
subbu
  • 21
  • 1
2
votes
2 answers

cx_Oracle: How do I connect to Oracle when you use a Wallet?

Here is the code in the file con = cx_Oracle.connect('/@database_name'). This is setup to use my oracle wallet but its not working for some reason (giving me login denied). How do I enter my user name and password in this line of code? con =…
1
vote
1 answer

https request in Oracle 18c : "ORA-29024: Certificate validation failure"

I use Oracle 18C pl sql script. I would like to make https requests. So, i begin with http requests and it works. But, with https requests, i have an error : "Certificate validation failure". I will explain below how I proceed in order to reach…
elongez
  • 21
  • 4
1
vote
2 answers

Connect jdbc via oracle wallet

Based on oracle document, I create a wallet mkstore -wrl /tmp/wl -create Add a credential mkstore -wrl /tmp/wl -createCredential localhost:1521/myservice user pass In my java application, I want to connect to the database via this wallet public…
SoT
  • 898
  • 1
  • 15
  • 36
1
vote
1 answer

How to fix: cx_Oracle.DatabaseError: ORA-12578: TNS:wallet open failed

I am establishing connection to Oracle database in Python using cx_Oracle. I am using wallet to connect to DB. And the code is running inside virtual env. When I activate the virtual env and run the script manually, it runs fine. But it throws below…
rd10
  • 1,599
  • 2
  • 10
  • 27
1
vote
1 answer

Oracle Wallet creation - what does the option -wrl stand for?

Please let me know what could this option (-wrl) stand for in relation to this Oracle wallet creation. This would help me to have a mental map what wrl means. Sample command: mkstore -wrl -createCredential wallet-alias scott tiger
1
vote
1 answer

SQLPLUS not getting credentials from ewallet.p12 file

Followed https://docs.oracle.com/cd/E78494_01/aip/pdf/1411/html/ig/aip-ig-apx_wallet.htm guide and created ewallet.p12 (also generates cwallet.sso), sqlnet.ora, and tnsnames.ora: PS C:\Users\myname\Oracle> echo…
Kiarash Zamanifar
  • 647
  • 1
  • 9
  • 19
1
vote
0 answers

Configure Quartz Scheduler with Oracle wallet

The application I am supporting uses Quartz Scheduler version 2.3.2 with Oracle database. User and password credentials are specified in Quartz configuration datasource section of the properties file. Here is the config properties file which works…
nephewtom
  • 2,941
  • 3
  • 35
  • 49
1
2 3