1)
checked alert log and found
Mon Oct 26
14:33:42 2009
ORA-00130:
invalid listener address
'(ADDRESS=(PROTOCOL=TCP)(HOST=rhel4.localdomain #<--- full="" hostname="" qualified="" span="">)(PORT=1521))'
1)
to change hostname
/etc/sysctl.conf
Commented the kernel.hostname
[oracle@rhel4 log]$ cat /etc/sysctl.conf
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.
# Controls IP packet forwarding
net.ipv4.ip_forward = 0
# Controls source route verification
net.ipv4.conf.default.rp_filter = 1
# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0
# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0
# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1
kernel.shmmax = 2147483648
kernel.shmmni = 100
kernel.shmall = 2097152
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 100 256 100 100
fs.file-max = 327679
#kernel.hostname =
rhel4.localdomain
kernel.domainname = localdomain
#<--- correct="" domain="" name="" o:p="">
1)
Rebooted the o/s after shutting down the instance.
Hostname is there in the following places
a)
/etc/hosts
b) /etc/sysctl.conf
c)
/etc/sysconfig/network
d) $sysctl
kernel.hostname
e) $sysctl
kernel.hostname=