By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
I have installed Red Hat Linux on a Windows 98 system as dual OS, i.e., I have 10 GB of space on my hard disk. I have installed Linux as well as Oracle10g in that space. The partitions are given as root 7 GB, for home 1.5, swap 1024, boot 110; the remaining space I have left blank. I have installed Oracle10g on Red Hat Linux Enterprise4. The database has been installed perfectly. When I connect to SQL*Plus it is giving an error. If I give sqlplus /nolog then it connects and shows sql>(prompt). Now I would like to connect any user like SCOTT or SYS or Connect /as sysdba. Then it gives me an error, "Net Service Name is incorrectly specified." What should I do?
This type of error usually indicates that either you do not have an entry for your database in the tnsnames.ora file or there is a problem with the file itself. Review your tnsnames.ora file and ensure there are no syntax errors; also look for any stray characters or unmatched parentheses in the file. It is possible that there are "hidden" characters in the file if it was edited with a program like Microsoft Word. This would render the file useless. If you cannot find any syntax problems with the file, delete it and re-create it using an appropriate editor or the Oracle Net Configuration Assistant.