Questions tagged [wallet]

17 questions
5
votes
2 answers

Oracle Wallet Setup ORA-12578

I am having trouble setting up the Oracle Wallet on a new box connecting to a new database. I have added the following lines to my SQLNET.ORA: SQLNET.WALLET_OVERRIDE = TRUE WALLET_LOCATION =…
Leigh Riffel
  • 23,884
  • 17
  • 80
  • 155
4
votes
1 answer

Can a Wallet be used with SQL Developer? How?

I have a Wallet configured and working fine for SQLPlus. Is there a way to make it work with SQL Developer?
Leigh Riffel
  • 23,884
  • 17
  • 80
  • 155
3
votes
2 answers

Renew Certificate in Oracle Enterprise Cloud Control OMS Manager Console

Environment: Oracle Enterprise Manager Cloud Control 13.4 OMS console with third party certificate Secured My situation is the following: I am new in this client and apparently the former DBA added a third party certificate in the OMS console,…
2
votes
1 answer

Recover encrypted Oracle database

A client fired their DBA. He used OWM to add a wallet to their Oracle database and secure a few necessary columns of tables that they need. I can see the walled using: orapki wallet display -wallet /opt/oracle/home/owm/root I do not know the…
kainaw
  • 1,404
  • 3
  • 15
  • 26
2
votes
2 answers

Information on Oracle MKSTORE utility for creating wallet

I'm looking for more information about the utility MKSTORE that can be used for creating and modifying a Wallet. I would like to know things like what the -createALO option is and what the difference is between -createSSO and CreateLSSO. A link to…
Leigh Riffel
  • 23,884
  • 17
  • 80
  • 155
2
votes
1 answer

How to configure so the Oracle wallet password can be authenticated with a web based Oracle application?

Does anyone know how to configure it so that the Oracle wallet password can be authenticated with a web based Oracle application? I’m trying to make secure LDAP connections with an Oracle web based application with secure ports. This requires that…
Kirk
  • 21
  • 3
2
votes
1 answer

How to automatically add TLS certificates to Oracle wallets?

When accessing external webservices via HTTPS via the Oracle database you need to add the corresponding certificate to a database wallet to prevent a certificate validation error. When one creates an account at apex.oracle.com, one is able to access…
WayneNani
  • 123
  • 5
1
vote
2 answers

Wallet open failed

I have a oracle server installed in a machine and e oracle client on another machine. I have created a wallet using this commands C:\Users\MRBULL93>mkstore -wrl C:\VideoWallet -create C:\Users\MRBULL93>mkstore -wrl C:\VideoWallet -createCredential…
MRBULL93
  • 13
  • 1
  • 1
  • 3
1
vote
0 answers

How to send job notifications with dbms_scheduler via ssl encrypted smtp

We have Oracle Enterprise 19 Databases installed on Linux and using job notification via smtp with Oracle dbms_scheduler for quite a long time. Defining jobs like this and having all the needed settings like SMTP server, ports etc defined in…
1
vote
0 answers

Carry forwarding token wallet concept

I'm trying to create a carry-forward wallet system. Recharge part I'm developing an app that has the carry forwarding token wallet concept. However, when an user recharge their wallet, an amount of the token will be credited to their wallet with an…
1
vote
2 answers

How to pass Oracle Wallet auth to sh script?

I am running an Oracle DB update script that requires password. I have Oracle wallet installed. How to pass Oracle wallet to sh script so that I don't have to enter password when running the script? I have my sqlnet.ora…
Stepan
  • 213
  • 3
  • 13
1
vote
1 answer

Oracle Wallet Error in Red Hat High Availability Resource

Environment: Running Red Hat 7.2, using Pacemaker 1.1.13-10.el7_2.2 and Corosync 2.3.4-7.el7_2.1 to implement cluster failover of an Oracle 12c Enterprise Edition Release 12.1.0.2.0 Database. Background: When I start the database outside the…
0
votes
0 answers

ORA-28759: failure to open file

I have implemented oracle wallet using orapki utility following this guide : https://stackoverflow.com/questions/63834638/how-to-change-protocol-for-oracle-database-connection-in-asp-net-core However, when I try to connect from the App Server to the…
Ali
  • 345
  • 3
  • 17
0
votes
1 answer

logon denied for oracle wallet user

Following a video tutorial on oracle wallets: https://youtu.be/LLZzUNb9ALU The db server is run from oracle's official docker container. The steps I have done are as follows: On server shell, ran sql plus as sysdba: $ sqlplus / as sysdba Created…
deostroll
  • 189
  • 1
  • 2
  • 7
0
votes
2 answers

Is it possible to limit connecting users to a schema from specific terminal or program?

I read about Oracle ACL, but on first sight, it doesn't look like it limits the access to a schema on terminal, program level. Is it even possible? I did experience such limitation once. I was connecting by sqlplus from unix box, the same box the…
Jakub P
  • 167
  • 1
  • 2
  • 10
1
2