DB version: 18.3
OS : Oracle Linux 7.6
I had successfully installed 18c oracle database software in my test laptop running on Oracle Linux 7.6 .
While trying to create a database using dbca, I am trying to configure a listener. But, I am getting the below error. But, nobody is using port 1521 in this laptop as shown in the netstat output below. In fact , if I use any port, I get the same error.
To fix this:
I tried disabling Wifi network interface
I tried disabling firewall
I tried assigning an IP (10.80.16.238) to this laptop's physical network card using nmtui utility. Physical interface name: p5p1
I tried disabling the WiFi adapter
Still , I keep getting the same error. I re-ran runInstaller with every change mentioned above. Tried removing everything from /tmp directory. I tried rebooting the machine too.
Details below.
---- Firewall is down
[root@depsy237 ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: inactive (dead) since Tue 2019-04-23 18:46:24 +07; 19s ago
Docs: man:firewalld(1)
Process: 4766 ExecStart=/usr/sbin/firewalld --nofork --nopid $FIREWALLD_ARGS (code=exited, status=0/SUCCESS)
Main PID: 4766 (code=exited, status=0/SUCCESS)
Apr 23 16:35:43 depsy237.localdomain systemd[1]: Starting firewalld - dynamic firewall daemon...
Apr 23 16:35:49 depsy237.localdomain systemd[1]: Started firewalld - dynamic firewall daemon.
Apr 23 18:46:23 depsy237.localdomain systemd[1]: Stopping firewalld - dynamic firewall daemon...
Apr 23 18:46:24 depsy237.localdomain systemd[1]: Stopped firewalld - dynamic firewall daemon.
[root@depsy237 ~]#
[root@depsy237 ~]#
[root@depsy237 ~]#
--- Current state of /etc/hosts
--- I tried adding depsy237.localdomain to the 127.0.0.1 line. No luck
[root@depsy237 ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.80.16.238 depsy237.localdomain
[root@depsy237 ~]#
[root@depsy237 ~]#
[root@depsy237 ~]#
[root@depsy237 ~]# hostname
depsy237.localdomain
[root@depsy237 ~]#
--- I can ping depsy237.localdomain
[root@depsy237 ~]# ping depsy237.localdomain
PING depsy237.localdomain (10.80.16.238) 56(84) bytes of data.
64 bytes from depsy237.localdomain (10.80.16.238): icmp_seq=1 ttl=64 time=0.021 ms
64 bytes from depsy237.localdomain (10.80.16.238): icmp_seq=2 ttl=64 time=0.038 ms
64 bytes from depsy237.localdomain (10.80.16.238): icmp_seq=3 ttl=64 time=0.044 ms
64 bytes from depsy237.localdomain (10.80.16.238): icmp_seq=4 ttl=64 time=0.050 ms
^C
--- depsy237.localdomain ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3081ms
rtt min/avg/max/mdev = 0.021/0.038/0.050/0.011 ms
[root@depsy237 ~]#
------- Nobody is using 1521 port
[root@depsy237 ~]# netstat -anp | grep 1521
[root@depsy237 ~]#
--- IP details
[root@depsy237 ~]# ifconfig -a
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10\<host>
loop txqueuelen 1000 (Local Loopback)
RX packets 444 bytes 42192 (41.2 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 444 bytes 42192 (41.2 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
p5p1: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500
inet 10.80.16.238 netmask 255.0.0.0 broadcast 10.255.255.255
ether 84:8f:69:a9:4c:73 txqueuelen 1000 (Ethernet)
RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
virbr0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500
inet 192.168.122.1 netmask 255.255.255.0 broadcast 192.168.122.255
ether 52:54:00:bf:61:1d txqueuelen 1000 (Ethernet)
RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
virbr0-nic: flags=4098<BROADCAST,MULTICAST> mtu 1500
ether 52:54:00:bf:61:1d txqueuelen 1000 (Ethernet)
RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
wlp3s0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.5.3 netmask 255.255.255.0 broadcast 192.168.5.255
inet6 fe80::51ad:8844:8b6c:d5ba prefixlen 64 scopeid 0x20\<link>
ether ac:72:89:81:12:b2 txqueuelen 1000 (Ethernet)
RX packets 35241 bytes 10314217 (9.8 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 8058 bytes 1916322 (1.8 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
[root@depsy237 ~]#
[root@depsy237 ~]# nmcli
wlp3s0: connected to RND_CD
"Intel Centrino 1030"
wifi (iwlwifi), AC:72:89:81:12:B2, hw, mtu 1500
ip4 default
inet4 192.168.5.3/24
route4 0.0.0.0/0
route4 192.168.5.0/24
inet6 fe80::51ad:8844:8b6c:d5ba/64
route6 fe80::/64
route6 ff00::/8
virbr0: connected to virbr0
"virbr0"
bridge, 52:54:00:BF:61:1D, sw, mtu 1500
inet4 192.168.122.1/24
route4 192.168.122.0/24
p5p1: connected to p5p1
"Realtek RTL8111/8168/8411"
ethernet (r8169), 84:8F:69:A9:4C:73, hw, mtu 1500
inet4 10.80.16.238/8
route4 10.0.0.0/8
lo: unmanaged
"lo"
loopback (unknown), 00:00:00:00:00:00, sw, mtu 65536
virbr0-nic: unmanaged
"virbr0-nic"
tun, 52:54:00:BF:61:1D, sw, mtu 1500
DNS configuration:
servers: 8.8.8.8
interface: wlp3s0
Use "nmcli device show" to get complete information about known devices and
"nmcli connection show" to get an overview on active connection profiles.
Consult nmcli(1) and nmcli-examples(5) manual pages for complete usage details.
[root@depsy237 ~]#