Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help! Multiple Instances on one Host
All you really need to do is to change the value of ORACLE_SID at the OS level (i.e., environment variable for Unix, logical name for VMS), and create an administrative directory structure for the second instance. Then perform your CREATE DATABASE, etc., either via the Oracle installer or using svrmgrl. If you created your first database via the installer, you can copy the generated scripts that created the DB, and edit them as needed to create the second DB.
-- Paul Baumgartel, Principal Consultant paul.baumgartel_at_worldnet.att.net Adept Computer Associates, Inc. (203) 735-3524Received on Thu Sep 25 1997 - 00:00:00 CDT
![]() |
![]() |