安装oracle后如果ip发生变化请查看一下两个文件的中host值是否和改变后的一致:
1: %ORACLE_HOME%/NETWORK/ADMIN目录下 编辑listener.ora文件中的HOST值更改为修改后的机器名即可。
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
2: % ORACLE_HOME%/NETWORK/ADMIN目录下 编辑tnsnames.ora文件中的HOST值更改为修改后的机器名即可。
ORCL_127.0.0.1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
1: %ORACLE_HOME%/NETWORK/ADMIN目录下 编辑listener.ora文件中的HOST值更改为修改后的机器名即可。
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
2: % ORACLE_HOME%/NETWORK/ADMIN目录下 编辑tnsnames.ora文件中的HOST值更改为修改后的机器名即可。
ORCL_127.0.0.1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)