Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Wallet

Arif2018Feb 20 2021

I am trying to consume third party webservices provided by one of our vendors which has https url. In order to consume this i need to setup oracle wallet and ACL on my Oracle DB which is on windows server. Can anyone help me in providing the steps.i tired the following by creating the folder in home directory of oracle.Adding the path in sql net.ora and then while issuing the command i am getting this error.
[code]
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = D:\app\administrator\product\12.1.0\dbhome_1\Wallet)
)
)
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0
--message i am getting while issuing the command.

D:\app\administrator\product\12.1.0\dbhome_1\Wallet>mkstore -wrl/d:/app/administrator/product/12.1.0/dbhome_1/Wallet -create
Oracle Secret Store Tool : Version 12.1.0.2
Copyright (c) 2004, 2014, Oracle and/or its affiliates. All rights reserved.

No wallet location specified.
mkstore [-wrl wrl] [-create] [-createSSO] [-createLSSO] [-createALO] [-delete] [-deleteSSO] [-list] [-createEntry alias secret] [-viewEntry alias] [-modifyEntry alias secret] [-deleteEntry alias] [-createCredential connect_string username password] [-listCredential] [-modifyCredential connect_string username password] [-deleteCredential connect_str
ing] [-help] [-nologo]
D:\app\administrator\product\12.1.0\dbhome_1\Wallet>
[/code]

Comments

User_5MDN2

您好,请问您的问题解决了吗?

Solomon Yakobson

Most likely ORACLE_HOME isn't set:

I:\>mkstore -wrl c:\temp -create
The syntax of the command is incorrect.

I:\>set ORACLE_HOME=C:\app\oracle_home_user\product\12.2.0\dbhome_1

I:\>mkstore -wrl c:\temp -create
Oracle Secret Store Tool : Version 12.2.0.1.0
Copyright (c) 2004, 2016, Oracle and/or its affiliates. All rights reserved.


Enter password:

SY.

Solomon Yakobson

Also :

mkstore -wrl/d:/app/administrator/product/12.1.0/dbhome_1/Wallet -create

There should be no slash in front of drive name and a space after -wrl:

 mkstore -wrl d:/app/administrator/product/12.1.0/dbhome_1/Wallet -create

SY.

Arif2018

Thanks Solomon , this one is working but i am not able to view the json response from rest url. it seems there is an issue with Oracle.12.1.0 version.

1 - 4

Post Details

Added on Feb 20 2021
4 comments
732 views