CentOS 8
Sponsored Link

Oracle Database 19c : Add Oracle Net Listener
2020/07/15
 
Add Oracle Net Listener that is the network service on Oracle.
[1] Login with the [oracle] user and input a command [netca] like follows.
[oracle@dlp ~]$ netca

[2] Check a box [Listener Configuration] and go next.
[3] Go to next.
[4] Set Listner's name. Set any name you like.
[5] This example goes next with keeping default [TCP].
[6] Set a port. This example goes next with keeping default.
[7] If you'd like to create more Listeners, Answer [Yes]. This example selects [No].
[8] Configuration completed.
[9] After creating Listener, [tnslsnr] listens on the port you configured like follows.
[oracle@dlp ~]$
ss -napt | grep 1521

TIME-WAIT  0       0                 10.0.0.30:59058            10.0.0.30:1521
LISTEN     0       128                       *:1521                     *:*      users:(("tnslsnr",pid=11061,fd=8))
TIME-WAIT  0       0        [::ffff:10.0.0.30]:1521    [::ffff:10.0.0.30]:59058

[oracle@dlp ~]$
tnsping localhost


TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 14-JUL-2020 21:43:19

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
OK (0 msec)
[10] If Firewalld is running, allow listener port.
[root@dlp ~]#
firewall-cmd --add-port=1521/tcp --permanent

success
[root@dlp ~]#
firewall-cmd --reload

success
Matched Content