Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
475 views