• The relationship about DB_NAME, DB_UNIQUE_NAME, SERVICE_NAMES, INSTANCE_NAME, and $ORACLE_SID


    这是Google肥来的博文,需要翻译请留言。。。

    Names Among MAA

    Under Oracle Maximum Availability Architecture (MAA), we might be confused about various kinds of name. Here I try to clarify these names by chart and table.

    DB_NAME (Enterprise-wide Name)

    You must set this parameter for every instance in order to startup the database. If you didn’t assign DB_NAME at installation-time, then DB_NAME = $ORACLE_SID

    DB_UNIQUE_NAME (Site-wide Name)

    If you didn’t assign DB_UNIQUE_NAME in the parameter file at startup-time, then DB_UNIQUE_NAME = DB_NAME

    If you didn’t assign SERVICE_NAMES in the parameter file at startup-time, then SERVICE_NAMES = DB_UNIQUE_NAME

    INSTANCE_NAME (Server-wide Name)

    If you didn’t assign INSTANCE_NAME in the parameter file at startup-time, then INSTANCE_NAME = $ORACLE_SID

    Naming Scope and Default Values

    Parameter NameName ScopeDefault ValueLevel
    DB_NAME Enterprise-wide = $ORACLE_SID
    (Installation-time)
    Database
    DB_UNIQUE_NAME Site-wide = DB_NAME
    (Startup-time)
    Role
    SERVICE_NAMES Site-wide (or Enterprise-wide) = DB_UNIQUE_NAME
    (Startup-time)
    Role (or Database)
    INSTANCE_NAME Server-wide = $ORACLE_SID
    (Startup-time)
    Instance
    $ORACLE_SID Server-wide N/A Instance

    The above featured image illustrates you a hierarchy tree for better understanding on all of these names. For more details, you may check DB_NAME and DB_UNIQUE_NAME in Oracle documentation.

  • 相关阅读:
    深入浅出前端本地储存
    移动端H5开发常用技巧总结
    Web API
    嵌入式软件工程师面试题目整理(二)
    嵌入式软件工程师面试题目整理(一)
    扒一扒ELF文件
    SpringCloud — (1) 服务治理Eureka
    asp.net练习①——Application聊天室
    js数字金额转换为大写金额
    SQL触发器
  • 原文地址:https://www.cnblogs.com/Jace06/p/10649089.html
Copyright © 2020-2023  润新知