How to Duplicate a 19c Physical Standby Database
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 »How to Duplicate a 19c Physical Standby Database
lsnrctl
Where is Oracle Listener Log Location
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 »Where is Oracle Listener Log Location
How to Resolve TNS-12541: TNS:no listener
TNS-12541 Let’s see how we reproduce TNS-12541. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 - Production on 22-JUL-2014 19:20:06 Copyright (c) 1997,… Read More »How to Resolve TNS-12541: TNS:no listener
How to Resolve TNS-12546: TNS:permission denied + Solaris Error: 13: Permission denied
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 »How to Resolve TNS-12546: TNS:permission denied + Solaris Error: 13: Permission denied
sqlplus, tnsping or lsnrctl Hangs
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 »sqlplus, tnsping or lsnrctl Hangs
How to Resolve The listener supports no services
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 Resolve The listener supports no services
How to Know Everything about an Unfamiliar Database
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 »How to Know Everything about an Unfamiliar Database
When Listener Seems Not Working in RAC
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 »When Listener Seems Not Working in RAC
How to Set Password for Listener
Earlier databases like 9i should set password for listeners, otherwise, they could be accidentally stopped by someone unknown. Here in this post, I will introduce… Read More »How to Set Password for Listener