Message-Id: <10701.123720@fatcity.com> From: Suneetha Kollipara Date: Tue, 5 Dec 2000 15:54:12 -0500 Subject: RE: dbname change -dblinks (SOLVED) NOW it works Thank you Dara > -----Original Message----- > From: Dara Vaughn [SMTP:dara.vaughn@wcom.com] > Sent: Tuesday, December 05, 2000 2:17 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: dbname change -dblinks > > Suneetha, > > You need to also set the global name of the database. You can see this > name > with the following statement: > > select global_name from global_name; > > Use the following to change it: > > ALTER DATABASE RENAME GLOBAL_NAME TO new_global_name; > > The database link has to be named the same as the global name. > > HTH, > > Dara Vaughn > Oracle DBA > Quality Software Engineering > > -----Original Message----- > Kollipara > Sent: Tuesday, December 05, 2000 12:02 PM > To: Multiple recipients of list ORACLE-L > > > Hi Gurus > > can you make me clear whether oracle is behaving strange or I am missing > some basic concept > > > Here is the strange situation I am facing > > after changing the database name from GEPROD TO GESTAGE (by recreating the > controlfile) > > I created database link GESTAGE > > (init parameter globelnames =true) > > when I am trying use the GESTAGE dblink it gives me error and asks me to > create database link with GEPROD > once I do this It works fine > > > please go through these the steps > > 1.change of database name from GEPROD to GESTAGE (by recreating the > control > file) > > 2.connect to database GEDEV > > GEDEV>create database link GESTAGE > connect to user1 > identified by user1 > using 'GESTAGE' > > ( connect string GESTAGE is in GEDEV sever :tnsnames.ora pointing to > GESTAGE database of server2) > > GEDEV> select * from v$dtabase@GESTAGE > > select * from v$database@gestage > * > ERROR at line 1: > ORA-02085: database link GESTAGE.WORLD connects to GEPROD.WORLD > > Action: Create a database link with the same name as the database to which > it connects > > GEDEV>create database link GEPROD > connect to user1 > identified by user1 > using 'GESTAGE' > > GEDEV>select * from v$dtabase@GEPROD > > DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS > PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE > --------- --------- --------- ----------------- --------- > ----------------------- --------- -------- > ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# > CONTROLFILE_CHANGE# > CONTROLFI OPEN_RESETL VE > --------------- ------- --------- --------------------- > ------------------- > --------- ----------- -- > 4.030E+09 GESTAGE 01-DEC-00 16206138 01-DEC-00 > 1 01-MAR-00 ARCHIVELOG 16208379 > 0 CURRENT 01-DEC-00 104257 > 16208379 > 05-DEC-00 NOT ALLOWED 01-DEC-00 READ WRITE > > > > **now I can't create dblink GEPROD pointing to GEPROD database > > > why is this happening > I have checked all the initGESTAGE parameters (+ v$parameter ) no one has > "GEPROD" value > > the story behind changing the database name is > > GESTAGE is the staging database created using hotbackup of GEPROD > so now we have production GEPROD on server1 > and staging GESTAGE on server 2 > > both the databases > have same DBID 4.030E+09 is this something to do with this problem > > I appreciate your patience in going through this lengthy mail > > In advance I thank you for your help > > Suneetha > > > > > > > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Suneetha Kollipara > INET: SKollipara@ahm-usa.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dara Vaughn > INET: dara.vaughn@wcom.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L