CentOS 7
Sponsored Link

Oracle Database 12c : Add Oracle Net Listener
2015/07/05
 
Create 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. Input any one 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                         *:22                    *:*
LISTEN     0      128                 127.0.0.1:631                   *:*
LISTEN     0      100                 127.0.0.1:25                    *:*
ESTAB      0      52                  10.0.0.30:22             10.0.0.5:50113
LISTEN     0      128                        :::1521                 :::*      users:(("tnslsnr",3988,9))
LISTEN     0      128                        :::22                   :::*
LISTEN     0      128                       ::1:631                  :::*
LISTEN     0      100                       ::1:25                   :::*

[oracle@dlp ~]$
tnsping localhost

TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 04-JUL-2015 01:03:07

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