Home | 簡體中文 | 繁體中文 | 雜文 | 打賞(Donations) | 雲棲社區 | OSChina 博客 | Facebook | Linkedin | 知乎專欄 | Github | Search | About

63.4. Opening the Encrypted Wallet

		
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 1 15:53:57 2016

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$encryption_wallet;

WRL_TYPE
--------------------
WRL_PARAMETER
-----------------------------------------------------------------------------
STATUS
------------------
file
/opt/oracle/admin/orcl/wallet
CLOSED
		
		
		
		
		$ orapki wallet create -wallet /opt/oracle/admin/orcl/wallet -auto_login_local
Oracle PKI Tool : Version 11.2.0.1.0 - Production
Copyright (c) 2004, 2009, Oracle and/or its affiliates. All rights reserved.

Enter password:       
Enter password again:   
                                                                                    
[oracle@orcl ~]$ ll /opt/oracle/admin/orcl/wallet
total 8
-rw------- 1 oracle oinstall 3589 Feb  1 15:58 cwallet.sso
-rw------- 1 oracle oinstall 3512 Feb  1 15:58 ewallet.p12
		
		
		
		SQL> select * from v$encryption_wallet;

WRL_TYPE
--------------------
WRL_PARAMETER
--------------------
STATUS
------------------
file
/opt/oracle/admin/orcl/wallet
OPEN_NO_MASTER_KEY
		
		

The Wallet must be open before opening the database:

		
SQL> startup mount;
SQL> alter system set wallet open identified by "password";
SQL> alter database open;
		
		

待續......