Skip to Main Content

Database Software

Define the distribution map of the database fail

User_L2G4QAug 15 2019 — edited Aug 19 2019

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

Comments
Post Details
Added on Aug 15 2019
1 comment
292 views