CentOS 7
Sponsored Link

Oracle Database 18c : Add Oracle Net Listener
2018/12/05
 
Add Oracle Net Listener that is the network service on Oracle.
[1] Login with the oracle admin user and input a command [netca] like follows.
[oracle@dlp ~]$ netca

[2] Check a box [Listener Configuration] and go next.
[3] Go 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

LISTEN     0      128         :::1521                    :::*                   users:(("tnslsnr",pid=17508,fd=8))
TIME-WAIT  0      0         ::ffff:10.0.0.30:1521                  ::ffff:10.0.0.30:56769

[oracle@dlp ~]$
tnsping localhost


TNS Ping Utility for Linux: Version 18.0.0.0.0 - Production on 05-DEC-2018 15:49:12

Copyright (c) 1997, 2018, 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 (10 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