Operating System - HP-UX
1748041 Members
5160 Online
108757 Solutions
New Discussion юеВ

Re: ORA-12546 TNS:Permission denied

 
SOLVED
Go to solution
Reinhard Burger
Frequent Advisor

ORA-12546 TNS:Permission denied

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
keep it simple
10 REPLIES 10
Clemens van Everdingen
Honored Contributor

Re: ORA-12546 TNS:Permission denied

Hi,

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

C.
The computer is a great invention, there are as many mistakes as ever, but they are nobody's fault !
T G Manikandan
Honored Contributor

Re: ORA-12546 TNS:Permission denied

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
Frequent Advisor

Re: ORA-12546 TNS:Permission denied

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
keep it simple
Clemens van Everdingen
Honored Contributor

Re: ORA-12546 TNS:Permission denied

Hi,

Check these permissions:

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

C.
The computer is a great invention, there are as many mistakes as ever, but they are nobody's fault !
Alan Casey
Trusted Contributor

Re: ORA-12546 TNS:Permission denied

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
Honored Contributor

Re: ORA-12546 TNS:Permission denied

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
Honored Contributor
Solution

Re: ORA-12546 TNS:Permission denied

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

They should be 6777.

Thanks
Reinhard Burger
Frequent Advisor

Re: ORA-12546 TNS:Permission denied

Thank you all for your help
the tip with dir /tmp was the one that fixed it
keep it simple
Alexander M. Ermes
Honored Contributor

Re: ORA-12546 TNS:Permission denied

Hallo, Reinhard.
Bitte weisen Sie den Leuten, die Ihnen geholfen haben, ein paar Punkte zu ( assign points ).
Mir bitte nicht.
MfG
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"