The below issue was faced by my fellow DBA while in checking OPatch version in Grid Home, Interestingly the same OPatch utility works fine in RDBMS Home Issue-OPatch version command failed with below error on GRID_HOME but it was working fine on DB home Error:- opatch version Error occurred during initialization of VM Initial heap […]
Category: ORA-ERRORS
ORA-16179 incremental changes to “log_archive_dest_10” not allowed with SPFILE
You might encounter ORA-16179 error while changing the archive destination. SQL> alter system set log_archive_dest_10=’d:\oracle\arc\dbtest\’; alter system set log_archive_dest_10=’d:\oracle\arc\dbtest\’ * ERROR at line 1: ORA-32017: failure in updating SPFILE ORA-16179: incremental changes to “log_archive_dest_10” not allowed with SPFILE There is syntax error in above command . It should be like log_archive_dest_n [n is a integer […]