Home » RDBMS Server » Server Administration » Oracle 11g R2 - Support/Approach for Multi-tenancy (Linux)
Oracle 11g R2 - Support/Approach for Multi-tenancy [message #631187] Sat, 10 January 2015 00:42 Go to next message
ninan
Messages: 163
Registered: June 2011
Location: Noida
Senior Member
Hi,

This is question is related to Multi-Tenancy, whether Multi-tenancy is supported by Oracle 11g R2 ?

The Application requirement is to be able to accommodate new Customers in a Muli-tenant approach.

We were planning to have a Single DB with Schemas and inside the Schema the Tables will be replicated for 'N' number of Customers.

I.e, User information of Client A and Client B will be in Tables USER_DATA_A and USER_DATA_B tables respectively,
Similiar for other Data objects.

I think this is the only way to achieve multi-tenancy in Oracle 11g R2 as Multi-tenancy Pluggable databases is introduced from Oracle 12 C only.

Kindly advise if this a good approach as we are limited to Oracle 11g R2. Or suggest any better approach to achieve multi-tenancy in Oracle 11g R2.

Scope is also limited to consider ORACLE RAC as the Oracle Database will be hosted in a Cloud.


Thanks,
Ninan

[Updated on: Sat, 10 January 2015 00:43]

Report message to a moderator

Re: Oracle 11g R2 - Support/Approach for Multi-tenancy [message #631189 is a reply to message #631187] Sat, 10 January 2015 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can use multi-schemas as you said.

Re: Oracle 11g R2 - Support/Approach for Multi-tenancy [message #631192 is a reply to message #631187] Sat, 10 January 2015 02:32 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Or you could create just one set of tables, and use Virtual Private Database to isolate customers' data.
Re: Oracle 11g R2 - Support/Approach for Multi-tenancy [message #631196 is a reply to message #631192] Sat, 10 January 2015 04:03 Go to previous message
ninan
Messages: 163
Registered: June 2011
Location: Noida
Senior Member
Hi,

Thanks for your reply and suggestions.

Thanks
Ninan
Previous Topic: ORA:00600: internal error code, arguments: [kkzuasid]
Next Topic: DB Server Configuration
Goto Forum:
  


Current Time: Fri Mar 29 01:12:52 CDT 2024