Author: dbalifeeasy

ORA-01078 When running Dbca Delete Database

When trying to delete a database by running dbca, the following errors appear:

$  dbca  -silent -deleteDatabase -sourceDB TESTDB -sysDBAUserName sys  -sysDBAPassword "sys_password"
ORA-01078: failure in processing system parameters

SOLUTION

  1. Remove the entry in /etc/oratab for this database to be deleted.
  2. Make sure here sourceDB name is actually UNIQUE_DB_NAME, instead of DB_NAME. 
$  dbca  -silent -deleteDatabase -sourceDB TESTDB_UQ sysDBAUserName sys  -sysDBAPassword "sys_password"
Connecting to database
9% complete
14% complete
19% complete
23% complete
28% complete
33% complete
38% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instances and datafiles
66% complete
80% complete
95% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/TESTDB.log" for further details.

How to Create Password File on ASM diskgroup

1) Make sure compatible.asm at least 12.1.

SQL> SELECT NAME,VALUE,GROUP_NUMBER FROM V$ASM_ATTRIBUTE where name like '%compatible%'

NAME                                     VALUE                                                                  GROUP_NUMBER
---------------------------------------- ---------------------------------------------------------------------- ------------
compatible.asm                           19.0.0.0.0                                                                        1
compatible.rdbms                         11.2.0.4                                                                          1
compatible.advm                          19.0.0.0                                                                          1
compatible.asm                           19.0.0.0.0                                                                        2
compatible.rdbms                         11.2.0.4.0                                                                        2
compatible.advm                          19.0.0.0.0                                                                        2

6 rows selected.

2) Create password by using ‘pwcreate’.

ASMCMD> pwcreate --dbuniquename TESTDB '+datac1/TESTDB/password/pwdtestdb'
Enter password: *********
ASMCMD>

3) Verify the password by :

$ crsctl stat res ora.testdb.db -f | grep PWFILE
PWFILE=+DATAC1/TESTDB/PASSWORD/pwdtestdb

For 11.2, there is no support for this feature.

$ crsctl stat res ora.testdb.db -f | grep PWFILE
PWFILE=

Please note:

Create new password file. Need after database and instances are added into CRS by ‘srvctl add database’ and ‘srvctl add instance’. Otherwise the following errors will occur:

OPW-00021: Failed to retrieve DB password file location from the CRS resource
ASMCMD-9454: could not create new password file

ASMCMD> pwcreate –dbuniquename RAC19DBA +DATA Enter password: **

“ORA-28367: wallet does not exist” When Opening TDE Wallet

ORA-28367 error appears when opening the TDE wallet/keystore.

In 11c:

SQL>ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY "software_wallet_password"; 
ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY "software_wallet_password"
*
ERROR at line 1:
ORA-28367: wallet does not exist

in 12c:

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "software_keystore_password";
 ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "software_keystore_password"
*
ERROR at line 1:
ORA-28367: wallet does not exist

CAUSE

1) Please check sqlnet.ora in place.

2) Check the format of “ENCRYPTION_WALLET_LOCATION” in sqlnet.ora right as the following:

ENCRYPTION_WALLET_LOCATION=
    (SOURCE=
      (METHOD=FILE)
      (METHOD_DATA=(DIRECTORY=/var/opt/oracle/dbaas_acfs/TESTDB/tde_wallet)))