Listener

How to Resolve ORA-00132: syntax error or unresolved network name

by Ed Chen
March 31, 2023March 27, 2023

ORA-00132 Found error ORA-00132 in the alert log, when we're starting up a database. 2023-03-01T22:41:54.802021-05:00 WARNING: Invalid value for listener related parameter MIXED LISTENER 2023-03-01T22:41:54.803545-05:00… Read More »

Alter System set Local_Listener Multiple Examples

by Ed Chen
November 24, 2022June 27, 2023

Multiple Listeners in LOCAL_LISTENER Theoretically, you don't have to configure parameters related to listener in database, neither LOCAL_LISTENER nor REMOTE_LISTENER. A background process, Listener Registration… Read More »

How to Resolve ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

by Ed Chen
April 13, 2022June 1, 2023
2 Comments

ORA-01035 Tried to connect to a database in restricted mode, but it failed with ORA-01035. C:\Users\ed>sqlplus hr/hr@ORCL ... ERROR: ORA-01035: ORACLE only available to users… Read More »

How to Resolve TNS-01201: Listener cannot find executable

by Ed Chen
October 11, 2021June 8, 2022

TNS-01201 After adding a static service to the local listener, I tried to start the listener, but it failed with TNS-01201. [oracle@test ~]$ vi $ORACLE_HOME/network/admin/listener.ora… Read More »

How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect

by Ed Chen
February 14, 2019August 18, 2023
28 Comments

ORA-12514 ORA-12514 means that the listener cannot find any matched service with yours, so it cannot establish the connection with the database for you. As… Read More »

How to Resolve ORA-12541: TNS:no listener

by Ed Chen
February 13, 2019August 15, 2023
10 Comments

ORA-12541 and TNS-12541 ORA-12541 is the same as TNS-12541, they all indicate that the listener is not running according to your specified destination. Let’s see… Read More »

How Oracle Disable Restricted Mode

by Ed Chen
October 11, 2018December 20, 2022

Disable Restricted Mode After you have done your jobs in restricted mode, you may consider to leave the mode. Disabling restricted mode means that we… Read More »

How Oracle Enable Restricted Mode

by Ed Chen
October 10, 2018April 9, 2022

Enable Restricted Mode Restricted mode is a mode that only allow users who have RESTRICTED SESSION or SYSDBA system privilege to connect to the database.… Read More »

TNS-01194: The listener command did not arrive in a secure transport

by Ed Chen
August 5, 2018October 3, 2021

TNS-01194 After adding SECURE_REGISTER_LISTENER to the listener.ora to prevent TNS Listener remote poisoning, we found TNS-01194 in the listener log of the server. Let's check… Read More »

How to Resolve TNS-12546 Error Message

by Ed Chen
February 10, 2018October 3, 2021
4 Comments

TNS-12546: TNS:permission denied I got TNS-12546 when I tried to start the listener as oracle. oracle@solaris11vm:~$ lsnrctl startLSNRCTL for Solaris: Version 11.2.0.4.0 - Production on… Read More »

JavaScript is not enabled. Please enable it and reload the page.