今天服务器数据库连接不上问题,总结下,希望帮助到大家。
1、需要在listener.ora和tnsnames.ora中的Host地址。
第一种方法
LAPTOP-T9CFKCI1 是计算机的名称
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LAPTOP-T9CFKCI1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
第二种方法
把Host地址改成本地IP地址
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
2、重新启动服务监听