My Oracle Support Banner

Error 'DRG-50857: Oracle error in get functional cache size" When Running the DBSetup.bat Utility to Install P6 Database (Doc ID 2189331.1)

Last updated on MARCH 22, 2022

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version and later
Primavera P6 Professional Project Management - Version and later
Information in this document applies to any platform.


When attempting to create an Oracle Schema using the dbsetup.bat (/.sh) Database Setup Wizard, the following error occurs:

ORA-20000: Oracle Text error:
DRG-50857: oracle error in drstldef
DRG-50857: oracle error in get functional cache size
ORA-06550: line 1, column 27:
PLS-00302: component 'GET_FUNCTIONAL_CACHE_SIZE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at line 6
)for query::declare
 vcnt pls_integer:=0;
 select count(1) into vcnt from user_indexes where index_name='DOCVER_DOCDATA_QSI';
 if vcnt=0 then
  execute immediate 'CREATE INDEX DOCVER_DOCDATA_QSI on DOC_VERSION(doc_data)INDEXTYPE IS CTXSYS.CONTEXT parameters(''lexer global_lexer wordlist mywordlist sync (on commit)'')';
 end if;


The issue can be reproduced at will with the following steps:
1. Launch the dbsetup utility.
2. Provide the necessary details as prompted.
3. During the Creating Database Objects process, the reported error occurs and the creation is not completed.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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