文档介绍：DBA never sleep-DBA,永不眠
Focus on Oracle Database, GodenGate and Unix
[置顶] How to open and close wallet for Oracle Databse 11g?
分类: Oracle 11g OCP Certification 2013-10-28 09:36 510人阅读评论(0) 收藏举报
Oracle 11gRACwalletcostdatabase
the following entries in the $work/admin/.ora (Note it is the DB's
ORACLE_HOME not the GRID'S ORACLE_HOME)
Make sure that the DIR you specified in the .ora exist on the host, Or you will encounter error
when creating wallet.
WALLET_LOCATION =
  (SOURCE =
    (METHOD = FILE)
    (METHOD_DATA =
      (DIRECTORY= /u01/app/oracle/product/)
    )
   )
ENCRYPTION_WALLET_LOCATION =
  (SOURCE =
    (METHOD = FILE)
    (METHOD_DATA =
      (DIRECTORY= /u01/app/oracle/admin/poddb/wallet)
    )
   )
2. Restart the listener , so that your previous configuration can take effect.
 
$ORACLE_HOME/bin/srvctl stop listener
$ORACLE_HOME/bin/srvctl start listener
3. Make a verify whether your wallet location config takes effect.
export ORACLE_HOME=/u01/app/oracle/product/
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=***
sqlplus / as sysdba
SQL> select wrl_type wallet,status,wrl_parameter wallet_location from v$encryption_wallet;
--the wallet_location must be the same as the value in the .ora
4. Create and open the wallet in the open read/wirte mode.
   
ALTER SYSTEM SET ENCRYPTION KEY