Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie Question: Adding A Database

Re: Newbie Question: Adding A Database

From: the clansman <the_clansman_at_vidioetron.ca>
Date: Tue, 7 Oct 2003 17:47:37 -0400
Message-ID: <lvGgb.48711$ti3.1175456@wagner.videotron.net>


Not very a good hint but it's your opinion. Thanks anyways.

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1065562022.870936_at_yasure...
> the clansman wrote:
>
> >Hi,
> >
> >Using Oracle 8.1.6, how do I add a database? Using the DBA Studio, I
> >selected "Add Database To Tree..." from the menu and I filled in the
> >information
> >
> >Hostname: Localhost (it's on the same box)
> >Port: 1525 (I already have another one on 1521)
> >SID: VINTAGE
> >NET Service Name: VINTAGE
> >
> >My problem is when I try to connect to it. What should I enter as the
> >Username and Password since I never been asked for it? I tried the usual
> >SYSTEM/MANAGER Stuff (which works for my other database) but no success.
Is
> >there's another step to perform prior creating a database?
> >
> >Thanks.
> >
> >
> The first thing you should do is recognize that Oracle is not SQL Server
> (or Sybase or Informix) and that
> you are misusing terminology.
>
> What you think of as a database is a user/schema in Oracle. Go to
> http://tahiti.oracle.com and learn the Oracle
> definitions of the words you are using. Star with these:
>
> database
> instance
> schema
>
> Also recognize that Oracle's architecture is completely different from
> that of all other major commercial RDBMS
> products and you should not be doing anything until you can competently
> explain the concepts behind multiversioning,
> locking, and transaction processing.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Tue Oct 07 2003 - 16:47:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US