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 SEPTEMBER 09, 2020

Applies to:

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

Symptoms

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-50858: OCI error: OCI_INVALID_HANDLE
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 "CTXSYS.TEXTINDEXMETHODS", line 366
ORA-06512: at line 6
)for query::declare
 vcnt pls_integer:=0;
 begin
 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;
 end;

 

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.

Changes

 

Cause

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.