Re: newbie Oracle 8i install question

From: Frank <fvanbortel_at_netscape.net>
Date: Sun, 13 Apr 2003 13:37:32 +0200
Message-ID: <3E994BFC.9060508_at_netscape.net>


David Eynon wrote:
> I'm installing Oracle 8i Personal Edition. What is the global database?

An unique identifier (globally unique!) you identify your database with.
Assuming you work for verizon, and your (global) domain would be verizon.net, you are installing this oracle on a machine, called PCXP1275 (whatever!). The (globally) unique name of the machine would therefore be PCXP1275.verizon.net.

Now, this is just Personal Oracle, but just imagine you will install PE for more than one PC; you will also install it on PCXP1276, and PCXP1250. The unique machine names are... Get the picture? Take it one step further: you create more than one instance on each machine, identified thru a System Identifier (SID): ORCL1 and ORCL2. The global database names would be:

ORCL1.PCXP1275.verizon.net, ORCL2.PCXP1275.verizon.net,
ORCL1.PCXP1276.verizon.net, ORCL2.PCXP1276.verizon.net,
ORCL1.PCXP1250.verizon.net, ORCL2.PCXP1250.verizon.net.

See - just by name, all instances are unique. It does require a well-thought network implementation, though, to start with.

> Can I just make anything up?

You can. Especially when it is for local use only. But it will default to the above. You can leave it the same as the SID.
> Is it changeable?

 It is.
> What are the implications?

Of what - such a change, or not following the above? Little - if it doesn't work, change again. ;-)
> The installation doesn't go into depth about that... Also, any other
> considerations?
Well, it is probably in the concept manual, of in the network admin manual.

-- 
Regards, Frank van Bortel
Received on Sun Apr 13 2003 - 13:37:32 CEST

Original text of this message