Re: Where does dbca get its info

Dave wrote:
> "Ujang M Zainudin" <Ujang_mz_at_yahoo.com> wrote in message
> news:21fa36fa.0503191836.58a7318_at_posting.google.com...
> > Dear all,
> >
> > I am writing a unix script to do a cold backup (and restore) of
oracle
> > instances. The backup script is supposed to be able to shutdown the
> > instance and copy all related files to a tape.
> >
> > At this point, the backup script is doing what it is supposed to do
> > and i am happy with that. The next step is to delete the database
> > using DBCA and try to restore them again from the tape. So I wrote
a
> > restore script. I just copy back whatever files in the tape to
their
> > original locations. The script is smart enough to reenter the
> > listener.ora and tnsnames.ora entries. And when I did the restore,
> > the instance is up and running. It seems fine to me.
> >
> > However, when I tried to delete the instance again for another
round
> > of testing, the instance name somehow is not registered in DBCA. So
> > now I cannot delete it using that tool. Of course, I could remove
all
> > the files manually to clean it up. But my question is, where does
the
> > DBCA tools get its info. Which files is it reading that I did not
> > update in my restore script?
> >
> > I have used 'grep' to search the common oracle and database
> > directories for any hint of where the dbca keep its things but so
far
> > I could not find it. Please help.
> >
> > Regards
> > Ujang
>
> the oratab

No, it resides here:

$ORACLE_HOME/inventory/Components21/oracle.assistants.dbca/9.2.0.1.0/context.xml

The dbstart and dbshut scripts obtain information from the oratab file.

David Fitzjarrell Received on Sun Mar 20 2005 - 07:40:48 CST