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