Změna hesla pro oracle wallet (orapki)

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/

Komentáře