Re: First time DB install !Help! -- I'm so new it's sickening

Andrew,

We had several problems with installing Oracle as well. When you create a new database, Oracle usually creates (a.o.) two standard users: SYS and SYSTEM. The accompanying passwords are by default "change_on_install" and "manager" respectively.

Good luck (you'll need it)

Rob van der Spek
Septa IT Consultancy
Teh Netherlands

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:3d4edaac$0$8512$cc9e4d1f_at_news.dial.pipex.com...
> "Andrew Falanga" <ccodewarrior_at_mailandnews.com> wrote in message
> news:3D134163.50508_at_mailandnews.com...
> > Hi,
> >
> > The deal is simple. Aside from the fact that I knew the name,
> > until this week I knew nothing of Oracle. This week, at my bosses
> > behest I installed Oracle for the first time in my life. (My boss by
> > the way, does know quite a bit about Oracle.)
> >
> > I'm installing the 9i release 2 database (I hope I said that right,
> > I know it's 9.2.0 or something like that) on to a Red Hat Linux box.
> > Here's the deal. After reading the installation guide. Well, ok, I
> > didn't exactly read all 252 pages of it, but I read the through the
> > requirements, adjusted my shared memory settings, IP settings and so
> > forth as stated in the manual (and setup the scripts to adjust those
> > settings on bootup), I installed Oracle.
> >
> > The install appears to be fine. However, I'm to a point where I'm
> > installing the Oracle Management Server, and it's asking me for a
> > username/password combination as well as service. I didn't set up
> > (chose to defer until later) the Oracle Net Server. In this senario,
> > the install program says to input service as <host>:<port>:<sid>. I've
> > done this, and that's fine. However, I can't figure out what
> > username/password to use.
> >
> > I tried the oracle user combination, but that didn't work. Said it
> > was invalid. Just prior to getting to this window I had to give
> > passwords to two users called SYS and SYSTEM. I've tried both of them,
> > but it doesn't like them either. When I use the SYSTEM account I get
> > invalid username/password. When I use SYS, it says that SYS should be
> > specified as sysdba or sysoper. I then try sysdba or sysoper to no
> > avail either.
> >
> > Is there a built in account that Oracle is expecting for this
> > purpose? What is it? Does anyone have any ideas? By the way, I've
> > tried to find the answer in the Installation Guide, but haven't found it
> > yet.
> >
> > Thanks for any help,
>
> I think knut has given you the answer you require, which is that you have
to
> create a database user to own the OMS repositories database objects. This
> most certainly can be done by issuing the following when connected to
> sqlplus.
>
> create user <name> identified by <password>
> default tablespace users
> temporary tablespace temp;
>
> grant connect,resource to <name>;
>
> However , at least on windows platforms, there is an assistant that you
can
> run which will create the user and the repository for you. It will require
> connection information (I use the system account) in order to do this. I
> suspect the assistant also runs on linux. You may already be running this.
>
> I would create a tnsnames alias (using the net manager app) for the
database
> and prove that you can connect using sqlplus and the alias first of all.
> then and only then would i run the configuration of the management
server.
>
> as for the users you encountered SYS is the owner of the data dictionary
and
> (effectively) the great god of any oracle database. You should never
connect
> as sys unless absolutely necessary. SYSTEM is the built in account for
> database administration type activities and is ideal for creating other
> accounts etc.
>
> HTH
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
>
>
Received on Tue Aug 13 2002 - 04:01:10 CDT