Sunday, May 11, 2014

ICM and Wallet Issue

Issue
=====


You are running adcmctl.sh version 120.17.12010000.5

ORACLE error 28365 in afpgdbcf

Cause: afpgdbcf failed due to ORA-28365: wallet is not open
ORA-06512: at "APPS.FND_SECURITY_PKG", line 539
ORA-06512: at line 1.

The SQL statement being executed at the time of the error was:  SELECT /*+ USE_NL (A I) */  DISTINCT A.APPLICATION_ID, A.APPLICATION_NAME,  A.APPLICATION_SHORT_NAME, A.BASEPATH, I.PRODUCT_VERSION  FROM FND_APPLICATION_VL A, FND_PRODUCT_INSTALLATIONS I  WHERE A.APPLICATION_ID = I.APPLICATION_ID (+)  and was executed from the file &ERRFILE.
Internal Concurrent Manager status could not be determined.
===============================
  declare
*
ERROR at line 1:
ORA-20000: ORA-28365: wallet is not open Failed to call the procedure
fnd_apps_mode_util.set_to_maintenance_mode while enabling
maintenance mode.
ORA-06512: at line 38

=============================


Alert Log error
=================

kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
Errors in file /SID/oracle/product/112/admin/SID_host/diag/rdbms/SID/SID/trace/SID_smon_4269.trc:
ORA-28365: wallet is not open
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet


==============================

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2235208 bytes
Variable Size             427820216 bytes
Database Buffers          624951296 bytes
Redo Buffers               13930496 bytes
Database mounted.
ORA-28365: wallet is not open


Fix
====
bash-3.2$  cd /SID/oracle/product/112/network/admin/SID_host/wallet
bash-3.2$ ls
cwallet.sso  encryption_passwd  ewallet.p12

orapki wallet change_pwd -wallet $ORACLE_HOME/wallet
-------------------

SQL> SELECT * FROM gv$encryption_wallet;

   INST_ID WRL_TYPE
---------- --------------------
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS
------------------
  1 file
/SID/oracle/product/112/network/admin/SID_host/wallet
CLOSED


SQL> ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "*****";

System altered.

No comments:

Post a Comment