Error:
[oracle@mylinux1 bin]$ ./dbca -silent -deleteDatabase -sourceDB orcl -sysDBAUserName larry -sysDBAPassword larry
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-00845: MEMORY_TARGET not supported on this system
Solution:
1. Logon to the database as sysdba
2. Execute the command.
SQL> show parameter memory_target;
NAME TYPE VALUE
———————————— ———– ——————————
memory_target big integer 3104M
SQL>
3. Issue the command.
SQL> alter system reset memory_target;
System altered.
SQL>
4. Shutdown the database
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
5. Startup the database.
SQL> startup open
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 217157632 bytes
Fixed Size 2211928 bytes
Variable Size 159387560 bytes
Database Buffers 50331648 bytes
Redo Buffers 5226496 bytes
Database mounted.
Database opened.
SQL>
6. Execute command:
SQL> show parameter memory_target
NAME TYPE VALUE
———————————— ———– ——————————
memory_target big integer 0
SQL>
7. re-execute
[oracle@mylinux1 bin]$ ./dbca -silent -deleteDatabase -sourceDB orcl -sysDBAUserName larry -sysDBAPassword larry
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
[oracle@mylinux1 bin]$
This completes resolution of Oracle Error ORA-32004 – ORA-00845.
Larry Catt, OCP
oracle@allcompute.com
www.allcompute.com