creating new PDB from PDB$SEED
Date: Thu, 5 Aug 2021 17:43:43 +1000
Message-ID: <CAFeFPA95zTSt4ChDCraGKwGBwkWZ6F4e8p=B-E2uJTLPmvf21Q_at_mail.gmail.com>
Hi All
Wallets always seem to not like me very much when dealing with them.
I am trying to create a PDB from PDB$SEED
12c R2
ASM
so I give the below command (with correct variables) and that works fine,
but I can not add new tablespaces because there is no key in the wallet for
that PDB. Expected behaviour.
create pluggable database TESTPDB admin user <username> identified by <password>;
Now I need to re-assure myself that the next step is simply below (the
force is apparently available since 12c R2 and negates having to close the
database and open the password wallet ) I would hate to screw up the wallet
somehow..even in our test system. Anyone doing this in this version of
oracle regularly?
open the new pdb
switch to new PDB as SYS
ADMINISTER KEY MANAGEMENT SET KEY FORCE KEYSTORE IDENTIFIED BY
"<passsword>" WITH BACKUP;
Jack van Zanen
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 05 2021 - 09:43:43 CEST