Re: renaming a database

Well, (if anyone's following along), I went ahead and entered the 'CREATE CONTROLFILE..' command from the produced tracefile manually in svrmgrl (pending figuring out how to have server manager read it from a file), and I got the following error:

ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name DC in file header does not match given name of REGRESS
ORA-01110: data file 1: '/oracle02/oradata/regress/system01.dbf'

DC is the old name of the database and REGRESS is the new name...

So apparently it doesn't like that the information in the datafile doesn't jive with the new name?

can anyone help me out?

thanks in advance,
Lee

On 13 Jun 2000 18:55:59 GMT, Lee <feigenb_at_is01.fas.harvard.edu> wrote:
>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?
>-- To delete a database, does deleting all the relevant datafiles and
> relevant files relating to the instance suffice?
>
>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