Connect to the database with Sqlplus without installing the Oracle client:
1, to the official website to download
Http://www.oracle.com/technetwork/topics/winx64soft-089540.html
Instantclient-basic-windows.x64-11.2.0.4.0.zip
Instantclient-sqlplus-windows.x64-11.2.0.4.0.zip
Instantclient-sdk-windows.x64-11.2.0.4.0.zip
2, the above three files extracted to the same directory will get instantclient_11_2 folder;
3, go to the system environment variables to configure environment variables (My Computer, properties, advanced system settings, environment variables):
4. New button Add
Tns_admin=d:\oracle\instantclient_11_2
Nls_lang=simplified Chinese_china. Zhs16gbk
Add D:\ORACLE\INSTANTCLIENT_11_2;D:\ORACLE\INSTANTCLIENT_11_2\SDK after the path variable;
5, Window+r--->cmd
Sqlplus User/[email protected]:p Ort/sid
Local host does not install Oracle client--Access remote Oracle Database