CentOS 7
Sponsored Link

Oracle Database 12c Release 2 : Add Net Listener
2015/07/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

State      Recv-Q Send-Q Local Address:Port               Peer Address:Port
LISTEN     0      128          *:111                      *:*
LISTEN     0      128          *:6000                     *:*
LISTEN     0      5      192.168.122.1:53                       *:*
LISTEN     0      128          *:22                       *:*
LISTEN     0      128    127.0.0.1:631                      *:*
LISTEN     0      100    127.0.0.1:25                       *:*
LISTEN     0      128         :::111                     :::*
LISTEN     0      128         :::6000                    :::*
LISTEN     0      128         :::1521                    :::*    users:(("tnslsnr",pid=13444,fd=8))
LISTEN     0      5         ::ffff:127.0.0.1:33622               :::*
LISTEN     0      128         :::22                      :::*
LISTEN     0      128        ::1:631                     :::*
LISTEN     0      100        ::1:25                      :::*
LISTEN     0      5         ::ffff:127.0.0.1:34633                   :::*

[oracle@dlp ~]$
tnsping localhost


TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 13-OCT-2017 11:13:38

Copyright (c) 1997, 2016, 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
 
Tweet