问题描述
- redha下安装oracle成功,但是lsnrctl start监听启动不了
-
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
解决方案
rhel6 32位安装oracle11g
listener.ora如下
#stener.ora Network Configuration File: /opt/oracle/app/product/11.2.0/dbhome_1/network/admin/listener.ora
Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME =orcl)
(ORACLE_HOME=/opt/oracle/app/product/11.2.0/dbhome_1)
(SID_NAME =orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
# (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost.localdomain)(PORT = 1521))
# )
)
ADR_BASE_LISTENER = /opt/oracle/app
[oracle@localhost admin]$ cat tnsnames.ora
tnsnames.ora Network Configuration File: /opt/oracle/app/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost.localdomain)(PORT = 1521))
(CONNECT_DATA =
# (SERVER = DEDICATED)
# (SERVICE_NAME =orcl.localdomain)
(SID = orcl)
)
)
解决方案二:
非常简单,localhost和127.0.0.1都是本地地址,你应该改成真实ip地址或者机器名称
解决方案三:
修改tnsnames.ora里面的localhost成真实ip地址或者真实hostname,然后执行lsnrctl start
解决方案四:
嗯,吧tnsname改下试试