1.Add the following entries in the $ORACLE_HOME/network/admin/sqlnet.ora (Note it is the DB's ORACLE_HOME not the GRID'S ORACLE_HOME)
Make sure that the DIR you specified in the sqlnet.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/11.2.0.3/dbhome_1/network/admin)
)
)
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/11.2.0.3/dbhome_1
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 sqlnet.ora
4. Create and open the wallet in the open read/wirte mode.
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "welcome1";
5.Reopen the wallet. When the instance is restarted or the wallet is closed, you must reopen the wallet in mounted mode.
startup mount;
ALTER SYSTEM SET ENCRYPTION WALLET IDENTIFIED BY "welcome1";
alter database open;
6.Close the wallet
Make sure that the DIR you specified in the sqlnet.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/11.2.0.3/dbhome_1/network/admin)
)
)
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/11.2.0.3/dbhome_1
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 sqlnet.ora
4. Create and open the wallet in the open read/wirte mode.
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "welcome1";
5.Reopen the wallet. When the instance is restarted or the wallet is closed, you must reopen the wallet in mounted mode.
startup mount;
ALTER SYSTEM SET ENCRYPTION WALLET IDENTIFIED BY "welcome1";
alter database open;
6.Close the wallet
ALTER SYSTEM SET ENCRYPTION WALLET CLOSE IDENTIFIED BY "welcome1";
转载请注明作者出处及原文链接,否则将追究法律责任:
作者:xiangsir
原文链接:http://blog.csdn.net/xiangsir/article/details/13288255
QQ:444367417
MSN:xiangsir@hotmail.com