经常碰到这个问题,在这里做个记录,
主要原因是服务器ip 地址或者计算机名改变。
修改$ORACLEHOME/network/admin/linstener.ora 文件中
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =EASYWAYTICKET)(PORT = 1521))
)
中间的hostname 改称现在机器名或者ip 地址就ok 了。
修改$ORACLEHOME/network/admin/tnsnames.ora文件中
TICKET =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = EASYWAYTICKET)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ticket)
)
)
更改以后就好了