Re: Housing 2 Oracle DBs on 1 server

Basic steps, not using orainst (and personally I have always done it manually)
setup init<sid>.ora and config<sid>.ora, making sure they end up in $ORACLE_HOME/dbs
make sure the db_name parameter is correct! edit /etc/oratab, or /var/opt/oracle/oratab (solaris) to add the new sid, it's oracle_home and a switch for autostart run . oraenv, specifying the correct sid svrmgrl
connect internal
startup nomount
create database
datafile etc.
After sucessful completion the database is mounted and open run $ORACLE_HOME/rdbms/admin/catalog.sql catproc.sql from same directory
catexp.sql from same directory
create a second rollback segment in the system tablespace Now you should be able to import an old database or start working

Hth,
Sybrand Bakker, Oracle DBA

Tony Smolar wrote in message ...
>On Thu, 17 Jun 1999 19:31:40 +0200, ManniP_at_Hotmail.com wrote:
>>Yes, but with two different Oracle S.I.D.
>>
>
>Can someone briefly run through the steps on setting up a second SID?
>
>This is what I tried:
> Copied the init*.ora and config*.ora files, and edited them to have
unique
>SID information and file paths.
> Started the SID with svrmgrl
> Ran a CREATE DATABASE command (taking mostly defaults)
>
>It didn't create any Rollback segments, I had to do them by hand. It also
>didn't seem to create the system tablespace, which my Oracle Documentation
>said that it would do.
>
>Also I created a User in the database successfully, but when I tried to
drop
>the user, I got a weird error about some recursive problem.
>
>Where might I have gone wrong?
>
>>Just4SC wrote:
>>
>>> Hi! This might be a stupid question but I was wondering if it is
possible
>>> to have two databases running simultaneously on one Oracle 8.05 server?
>>>
>>> Thanks!
>>
>
>
>--
>
>Tony Smolar
>
>---------------------------------------------------------------------------
---
>asmolar_at_ma.ultranet.com home email
>http://www.ultranet.com/~asmolar homepage
Received on Sat Jun 19 1999 - 14:01:15 CDT