Modifying the Oracle Database listening port number

The Oracle default port number is 1521. It's easy for hackers to scan and remember your database every day.

So it's necessary to modify the default port number.

1. Check the listening status first

Lsnrctl status

2. Turn off monitoring

Lsnrctl stop

3. Modify the Listening file 1521====>10001

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Oracle_home =/u01/11g)
(Sid_name = PU)
)
)


LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = target) (PORT = 10001))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
)


Adr_base_listener =/u01/oracle

4, Login Database modification Local_listenner

Sql> Show Parameter Local_listener


NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
Local_listener string

Values value is empty

Modifying the Local_listener parameter

Sql> Show Parameter Local_liste


NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
Local_listener string


Sql> alter system set local_listener= "(address = (protocol = TCP) (host = target)
2 (port = 10001)) ";


System altered.


Sql> Show Parameter Local_lis


NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
Local_listener string
(address = (protocol = tcp) (ho
St = target)
(port = 10001))

5. Start monitoring

[[email protected] ~]$ lsnrctl start


Lsnrctl for linux:version 11.2.0.3.0-production on 10-may-2016 16:48:35


Copyright (c) 1991, Oracle. All rights reserved.


Starting/u01/11g/bin/tnslsnr:please wait ...


Tnslsnr for Linux:version 11.2.0.3.0-production
System parameter File Is/u01/11g/network/admin/listener.ora
Log messages Written To/u01/oracle/diag/tnslsnr/target/listener/alert/log.xml
Listening on: (Description= (Address= (protocol=tcp) (Host=target) (port=10001)))
Listening on: (Description= (Address= (PROTOCOL=IPC) (key=extproc1521)))


Connecting to (Description= (address= (protocol=tcp) (Host=target) (port=10001)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for Linux:version 11.2.0.3.0-production
Start Date 10-may-2016 16:48:36
Uptime 0 days 0 hr. 0 min. 0 sec
Trace level off
Security on:local OS Authentication
SNMP OFF
Listener Parameter File/u01/11g/network/admin/listener.ora
Listener Log File/u01/oracle/diag/tnslsnr/target/listener/alert/log.xml
Listening Endpoints Summary ...
(Description= (address= (protocol=tcp) (Host=target) (port=10001)))
(Description= (address= (PROTOCOL=IPC) (key=extproc1521)))
Services Summary ...
Service "Pu" has 1 instance (s).
Instance "Pu", status UNKNOWN, have 1 handler (s) for the This service ...
The command completed successfully

6. View System Status

[Email protected] ~]$ Netstat-ano|grep 10001
TCP 0 0 192.168.6.152:26082 192.168.6.152:10001 established off (0.00/0/0)
TCP 0 0::: 10001:::* LISTEN off (0.00/0/0)
TCP 0 0:: ffff:192.168.6.152:10001:: ffff:192.168.6.152:26082 established keepalive (7193.37/0/0)

10001 Port number has been turned on

7. Verify Login

[Email protected] ~]$ sqlplus/as [email protected]:10001:pu


Sql*plus:release 11.2.0.3.0 Production on Tue 10 16:50:50 2016


Copyright (c) 1982, Oracle. All rights reserved.




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real application testing options


Sql>

Modifying the Oracle Database listening port number