2 u011506498 u011506498 于 2014.12.06 09:36 提问

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...

4个回答

u011506498
u011506498   2014.12.06 09:40

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)

)
)

u013371709
u013371709 太感谢了,我安装了VMwaretools,结果两个ora文件都被改了。
2 年多之前 回复
eagleyan
eagleyan   Rxr 2014.12.06 11:34

非常简单,localhost和127.0.0.1都是本地地址,你应该改成真实ip地址或者机器名称

eagleyan
eagleyan   Rxr 2014.12.06 11:37

修改tnsnames.ora里面的localhost成真实ip地址或者真实hostname,然后执行lsnrctl start

arlen1990
arlen1990   Rxr 2015.02.03 19:03

嗯,吧tnsname改下试试

Csdn user default icon
上传中...
上传图片
插入图片