Multiple copies of database running...

[mrmac228]

I don't know whether this is valid or not but I want to set up a database server that will serve several independent clients.

That is I will have several identical systems running the same software that need to connect to independent database instances on a general database server.

What I was thinking was that on the db server I'd install the software in /u01 and then for each system that needs to connect I'd have a seperate /host1/u02/oradata..., /host2/u02/oradata structure. Where host1 and host2 are clients that connect to 5 identical/replica databases each.

The reason for this configuration is to allow independent testing of aspects of the software in parallel on each of the client hosts.

I'd then be able to set up separate listeners, each controlling connection to the 5 databases, on different ports.

The questions I have are:

Is this achievable?
What problems might I have (init*.ora files is one that may be a problem)?

Thanks in advance.

I love deadlines. I like the whooshing sound they make as they fly by - Douglas Adams

 

[sem]

Oops, my apologies, the number of instances really doesn't matter.
I don't think you need multiple listeners, because even a single listener may handle multiple Oracle instances. We have an environment, when 1 listener serves different versions of Oracle database.

Regards, Dima

http://seminihin.narod.ru