How to create and access multiple databases in Oracle 11g?

Question

I recently bought Oracle 11g and I wanted all my developers to use it. Obviously, I cannot buy different licenses for each. Can I create one database for each of the developers ?. Logically, I know that this is possible.

However, I could not find how I could do this. I googled. In this particular case, there was no specific guide. Can you point to the correct resource? Or can you list the steps to achieve this? I would be thankful.

-

Sheldon

Answer 1

When you create a user in Oracle, you create a schema. A schema is a collection of tables and related objects (views, functions, stored procedures, etc.) that are specific to this schema. Therefore, each developer can have his own user / scheme and work independently of each other. Access to other users can be granted, and public synonyms can be created to ensure that YOUR_TABLE points to YOUR_TABLE in a particular scheme, without the need to specify this scheme. But it can eat space ...

If there is a common development, it is best to have one scheme so that everyone works on the same copy.

Answer 2

Create one database and give each developer their own scheme (username / password).

Answer 3

As long as all database instances are on the same server, you can build as many as you want without paying more. Performance can be a problem with a large number of instances, depending on how much they are used.

You do not mention your platform.

In the windows, here is how to use the Database Configuration Adapter (DBCA) . I think this is very similar to * nix.

Each created database has a different name. To access them, it’s just a matter of using the tnsnames.ora file with different entries for each instance on the server.

Answer 4

You can buy a personal version of Oracle for each developer and install it on your desktop / laptop. According to shop.oracle.com, it is $ 460 per user. Thus, you can give everyone full access to Oracle and save a lot of trouble. Developers can learn Oracle more quickly and be more productive, and database administrators do not have to worry about server crashes.

Or perhaps you can even use it for free if your program is not already running. Oracle Developer License allows you to:

... use the Programs, subject to the restrictions specified in this Agreement, only for the purpose of developing, testing, prototyping, and demonstrating your application and only until the application has been used for data processing, business, commercial or industrial purposes, and not for any other purpose.