Access Oracle 19 Database on VM Windows Server 2022 on Azure

Jörg Riedmiller 21 Reputation points
2022-04-29T09:18:27.787+00:00

I started a Windows 2022 server on Azure, installed Oracle 19c database on this VM
The database is running, listner is running
I can access the database local on the server

but when I try to access the database from an other machine I get TNS-12541: TNS Kein Listener !!

In Defender Firewall I entered TNSLSNR.exe and oracle.exe to be accessed from outside.
Event when I turn off Defender Firewall on the server I get this error.

What do I have to configure how that I can access the oracle 19c database on a VM Windows Sever2022 in Azure?

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,365 questions
0 comments No comments
{count} votes

Accepted answer
  1. deherman-MSFT 37,851 Reputation points Microsoft Employee
    2022-05-03T20:03:57.493+00:00

    @Jörg Riedmiller
    Apologies for the delayed response. Since you are getting a response when attempting to connect with Oracle the issue does not appear to be related to Azure or the networking security groups or firewall.

    I found this information on the Oracle documentation
    "TNS-12541 or ORA-12541: TNS:No Listener
    These messages indicate that the connection request could not be completed because the listener is not running.

    Perform the following actions:

    Ensure the supplied destination address matches one of the addresses used by the listener.

    Verify the listener is running at the address specified by the request.

    Ensure the listener is listening on the host and port specified by the request.

    Verify the client is pointing to the listener."

    Since this is related to the Oracle specific configuration I recommend reaching out to Oracle Support or posting on a forum such as Stack Exchange.

    -------------------------------

    Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.