Lze použít i GUI Oracle wallet manager (owm)
Změna hesla
[oracle@dbserver ~]$ cd /cloudfs/wallets/racdb/
[oracle@dbserver racdb]$ cp ewallet.p12 ewallet.p12.bkp
[oracle@dbserver racdb]$ orapki wallet change_pwd -wallet /cloudfs/wallets/racdb/ewallet.p12
Oracle PKI Tool : Version 11.2.0.4.0 – Production
Copyright (c) 2004, 2013, Oracle and/or its affiliates. All rights reserved.
Enter wallet password: [stare heslo]
New password: [nove_heslo] Enter wallet password: xxxxxx
Síla hesla PKI-01002: Invalid password:Passwords must have a minimum length of eight characters and contain alphabetic characters combined with numbers or special characters.
Kontrola [oracle@dbserver racdb]$ sqlplus / as sysdba SQL> col wallet format a10 col status format a10 col wallet_location format a50 set echo on select wrl_type wallet,status,wrl_parameter wallet_location from gv$encryption_wallet;
WALLET STATUS WALLET_LOCATION ---------- ---------- -------------------------------------------------- file OPEN /cloudfs/wallets/racdb/ file OPEN /cloudfs/wallets/racdb/
SQL> exit [oracle@dbserver racdb]$ srvctl stop database -d racdb [oracle@dbserver racdb]$ srvctl start database -d racdb [oracle@dbserver racdb]$ sqlplus / as sysdba SQL> col wallet format a10 col status format a10 col wallet_location format a50 set echo on select wrl_type wallet,status,wrl_parameter wallet_location from gv$encryption_wallet; 2
WALLET STATUS WALLET_LOCATION ---------- ---------- -------------------------------------------------- file CLOSED /cloudfs/wallets/racdb/ file CLOSED /cloudfs/wallets/racdb/
SQL> alter system set encryption wallet open identified by "staré_heslo"; alter system set encryption wallet open identified by "staré_heslo" * ERROR at line 1: ORA-28353: failed to open wallet
SQL> alter system set encryption wallet open identified by "nové_heslo";
System altered.
SQL> col wallet format a10 col status format a10 col wallet_location format a50 set echo on select wrl_type wallet,status,wrl_parameter wallet_location from gv$encryption_wallet;SQL> SQL> SQL> SQL> 2
WALLET STATUS WALLET_LOCATION ---------- ---------- -------------------------------------------------- file OPEN /cloudfs/wallets/racdb/ file OPEN /cloudfs/wallets/racdb/