Q
Manage Learn to apply best practices and optimize your operations.

How to start multiple instances in Oracle 10g

I want to know how to start multiple instances in Oracle 10g. I have created two databases using DBCA and I have one database server.

Hi Brian,
I want to know how to start multiple instances in Oracle 10g. I have created two databases using DBCA and I have one database server.
Use the DBCA to create your second database. It will take care of all of the details for you. The only item I would recommend is to store your datafiles in a separate directory from your first database. I typically use the naming convention "/diskvolume/oracle_sid/". This way, I can use the same disk volume for two databases. The DBCA will take care of the rest of the details for you. Another thing to make sure is that you have enough memory on the server for two Oracle instances.

Dig Deeper on Oracle DBA jobs, training and certification

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close