Search code examples
centos6hostnameoracle-xe

CentOS Hostname Change

I'm using CentOS 6.5 where I successfully install Oracle XE. I want to change my Initial Hostname 'NAFD.WS' to something else. Will this affect Oracle Xe installation? If yes, what's the work around aside from reinstalling the Oracle Xe.

Thanks for your time dear SO.

Solution

  • Looks like your question is addressed here: http://minhtech.com/oracle/oracle-11g-xe-hostname-change/

    Basically:

    Edit both the listener.ora and tnsnames.ora files at $ORACLE_HOME/network/admin/listener.ora and $ORACLE_HOME/network/admin/tnsnames.ora. In the files, replace instances of the old hostname with the new hostname. Finally, log into root and force a reload:

    $ su -
$ /etc/init.d/oracle-xe force-reload