ORA-12546: TNS:permission denied

You do not have the necessary privileges to execute the operation.

If you are trying to start the listener:
Make sure the user you are trying to start the lsnrctl has the necessary privileges to create sockets.

If you are trying to make a connection to Oracle:
Make sure you belong to a group the has execute privileges on the oracle executable.
Make sure the sticky bit is set.
eg:


-rwsr-s---   1 oracle    dba        75347704 Jul 14 14:14 oracle

In this example, world has no execute privileges on the oracle executable, so you either need to be the oracle user, or belong to the dba group.

Another thing to check is the hidden directory, mostly located at /tmp/.oracle or /var/tmp/.oracle .

Should these have the incorrect privileges, you probably will get the ORA-12546 error as well.

Welcome to our forum for Oracle error: ORA-12546 Add your own message

On 04-JUN-2008 13:52:59 akhil mahajan asked: cursor caching

can anyone explain cursor caching?
wat happens when a cursor is cached? Is it closed when we switch over to the new form?
if it is closed,then whats the benefit of cachin the cursor as memory is deallocated when the cursor is closed.

On 13-JUN-2008 15:40:39 Eric Ibekwe asked: Oracle 10g installation

While installtion oracle 10g on my system, I checked for it to creat a starter database but when it got to the database configuration assistant to create the database, this error ORA-12546: TNS permission denied came up and till now, it is still preventing me from creating the database

On 13-JUN-2008 15:43:31 DbMotive replied

Check your listener.log file, it will contain an additional error.

Do you have a firewall running on your system?

On 26-JUN-2008 11:25:41 Ervin asked: getting ORA-12546 when trying to connect sqlplus for dos and Toad to OracleXE (running on windows XP home)

I managed to install succesfully OracleXE on my home computer running windows XP home. I can connect to the database using the oracle forms builder, oracle reports builder and the sqlplus for windows, but I cannot connect using the dos sqlplus or using other utilites like Toad.

Initially I managed to get sqlplus for dos running and I could run my scripts and create all my tables, triggers ...etc succesfully. Later I disconnected from the internet (I'm temporarily using a dial-up connection to AOL until I set my ADSL2). Then, later on, I closed the dos window and when I reopenned and tried to connect again to the database using sqlplus and I could not connect anymore and I keep getting ORA-12546.

I modified the listener.ora and the tnsnames.ora (in both locations: Oracle XE and the developer suite) and I ensured that all had the host pointing to 127.0.0.1 It didn't seem to help. Again, only the forms, reports and sqlplus for windows (the dev suite) are working.

What went wrong? Can someone please help? I only have very limited (minimal) experience installing and configuring an oracle database. Many thanks.

On 26-JUN-2008 11:30:41 DbMotive replied

You did the corrective action.

When connected to the internet when you install Oracle software, the ip address of the internet connection will be in your listener.ora and tnsnames.ora files.

You have to change them to 127.0.0.1 in order to let it work.

Because you have both a database and developer suite, you probably have 2 different Oracle Homes where these changes need to be made.

You can download our free tool "Oracle Locator Express" to see how many Oracle homes you have, and than make all the changes to all the files

On 26-JUN-2008 11:30:26 Ervin asked: getting ORA-12546 when trying to connect sqlplus for dos and Toad to OracleXE (running on windows XP home)

On 12-AUG-2008 21:30:35 eric A ibekwe asked: Installing Oracle 10g

While installing oracle 10g on 3400x IBM server, I got this error message:

Error in writing to file D:\oracle\product\10.1.0\javavm\admin\classes.bin (invalid entry size 62208454 but got 62210787 bytes)

how do i correct this

On 19-DEC-2008 20:41:43 vijay prajapati asked: TNS Permission Denied on windows vista

I have managed to install Oracle 10g on windows vista but when i'm trying to connect and start instance it show me permission error. Which file should i have to give permission? i have set security of Bin folder in oracle to everyone with full control but same error. please help me, this error really frustrating me :(.

On 01-FEB-2009 09:56:58 ipsita replied

I have managed to install Oracle 10g on windows vista but when i'm trying to connect and start instance it show me TNS permissiondenied .please inform me what to do next?

On 19-DEC-2008 21:06:06 vijay prajapati asked: TNS Permission Denied on windows vista

On 02-MAY-2009 14:51:21 mahe asked:

On 04-MAY-2009 20:42:32 DbMotive replied

Can you post the last entries of your %ORACLE_HOME%/network/log/listener.log file.
This will contain additional info needed to solve this error

On 25-SEP-2009 20:10:35 Sollyk asked: ORA-12546: TNS:permission denied

While trying to install Oracle10g on my vista it gives me, "ORA-12546: TNS:permission denied "
at Database configuration Assistant.

On 28-SEP-2009 02:34:36 DbMotive replied

You are probably installing Oracle as a user without the correct administrative privileges.

When you install Oracle, it need to listen to some sockets. The sockets can only be created if you have the correct privileges.

On 13-OCT-2009 03:28:11 Sollyk replied

What administrative privileges do i need on pc? Or you mean @ oracle instance.

On 13-OCT-2009 09:54:50 DbMotive replied

You need to be a local administrator on your pc in order to install Oracle.

Privileges needed are 'logon as a service' amongst others.

On 24-DEC-2009 11:19:23 Shamsul Alam Rony replied

I added the user as a administrator of local computer and the user is also domain administrator but still getting same message.

On 24-DEC-2009 11:24:23 DbMotive replied

And are you using this user to start the Oracle services?

In order to find out, open the services control panel, right click on the service, choose properties, next click on the 'Log On' tab.

You have 2 options, either the 'Local System Administrator' is used, or you can overrule with another privileged user.

If you overruled the user, does this user have the necessary admin privileges?

On 26-DEC-2009 05:20:30 Shamsul Alam Rony replied

Actually when i m going to install Oracle i m getting the error message.

My OS is windows server 2003, i m not using linux based OS. i tried to install as local administrator.

On 03-MAR-2010 17:18:02 Nash asked: Oracle XE home page could'nt launch/Listener not working properly

Hello Sir

I installed Oracle 10g XE on my laptop and struggling to make it work, no issue with installation but cant launch database home page – receiving page not found error (http://127.0.0.1:8080/apex) I changed 127.0.0.1 to localhost but same problem. There is no other instance of Oracle running on my PC.
My PC info:-
OS - Windows XP, SP3
Memory – 1.99 GB
HD Available Space -62 GB
User – Administrator, member of ORA_DBA group (can change PC name and registry values)

I can start all oracle related services except OracleXETNSListener

"The OracleXETNSListener service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

When I try to start from command prompt using lsnrctl start, I am getting following error.

C:\Documents and Settings\me>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-MAR-2010 12:19
:05
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\AD
MIN\listener.ora
Log messages written to C:\oraclexe\app\oracle\product\10.2.0\server\network\log
\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR
_XEipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TCT_PC)(PORT=1521)
))
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 13: Permission denied

