Re: instances question

Hi Lawrence,

As one instance monitors one database, you will have to create both instance and database.
Here's how:
copy the init<sid>.ora in $ORACLE_HOME/dbs to init<yournewsid>.ora (in the same dir). Make ABSOLUTELY sure you change the control_files parameter included in this file, or you will OVERWRITE the control files of your current instance.
Now add the sid to /etc/oratab or /var/opt/oracle/oratab (depends on Unix platform, there will be an oratab somewhere) Now write a create database statement in a sql script. The Create database statement is well documented, I will not repeat it here. Don't do it on the fly!!
Now startup svrmgrl
(make sure $ORACLE_SID is your new sid before you start server manager) and issue a connect internal
now spool <some filename>
and run your script
now run $ORACLE_HOME/rdbms/admin/catalog.sql

             $ORACLE_HOME/rdbms/admin/catproc.sql
             $ORACLE_HOME/rdbms/admin/catexp.sql

and you should be up and running

Hth
Sybrand Bakker,
postbus_at_sybrandb.demon.nl
lawrence wrote:

> Hi everyone,
>
> I have installed Oracle Enterprise Server on Sun Solaris .
> I created a database for the only instance that I have asked Oracle
> to create during the installation of the software.
> My questions are:
> 1. how do I create a additional database for the existing instance?
> or what are the procedures to create additional database for an
> existing instance.
> 2.If I have to create a new instance for the new database, then
> how do I do that? Do I have to reinstall Oracle software ,
> specified new dabase file/ disk allocation .. etc.. ???
>
> Thanks in advance,
>
> Lawrence.
Received on Fri Aug 07 1998 - 13:52:23 CDT