Answer:

   I can't answer all your questions because Oracle takes several
installation manuals to do so.  Install 8i first.  As part of the
install you can chose to accept the creation of a small sample
databse.  If you say yes you will be prompted by the installer
for details on 5 tablespaces - System, Rollback, Users, Temp and
Indexes I think.  Without prompting Oracle will also create a
separate tablespace for use by OEM if you install that at some
future date.
   There is much to be done in the way of post-installation tasks
and some the most important are included in your initSID.ora
file.  There, for example, you can uncomment the line for
rollback segements.
   You can install OEM next.  It will not do everything for you,
although it will help with routine tasks.  You will still need to
understand what you are doing and why it should be done.  OEM is
useful in that it always has the correct syntax for an action
which saves you having to look it up.
   WebDB and the Application Server are separate products.  You
can think of the Application Server as more complete and "heavy
duty".  The current version is 4.0.8.1 so install that if you are
going to use OAS.  If you go with WebDB install the current
version of that.
   Email me at [email protected] if you wish and I will send
you five or six pages of installation instructions.  However,
they are specific to my setup and your setup will not be
identical - just similar.

Van

Question:

Hi,

After all the problems and seeing that I did some things wrong (or
just not totally right), I'm going to reinstall everything.
Hopefully this will resolve all (or most) of my problems.

But one of my major problems is (besides absolutely not knowing
what I'm doing) that all the documents are filled with statements
about what one should do to get it all installed, but the `how to
do it' parts are very absent. And even a simple question like
the order in which to install it all doesn't get answered in
the docs.

I can't answer questions like `what are you going to use all this
for anyway', because I don't know. I'm supposed to get the full
package working, after which people can go play with it all.
Ofcourse I want OEM for myself ...

Does anyone know a good install guide for this? Somewhere on
the web? Or can anyone answer the questions below?

I have a full package, all for Solaris 2.6 (says so on the CD-covers).

I have both Oracle8i (8.1.5) and Oracle8i Enterprise Edition (8.1.5).
I take it I only need the Enterprise Edition?
There are a lot of subparts you can select when creating a
database. What do I need of these (in relation to the packages I
want to install)?

I have WebDB (2.1), Enterprise Manager (2.0.4) and Web Application
Server (both 3.0.2.0.0 and 4.0.5.3). Are WebDB and Application
Server two different things? And in which order should I install
this all?

When you install the Enterprise Manager, you need a database (WebDB
says something similar in the docs). But when you give it a database,
it complains about not having non-system tablespaces and rollback
segments. I find it strange that it isn't capable of making those
in the installation process and I can't find how to create those
up front (I want the OEM because I don't know how to do things in
Oracle, as far as I understand OEM it looks like it will do all the
work and you just have to know *what* has to be done, not *how* to
do it).
Can anyone give me a recipe for creating non-system rollback segments
and tablespaces?

It was a lot of work to find out that for 8.1.* databases you don't
need listener.ora entries because they will administer themselves
with the listener (netasst finally gave some clues) and that you
have to start the listener *before* the databases to get this
working. But in the end I still had problems with getting dbsnmp
to work (dbsnmp_start command of lsnrctl). In the OEM help it says
something about tnsnames, but I could find nothing about how to
create everything for this in relation to my databases.
So the questions here are:
What files do I need for 8.1.5 to get the tnsnames part working?
Does anyone have a /etc/init.d/<oracle-startup-file> with the
proper order of starting things?

Thanks for all the help sofar and hopefully in the near future,

Ronald.

--
// Ronald Hello  ([email protected])
// University of Twente
// Department of Computer Science
// The Netherlands