Sunday, July 16, 2017

UDE-12560: operation generated ORACLE error 12560 ORA-12560: TNS:protocol adapter error

When I export from my oracle 12c database i got
 UDE-12560: operation generated ORACLE error
 12560 ORA-12560: TNS:protocol adapter error


I set everything  on my windows machine.

from command promp(CMD)
C:> set ORACLE_SID=ORCL
C:> loging sqlplus /nolog

sql> conn sys / as sysdba
UDE-12560: operation generated ORACLE error
 12560 ORA-12560: TNS:protocol adapter error

But found getting this error.

Solution for this error:
UDE-12560: operation generated ORACLE error
 12560 ORA-12560: TNS:protocol adapter error


Solution: LSNRCTL FROM COMMAND PROMPT


C:>set oracle_sid=ORCL
C:> LSNRCTL
 
LSNRCTL> status
LSNRCTL> stop
LSNRCTL> start


Go windows machine services:

restart oracle services
restart tns services.

Then I ran again expdp command and chill
Now  below error vanish!!!!
UDE-12560: operation generated ORACLE error
 12560 ORA-12560: TNS:protocol adapter error