Solution : https://service.sap.com/sap/support/notes/1233458 (SAP Service marketplace login required)
Summary :
When initiating the Oracle database, an ORA-00940 error may appear due to an improperly set _FIX_CONTROL parameter without corresponding installed patches. This parameter toggles fixes within patches and must correlate with your system's patch level. To resolve, verify _FIX_CONTROL settings against installed patches. Modify the parameter in the Pfile after converting from Spfile if needed. Steps include copying the Spfile to a Pfile, editing the Pfile as per guidelines, and then regenerating the Spfile from the Pfile before restarting the database. Reference SAP Note 830576 for parameter details.
Key words :
invalid alter command, relevant parameter note, oracle database, error occurs, terms oracle, patch reason, deactivate fixes, solution check, installed patches, create pfile
Related Notes :
| 1455168 | _FIX_CONTROL syntax |
| 830576 | Parameter recommendations for Oracle 10g |