Oracle Solution for ORA-12560

ORA-12560 resolution Method

Today, when performing Oracle data imp/exp, we suddenly find that the exp input scott/tiger is prompted after CMD:

EXP-00056: ORACLE Error 12560 encountered

ORA-12560:TNS: Protocol Adapter error

EXP-00000: Export termination failed

I began to think that I had the wrong username, after all, I am not familiar with Oracle here. Enter username and password again, still error.

Just think about it----listeners and database instances have been started and are using their own batch scripts. Under the Linxu I can also imp/exp, Linxu under the concept of not register, and the existence of environmental variables this concept. After you exclude the registry, the difference is here.

So I google ...

As I expected, the key value under Hkey_local_machine/software/oracle/key_oradb10g_home1 in the registry Oracle_sid the same as my database instance name is ORC. You can now exclude the registry. Then set the system environment variable ORACLE_SID=ORC and then go to cmd under the re-exp without prompting any errors can be exported.

And then do experimental verification is the reason for environmental variables, I set ORACLE_SID=ORCS, then exp again appear above the ORA-12560 error, and then set back to Oracle_sid=orc, the problem is solved again.

The relationship between environment variables and Oracle in Linxu was previously seen in a book in Eygle. Under Windows I personally think that the association with the Registry will be more, for me this more accustomed to command line of people in Windows and environment variables also have some connection.