Delphix Products

Expand all | Collapse all

Why is there an underscore in the generated DB Unique name and DB Name

Jump to Best Answer
  • 1.  Why is there an underscore in the generated DB Unique name and DB Name

    Posted 10-21-2015 10:46:00 PM
    I'm curious as to why the automatic values generated for a VDB during provisioning have the underscore character in the DB Unique Name and DB Name but not in the SID field. I'm hoping there's a good reason, possibly related to the renaming of VDB process, or RAC, 12c Multitenant or some other configuration we don't use?


  • 2.  RE: Why is there an underscore in the generated DB Unique name and DB Name
    Best Answer

    Posted 10-21-2015 10:49:00 PM
    Hi Thom-

    In Oracle documentation, a database name (dbname) and database unique name (db_unique_name) can have underscore () as one of its characters. But underscore is not a valid character in SID (the one that registers with listeners) before Oracle 12c. The main reason we use _ is to distinguish Delphix generated db names from customer's own databases, because _ is not widely used by Oracle customers. There is no requirement that we have to use _. It is just a convention. We don't regard making db names and SID the same as a high priority: first, the maximum number of characters are different; Second, in RAC databases, each instance has different SID anyway.

    Typically we don't see customers using the default random VDB names anyway, so this doesn't end up being a concern in normal operations.

    Does this answer your question?


  • 3.  RE: Why is there an underscore in the generated DB Unique name and DB Name

    Posted 10-21-2015 10:55:00 PM
    Yes, thanks!