Ask the Expert

Error connecting to 10g on dual OS system

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: