OraFAQ Forum: Server Administration » Domain change -- easy?

Home » RDBMS Server » Server Administration » Domain change -- easy? (Oracle 11g, Linux 32bit)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Domain change -- easy? [message #504249]

Fri, 22 April 2011 17:31

mlgoins
Messages: 115
Registered: March 2007
Location: Denver, CO

Senior Member

When Oracle was installed, there was an error in the server's domain name (missing a "."). Is there an easy way to fix this domain name in the Oracle installation after the fact? I know about tnsnames.ora, pfile, system parameters, and I'm pretty sure I can do emagent -config. My concern is that the "Installed Products" would not like the fact that the domain name is now "abc.proj.org" when installation was done on "abcproj.org". The /etc/hosts file had "abcproj.org", and we want to fix it to "abc.proj.org".

I'm thinking I need to reinstall Oracle -- is there a better way?

Report message to a moderator

Re: Domain change -- easy? [message #504264 is a reply to message #504249]

Fri, 22 April 2011 19:09

BlackSwan
Messages: 20086
Registered: January 2009

Senior Member

SELECT GLOBAL_NAME FROM GLOBAL_NAME;

Report message to a moderator

Re: Domain change -- easy? [message #504374 is a reply to message #504264]

Sun, 24 April 2011 05:53

mlgoins
Messages: 115
Registered: March 2007
Location: Denver, CO

Senior Member

Is that it? I update GLOBAL_NAME in GLOBAL_NAME and OraInventory, OEM, and everything else in the database is copacetic? Regardless, it's a good search string, thanks!

Report message to a moderator

Re: Domain change -- easy? [message #504377 is a reply to message #504374]

Sun, 24 April 2011 06:04

Michel Cadot
Messages: 54129
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Copacetic! Woo, I learn a new word. Does someone know where does it come from?

Regards
Michel

Report message to a moderator

Previous Topic:	How to reduce size of TEMP01.DBF?
Next Topic:	Database shutdown is required or not

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 00:05:17 CDT 2013

Total time taken to generate the page: 0.10217 seconds