ORA-12154: TNS: 无法解析指定的连接标识符--问题解决

旧的：环境变量--path:%JAVA_HOME%"bin;F:"oracle"product"10.1.0"Db_1"bin;F:"oracle"product"10.1.0
"Db_1"jre"1.4.2"bin"client;F:"oracle"product"10.1.0"Db_1"jre"1.4.2
"bin;F:"Oracle"product"10.1.0"Client_1"bin;F:"Oracle"product"10.1.0"Client_1"jre"1.4.2
"bin"client;F:"Oracle"product"10.1.0"Client_1"jre"1.4.2"bin;%SystemRoot%
"system32;%SystemRoot%;%SystemRoot%"System32"Wbem;C:"Program
Files"Microsoft SQL Server"80"Tools"Binn";C:"Program Files"Microsoft SQL Server"90
"DTS"Binn";C:"Program Files"Microsoft SQL Server"90"Tools"binn";C:"Program
Files"Microsoft SQL Server"90"Tools"Binn"VSShell"Common7"IDE";C:"Program
Files"Microsoft Visual Studio 8"Common7"IDE"PrivateAssemblies"

 

改后的环境变量-Path:%JAVA_HOME%"bin;F:"Oracle"product"10.1.0"Client_1"bin;F:"Oracle"product"10.1.0
"Client_1"jre"1.4.2"bin"client;F:"Oracle"product"10.1.0"Client_1"jre"1.4.2
"bin;F:"oracle"product"10.1.0"Db_1"bin;F:"oracle"product"10.1.0"Db_1"jre"1.4.2
"bin"client;F:"oracle"product"10.1.0"Db_1"jre"1.4.2"bin;%SystemRoot%"system32;%
SystemRoot%;%SystemRoot%"System32"Wbem;C:"Program Files"Microsoft SQL
Server"80"Tools"Binn";C:"Program Files"Microsoft SQL Server"90"DTS"Binn";C:"Program
Files"Microsoft SQL Server"90"Tools"binn";C:"Program Files"Microsoft SQL Server"90
"Tools"Binn"VSShell"Common7"IDE";C:"Program Files"Microsoft Visual Studio 8
"Common7"IDE"PrivateAssemblies"