KatrinaH wrote:

> I need to set up 2 databases on one host. What is the best way to do
> this?

1) As yourself WHY? (Could this be accomplished by a new schema?)

2) If you still want to proceed ... clarify the version (Oracle8, Oracle8i,
8.1.6 ...) as Oracle-8 is not recognized and might be misinterpreted. And
tell us the operating system

3) Decide whether it makes sense to have a new ORACLE_HOME or use the
existing one. If you want us to answer that - tell us WHY you want a new
database.

4) Optionally do a new install into a new Oracle Home based on 3)

5) Then, probably use dbca or Database Configuration Assistant if that's
available in your environment.

HTH
/Hans