Ask the Expert

Installing a second database on the same server

We have a production database running. We want to install one more database running on the same server. How can I do this? Please explain in detail the procedure required for this.
The details to do this vary depending on your hardware platform. It is a little different on Unix/Linux and Windows. But to make it easier, just fire up the Database Configuration Assistant (DBCA) that was installed when you installed the Oracle software. On Unix/Linux, this utility is found in $ORACLE_HOME/bin. On Windows, there will be a shortcut somewhere under Start->Programs->Oracle.

    Requires Free Membership to View

Fire up this utility and tell it you want to create a new database. It's that simple! Without this utility, the instructions get more complicated.

This was first published in December 2003

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: