Could you post the exact commands and output (just copy/paste from your terminal)? Remove the real usernames and passwords, of course :) Details such OS and Oracle database version will be useful. Dimitre On 03/11/2011 17:26, Zelli, Brian wrote: > Yes, that's what aggravates me.... > > Brian > > > -----Original Message----- > From: Radoulov, Dimitre [mailto:cichomitiko@xxxxxxxxx] > Sent: Thursday, November 03, 2011 12:25 PM > To: Zelli, Brian > Cc: 'oracle-l@xxxxxxxxxxxxx' > Subject: Re: ora 12154 > > On 03/11/2011 17:21, Zelli, Brian wrote: >> Ok, this is really ticking me off. I created a user and when I try >> and connect via sqlplus I get ORA-12154: TNS:could not resolve service name >> Yet I can connect with other users to the same instance from the same >> machine. >> >> Why just this user? I checked roles, privs and everything else. I >> checked tnsnames file, sqlnet.ora file >> > Could you connect with other users from the same unix session (from the same > shell)? > > > > Dimitre > > > This email message may contain legally privileged and/or confidential > information. If you are not the intended recipient(s), or the employee or > agent responsible for the delivery of this message to the intended > recipient(s), you are hereby notified that any disclosure, copying, > distribution, or use of this email message is prohibited. If you have > received this message in error, please notify the sender immediately by > e-mail and delete this email message from your computer. Thank you. -- //www.freelists.org/webpage/oracle-l