Re: 10g - Configuration Issues to support multiple apps.

Answers embedded

On Mon, 24 Jan 2005 17:37:03 GMT, "Lee Chalupa via OracleMonster.com" <forum_at_OracleMonster.com> wrote:

>I'm a java developer that is learning to work with oracle 10g.
>
>I've installed 10g and I've read the installation guide and the DBA -two day guide.
>
>I'm trying to setup an instance of Oracle to use to prototype a couple of small applications.
>
>One application/database server will support the database needs of these applications each supporting a small number of users and small volumes.
>
>Each application will eventually have a production database and a test database.
>The applications may or may not share common data with each other.
>
>I'd like to be able to track the tables and other database objects used by each application in case I have to move the applications in the future.
>
>How do I configure oracle to to support these requirements?

Basically, you don't need to configure Oracle to do this.

>
>For example, one instance or more? One database or more?
One instance, and one instance can manage only one database. You don't need multiple databases, and multiple databases would require database links,as they may share data.

Does the use of
>a schema come into play here?
>

Of course!
>I'd like to use EM to administer the configuration but I don't want to mess with
>implementing the grid control.
>
>Any references to further documentation would be helpful as well.
>
>Thanks.
>
>lee

I guess the Oracle Concepts Manual is obligatory read for anyone.

--
Sybrand Bakker, Senior Oracle DBA