启动Oracle Spatial Studio时无法初始化存储库

mbskvtky  于 2023-06-05  发布在  Oracle
关注(0)|答案(1)|浏览(525)

在我大约一个月没有使用它之后,我想在我的本地计算机(localhost)上启动我的Oracle Spatial Studio。连接正常,我收到通知:
找到Spatial Studio资料档案库。正在初始化元数据...
看起来初始化不起作用,应用程序中的通知:
无法初始化存储库。请验证信息并重试。
控制台错误:

SEVERE: Unable to initialize metadata schema !
Jun 01, 2023 4:26:36 PM oracle.sgtech.jee.Bootstrap createGlobalMetadataSchema
SEVERE: ******* Default metadata schema could not be loaded; status is INVALID . Check previous log entries for more information *******

sgtech_config.json(文件夹:.sgtech)看起来是这样的:

{
  "version" : "22.1.0",
  "_comments" : [
    "Product Configuration for Oracle Spatial Studio",
    "Top level properties are:",
    " - work_dir: the runtime working folder of the Studio app; empty to use same folder as this configuration file.",
    " - https_only:  if set to 'true', then Studio will only allow HTTPS access",
    " - master_seed: the randomly generated seed used by Studio for security purposes",
    " - metadata_schema: defines details of the Studio's own metadata schema in a 12.2+ Oracle database instance.",
    " - upload: defines settings related to dataset uploads",
    " - logging: application-wide logging settings",
    " - jobs: application-wide settings related to internal job queuing"
  ],
  "work_dir" : "",
  "https_only" : true,
  "master_seed" : "aZmwLaRTS6wLDG9LN7V43fqlykONdBhW",
  "metadata_schema" : {
    "_comments" : [
      "This section provides connection details to the Studio's own metadata schema.",
      "Note that the property 'connection_manager' tells Studio who manages the schema connections.",
      "Value for 'connection_manager' must be 'CONTAINER' or 'SPATIAL_STUDIO'."
    ],
    "connection_manager" : "SPATIAL_STUDIO",
    "studio_managed" : {
      "_comments" : [
        "To be used when 'connection_manager' is SPATIAL_STUDIO.",
        "Either 'database_url' or 'database_wallet' have to be specified, but not both.",
        "The 'database_url' property should look like 'jdbc:oracle:thin:@//localhost:1521/orcl'."
      ],
      "database_url" : "[URL TO DATABASE]",
      "database_user" : "user",
      "database_password" : "psw",
      "max_connections" : 64,
      "init_connections" : 30
    },
    "cache" : {
      "_comments" : [
        "Configures the in-memory cache of metadata objects.",
        "'enabled' specifies whether the cache is enabled or not.",
        "'max_size' specifies the maximum number of entries to be cached.",
        "'max_age_seconds' specifies how many seconds after the last write or update will ",
        "an entry be evicted. If value is <=0 then age-based eviction is disabled."
      ],
      "enabled" : true,
      "max_size" : 1500,
      "max_age_seconds" : 900
    }
  },
  "upload" : {
    "_comments" : [
      "Maximum combined size of dataset files allowed in an upload request.",
      "Default is 50 MB."
    ],
    "dataset_max_size" : 50
  },
  "logging" : {
    "_comments" : [
      "Configures the logging level for server loggers.",
      "Supported logging levels are: OFF SEVERE WARNING INFO CONFIG FINE FINER FINEST ALL",
      "'level' specifies the default logging level.",
      "Optional. The 'custom' key/value map overrides the default logging level on specific ",
      "          loggers; each key must be a valid logger name and its value must be the ",
      "          override logging level."
    ],
    "level" : "INFO"
  },
  "jobs" : {
    "_comments" : [
      "Configures jobs settings",
      "'init_threads_count' specifies the initial amount of threads available for the jobs to run."
    ],
    "init_threads_count" : 15
  }
}

有人能帮忙吗?谢谢

72qzrwbm

72qzrwbm1#

尝试在控制台上向上滚动以查找更清晰的异常。由于这曾经有效,而您有一段时间没有使用它,可能是数据库帐户的密码已过期。或者可能是由于连接失败次数太多而导致帐户被锁定。或者甚至你的数据库没有启动和运行。
尝试使用sqlplus或sqlcl或sql developer连接到该帐户。

相关问题