Oracle-XE Configuration failes.

I installed today Oracle XE on SUSE 11 and I got this error during configuration:


Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details

In the files in /u01/app/oracle/product/11.2.0/xe/config/log

there were these errors:

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=linux-jbzk.site)(PORT=1521))'


The problem was on my machine the hostname was not pingeable.

Solution:

Add your current hostname (output of echo $HOSTNAME) to your /etc/hosts file

For example if your hostname is linuxbox :


127.0.0.1    linuxbox


Then you can re-run the oracle configuration:

/etc/init.d/oracle-xe configure


Source
https://community.oracle.com/

Restart ORACLE without using sqlplus

In Linux (as root):


To obtain help on the command:

/etc/init.d/oracle-xe help


Usage: ./oracle-xe {start|stop|restart|force-reload|configure|status|enable|disable}

To restart:

/etc/init.d/oracle-xe restart