Question

怎样查看centos中oracle数据库端口号

Answer 1

[oracle@ylemser2 bin]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-AUG-2016 09:10:45

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ylemser2)(PORT=1521)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date                30-JUN-2016 13:40:29

Uptime                    55 days 19 hr. 30 min. 17 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

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

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

Listening Endpoints Summary...

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

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

Services Summary...

Service "emrepo" has 1 instance(s).

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

Service "emrepoXDB" has 1 instance(s).

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

The command completed successfully

切换到oracle用户执行lsnrctl status 加粗的就是端口号的哪行。