Q

Error connecting to 10g on dual OS system

I have installed Red Hat Linux on a Windows 98 system. When I connect to SQL*Plus it is giving an error: "Net Service Name is incorrectly specified."

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.
This was first published in January 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close