更改计算机名后,oracle无法连接怎么办
发布网友
发布时间:2022-04-07 18:44
我来回答
共3个回答
热心网友
时间:2022-04-07 20:14
编辑$ORACLE_HOME/network/admin/listener.ora
(ADDRESS = (PROTOCOL = TCP)(HOST = old_hostname)(PORT = 1521))
将原主机名改成
(ADDRESS = (PROTOCOL = TCP)(HOST = new_hostname)(PORT = 1521))
或
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
重启监听服务即可(lsnrctl)。
热心网友
时间:2022-04-07 21:32
更改计算机名后 oracle 服务可能开启不了
需要修改:
oracle\proct\10.2.0\db_1\NETWORK\ADMIN中 listener.ora
对应的
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 计算机名)(PORT = 1521))
)
)
tnsnames.ora 中配置修改
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 计算机名)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
热心网友
时间:2022-04-07 23:06
修改oracle配置文件