Re: How to create new instance ?

From: oracle <oracle_at_nightmare.com>
Date: 1997/03/06
Message-ID: <331F7226.7C74@nightmare.com>#1/1

------------76635C7D2FFA22
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii

Tom Helmer Jensen wrote:

>
> Hi there
>
> I'm new to the more advanced Oracle setups.
>
> We are running Oracle 7.3.2 on a Solaris 2.5.1/Ultra 2, but are in

need

> of a second instance of our db for development purposes.
>
> I've tried to use the script's shipped with Oracle:
>
> /opt/app/oracle/admin/<sid>/create/crdb<sid>.sql
> /opt/app/oracle/admin/<sid>/create/crdb2<sid>.sql
> /opt/app/oracle/admin/<sid>/pfile/init<sid>.ora
> /opt/app/oracle/admin/<sid>/pfile/config<sid>.ora
>
> (of course I had to create a new set of files and modify them)
>
> ..it seems to work, the instance can be started, but it's not created
> properly.
> Eg. all the packages and other system tables are missing.
>
> What do i need to do ??
>
> Regards, Tom

Do the following:

cd $ORACLE_HOME/rdbms/admin
svrmgrl connect internal
If the database is started shut it down and do a "startup restrict"
Within svrmgrl run the following scripts: catalog.sql catproc.sql catexp.sql

This should do it. If you are using replication you will also need to run
"catrep.sql" and "catrepad.sql".

------------76635C7D2FFA22
Content-Transfer-Encoding: 7bit
Content-Type: text/html; charset=us-ascii

<HTML><BODY>

<DT>Tom Helmer Jensen wrote:<BR>

&gt;&nbsp;<BR>
&gt; Hi there<BR>
&gt;&nbsp;<BR>
&gt; I'm new to the more advanced Oracle setups.<BR>
&gt;&nbsp;<BR>
&gt; We are running Oracle 7.3.2 on a Solaris 2.5.1/Ultra 2, but are in

need<BR>

&gt; of a second instance of our db for development purposes.<BR>
&gt;&nbsp;<BR>
&gt; I've tried to use the script's shipped with Oracle:<BR>
&gt;&nbsp;<BR>
&gt; /opt/app/oracle/admin/&lt;sid&gt;/create/crdb&lt;sid&gt;.sql<BR>
&gt; /opt/app/oracle/admin/&lt;sid&gt;/create/crdb2&lt;sid&gt;.sql<BR>
&gt; /opt/app/oracle/admin/&lt;sid&gt;/pfile/init&lt;sid&gt;.ora<BR>
&gt; /opt/app/oracle/admin/&lt;sid&gt;/pfile/config&lt;sid&gt;.ora<BR>
&gt;&nbsp;<BR>
&gt; (of course I had to create a new set of files and modify them)<BR>
&gt;&nbsp;<BR>
&gt; ..it seems to work, the instance can be started, but it's not created<BR>
&gt; properly.<BR>
&gt; Eg. all the packages and other system tables are missing.<BR>
&gt;&nbsp;<BR>
&gt; What do i need to do ??<BR>
&gt;&nbsp;<BR>
&gt; Regards, Tom<BR>

<BR></DT>

<DT>Do the following:</DT>

<DT> </DT>

<DT>1)  cd $ORACLE_HOME/rdbms/admin</DT>

<DT>2)  svrmgrl</DT>

<DT>     connect internal</DT>

<DT>3)  If the database is started shut it down and do a "startup
restrict"</DT>

<DT>4)  Within svrmgrl run the following scripts:</DT>

<DT>         catalog.sql</DT>

<DT>         catproc.sql</DT>

<DT>         catexp.sql</DT>

<DT> </DT>

<DT>This should do it.  If you are using replication you will also
need to run</DT>

<DT>"catrep.sql" and "catrepad.sql".</DT>

<DT> </DT>

<DT>  </DT>

</BODY>
</HTML>

------------76635C7D2FFA22-- Received on Thu Mar 06 1997 - 00:00:00 CST