Re: Adding Database or ... Challenge !

From: Lando <MarkL_at_quebim.com>
Date: 1997/09/30
Message-ID: <3431654E.64AA8455@quebim.com>#1/1

1. set up file structure for where you want the db data,redo,control files to reside.
2. create a new initSID.ora for the new database, set DB_NAME to new dbname
3. Create your create database script: For example (I am using test for the db name):

create database test

        controlfile reuse
            MAXLOGFILES 16
            MAXLOGMEMBERS 2
            MAXDATAFILES 128
            MAXINSTANCES 1
            MAXLOGHISTORY 100
        datafile '/u2/app/oradata/test/tbs/system01.dbf' size 400M reuse

        logfile
          group 1 ( '/u2/app/oradata/test/redo/redo01a.dbf',
                        '/u2/app/oradata/test/redo/redo01b.dbf' ) size
2M reuse,
          group 2 ( '/u2/app/oradata/test/redo/redo02a.dbf',
                         '/u2/app/oradata/test/redo/redo02b.dbf' ) size

2M reuse;
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

4) Set oracle sid to you new db, export ORACLE_SID=test 5) log into svrmgrl, connect internal and issue

         startup nomount
pfile=/u2/app/oracle_base/admin/test/pfile/inittest.ora

    (replace the path and initSID name with your path to the new initSID file name).
6) in svrmgl connect as internal and database started but not mounted:

         @creatdb.sql -- this is you create db script 7) alter database open;
8) create temporary tablespace and user tablespaces, rollback segments etc.
9) add a new database entry to oratab (/var/opt/oracle) if you are autostarting.
10) Do all of the other stuff like listener entries, links, tuning, etc.

I have'nt seen it, but I think someone put a web page with all of these steps outlined (hopefully in more detail), do a search in deja vu news or whatever it is called.

David Parry wrote:

> Sorry for being so long and drawn out!
>
> Specs:
> Oracle 7.3.3
> SCO Unix
>
> I have been attempting to add an additional database for about a month
>
> to no avail. I am a new to Oracle and so far having a Hell of a time
> with it. I need help to add another database to my server, a separate
> area to do testing. If a database is not the best way, then I need to
> know how to add another SID or Instance. I don't care as long as it is
>
> isolated from the live database and running on the same server. If
> anyone has the information I am looking for please send it to me, the
> more e-mail the better.
>
> Below is as far as I have gotten:
>
> 1) Tried to create it manually with the Create Database command
> Result: ora-01501
>
> 2) I have edited the 2 files used to create my initial database
> (crdbSID.sql crdb2SID.sql)
> Result: ora-01501 error code.
>
> There must be another *.ora file I need to modify it looks like the
> config.ora file, there is a section in there that states:
>
> DB_NAME DATABASE_NAME(current database)
>
> Can I add another Database name and to the config.ora file to create
> another database? Do I need to create another config.ora file and
> specify it else where?
>
> I don't want to overwrite my current database just add a separate
> database.
>
> Please Help, More Responses The Better.
> Thanks
> dparry_at_nu-pharm.com
Received on Tue Sep 30 1997 - 00:00:00 CDT