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
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
No comments:
Post a Comment