ora - 12514 and ora - 12505 tns listener error fixed ✅

Summary

In this tutorial, the presenter shares a solution to the 'or, 12515' and 'or, 12505' errors. They explain how to resolve these issues by checking the local listener, which was found to be empty. The solution involves using the 'alter system set' command to dynamically adjust listeners settings and then registering them with the 'alter system register' command. The presenter demonstrates that after these steps, the errors are resolved, and they can successfully connect. They conclude by encouraging viewers to subscribe for more helpful content.

Takeaways

• 😕 The speaker encountered an 'or, 12515' and 'or, 12505' error.
• 🔍 They initially checked the local listener, which was empty.
• 🛠️ To resolve the issue, they used the 'alter system set' command to adjust the dynamic listeners setting.
• 📡 After setting the system, they used the 'alter system register' command to register the listener.
• 💡 The error was resolved after these steps, and the system was functioning correctly.
• 📱 The speaker was then able to connect successfully.
• 🎉 The speaker thanks the viewers for watching and encourages them to subscribe for future content.
• 👨‍💻 The issue was resolved by modifying system settings, indicating a technical approach to troubleshooting.
• 🔑 The use of specific commands suggests that the speaker has a good understanding of system administration.
• 📝 The script serves as a tutorial for others facing similar issues, providing a step-by-step guide.

Q & A

What were the error codes mentioned in the transcript?

The error codes mentioned were ORA-12515 and ORA-12505.

What was the initial condition before the error occurred?

Everything was working perfectly fine before the error occurred.

What was the first step taken to troubleshoot the error?

The first step was to check the local listener.

What was the status of the local listener when checked?

The local listener was empty.

What command was used to check the local listener?

The command used was 'show parameter local listener'.

What action was taken to resolve the issue?

The issue was resolved by altering the system and setting the dynamic listeners.

What was the specific command used to alter the system?

The specific command used was 'alter system set' followed by the dynamic listeners setting.

How was the system registered after the alteration?

The system was registered using the 'alter system register' command.

What was the outcome after the commands were executed?

After executing the commands, everything was okay, and the user was able to connect successfully.

What was the final message to the viewers?

The final message was a request to subscribe to the channel for future content.

What does ORA-12515 and ORA-12505 typically indicate?

ORA-12515 typically indicates that the listener does not have the requested service handler, while ORA-12505 indicates that the listener was refused the connection.