SEO

#1 (**permalink**) 02-24-2008, 08:08 AM

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

#2 (**permalink**) 02-24-2008, 08:09 AM

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

#3 (**permalink**) 02-24-2008, 08:09 AM

I guess I left things a little ambiguous. Here are the details:

1) My goal is to make a carbon copy of my company's current databse setup
on a new host for testing purposes. The current database setup has two
databases on one host - one database holds the 'data'- this database has 5
schemas - and the other is used to keep track of work requests.

2) I using Oracle8i (8.1.7). My OS is Compaq Tru64 UNIX

3) I want to keep the same ORACLE_HOME - this is what was done in the
databases I am making a copy of.

I have already installed Oracle and I set up the 'data' database. After I
had set it up I realized the 'work request' database needed to be on the
same host. I am now unsure how to create the second database on this
host.

#4 (**permalink**) 02-24-2008, 08:09 AM

I guess I left things a little ambiguous. Here are the details:

1) My goal is to make a carbon copy of my company's current databse setup
on a new host for testing purposes. The current database setup has two
databases on one host - one database holds the 'data'- this database has 5
schemas - and the other is used to keep track of work requests.

2) I using Oracle8i (8.1.7). My OS is Compaq Tru64 UNIX

3) I want to keep the same ORACLE_HOME - this is what was done in the
databases I am making a copy of.

I have already installed Oracle and I set up the 'data' database. After I
had set it up I realized the 'work request' database needed to be on the
same host. I am now unsure how to create the second database on this
host.

#5 (**permalink**) 02-24-2008, 08:09 AM

The best way to do is that go ahead and do it.

1 - Check the disk space.

2- have different SIDs for both of them.

3- No problem .. in using them...

4 - You will have one Listener.

Good Luck .

Nisar tareen

"KatrinaH" <kcheathcote@nospam.yahoo.com> wrote in message news:<430b2c05d973eb94debdb1ffa9465318@localhost.t alkaboutdatabases.com>...
> I need to set up 2 databases on one host. What is the best way to do this?

#6 (**permalink**) 02-24-2008, 08:09 AM

On Wed, 13 Oct 2004 14:09:08 -0400, "KatrinaH"
<kcheathcote@nospam.yahoo.com> wrote:

>I guess I left things a little ambiguous. Here are the details:
>
>1) My goal is to make a carbon copy of my company's current databse setup
>on a new host for testing purposes. The current database setup has two
>databases on one host - one database holds the 'data'- this database has 5
>schemas - and the other is used to keep track of work requests.
>
>2) I using Oracle8i (8.1.7). My OS is Compaq Tru64 UNIX
>
>3) I want to keep the same ORACLE_HOME - this is what was done in the
>databases I am making a copy of.
>
>I have already installed Oracle and I set up the 'data' database. After I
>had set it up I realized the 'work request' database needed to be on the
>same host. I am now unsure how to create the second database on this
>host.

You create it just like you did the first one. Hopefully you used an
OFA compliant scheme for naming your directories and files, so that
the files for this new db will be in their own directories. Don't
forget to always set ORACLE_SID for the db you want to work with. And
as Nasir said, you only need one listener.

#7 (**permalink**) 02-24-2008, 08:09 AM

hi,

Depending on your OS : Unix / Windows.

On Windows You will have no choice to install once Oracle and create 2
database.

But on Unix it depends of your need.

Personnaly, I prefer use 2 Oracle user, install twice Oracle, have 2
listeners, ...

Main advantages :
- if you want to upgrade one database (patch, ...) you can only do
it on 1 instance and leave the other instance alive.

But if it is only development instance, I generally don't care.

regs,

Olivier

"KatrinaH" <kcheathcote@nospam.yahoo.com> wrote in message news:<430b2c05d973eb94debdb1ffa9465318@localhost.t alkaboutdatabases.com>...
> I need to set up 2 databases on one host. What is the best way to do this?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

setting up 2 Oracle-8 databases on one host