Tuesday, July 26, 2016

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/

No comments:

Post a Comment

Your comment will be visible after approval.