Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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"
Reinhard Burger
Frequent Advisor

Re: ORA-12546 TNS:Permission denied

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 )
keep it simple