Change Domain Name Oracle Database. Follow below steps for changing the oracle database name using nid utility. SQL alter system set db_nameprod123 scopespfile.
SQL ALTER DATABASE RENAME GLOBAL_NAME TO SIDDOMAINCOM. SHUTDOWN IMMEDIATE STARTUP MOUNT. The following example changes the database name to sales in the domain us.
A global database name consists of the database name and database domain.
Change the hostname in etcsysconfignetwork file. Prior to this utility the alteration of the internal DBID of a database was impossible and alteration of the database name required the recreation of controlfils. Open the file networkadmintnsnamesora in a text editor. This documentation shows how to change the network domain name of the server that houses an Oracle Applications 11i instance ebusiness.