Hi all,
i have import virtual machine to my host server but now i have problem
when i want to start listener on oracle database server..
[oracle@oratest bin]$ ./lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-NOV-2014 09:06:52
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oratest.pera.com)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
next ...
[oracle@oratest bin]$ ./lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-NOV-2014 09:07:39
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /opt/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
in dmesg i have found this ..
[oracle@oratest bin]$ dmesg |tail -10
lo: Disabled Privacy Extensions
ip6_tables: (C) 2000-2006 Netfilter Core Team
nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
SELinux: initialized (dev xenfs, type xenfs), uses genfs_contexts
eth0: no IPv6 routers present
tnslsnr[7699] trap invalid opcode ip:7f600da21c30 sp:7fff9ce7e238 error:0 in ld-2.12.so[7f600da0d000+20000]
ip_tables: (C) 2000-2006 Netfilter Core Team
tnslsnr[7902] trap invalid opcode ip:7f05a34acc30 sp:7fff321e83e8 error:0 in ld-2.12.so[7f05a3498000+20000]
tnslsnr[8242] trap invalid opcode ip:7f67fae58c30 sp:7fff32a204e8 error:0 in ld-2.12.so[7f67fae44000+20000]
tnslsnr[9135] trap invalid opcode ip:7f9b67f61c30 sp:7fff45a4a858 error:0 in ld-2.12.so[7f9b67f4d000+20000]
[oracle@oratest bin]$
my listener.ora looks like this
# listener.ora Network Configuration File: /opt/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /opt/oracle/product/11.2.0/db_1)
(SID_NAME = ECDP1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oratest.pera.com)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /opt/oracle
i have succefully started database with
$> sqlplus '/as sysdba'
$> startup;
and there are oracle services atached to ports
[root@oratest ~]# netstat -plunta
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1104/sshd
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 1180/master
tcp 0 0 172.20.102.161:22 172.20.102.64:39199 ESTABLISHED 7323/sshd
tcp 0 0 172.20.102.161:22 172.20.102.64:39217 ESTABLISHED 7832/sshd
tcp 0 0 :::22 :::* LISTEN 1104/sshd
tcp 0 0 :::28345 :::* LISTEN 7544/ora_d000_ECDP1
tcp 0 0 ::1:25 :::* LISTEN 1180/master
udp 0 0 0.0.0.0:64076 0.0.0.0:* 989/avahi-daemon
udp 0 0 0.0.0.0:5353 0.0.0.0:* 989/avahi-daemon
udp 0 0 ::1:43926 :::* 7512/ora_pmon_ECDP1
udp 0 0 ::1:36163 :::* 7546/ora_s000_ECDP1
udp 0 0 :::12780 :::* 7540/ora_mmon_ECDP1
udp 0 0 ::1:11645 :::* 7544/ora_d000_ECDP1
my /etc/hosts file look like this
[root@oratest ~]# less /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
172.20.102.161 oratest.pera.com oratest pera.com ecdp1 ECDP1
my iptables rules are..
[root@oratest ~]# iptables -L
Chain INPUT (policy ACCEPT)
target prot opt source destination
Chain FORWARD (policy ACCEPT)
target prot opt source destination
Chain OUTPUT (policy ACCEPT)
target prot opt source destination
i am stumped here so if anyone have some idea .. thanks in advance