Shulou(Shulou.com)06/01 Report--

Operating System: Windows 7

Database version: 11.2.0.1

Problem Description:

You can log in directly through sqlplus sys/oracle@10.10.100.109:1521/ysxt as sysdba, but you cannot log in through sqlplus sys/oracle@YSXT as sysdba, and ORA-12557: TNS: Protocol adapter cannot be loaded. Check the environment variables TNS_ADMIN and ORACLE_HOME.

Finally, check the PATH environment variable and find that both client and server directories have been added to path, and remove the client configuration. As follows:

Solution:

Put it in PATH

F:\app\Administrator\product\11.2.0\client_1\bin;F:\app\Administrator\product\11.2.0\dbhome_1\bin;

changed to

F:\app\Administrator\product\11.2.0\dbhome_1\bin;

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.