Listener failed to start. See the error message(s) above...

*If I change host name from HOST=TCT_PC to HOST=localhost, listener starts but cannot launch home page. After I make changes I am getting following status with no XE instance.*
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\me>lsnrctl stat
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-MAR-2010 15:30
:00

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date                02-MAR-2010 15:27:05
Uptime                    0 days 0 hr. 2 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\A
DMIN\listener.ora
Listener Log File         C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRI

On 03-MAR-2010 17:26:19 Nash replied

Continue.....

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

I have downloade Oracle Locator Exp. - Its finding only on ORACLE_HOME, I also download Oracle Listener Remover - Finding only one listener.

I hope some one can help me, I have been searching other forum but couldn’t find solution on similar to my case, appreciate your time and efforts. Thanks

On 04-MAR-2010 08:31:52 DbMotive replied

As for the dns part:

Did you install XE when connected to internet? Sometime a different ip address is used.
When you open a command prompt and do ping TCT_PC, does it match the correc ip address?

Can you also send the listener.ora, sqlnet.ora and tnsnames.ora located in %ORACLE_HOME%/network/admin to support@dbmotive.com, if they exist.

Can you logon as sysdba and give the result of local_listener:

sqlplus "/ as sysdba"

show parameter local_listener

Can you also provide the info of the listener ports (still connected as sysdba):

select dbms_xdb.gethttpport, dbms_xdb.getftpport from dual;

Also, please provide the info of the command (run on dos command prompt):

lsnrctl services

On 05-MAR-2010 01:52:45 Nash replied

Thanks for quick reply, here are the results, I emailed you result of ping and listener.ora, sqlnet.ora and tnsnames.ora files to support email. Thanks

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 4 19:39:10 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect sys as sysdba
Enter password:
Connected.

SQL> show parameter local_listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string

SQL> select dbms_xdb.gethttpport, dbms_xdb.getftpport from dual;

GETHTTPPORT GETFTPPORT
----------- ----------
       8080          0

C:\Documents and Settings\me>lsnrctl services

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-MAR-2010 19:51
:35

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1002 state:ready
         DISPATCHER <machine: TCT_PC, pid: 3188>
         (ADDRESS=(PROTOCOL=tcp)(HOST=TCT_PC.TCTGROUP)(PORT=1027))
Service "XE_XPT" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
The command completed successfully

On 05-MAR-2010 08:47:35 DbMotive replied

Can you also please post the result of following query:

select * from v$parameter where name='dispatchers';

On 05-MAR-2010 16:13:19 Nash replied

Here is the result

SQL> connect sys as sysdba
Enter password:
Connected.
SQL> select *from v$parameter where name='dispatchers';

       NUM
----------
NAME
--------------------------------------------------------------------------------

      TYPE
----------
VALUE
--------------------------------------------------------------------------------

DISPLAY_VALUE
--------------------------------------------------------------------------------

ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------

UPDATE_COMMENT
--------------------------------------------------------------------------------

      HASH
----------
       797

       NUM
