Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Adding Database or ... Challenge

Re: Adding Database or ... Challenge

From: Satar Naghshineh <satarnag_at_worldsite.com>
Date: 1997/10/03
Message-ID: <34358467.6BE7@worldsite.com>#1/1

And you must be speaking out of Ignorance, I am on a Unix Box, and I have a config.ora file. It contains additional information that we decided not to include in the init<sid>.ora file.

flange wrote:
>
> Hi,
> In Unix you don't have the config.ora file.
> It look like you sell yourself as a Master DBA and you have only knowledge
> about Oracle on PC.
>
> Change the folloowing things.
>
> 1)
> /var/otp/oracle/oratab
> 2)
> ORACLE_SID
> 3)
> DBNAME in the creation scripts.
> 4)
> init.ora ( init${ORACLE_SID}_0.ora, init${ORACLE_SID}_1.ora,
> init${ORACLE_SID}.ora, config${ORACLE_SID}.ora )
> 5)
> Use Network Manager to add entry in the following file.
> tnsnames.ora
> listener.ora
> ( tnsnav.ora )
> 6)
> Backup Procedure
> ebu Register
> Self writting script which doesn't take care of the oratab
>
> Regards Francois
>
> David Parry <dparry_at_nu-pharm.com> wrote in article
> <3431295A.50B3_at_nu-pharm.com>...
> > 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 Fri Oct 03 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US