How to solve ORA-12541- TNS- no listener problem
I Get The Ora-12541 Error Message When I Try To Connect Via Forms And Reports Builder. I Have Also Started The Audience. I Have No Problem Accessing The Database With SQL * Plus. I Checked The Listener.ora And Tnsnames.ora Files And Everything Seems To Be Fine.
From The Document:
Ora-12541: TNS Has No Listeners
Reason: The Listener Was Not Started For The Source Repository.
Action: Start The Listener On The Machine Where The Source Is Stored.
Originally, The Form Server Could Not Find The Listener. First Check The Tnsnames.ora File And Make Sure It Points To The Correct Server And Port. If The Form Server Is On Another Machine, Check The TNS Solution Via Tnsping From The Command Prompt. Finally, Check The Audience.
Steps To How to solve ORA-12541- TNS- no listener problem
Step 1 - Edit listener.ora
This file is located in:
Windows: %ORACLE_HOME%\network\admin\listener.ora.
Linux: $ORACLE_HOME/network/admin/listener.ora
Replace localhost with 0.0.0.0
# ...
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
)
)
# ...Step 2 - Restart Oracle services
Windows: WinKey + r
services.msc
Linux (CentOs):
sudo systemctl restart oracle-xe
🔗 Demo Application-
URL- Demo Application
Username - demo, Pass- demo
I hope everyone will like it. Please watch the full video,
Comment on any of your problems, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
Please stay tuned by subscribing to the YouTube channel, and encourages new videos to be uploaded.
=================
Visit my site to get more collaborative posts about Oracle Apex and subscribe to my YouTube channel. Thanks.
Comment on any of your issues, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable.
Visit my blog site, new technology-related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
==============================
🙍🏾 Md jABER HOSSEN
📲 Mobile- +8801760688286
📨 Email- jaberit786@gmail.com
🌐 FB- facebook.com/mdjaber.hossen1
Please Subscribe to My Channel
Many thanks for visiting the site.
Then Enjoy.........................