Đổi port mặc định của Oracle từ 1521 sang port bất kỳ

 

Giả sử chúng ta muốn thay đổi port mặc định của oracle là 1521 sang port 8521. Chúng ta thực hiện các bước sau:

11.  Kiểm tra listener

[oracle@localhost ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-DEC-2017 16:41:56

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                04-JAN-2017 10:49:54

Uptime                    345 days 5 hr. 52 min. 1 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

Services Summary...

Service "ora15" has 1 instance(s).

  Instance "ora15", status READY, has 1 handler(s) for this service...

Service "ora15XDB" has 1 instance(s).

  Instance "ora15", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@localhost ~]$

22. Tắt listener

lsnrctl stop

33.       Sửa file listener.ora

vim /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Sửa tại vị trí (PORT = 1521) thành (PORT = 8521) sau đó lưu lại

44.       Bật lại listener

lsnrctl start

55.       Kết nối sqlplus và chạy 2 lênh sau:

Bạn chú ý đổi tham số host bằng hostname của server

ALTER SYSTEM SET LOCAL_LISTENER ="(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=8521))";

ALTER SYSTEM REGISTER;

66.       Thoát khỏi sqlplus và kiểm tra lại listener

lsnrctl status

[oracle@localhost ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-DEC-2017 16:41:56

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                04-JAN-2017 10:49:54

Uptime                    345 days 5 hr. 52 min. 1 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=8521)))

Services Summary...

Service "ora15" has 1 instance(s).

  Instance "ora15", status READY, has 1 handler(s) for this service...

Service "ora15XDB" has 1 instance(s).

  Instance "ora15", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@localhost ~]$

Như vậy sau 6 bước trên chúng ta đã đổi thành công port listener từ 1521 thành 8521