TNSNAMES.ORA entry [message #361601] |
Thu, 27 November 2008 02:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahnazurs
Messages: 240 Registered: June 2005 Location: India
|
Senior Member |
|
|
Dear All,
I have 2 user's in UNIX development box.
1) oracle
2) test
I have a tnsnames.ora file which holds production DB access details in development box.
When I try to connect to the production DB from oracle account like below
sqlplus scott/tiger@proddb
I can able to access
but when I try from test user
it shows error like
SQL*Plus: Release 9.2.0.6.0 - Production on Thu Nov 27 08:50:49 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve service name
Much appreciated if anybody tell me what can I do?
Thanks,
Shahnaz.
|
|
|
|
|
|
Re: TNSNAMES.ORA entry [message #361627 is a reply to message #361625] |
Thu, 27 November 2008 03:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahnazurs
Messages: 240 Registered: June 2005 Location: India
|
Senior Member |
|
|
Through unix user "oracle", I can access proddb.
Not through unix user "test"
user "test" is able to read tnsnames.ora file which exists in $ORACLE_HOME/network/admin
Am I clear now?
Thanks,
Shahnaz.
|
|
|
Re: TNSNAMES.ORA entry [message #361647 is a reply to message #361627] |
Thu, 27 November 2008 04:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68679 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Yes, is TNS_ADMIN variable set?
Post (copy and paste) what you did with both users.
Post environment variables for both users.
Post this formatted using code tags (see OraFAQ Forum Guide).
Regards
Michel
|
|
|