Re: ora 12154
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Thu, 03 Nov 2011 16:25:28 +0000
Message-ID: <4EB2C078.6000705_at_dunbar-it.co.uk>
On 03/11/11 16:21, Zelli, Brian wrote:
> Why just this user? I checked roles, privs and everything else. I checked tnsnames file, sqlnet.ora file
Date: Thu, 03 Nov 2011 16:25:28 +0000
Message-ID: <4EB2C078.6000705_at_dunbar-it.co.uk>
On 03/11/11 16:21, Zelli, Brian wrote:
> Why just this user? I checked roles, privs and everything else. I checked tnsnames file, sqlnet.ora file
Have you checked for a rogue version of TNS_ADMIN?
Can you perhaps tnsping it?
If it's on Linux, and assuming tnsping fails, do you see anything in the log file for the following command:
strace -o your_log_file tnsping alias_name
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 03 2011 - 11:25:28 CDT