Re: Newbie: How to create multiple instances on same server

On Solaris 2.6, the "selected" instance is controlled by the environment variable ORACLE_SID. Logged in as the Oracle user, type SET to see the current environmental variable settings. To change the Oracle-specific variables, run . oraenv (include the dot) and it will prompt you for a different ORACLE_SID and ORACLE_HOME (if necessary). You can then control the new SID (instance) and run things like SVRMGRL and so on. Works great! Good Luck

Regards,

Michael VanTyne

D Smith wrote:

> All,
>
> How do I create multiple instances (or is the correct term databases?) on
> the same linux (intel) server? Is the procedure the same for solaris 2.6
> and NT 4?
>
> I already have the default ORCL service running on each box.
>
> Apparently, there is more to it than the create database command. Any
> advice or guidance would be greatly appreciated, as my oracle press dba
> handbook is not very helpful. Thanks in advance.
>
> --David Smith
Received on Tue May 16 2000 - 00:00:00 CDT