Component : Oracle - BW ORACLE

Solution : https://service.sap.com/sap/support/notes/1455168 (SAP Service marketplace login required)

Summary :
SAP Note highlights the importance of correct syntax when configuring the "_FIX_CONTROL" parameter in Oracle databases, as incorrect configurations can lead to database issues, including ORA-940 errors. The note specifies the proper syntax to avoid such errors, detailing how multiple "_FIX REAL-TIME_COMPILE" values should be set collectively or in consecutive lines through `init.ora` or `spfile.ora` files. Furthermore, incorrect syntax inside quotation marks can cause wrong parameter processing, potentially leading to ignored values post database restart, affecting performance without generating explicit error messages.

Key words :
databasesql> show parameter fixname           type, ora            alter system set, sql> alter system set, alter system set, invalid alter command, symptom database problems, consecutive lines            _fix_control = '6660162, set correctly, oracle database, occurred due

Related Notes :

1454675	_FIX_CONTROL parameters are ignored
1431798	Oracle 11.2.0: Database Parameter Settings
1289199	Information about Oracle parameters
1233458	Error during startup: ORA-00940: invalid ALTER command
1114704	ORA-940 after alter system "_FIX_CONTROL"=''