3 Replies Latest reply on Jul 8, 2014 5:16 AM by Robert Dołęga

    ORA-12805 during schema installation

      Hi,

       

      The time has come to install BL 8.5. And first problem has been encountered.

      During execution oracle_master.sql which run schema/create_index_for_foreign_key.sql such error occurs

       

      INSTALLING Indexes for Foreign keys

      DECLARE

      *

      ERROR at line 1:

      ORA-20000: Exception Occured during Execution, ErrorMessage :ORA-12805:

      parallel query server died unexpectedly

      ORA-06512: at line 130

       

      And I have no idea how to go through.

       

      My params:

       

      SELECT version FROM V$INSTANCE

      11.2.0.3.0

       

       

      show parameter PROCESSES

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      aq_tm_processes                      integer     1

      db_writer_processes                  integer     8

      gcs_server_processes                 integer     0

      global_txn_processes                 integer     1

      job_queue_processes                  integer     1000

      log_archive_max_processes            integer     4

      processes                            integer     200

       

       

      SELECT value FROM v$parameter WHERE name = 'db_block_size';

      8192