Re: ORA 10G -ORA-12546 Error

nwjb wrote:
Hi,

I have a strange problem:

Being logged in as standard user:(even root)(all members of oinstall group)

sqlplus scott/tiger@A works
sqlplus scott/tiger does not work and ends with ORA-12546:TNS permission denied.

Environment is:
Compaq proliant server
Suse 9.3 Pro Linux
Oracle 10G
ORACLE_SID set to 'A' in both cases

Being logged in as oracle works in both cases.

Have checked /tmp and /var/tmp permissions (777)

Have checked environment variables related to oracle: the only differences are
CLASSPATH and ORA_NLS which are defined when oracle and not as other user.

Changing ORACLE_HOME protections to 755 does not help.

Joining to dba/oracle group does not help.

I suppose it is some kind of file permission but have no idea.

Thanks for any help.



--J.Bratières

Enlever paspub pour répondre
Please remove paspub when answering

Are you physically on the server or connecting from a client machine?
Member of the DBA group too?
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • ORA 10G -ORA-12546 Error
    ... Being logged in as standard user:(all members of oinstall group) ... sqlplus scott/tiger does not work and ends with ORA-12546:TNS permission denied. ... Being logged in as oracle works in both cases. ... I suppose it is some kind of file permission but have no idea. ...
    (comp.databases.oracle.server)
  • AW: dynamic lib ignored even after "found" in "install_driver(Oracle) failed: Cant load..." cgi prob
    ... permission denied" possibly ... Oracle 10.2.0 ... a process needs execute permissions on that directory. ... really using a different oracle client installation. ...
    (perl.dbi.users)
  • NFS mounted stale redo log
    ... We have an Oracle database with 4 redo log groups with 3 ... Of the 3 members, one of those member is NFS ... redo log member stale for a split second and then it's status will go ...
    (comp.databases.oracle.server)
  • Re: How my other Unix account can access oracle binaries?
    ... Other than change file permission by chmod or add dba group in my ... make sure the suid bit of the Oracle executable is set. ... Your installation is incorrect, otherwise you wouldn't have faced this ...
    (comp.databases.oracle.server)
  • Re: problem in exporting table from MSAccess to Oracle....
    ... and i dont think this user is not needed a read permission... ... "Joe Fallon" wrote: ... > I would create the table in Oracle. ... >> With best regards ...
    (microsoft.public.access.externaldata)