In 2008 the client Server installation install oracle 11 g and configure the TNS after
Sqlplu xx/xx xx
a successful login to the target database @But an error in one folder ": ORA - 12543: TNS: unable to connect the target host

Is
Open the CMD window, enter sqlplu xx/xx xx
a successful login to the target database @
Then CD/D D: \ \ XXX XXX, sqlplu xx to xx/xx @ ORA - 12543: unable to connect to the target host TNS:

CodePudding user response:

After the CD to the directory, tnsping next look at the results, it is best to you the operation of the map

CodePudding user response:

Is likely to be the problem of environment variables, you change the PATH and identify the PATH configuration Oracle installation PATH,

CodePudding user response:

Actually don't need to go to open the folder,
After you connected to the oracle, or using the @ @ @, will prompt you to select the target file,

CodePudding user response:

Maybe I didn't say clear, I am running in the same command window, and environment variables are seen, the path is the path of the oracle client yes

First of all, the default directory in the CMD perform up sqlplus login successfully, then quit exit
CD to the problematic directory, again up sqlplus is submitted to the TNS,,,

CodePudding user response:

Inspection report ora - 12543 error directory name, whether have braces - oracle client in a directory with parentheses, amazing problem may come up (especially 64 - bit OS + 32-bit client)

CodePudding user response:

Environment, variables, or abnormal monitoring, and see what is new installed software, affect the use, CND - & gt; TSNRTL look listen, not to get into the control panel - service, for instance to restart to see see!

CodePudding user response:

reference 5 floor wawxj reply:

inspection report ora - 12543 error directory name, whether have braces - oracle client in a directory with parentheses, amazing problem may come up (especially 64 - bit OS + 32-bit client)

Path without symbols with a space, can only to 64 OS + 32 strange issue to the client,,
And tried it on these days, seems to only one specific directory has a problem, other directory is normal, but on the other environment (64 OS + 32 client) never happened this problem,
When was the first time such a wonderful work problems