How RMAN Duplicate 19c 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 RMAN Duplicate 19c 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 ORA-12541: TNS:no listener
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 to Resolve ORA-12541: TNS:no listener
How to Resolve TNS-12546 Error Message
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 »How to Resolve TNS-12546 Error Message
Why Tnsping Hang
sqlplus, tnsping or lsnrctl Hangs I can't cover all situations in this post, but I have some cases to share with you. Those hanging all… Read More »Why Tnsping Hang
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
What Oracle Command-line Utilities Need Authentication - Oracle
Oracle provides many utilities to operate the infrastructure and database. Some of them need authentications to access database, but some don't. The bottom line is… Read More »What Oracle Command-line Utilities Need Authentication - Oracle
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