Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00922: missing or invalid option when setting "_TRACE_FILES_PUBLIC" parameter value

Eslam_ElbyalyOct 10 2023 — edited Oct 11 2023

Hello all.

I am on Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production.

There's a security requirement to set "_TRACE_FILES_PUBLIC" parameter to false using the following command…

ALTER SYSTEM SET '_TRACE_FILES_PUBLIC' = FALSE SCOPE = spfile;

When I try the above command, I face the following error…

ORA-00922: missing or invalid option

Same error appears when using “TRUE” instead of “FALSE” or when removing “SCOPE = spfile” part.

Running the following query retrieves no rows…

select * from v$parameter where upper(name) like '_TRACE_FILES_PUBLIC';

Comments
Post Details
Added on Oct 10 2023
4 comments
517 views