I stared my very first instance as well as my database by using the STARTUP command. If I want to start the second instance in the same machine, is it necessary to have a parallel server configured with my database? If so, how do I configure it?
You do not need Oracle Parallel Server to run more than one instance on a machine. OPS is for running multiple instances connected to the same database. You want to run multiple instances connected to their own database. You do not need special software for this.
To create a second instance on your machine, just fire up the Database Configuration Assistant and select the option to create a new database. The wizard will guide you through the process.
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.