----------
NAME
--------------------------------------------------------------------------------

      TYPE
----------
VALUE
--------------------------------------------------------------------------------

DISPLAY_VALUE
--------------------------------------------------------------------------------

ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------

UPDATE_COMMENT
--------------------------------------------------------------------------------

      HASH
----------
dispatchers

       NUM
----------
NAME
--------------------------------------------------------------------------------

      TYPE
----------
VALUE
--------------------------------------------------------------------------------

DISPLAY_VALUE
--------------------------------------------------------------------------------

ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------

UPDATE_COMMENT
--------------------------------------------------------------------------------

      HASH
----------
         2

       NUM
----------
NAME
--------------------------------------------------------------------------------

      TYPE
----------
VALUE
--------------------------------------------------------------------------------

DISPLAY_VALUE
--------------------------------------------------------------------------------

ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------

UPDATE_COMMENT
--------------------------------------------------------------------------------

      HASH
----------
(PROTOCOL=TCP) (SERVICE=XEXDB)

       NUM
----------
NAME
--------------------------------------------------------------------------------

      TYPE
----------
VALUE
---------------------------------------------------------------------------

On 05-MAR-2010 16:17:59 Nash replied

Continue......

DISPLAY_VALUE
--------------------------------------------------------------------------------

ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------

UPDATE_COMMENT
--------------------------------------------------------------------------------

      HASH
----------
(PROTOCOL=TCP) (SERVICE=XEXDB)

       NUM
----------
NAME
--------------------------------------------------------------------------------

      TYPE
----------
VALUE
--------------------------------------------------------------------------------

DISPLAY_VALUE
--------------------------------------------------------------------------------

ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------

UPDATE_COMMENT
--------------------------------------------------------------------------------

      HASH
----------
FALSE     FALSE IMMEDIATE TRUE FALSE      FALSE FALSE

       NUM
----------
NAME
--------------------------------------------------------------------------------

      TYPE
----------
VALUE
--------------------------------------------------------------------------------

DISPLAY_VALUE
--------------------------------------------------------------------------------

ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------

UPDATE_COMMENT
--------------------------------------------------------------------------------

      HASH
----------
specifications of dispatchers

       NUM
----------
NAME
--------------------------------------------------------------------------------

      TYPE
----------
VALUE
--------------------------------------------------------------------------------

DISPLAY_VALUE
--------------------------------------------------------------------------------

ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------

UPDATE_COMMENT
--------------------------------------------------------------------------------

      HASH
----------

       NUM
----------
NAME
--------------------------------------------------------------------------------

      TYPE
----------
VALUE
--------------------------------------------------------------------------------

DISPLAY_VALUE
--------------------------------------------------------------------------------

ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------

UPDATE_COMMENT
--------------------------------------

On 05-MAR-2010 16:24:39 Nash replied

Continue......

      HASH

----------

2044337135

       NUM

----------

NAME

--------------------------------------------------------------------------------

      TYPE

----------

VALUE

--------------------------------------------------------------------------------

DISPLAY_VALUE

--------------------------------------------------------------------------------

ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP

--------- ----- --------- ----- ---------- ----- -----

DESCRIPTION

--------------------------------------------------------------------------------

UPDATE_COMMENT

--------------------------------------------------------------------------------

      HASH

----------

SQL>

On 08-APR-2010 14:50:18 Manish replied

Hi All,

Even I'm facing exactly the same problem with OracleXETNSlistener as Nash's one.
Kindly help me with this issue.

Thanks,

Manish

On 05-MAY-2010 07:49:30 chilembo asked: TNS: PERMISSION DENIED

I have installed oracle database 10g now connecting to it using Oracle SQL*plus flags the error,"permission denied" when I key in the username, password and host string but connects by keying in the password and username without the host string. what could be wrong the host string.

can I be assisted please.

On 29-JUN-2010 04:52:54 Kadhir asked: Oracle 10g installation on Windows 7 Ultimate

Hi,

I tried installing Oracle 10g (10.1.0) on Windows 7 Ultimate. I was able to install Oracle software, managing all initial roadblocks (Ran as Administrator and XP compatibility mode). While creating the instance and database using DBCA tool, I face problem. The DBCA tool receives all parameters, while actually trying to create it, it throws "ORA-12546 TNS: Permission Denied" error.

what is wrong here ? How to go about it ? Please suggest.

Thanks.

On 12-JUL-2010 16:34:21 Ramanath yadav asked: oracle 10g instalation error

while i was instaling oracle 10g i got tns:denied error.what is the problom in instaling?

On 25-AUG-2010 09:12:27 ihtsham asked: Is there any one who can give positive to the point solution

i am facing following problem when i start listener in widows services

"The OracleXETNSListener service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and Alerts service."

On 26-AUG-2010 12:48:42 DbMotive replied

In your %ORACLE_HOME%/network/log directory, there will be a log file.

It will probably contain extra information as for why the listener stopped working.

Also, if you have some kind of firewall software, check that there are no policies preventing the listener from starting up/staying up

Add your message

Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.

Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.

Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.