Set Menu To User Access Role, User Authentication, Part-6

How to Resolve ORA-12514 TNS. listener does not currently

We saw ORA-12514 after we tried to start the closed database. Here's why: When you close the instance, you lost connection to the database and the service from the listener was unregistered, there is no more service information in the database on the listener. Therefore, ORA-12514 notifies you that you will not be able to do any more work in this database.

Solution... Database 19c

Steps How To Solution ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Database 19c.

You need to set Oracle to listen to all IP addresses (by default, it only listens to localhost connections.)

1. You may need to edit the listener.ora file in your database.

This file is located at:
Windows: %ORACLE_HOME%\network\ admin\listener.ora.

2. Replace the localhost with 0.0.0.0

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

3. Restart Oracle services

Open Windows Run Box, click- Windows + R.
Enter- services.msc and click on enter button

Restart the listener by command:

SQL- lsnrctl stop SQL- lsnrctl start

alter system set local_listener = '(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))' scope=memory;
alter system register;

LOG_DIRECTORY_CLIENT = d:\Apps\Ora81\network\log

2nd Solution... Database 19c

1. First, open the CMD window on your computer.

2. Check lsnrctl status.

3. Check tnsping ora11g.

4. Check your listener.ora And tnsnames.ora files.

# tnsnames.ora Network Configuration File: D:\db_home\NETWORK\ADMIN\tnsnames.ora # listener.ora Network Configuration File: D:\db_home\NETWORK\ADMIN\tnsnames.ora

5. Connect your database,

SQL- Sqlplus / As Sysdba

6. Check the service name of the database 19c

SQL- show parameter service_names OR select value from v$parameter where name='service_names';

7. We can definitely check a parameter named LOCAL_LISTENER:

SQL- show parameter local_listener

 

 

🔗 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.........................