我在2016年的windows服务器上使用甲骨文12c。我想让我的先知听1521到0.0.0.0端口
这是我的listner.ora文件。
# listener.ora Network Configuration File: C:\app\bhuvi\virtual\product\12.2.0\dbhome_2\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_ORCL_BHUVI =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\bhuvi\virtual\product\12.2.0\dbhome_2)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\bhuvi\virtual\product\12.2.0\dbhome_2\bin\oraclr12.dll")
)
)
ORCL_BHUVI =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
您可以看到主机是0.0.0.0,但是当我启动监听器时,它在那里侦听端口1521到本地主机(我的主机名是不丹-oracle)。
C:\Windows\system32>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 18-APR-2020 17:29:19
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
Start Date 18-APR-2020 17:29:12
Uptime 0 days 0 hr. 0 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\bhuvi\virtual\product\12.2.0\dbhome_2\network\admin\listener.ora
Listener Log File C:\app\bhuvi\virtual\diag\tnslsnr\bhuvi-oracle\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bhuvi-oracle)(PORT=1521)))
The listener supports no services
The command completed successfully
有人能帮我解决这个问题吗?
发布于 2022-01-11 18:42:51
您必须在以下位置更改文件:
$ORACLE_HOME/network/admin/listener.ora
$ORACLE_HOME/network/admin/tnsnames.ora
在这两个文件中,您必须将HOST
属性更新为0.0.0.0
在进行这些更改后,重新启动Oracle数据库和侦听器。
希望这能帮助其他在这个问题上陷入困境的人。
https://dba.stackexchange.com/questions/265348
复制相似问题