Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Oscar.

Asked: June 29, 2017 - 11:20 am UTC

Last updated: April 09, 2019 - 1:51 am UTC

Version: 12.1

Viewed 10K+ times! This question is

You Asked

Hi,

In a RAC database, I have a open keystore (wallet) with AUTOLOGIN. I would like to disable the AUTO LOGIN, but I am not sure of the correct procedure for that.


select * from gv$encryption_wallet;

WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_OR FULLY_BAC CON_ID
-------------------- ---------------------------------------------------------------------- -------------------- -------------------- --------- --------- ----------
FILE /fscompgg/oracle/Wallet_Oracle/WALLE/ OPEN AUTOLOGIN SINGLE NO 0

SQL>
INST_ID WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_OR FULLY_BAC CON_ID
---------- -------------------- ---------------------------------------------------------------------- -------------------- -------------------- --------- --------- ----------
2 FILE /fscompgg/oracle/Wallet_Oracle/WALLE/ OPEN AUTOLOGIN SINGLE NO 0
1 FILE /fscompgg/oracle/Wallet_Oracle/WALLE/ OPEN AUTOLOGIN SINGLE NO 0

SQL>


Could you please give me an idea? Thank you in advance.


and Connor said...

I'd probably start with the section of the documentation called:

"Disabling Auto Login for Oracle Wallets"

:-)

which you can find here

http://docs.oracle.com/database/122/DBIMI/using-oracle-wallet-manager.htm#DBIMI9745

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

I prefer not using wallet manager

Oscar --, June 30, 2017 - 5:50 am UTC

Thank you. I will try this:

rename cwallet.sso at so:

mv cwallet.sso cwallet.sso.bkp

close wallet:
alter system set wallet close;

open wallet as a password keystore:

ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY password;


I prefer not using wallet manager.

Thank you very much.

Regads
Connor McDonald
July 01, 2017 - 2:46 am UTC

"I prefer not using wallet manager."

I prefer sunny days.... but that doesn't mean that it wont rain :-)

Disable by command line

Riné Huiden, March 04, 2019 - 3:03 pm UTC

How can you disable "Auto Login for Oracle Wallets" in scripting or by command line. Because we want to create a script which clones PDB's and current Cloning with AUTO LOGIN doesn't work.
Connor McDonald
April 09, 2019 - 1:51 am UTC

Um...the steps above trivially scripted
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.