Re: Multiple Databases

Angel Leyva wrote:
>
> We purchased an Oracle 7 database which runs on an RS6000. This was
> purchased with a custom application which runs forms on a Mac.
>
> I want to create additional databases, that have nothing to do with
> the current one. Basically, use oracle for other things not related at
> all with the original application.
>
> How can I accomplish this? I have been reading the Oracle
> documentation and it seems as though this can be done, it just isn't
> clear how to do this.
>
> Remember, I don't want to interrupt the current system, nor its table
> spaces, I want to create all from scratch.
>
> Angel Leyva (airborne_at_cybernex.net)
> http://cybernex.net/~airborne

If the new database has nothing to do with the original one, and you want to limit the chance of harming the original, I would run multiple instances on the same hardware. Basically, you would have the original instance (we will call it originst) and the new instance (we will call it newinst.)

Both instances will have an init<sid>.ora parameter file. They will also have their own rollback segments, control files, tablespaces, etc... You will create newinst with the create database command.

When you bring your server up, you will bring up both instances, and their listeners (they will both have their own listeners.)

I hope this helps,

Robert(Bob) Smith Received on Mon Oct 21 1996 - 00:00:00 CEST