主要症结:tnsnames.ora文件中,服务名需要顶格,服务名所在行前有空格就不行
pabc =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.22.44)(PORT = 1521))
)
(CONNECT_DATA =
(SID = pabc)
(SERVER = DEDICATED)
)
)
pabc_alice =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ocm)
(SERVER = DEDICATED)
)
)
其它一系列尝试包括:()
cmd命令
Oracle相关服务的启动
环境变量的设定