NOW it works
Thank you Dara
> -----Original Message-----
> From: Dara Vaughn [SMTP:dara.vaughn_at_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_at_GESTAGE
>
> select * from v$database_at_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_at_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_at_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_at_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_at_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_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Tue Dec 05 2000 - 14:54:12 CST
