OraFAQ Forum: Server Administration » Are separate databases distinct enough for my situation?

Home » RDBMS Server » Server Administration » Are separate databases distinct enough for my situation?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Are separate databases distinct enough for my situation? [message #51359]

Fri, 17 May 2002 07:05

Erica
Messages: 3
Registered: May 2002

Junior Member

I�m very new to Oracle. A little background: we bought a commercial product that required oracle so we bought it (8i), the software vendors installed it for us (on Windows 2k), showed me how to add accounts, and went on their merry way. We are not using that product anymore but since this decision was made recently and we may still need info out of the database for our new solution we don�t want to disturb that one. Now we want to develop a small Oracle database on the same server mostly as a learning experience. We only have an oracle license for this one server. I�m looking for the best way to separate this very risky learning database from the other database. Can I create more than one instance without installing a second copy of oracle into a separate directory or will I be better off to just create a new database in the same instance?

Report message to a moderator

Re: Are separate databases distinct enough for my situation? [message #51360 is a reply to message #51359]

Fri, 17 May 2002 07:29

saleem
Messages: 65
Registered: January 2002

Member

You can create multiple instances on one box.

Once you have installed oracle on a server you do not need to re-install it to create other databases. in fact doing so can cause tremendous complication and headache that you can do without.

there are a # of little things to do before you set up a new datbase (platform, version dependant), but once you take care of that you can set up many databases on the same server. each instance is separate from the other and if one goes down it almost never affects the other.

review the oracle documentation that came with the installation for more info on creating db's for your particular operating system. or use the GUI tools if you have them installed.

Report message to a moderator

Re: Are separate databases distinct enough for my situation? [message #51362 is a reply to message #51359]

Fri, 17 May 2002 09:14

Erica
Messages: 3
Registered: May 2002

Junior Member

Thanks for your help. So when you create the new database you can specify the new instance then? This is the root of my confusion: does each new database get a separate instance by default? Or do you have one instance per installation and all your databases on that machine use the same one?

Report message to a moderator

Re: Are separate databases distinct enough for my situation? [message #51364 is a reply to message #51359]

Fri, 17 May 2002 09:51

Erica
Messages: 3
Registered: May 2002

Junior Member

That was exactly what I needed to know. Thanks again!

Report message to a moderator

Previous Topic:	Re: ORA-17412 "Bigger type length than Maximum"
Next Topic:	Installation problem of form 6 and form6i on windows XP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 06 01:27:32 CDT 2026