ora-28365 wallet not open but can't open database either
636510Sep 29 2009 — edited Jun 14 2011Hi
we had a Solaris Sparc 64-bit server crash ( power outage) while an oracle 11g database was open and using a wallet for encrypted tables and so on..
I'm getting two errors that are pinning me in a catch-22 situation.
oracle 11g Enterprise edition.
startop open causes 'ORA-28365 - Wallet is not open' error, but when I try to create and open wallet via
alter system set encryption key identified by "pasword"; oracle spits out
ORA-28380 - Database not open in read/write mode.
Can't open database without the Wallet being opened ( I've never seen that before) , and it can't create or open wallet without database being in 'read/write' mode.
I've also tried $ORACLE_HOME/bin/owm to create and open a wallet, and then try to open the database, and still get the same errors as above.I'm sure it all has to do with the server power outage..how can I 'open' the database without using the wallet in this case? I'd like to just get it to open without using wallet..
the database was in "noarchivelog" mode, I do have backups, but I doubt they'd work since they were done with the 11g database up and running..
would re-creating the control files solve the wallet issue?
thanks in advance.
Rob
Edited by: user633507 on Sep 29, 2009 8:45 AM