1 Reply Latest reply on Aug 19, 2019 8:29 AM by 1026951

    Define the distribution map of the database fail

    1026951

      Hello guys! Try to study 18.1 scaleout. Have 4 datastore hosts with K=2 and one with management server.

      Making installation according to official doc. On the step https://docs.oracle.com/database/timesten-18.1/TTGRD/managing_database.htm#TTGRD223 Define the distribution map of the database get the error,

      from management host:

      timesten@$ ttGridAdmin dbDistribute database1 -apply     

      Error 99: Error - No JSON created:Error in applying distribution map in the TTGRIDADMIN database

      Failing command stdout: /opt/ttgrid/installation1/instance1/diag/ttGridAdmin.1565875723.out

      Failing command stderr: /opt/ttgrid/installation1/instance1/diag/ttGridAdmin.1565875723.err

       

      more /opt/ttgrid/installation1/instance1/diag/ttGridAdmin.1565875723.out

      {

         "errmsg" : "Error - No JSON created:Error in applying distribution map in the TTGRIDADMIN database",

         "errno" : 99,

         "status" : 99,

         "stderr" : [

            " 8507: [TimesTen][TimesTen 18.1.2.1.4 ODBC Driver][TimesTen]TT8507: ORA-01422: exact fetch returns more than requested number of rows",

            "",

            " 8507: [TimesTen][TimesTen 18.1.2.1.4 ODBC Driver][TimesTen]TT8507: ORA-06512: at line 865 (ttGridAdmin file generatepartitiontable.sql line 233)",

            "",

            " 8507: [TimesTen][TimesTen 18.1.2.1.4 ODBC Driver][TimesTen]TT8507: ORA-06512: at line 1078 (ttGridAdmin file generatepartitiontable.sql line 446)",

            "",

            " 8507: [TimesTen][TimesTen 18.1.2.1.4 ODBC Driver][TimesTen]TT8507: ORA-06512: at line 1249 (ttGridAdmin file main line 8)",

            ""

         ],

         "stdout" : [

            "",

            "Copyright (c) 1996, 2019, Oracle and/or its affiliates. All rights reserved.",

            "Type ? or \"help\" for help, type \"exit\" to quit ttIsql.",

            "",

            "",

            "",

            "connect \"DSN=TTGRIDADMINCS;UID=INSTANCE50;PWD=********\";",

            "Connection successful: DSN=TTGRIDADMINCS;TTC_SERVER=f1vm208;TTC_SERVER_DSN=TTGRIDADMIN;UID=INSTANCE50;DATASTORE=/opt/ttgrid/installation1/instance1//grid/admin/database/ttgridadmi

      n.0;DATABASECHARACTERSET=AL32UTF8;CONNECTIONCHARACTERSET=AL32UTF8;AUTOCREATE=0;DURABLECOMMITS=1;PERMSIZE=200;TEMPSIZE=100;LOCKWAIT=120;CONNECTIONS=356;PLSQL_TIMEOUT=0;DBUUID=D62CEAAB-6D9

      0-475C-A805-51841E4ACA1C;",

       

      timesten@$ ttGridAdmin dbDistribute database1 -list

      Distribution Map version: 0

      RS   Host    Instance  Holds Data Will Hold Data Removed Evicted

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

      NULL f1vm145 instance1          N              Y       N       N

      NULL f1vm283 instance1          N              Y       N       N

      NULL f1vm146 instance1          N              Y       N       N

      NULL f1vm281 instance1          N              Y       N       N

       

      Could not find any information how to fix this. Distrib was the latest available 18.1.2.1.4 - p30068895_1810_Linux-x86-64.zip