How to Run NETCA in Silent Mode
By design, we split the entire installation into several clear sections and make the job easy to troubleshoot. Install Oracle Software Only in Silent Mode… Read More »How to Run NETCA in Silent Mode
listener.ora
How to Set Multiple Listeners in Database
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 Set Multiple Listeners in Database
How to Resolve TNS-01201: Listener cannot find executable
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 TNS-01201: Listener cannot find executable
How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect
ORA-12505 ORA-12505 means that the SID you provided in the connect identifier does not match any SID registered with the listener. Basically, SID means $ORACLE_SID,… Read More »How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect
How to Configure SID_LIST_LISTENER Static Listener
SID_LIST_LISTENER Dynamic service is a representative which is registered with the listener when the instance is up and running on the server, whereas static service… Read More »How to Configure SID_LIST_LISTENER Static Listener
How Oracle Auto Start Database in Solaris
For Linux Os, you should check this post: How to Auto Start Oracle Database on Linux. Assuming that you already have some knowledge about how… Read More »How Oracle Auto Start Database in Solaris
How Oracle Auto Start Database in Linux
For Solaris OS, you should check this post: How to Auto Start Oracle Database on Solaris. Assuming that you already have some knowledge about how… Read More »How Oracle Auto Start Database in Linux
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 Add a Public IP Address to Grid
Strictly speaking, adding a public IP to server at OS-level is no problem, but you can't add any public IP to join any node of… Read More »How to Add a Public IP Address to Grid