OAKCLI Delete Database Failing with "ORA-01078: failure in processing system parameters "
(Doc ID 2675272.1)
Last updated on JANUARY 15, 2023
Applies to:
Oracle Database Appliance Software - Version 18.8.0.0.0 ODAVP and laterInformation in this document applies to any platform.
Only apply to VM.
Symptoms
oakcli delete database -db fails with below errors and messages.
root@ODA1 ~]# oakcli delete database -db MYDB123
INFO: 2020-05.... Look at the log file '/opt/oracle/oak/log/srv-odb01/tools/18.7.0.0.0/deletedatabase_MYDB123_44190.log' for more details
Please enter the 'root' password :
Please re-enter the 'root' password:
Please enter the 'SYS' password :
Please re-enter the 'SYS' password:
INFO: 2020-05... Setting up SSH
............Completed
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.##.##.##:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm and it returned: RC=0
............Completed
......SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive.
INFO: 2020-05...-28 11:31:36: SSH has been successfully established
ERROR : Ran '/bin/su oracle -c "/u01/app/oracle/product/11.2.0.4/dbhome_1/bin/dbca -silent -deleteDatabase -sourceDB MYDB123"' and it returned code(1) and output is:
ORA-01078: failure in processing system parameters
INFO: 2020-05.... Look at the log file '/opt/oracle/oak/log/srv-odb01/tools/18.7.0.0.0/deletedatabase_MYDB123_44190.log' for more details
Please enter the 'root' password :
Please re-enter the 'root' password:
Please enter the 'SYS' password :
Please re-enter the 'SYS' password:
INFO: 2020-05... Setting up SSH
............Completed
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.##.##.##:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm and it returned: RC=0
............Completed
......SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive.
INFO: 2020-05...-28 11:31:36: SSH has been successfully established
ERROR : Ran '/bin/su oracle -c "/u01/app/oracle/product/11.2.0.4/dbhome_1/bin/dbca -silent -deleteDatabase -sourceDB MYDB123"' and it returned code(1) and output is:
ORA-01078: failure in processing system parameters
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |