Don't use replication, and the procedure was not intended to deal with
it.
-----Original Message-----
From: Sangster Simon
[mailto:oracledba-ezmlmshield-x98836485.[Email address protected]
Sent: Thursday, March 31, 2005 2:28 AM
To: LazyDBA Discussion
Subject: RE: dbname
I think if you use replication and try to change the global name then
replication will fail ....
Si
-----Original Message-----
From: Poole David
[mailto:oracledba-ezmlmshield-x47954100.[Email address protected]
Sent: Wednesday, March 30, 2005 6:55 PM
To: LazyDBA Discussion
Subject: RE: dbname
Thanks for everyones input re changing database names. I for one was one
of
those who for some reason mistakenly believed that it was a bad idea and
difficult to change a database name. I cannot remember where for sure I
picked this belief up but it is one I have held for a few years. I can
only
point this out to have been picked up on a course years ago as I
certainly
wouldn't make something up I didn't know for sure. Can anyone else who
may
have contributed to this thread or not pinpoint when and where they
picked
up there belief that renaming databases was bad. I can swear on it I
heard
it on a course but cannot be sure as it was years ago. :/
-----Original Message-----
From: Patterson Joel
[mailto:oracledba-ezmlmshield-x33340087.[Email address protected]
Sent: 30 March 2005 15:06
To: LazyDBA Discussion
Subject: RE: dbname
Not so hard
This is done lots of times when creating/refreshing the database on a
new
box. Usually the file names now reference different directories also
which
you can also remedy by changing the names in the trace controlfile.
A very brief outline of steps... i.e. doesn't show how to create a trace
controlfile
Take your backup controlfile to trace, edit it.
Change the line that begins:
CREATE CONTROLFILE REUSE DATABASE "OLD" NORESETLOGS ARCHIVELOG
To:
CREATE CONTROLFILE SET DATABASE "NEW" RESETLOGS ARCHIVELOG
Edit init.ora file, change all references from old to new
Connect as sysdba
Startup nomount
Create controlfile... execute the trace you edited... @trace Recover
database using backup controlfile until cancel, or auto. Alter database
open
resetlogs Rename your global name... i.e. select * from global_name;
alter
database rename global_name to "" (syntax could be off) change
tnsnames.ora
-----Original Message-----
From: Kerber Andrew [mailto:oracledba-ezmlmshield-x56337572.[Email
address
protected]
Sent: Wednesday, March 30, 2005 8:22 AM
To: LazyDBA Discussion
Subject: RE: dbname
Generally it is not a good idea to change database names, because it is
very
confusing to other users, and can mess up your software. Also, I
believe
you have to open the database with resetlogs rename it, and will thus
lose
your old backups unless you are on 10g.
-----Original Message-----
From: Michael Porter [mailto:oracledba-ezmlmshield-x40590617.[Email
address
protected]
Sent: Wednesday, March 30, 2005 07:05
To: LazyDBA Discussion
Subject: Re: dbname
Your statement is wrong and confusing people on this list "... you
should
not change the db name after database creation mena say first db name
was
DHW and after creation your changing to some thing like DBDHW then it
wont
work database will not start"...
That is totally false. There is NO reason you cannot change the database
name as much as you want. You need to understand the implications to any
apps or software that might access it but.. Oracle could care less how
often
you rename. I do it nearly daily for test purposes and have done so
since
the beginning of Oracle. Please get your facts straight before making
such
statements.
M
>>> "Rahul " <oracledba-ezmlmshield-x69557142.[Email address protected]
03/29/05 11:19 PM >>>
hi there,
yes!!! you can change the db name in any case after
creating
the database but you should not change the db name after database
creation
mena say first db name was DHW and after creation your changing to some
thing like DBDHW then it wont work database will not start
and if you want to do these thing then you need to create controlfile by
create controlfile command ................
Regards
Rahul Chaudhari
----- Original Message -----
From: "Sajid Iqbal "
<oracledba-ezmlmshield-x33938750.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, March 24, 2005 3:10 PM
Subject: dbname
>
> Are the Instance_name and db_name parameters in the init file
case
> sensitive ?
>
> Can I change them to be lower case ? without it affecting anything ?
>
> Regards
>
> Sa
>
>
************************************************************************
****
****
> This e-mail and any files transmitted with it are confidential and
intended
> soley for the use of the individual to whom it is addressed. Any
views
or
> opinions presented are soley those of the author and do not
necessarily
> represent those of City College Manchester.
>
> If you are not the intended recipient, please be advised that you
have
> received this e-mail in error and that any use, dissemination,
forwarding,
> printing, or copying of this e-mail is stricty prohibited.
>
>
************************************************************************
****
****
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page