Cannot tnsping or connect locally except from root and oracle Linux accounts, but remote connections work

I just installed Oracle 11g on a new Fedora 9 Linux box.  Everything installed fine.  However, I am seeing some odd behavior that I can't figure out: I can tnsping and sqlplus (connect) perfectly from *remote* machines and from the root and oracle user accounts on the local box.  However, whenever I try to tnsping or sqlplus to the database from any "normal" Linux user account it throws a "TNS-03505: Failed to resolve name" error.  At first I thought it was invalid data in tnsnames.ora, but I have triple-checked it and plus I can connect just fine from the 'root' and 'oracle' accounts.

To summarize, here is what I am seeing ('shanadl' is the oracle service name):
1. Log in as 'dougb' on the local Linux box.
2. tnsping shanadl  << ERROR: "TNS-03505: Failed to resolve name"
3.  Log in as 'test' (which is another normal account) on the local Linux box.
4. tnsping shanadl << ERROR: "TNS-03505: Failed to resolve name"
5.  Log in as 'oracle' on the local Linux box.
6. tnsping shanadl << WORKS!
7.  Log in as 'oracle' on the local Linux box.
8. tnsping shanadl << WORKS!
9. Log in to any remote box (e.g., Windows or a different Linux box).
10. tnsping shanadl << WORKS!  (granted, this uses a different tnsnames.ora file local to the client box)

In the past I have installed Oracle 8, 9i, and 10g instances and I have never seen this behavior.  The fact that I can connect to the Oracle instance as root and the 'oracle' accounts but not from normal accounts makes me think this is some new security feature in Oracle 11g.  However, Googling hasn't turned up anything.  Why can't I connect from non-privileged Linux accounts?  I'm really stumped here!  Any advice is appreciated.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dbeachy1Author Commented:
Correction, step 7 should read:
7. Log in as 'root' on the local Linux box.
DavidSenior Oracle Database AdministratorCommented:
Weird.  Problems like this are commonly solved when we methodically examine our assumptions, right?  Although you triple-checked a tnsnames file, it's possible that your box has more than one tnsnames.ora.  Check with executing "find / -name "tnsnames.ora" -type f -print" and see whether or not you have duplicates.
Secondly, are the .profiles for test and dougb identical to the others?  I'd connect as test, and eyeball my "env|sort" results to confirm the Oracle homes, and TNS_ADMIN variable are correct.
Thirdly, your symptom suggests that the test accounts simply don't have execute permission on $ORACLE_HOME/bin/sqlplus.  Check for group priviledges, and let me know what comes back.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dbeachy1Author Commented:
Sure enough, it turned out to be a permissions problem on tnsnames.ora! Oracle 11g created the tnsnames.ora file with 0640 permissions (rw owner, r group, NO ACCESS world), and so only root and users in the 'dba' group could connect locally.  I assume this is part of the security ehnancements talked about in Oracle 11g.  In any case, the fix was this:
1. Log in as oracle.
2. chmod a+r $ORACLE_HOME/network/admin/tnsnames.ora

And presto, I can connect from my local account now!  That little change from previous Oracle versions sure caused me a lot of grief.  :)  
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux Distributions

From novice to tech pro — start learning today.