Friday , October 20 2017
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)

Comments

comments

Check Also

Moving a database from Normal File System to ASM storage

Default storage for oracle database is File System, where database files resides on local storage. …

Leave a Reply

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