change global_name on 9i

From: Michael Barger <mrbargerusa_at_yahoo.com>
Date: Thu, 14 Nov 2002 11:48:41 -0800
Message-ID: <F001.00503A74.20021114114841@fatcity.com>

Oracle 9.2.0 on Solaris 2.8 - I've got global_name = FALSE and db_domain = "" - however I mistakenly issued the command alter database rename global_name to instance.world, and now I cannot get rid of it.

I've found the following on Metastink, but am wondering if there is any other method of getting the global_name back to instancename (without the .world)

This problem doesn't happen in 9i because a value NULL for db_domain is allowed, therefore if you set in 9i db_domain="", then you have a GLOBAL_NAME with only db_name and you can rename global_name to include domain and after rename it back without including domain.

Updating props$ manually is not a supported workaround.

Any help would be appreciated.

TIA,
mb

---

Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Michael Barger
  INET: mrbargerusa_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Thu Nov 14 2002 - 13:48:41 CST