ORA-12546 TNS:Permission denied

[Reinhard Burger]

Hi
We have the following situation. After a colleque of us restored partially a backup ( core dump happended) ORACLE is behaving somehow strange :
Logon to ORACLE using sqlplus works fine
Using the application that is normally used with the db alos works fine.
If the application tries to logon to ORACLE using programmatic access does not work at all .We always get the ORA-12546 error
We cannot fin whats wrong.
Has anyone a idea where we should search

[Clemens van Everdingen]

Hi,

My best guess is to check the permissions of the restored files.

C.

[T G Manikandan]

As which user the application is running.
Are you trying to connect using a different user.

sqlplus using "oracle" user is fine.
check the permissions for the directories whether they have permissions for other users.


Thanks

[Reinhard Burger]

Hi
Let me precise my question a little bit :

Which files usually cause this problem if they are not readable for users

It's possible to logon to the db as any configured user as long a logon prompt pops up

Thats what confuses us.
Also tnsmanes resolution works ok

[Clemens van Everdingen]

Hi,

Check these permissions:

$ORACLE_HOME 755
$ORACLE_HOME/bin 755
$ORACLE_HOME/bin/oracle 6751

C.

[Alan Casey]

Make sure the permission on the oracle execuatble is correct. The oracle executable permission should be:

52224 -rwsr-sr-x 1 oracle dba 53431665 Aug 10 11:07 oracle

Explanation:
The error, ora-12546, occurs due to an incorrect setting on the oracle executable.

[T G Manikandan]

check whether the user has write permissions to the trace and log files specified in listener.ora.

edit your listener.ora file

TRACE_LEVEL_LISTENER = 16 TRACE_DIRECTORY_LISTENER = /tmp TRACE_FILE_LISTENER = "listener"

restart the listener.

lsnrctl stop and start.

checck for the errors in the file.


Thanks

[T G Manikandan · Accepted solution]

check for the permissions of the /tmp and /var/tmp directories.

They should be 6777.

Thanks

[Reinhard Burger]

Thank you all for your help
the tip with dir /tmp was the one that fixed it

[Alexander M. Ermes]

Hallo, Reinhard.
Bitte weisen Sie den Leuten, die Ihnen geholfen haben, ein paar Punkte zu ( assign points ).
Mir bitte nicht.
MfG
Alexander M. Ermes

[Reinhard Burger]

Yes of course i would like to assign points and i tried it THREE times.
But just open your Mail i saw that it did'nt work again.
So what's wrong.
Have i to do it one by one or may there be a problem with my browser ( IE 5.5 )