Re: Adding Additional Databases

Michael Bierenfeld <michael.bierenfeld_at_ibsgmbh.de> writes:

>David Parry wrote:
 

>> Hello,
>>
>> I need to create 2 additional database on my Oracle server. I
[...]

> In the subdir $ORACLE_HOME/dbs you will find two
>scripts."crdb<ORA_SID>.sql" and "crdb2<ORA_SID>.sql"
>copy those files (Those files were used to create your first instance).

Mmm, to create a second _instance_, copy the init.ora to a new name (initSID.ora, where SID is whatever you want the instance called), edit the appropriate params (db_name, rollback segments, control files, etc.), set your ORACLE_SID env variable, run svrmgr and startup nomount pfile=xxx.

Now, to do the _database_ create you can run the create database command (from crdb.sql scripts, or by hand - whatever), startup open, and run the additional objects scripts (for ts, rbs, redo, etc), eithier through crdb2 or whatever. Don't forget catalog, catproc, catkitchensink, right after open for data dictionary and pl/sql.

It is a good idea to edit oratab, as mentioned below, so that Oracle specific tools that expect it don't break.

>You can use the cr
>Change the string <ORA_SID< to your new instancename. Let them run. This
>will create you a new instance. WATCH OUT!!!!!! DONT DELETE YOUR OLD
>INSTANCE. Double check the new filenames etc. !!!!
 

>To startup the instance locate the file /etc/oratab. and copy the line
>"<ORA_SID>:$ORACLE_HOME:Y to
><NEW_SID>:$ORACLE_HOME:Y. This file is used be the "dbstart" command. It
>will startup two instances then.
Received on Tue Sep 16 1997 - 00:00:00 CDT