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 OCTOBER 10, 2016

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 dbsetup (.bat or .sh), the following error occurs during script execution:

ERROR
-----------------------
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;


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run dbsetup.bat
2. Complete the wizard with database details
3. During the creating database objects, the error is displayed and the creation is not completed.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot install the P6 database.

Cause

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 hundreds of Community platforms