Confused when trying to set the parameter '_bug18418984_ges_vbfreelists' (Doc ID 2724570.1)

Last updated on JULY 20, 2024

Applies to:

Goal

- Can see the fix 18418984 after applying the fix for 31904500

[diaeesd3qa:/orahome/app/oracle/product/11.2/dbs]$ opatch lsinv -bugs_fixed |
grep 18418984
18418984   24438247  Tue Sep 26 11:53:10 KST 2017   HIGH LATCH FREE WITH
DISTRIBUTED TXN DESPITE FIX

- But can't set the parameter like below.

--With pfile
ORA-01078: Failures in processing system parameters
LRM-00101: Unknown parameter name '_bug18418984_ges_vbfreelists'

--With spfile
SQL> alter system set "_bug18418984_ges_vbfreelists"=0 ;
alter system set "_bug18418984_ges_vbfreelists"=0
                 *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

SQL> alter system set "_bug18418984_ges_vbfreelists"=0 scope=spfile;
alter system set "_bug18418984_ges_vbfreelists"=0 scope=spfile
                 *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

 Note both 18418984 31904500 are unpublished bugs.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.