(1)检查OracleOraDb10g_home1TNSListener监听服务是否启动;OracleServiceTEST服务是否启动。
(2)tnsping test,不通的话检查product/10.2.0/db_1/NETWORK/ADMIN目录下
listener.ora与tnsnames.ora中test的host是否和机器的IP一致。例如:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.18)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.18)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)
(3)再次启动。