oracle端口怎么查看 怎么查看oracle的端口

oracle如何查看本地端口号,连接字符串老是提示不对LOCALHOST;1521不好使 。查看数据库监听端口号, 看 listener.ora 位于 D:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
查看连接串端口号, 看tnsname.ora, 位于 D:\oracle\product\11.2.0\client_1\network\admin\tnsnames.ora
两者端口号要一致
linux下怎么查看Oracle端口号1、more $ORACLE_HOME/network/admin/listener.ora
PORT = 1521
2、lsnrctl status
3、tnsping localhost
4、netstat -ntlp
怎样查看centos中oracle数据库端口号[oracle@ylemser2 bin]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-AUG-2016 09:10:45
【oracle端口怎么查看 怎么查看oracle的端口】Copyright (c) 1991, 2014, Oracle.All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ylemser2)(PORT=1521)))
STATUS of the LISTENER
------------------------
AliasLISTENER
VersionTNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date30-JUN-2016 13:40:29
Uptime55 days 19 hr. 30 min. 17 sec
Trace Leveloff
SecurityON: Local OS Authentication
SNMPOFF
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 加粗的就是端口号的哪行 。
关于oracle端口怎么查看和怎么查看oracle的端口的介绍到此就结束了,不知道你从中找到你需要的信息了吗 ?如果你还想了解更多这方面的信息,记得收藏关注本站 。

    推荐阅读