lsnrctl

How to Duplicate a 19c Physical Standby Database

by Ed Chen
August 11, 2019March 9, 2020
2 Comments

You don't have to create an empty database on the standby server for building a standby database. In this post, I will show you how… Read More »

Where is Oracle Listener Log Location

by Ed Chen
April 18, 2019July 6, 2019
3 Comments

The Default Location of Oracle Listener Log If you have read Where to Find Oracle Alert Log Location, you may have some clues to find… Read More »

How to Resolve TNS-12541: TNS:no listener

by Ed Chen
February 13, 2019September 11, 2019
8 Comments

How to Resolve TNS-12546: TNS:permission denied + Solaris Error: 13: Permission denied

by Ed Chen
February 10, 2018May 13, 2019
4 Comments

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

sqlplus, tnsping or lsnrctl Hangs

by Ed Chen
April 9, 2017May 30, 2019

sqlplus, tnsping or lsnrctl Hangs I can't cover all situations in this post, but I have some cases that can share with you. Those hanging… Read More »

How to Resolve The listener supports no services

by Ed Chen
November 5, 2016January 29, 2020
22 Comments

The listener supports no services I newly created a database called SMALLDB, but I can't see any service registered with the new LISTENER2 which is… Read More »

How to Know Everything about an Unfamiliar Database

by Ed Chen
June 14, 2016August 3, 2018

In an unfamiliar environment, if there's only oracle or grid account is available for DBA to use, how can he to know everything about the database… Read More »

When Listener Seems Not Working in RAC

by Ed Chen
June 5, 2016August 3, 2018

You may found out the listener seems not working:[oracle@primary01 ~]$ lsnrctl statusLSNRCTL for Linux: Version 12.1.0.2.0 - Production on 05-JUN-2016 19:40:08Copyright (c) 1991, 2014, Oracle.… Read More »