Prev: Collection
Next: Sun IDM resources | Multiple Locations
From: The Quiet Center on 24 Jun 2010 11:24
hi, I'm an open source developer who has been cast into the wide wide
world of Oracle. As a former MySQL user mainly (no boos please :),
there is a lot of Oracle terminology that I dont understand.

Specifically:
- instance
- database (it appears that a single host and port can have several
databases)
- sid
- schema (it appears that a single database can have several schemas
and that a schema is a collection of tables, views, triggers, etc)
- user (it appears that a user can have access to various schemas and
various permissions within schemas... contrast with MySQL where there
are only databases)

Beyond definitions for the above, my goal is to ask: how do you
uniquely identify a schema? We are running both 10g and 11g here and
so we cannot truly refer to a schema by the name alone without
qualifying it with the database. But since the word "instance" is
being thrown around here as well, I have to wonder what is meant by
that also.

Thanks,
Terrence
From: The Quiet Center on 24 Jun 2010 11:28
On Jun 24, 11:24 am, The Quiet Center <thequietcen...(a)gmail.com>
wrote:

> there is a lot of Oracle terminology that I dont understand.

> Specifically:
> - instance

Found it - http://www.orafaq.com/wiki/Database_Concepts_and_Architecture
An instance can mount and open one and only one database.


From: rogergorden on 24 Jun 2010 11:41
On Jun 24, 11:24 am, The Quiet Center <thequietcen...(a)gmail.com>
wrote:
> hi, I'm an open source developer who has been cast into the wide wide
> world of Oracle. As a former MySQL user mainly (no boos please :),
> there is a lot of Oracle terminology that I dont understand.
>
> Specifically:
> - instance
> - database (it appears that a single host and port can have several
> databases)
> - sid
> - schema (it appears that a single database can have several schemas
> and that a schema is a collection of tables, views, triggers, etc)
> - user (it appears that a user can have access to various schemas and
> various permissions within schemas... contrast with MySQL where there
> are only databases)
>
> Beyond definitions for the above, my goal is to ask: how do you
> uniquely identify a schema? We are running both 10g and 11g here and
> so we cannot truly refer to a schema by the name alone without
> qualifying it with the database. But since the word "instance" is
> being thrown around here as well, I have to wonder what is meant by
> that also.
>
> Thanks,
> Terrence

A handy conversion chart:

MySQL ORACLE Notes
instance instance/ An oracle database is simply the processes
and memory structures running on the machine, Oracle can have more
database than one database instance running on
the same machine or from the same Oracle home/version. This is also
true for
MySQL as we have both as long as
you're on a different port and socket. I've had 4 different MySQL
instances running
on the same machine.
database schema A collection of related tables/views etc.
sid A unique identifier of an instance/
database on a server DEMO and DEMO10G would be valid names for 2
different
instances. You can emulate this in
MySQL by having aliases that will connect to different MySQL instances
running on
different sockets and ports
user user a user can have access to various
schemas and various permissions within schemas in oracle. In MySQL a
user can
have access to various databases
and various permissions.


I hope that helps.

Roger Gorden


From: joel garry on 24 Jun 2010 11:53
On Jun 24, 8:28 am, The Quiet Center <thequietcen...(a)gmail.com> wrote:
> On Jun 24, 11:24 am, The Quiet Center <thequietcen...(a)gmail.com>
> wrote:
>
> > there is a lot of Oracle terminology that I dont understand.
> > Specifically:
> > - instance
>
> Found it -http://www.orafaq.com/wiki/Database_Concepts_and_Architecture
> An instance can mount and open one and only one database.

The database concepts manual is required reading first. After that,
check out books by Tom Kyte, he is good at relating concepts you
already know to their Oracle equivalents. He also rewrote the
concepts manual for 11g, btw.

Over the years, I've noticed the most important thing for developers
coming from other dbms's is to understand Oracle's locking and
concurrency model.

jg
--
@home.com is bogus.
http://groups.google.com/group/comp.os.linux.development.system/msg/30ff122e2dd33c69?dmode=source
From: rogergorden on 24 Jun 2010 12:07
On Jun 24, 11:53 am, joel garry <joel-ga...(a)home.com> wrote:
> On Jun 24, 8:28 am, The Quiet Center <thequietcen...(a)gmail.com> wrote:
>
> > On Jun 24, 11:24 am, The Quiet Center <thequietcen...(a)gmail.com>
> > wrote:
>
> > > there is a lot of Oracle terminology that I dont understand.
> > > Specifically:
> > > - instance
>
> > Found it -http://www.orafaq.com/wiki/Database_Concepts_and_Architecture
> > An instance can mount and open one and only one database.
>
> The database concepts manual is required reading first.  After that,
> check out books by Tom Kyte, he is good at relating concepts you
> already know to their Oracle equivalents.  He also rewrote the
> concepts manual for 11g, btw.
>
> Over the years, I've noticed the most important thing for developers
> coming from other dbms's is to understand Oracle's locking and
> concurrency model.
>
> jg
> --
> @home.com is bogus.http://groups.google.com/group/comp.os.linux.development.system/msg/3...

I've also seen that developers coming from other rdbms's should
understand is Oracle's Sequence, rather than "MAX(id) + 1" for
inserts.

Roger Gorden
 |  Next  |  Last
Pages: 1 2
Prev: Collection
Next: Sun IDM resources | Multiple Locations