Home / Oracle DBA / TYPES OF ERRORS in Oracle database

TYPES OF ERRORS in Oracle database

Error 1: Connect failed because target host or object does not exist

Solution : goto run->drivers->etc->hosts file and open it with notepad. Then do add a entry.
Note : If it is unix machine, check in /etc/hosts.
Error 2 : protocol adapter error
Solution : Generally it will occur if network connectivity is not there. So ping the serverand if its working fine then check if firewall is enabled either at client side or server side.
Error 3 : connection description doesn’t found
Solution : check tns entry in tnsnames.ora for any syntax error.
Note : port number in listener.ora and tnsnames.ora should be same.
Read More:
PROFILE MANAGEMENT
USER MANAGEMENT
ORACLE MANAGED FILES (OMF)
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

Your email address will not be published. Required fields are marked *

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe