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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
3 comments
452 views