ORACLE: ORA-12560 Solutions

ORACLE: ORA-12560 solution today when oracle Data imp/exp was suddenly found in cmd execute exp input scott/tiger prompt: EXP-00056: encountered ORACLE error 12560ORA-12560: TNS: protocol adapter error EXP-00000: Export termination failed to start thinking you have entered the wrong user name, after all, I am not familiar with oracle here. If you enter the user name and password again, an error still occurs. Calm down and think about it ---- the listener and database instance have been started and still use their own batch processing scripts. In Linxu, I can also use imp/exp. In Linxu, there is no registry concept, but the concept of environment variables exists. After the registry is excluded, the difference is here. So I Google ...... as I expected, the key value of ORACLE_SID under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/KEY_OraDb10g_home1 in the registry is the same as that of my database instance. Now you can exclude the registry. Then, set the system environment variable ORACLE_SID = orc and go to cmd to retry exp without prompting you to export any errors. Test again to verify is the cause of environmental variables, I set ORACLE_SID = orcs, then exp and the above ORA-12560 error, and then set back ORACLE_SID = orc, the problem is resolved again. I have seen the relationship between environment variables and oracle in Linxu in a previous book on Eygle. In windows, I personally think that there will be more associations with the Registry. For me, I am more accustomed to using command lines. In windows, there is also a certain relationship with environment variables.