Re: renaming a database

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/06/13
Message-ID: <960927868.18131.4.pluto.d4ee154e@news.demon.nl>#1/1

Answers embedded

"Lee" <feigenb_at_is01.fas.harvard.edu> wrote in message
news:slrn8kd0tv.9ts.feigenb_at_is01.fas.harvard.edu...

> Thanks, Sybrand...
>
> That's worked so far, but I still have a couple questions. If the
> answers to these are found in documentation online, please point me to
> it (I realize these are very elementary questions): [I'm running Oracle
> 8.1.6 on Redhat Linux]
>
> -- How do I 'run' the trace file in sever manager?
@<filename> just as in sqlplus

> -- To delete a database, does deleting all the relevant datafiles and
> relevant files relating to the instance suffice?
>

and edit /etc/oratab of course

> Thanks again,
> Lee
>
> On Tue, 13 Jun 2000 19:15:32 +0200, Sybrand Bakker
 <postbus_at_sybrandb.demon.nl> wrote:
> >The proper way to do it is
> >alter database backup controlfile to trace
> >The trace file will be in the directory pointed to by the user_dump_dest
> >parameter.
> >Now edit the file changing the database name
> >and run it using whatever version of server manager is appropiate for
 your
> >otherwise unknown platform.
> >The other command just does what it does: it renames the global name
 which
> >is composed of the db_name, and the db_domain parameter.
> >
> >Hth,
> >
> >Sybrand Bakker, Oracle DBA
> >
> >
> >"Lee" <feigenb_at_is01.fas.harvard.edu> wrote in message
> >news:slrn8kcq1k.jfh.feigenb_at_is01.fas.harvard.edu...
> >> I tried poking around this newsgroup archives and docs to see
> >> how to rename a database...
> >>
> >> I tried doing: alter database <name> rename global_name to <newname>
> >>
> >> which claimed to have succeeded but didn't seem to do anything...
> >>
> >> So I tried manually moving all the files and replacing all occurrences
> >> of <name> with <newname> but now when I startup the database I receive
> >> an ORA-01103 error that the database name doesn't match the database
> >> name in the control files.
> >>
> >> Is there a way to change the database name in the control files at the
> >> point i'm at? Otherwise if I go back and rename everything to the
 original
> >> database name and get that started-up, how do I correctly go about
> >> renaming the database?
> >>
> >> on a (slightly) related note, what's the 'proper' method for deleting a
> >> database and associated instance completely?
> >>
> >> Thanks in advance,
> >> Lee
> >>
> >
> >
Received on Tue Jun 13 2000 - 00:00:00 CDT