Results 1 to 5 of 5

Thread: Database domain

  1. #1
    Join Date
    Oct 2004
    Posts
    268

    Unanswered: Database domain

    Hi.

    I am an SQL Server and DB2 DBA and have no clue about Oracle. I have a dumb question that I couln'd find an answer yet. I have been reading the Oracle 11G document (2 Day DBA - Not finished) and it is refered that the database global name would be in the form of database_name.database_domain. I understand the database_name piece but the database_domain. Does the database_domain supposed to be the same as the server domain like myserver.mydomain.com or the domain is also a given name and has nothing to do with server/network domain ?

    If it is the domain that the server is in, then you can create only one database with the same database name ?. Is this a true statement ?

    Thanks for any info and again sorry for the dumb question.

    Mike.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    GLOBAL_NAME is optional & frequently not used.

    On any/every DB Server system the database name (SID) must be unique.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2004
    Posts
    268
    Thank you for your reply. I don't even have the software installed so that I can test. We are just purchasing the license and getting the software. I am trying to be prepeared. So, I can only enter the database name and it would allow me to create the database without the domain name ?

    Thanks.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I can only enter the database name and it would allow me to create the database without the domain name ?
    The short answer is YES.

    the DBCA (Data Base Creation Assistant) is a GUI that creates a database.
    One of the things you need to enter is the "SID" (database name).
    Typically it is a 3 - 8 character string & can contain numbers

    visit Search and Download Oracle Database, Application Server, and Collaboration Suite Documentation which contains the Documentation set.
    Concept Manual should be 1st read.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Oct 2004
    Posts
    268
    Got it..............Thanks.................

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •