Re: Help! ORA-12546: TNS:permission denied

Gerhard Moeller wrote:
>
> (This message was already sent on 7/16/97, but unanswered... Also
> sorry for the crossposting, but I am really clueless.)
>
> Oooops...
>
> After installing the OracleWeb Server 2.1 I cannot log into the DBMS
> with sqlplus from my user account!
>
> Sqlplus always returns: ORA-12546: TNS:permission denied
>
> But only for me! sqlplus works fine for user oracle, root, and any
> other user! I have dba rights and I am in the UNIX groups 0(system),
> 100(gprog), 109(oper). It does not help to change the group with
> newgrp...
>
> What happened?
>
> I did not change anything in listener control files!
>
> Thanks for any help, Gerhard.
>
> BTW, here's the log-output:
>
> ***********************************************************************
> Fatal OSN connect error 12546, connecting to:
>
> (DESCRIPTION=(CONNECT_DATA=(SID=orcl)(GLOBAL_NAME=gerhard.world)(CID=(PROGRAM=)(HOST=gerhard.bis.uni-oldenburg.de)(USER=gemoe)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=gerhard.world))(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=gerhard.bis.uni-oldenburg.de)(Port=1526))))
>
> VERSION INFORMATION:
> TNS for DEC OSF/1 AXP: Version 2.3.2.1.0 - Production
> Unix Domain Socket IPC NT Protocol Adaptor for DEC OSF/1 AXP:
> Version 2.3.2.1.0 - Production
> Time: 16-JUL-97 18:16:58
> Tracing not turned on.
> Tns error struct:
> nr err code: 12206
> TNS-12206: TNS:received a TNS error during navigation
> ns main err code: 12546
> TNS-12546: TNS:permission denied
> ns secondary err code: 12560
> nt main err code: 516
> TNS-00516: Permission denied
> nt secondary err code: 13
>
> --
> Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE
>
> OFFIS | | | | | | Tel.: 0441/9722-122
> Escherweg 2 | | | | | | Sekr.: 0441/9722-113 oder -101
> D-26121 Oldenburg |O|F|F|I|S| Fax: 0441/9722-102

Seems like you have a tnsnames.ora file somewhere in your account or at some place which gets accessed before the actula location. Check your path also. You also might have a variable 'tns_admin' in your .profile/.cshrc file. Make sure it points correctly.

amit
Oracle DBA/Unix SA Received on Tue Aug 19 1997 - 00:00:00 CDT