sorry I made a mistake it should be C:\windows\syswow64
but as what I said previously, service name is not populated at at all.
C:\Windows\SysWOW64>echo %PATH%
C:\app\oracle\product\12.1.0.2\instantclient_12_1;C:\ProgramData\Oracle\Java\javapath;C:\app\oracle\product\11.2.0.4\dbhome_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\7-Zip;C:\Program Files (x86)\PuTTY;C:\Program Files (x86)\Skype\Phone\;C:\Program Files\Oracle\VirtualBox
sqlplus
SET local=orcl
c:\Windows\SysWOW64>sqlplus sys/****** as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 5 21:46:59 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
so obviously that's nothing wrong with the path and environment variable.
any other variable that I need to set
thanks