Skip to Content
author's profile photo Former Member
Former Member

Changing Global name

Hi,

I am just curious how the SAP systems gets affected by changing database global name on the fly.

I have just refreshed my Q box in ECC and the global name is showing Prod db name.

Any suggestions?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 07:09 AM

    Have a look on http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/ds_admin001.htm

    With Example it is Explained effect of changing Global Name

    The global database name is set at database creation time and it defaults to

    db_name.db_domain If the db_name or db_domain is modified after database creation, the value for the global database name does not change. This means that the db_domain set in the init.ora file could be different from the db_domain part of the global_name.

    Now it will be a problem in case u have Any DB links or Replicated Env , Otherwise its ok

    Vinod

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Shawn

      We did migrate our system tablespace from dict managed to locally managed with brspace and ran in the problem described in sap note 775029 - ORA-23327 during brspace dbcreate.

      So in some cases a wrong global name can cause problems, i suggest you just add a step to set the global name in your documentation, when you refresh your quality system.

      Regards

      Michael

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 03:19 PM

    Thanks guys.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.