12.1 non-cdb TDE change the keystore password

[oracle@stormking DB12102 admin]$ oh
[oracle@stormking DB12102 dbhome_1]$ cd network/admin/
[oracle@stormking DB12102 admin]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin
[oracle@stormking DB12102 admin]$ cat sqlnet.ora

encryption_wallet_location =
        (source =
        (method = file)
        (method_data =
        (directory = /u01/app/oracle/wallet/$ORACLE_SID/wallet)))
[oracle@stormking DB12102 admin]$ mkdir -p /u01/app/oracle/wallet/$ORACLE_SID/wallet

[oracle@stormking DB12102 admin]$ sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 15 09:36:36 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> administer key management create keystore '/u01/app/oracle/wallet/DB12102/wallet' identified by kspw;


keystore altered.

SQL> SQL>
SQL> administer key management set keystore open identified by kspw;

keystore altered.

SQL> administer key management set key identified by kspw with backup;

keystore altered.

SQL> create tablespace ts encryption using 'aes256' default storage ( encrypt );

Tablespace created.

SQL> create table tcr ( a varchar2(30)) tablespace ts;

Table created.

SQL> insert into tcr ( a ) values ( rpad( 'A', 30, 'A' ));

1 row created.

SQL> commit;

Commit complete.


SQL> set linesize 200;
SQL> select rowid, a from tcr;

ROWID              A
------------------ ------------------------------------------------------------------------------------------
AAAFGoAAAAAAAMOAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA


SQL> administer key management alter keystore password identified by kspw set npw with backup;

keystore altered.

SQL> startup force
ORACLE instance started.

Total System Global Area 3221225472 bytes
Fixed Size                  2929552 bytes
Variable Size             603982960 bytes
Database Buffers         1526726656 bytes
Redo Buffers               13844480 bytes
In-Memory Area           1073741824 bytes
Database mounted.
ORA-28365: wallet is not open


SQL> administer key management set keystore open identified by npw;

keystore altered.

SQL> alter database open;

Database altered.

SQL> select rowid, a from tcr;

ROWID              A
------------------ ------------------------------------------------------------------------------------------
AAAFGoAAAAAAAMOAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA