Re: Newbie Question - 2nd instance

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sat, 24 Jul 1999 19:07:31 +0200
Message-ID: <932836036.14800.0.pluto.d4ee154e@news.demon.nl>

It would have been helpful if you would have specified your platform. On NT this is an issue of running ORADIM<xx> in GUI mode and create a new instance.
Make sure you have the correct init<sid>.ora before you start to do this. Info on oradim usually is in the getting started manual and/or the NT specific installation manual.
The same roughly applies to Unix port.
Here it should be possible to use orainst. I never did that, I always followed the manual procedure: - editing /etc/oratab (/var/opt/oracle/oratab on Solaris) to add the new instance

- write a create database script
- set ORACLE_SID and ORACLE_HOME by running . oraenv.
- issue

  svrmgrl
  connect internal
  startup nomount
rem say prayers
  @<the create database script>
  spool $HOME/catlog.log
  ?/rdbms/admin/catalog.sql
spool $HOME/catproc.log
?/rdbms/admin/cataproc.sql
?/rdbms/admin/catexp.sql
rem ready
exit

Of course you need to create a second rollback segment in the system tablespace etc, etc.
(and copy and paste the code above)

Hth,

Sybrand Bakker, Oracle DBA

Just Visting <guest_at_example.com> wrote in message news:3799dabc.8702032_at_news...
> I'd like to create a 2nd Oracle instance.
> What procedure(s) do I run to accomplish this?
> I'm willing to RTFM is I knew which FM to read.
> Any hints, pointers or directions would be
> greatly appreciated.
Received on Sat Jul 24 1999 - 12:07:31 CDT