Re: Adding Database or ... Challenge

this is funny

francois bags on you for mentioning the config.ora file and says that you do not have one in UNIX, and then they mention that you have to change this file in step 4 of their instructions.

one more thing, creating a database is not just a matter of changing the oratab file, ORACLE_SID, DBNAME in creation scripts, init.ora, config.ora, tnsnames.ora, listener.ora, and tnsnav.ora?

you need to specify the redo logs, control files, datafiles, etc. this must be done in coordination with the system administrator.

to the person having the problem - post or email your create database script, and i will gladly point out the problem.

Satar Naghshineh wrote:
>
> 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 Thu Oct 09 1997 - 00:00:00 CDT