| Open more than one Database [message #72781] |
Thu, 16 October 2003 21:15  |
Muhammad Shiraz
Messages: 4
Registered: October 2003
|
Junior Member |
|
|
Dear,
Im using Oracle 8.1.7 databae. And I have created four database on it. I want to know that can i open & close four database at a time. Im using unixware OS.
Thanks
|
|
|
|
| Re: Open more than one Database [message #72786 is a reply to message #72781] |
Fri, 17 October 2003 07:35  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
You mean you have created 4 different database instances on a Single server ? or do you mean you have created 4 tablespaces in a single database ?
You should be able to OPEN and operate the 4 databases at a time, provided you have configured enough shared memory and semaphores in Unix. Configure appropriate init.ora parameters(buffer cache,shared pool,processes etc) and Start the databases one by one(using ORACLE_SID=<SID>; svrmgrl>connect internal; startup) and see what happens. You can decrease the various instance parameters to accomodate all of them at once.
but again it depends on how much memory you have and your requirements etc.
-Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
