Cannot access Oracle12c Database from outside the AzureVM, can connect inside VM

SKR 1 Reputation point
2020-08-24T18:44:58.037+00:00

Dear Friends,

I Installed Oracle 12c in Azure VM (Windows server 2012r2). I did all configuration steps and I can access my Oracle instance from inside the VM, including the Oracle Enterprise Manager.

But i can not connect/access outside the VM.

URL: https://VMmachineName.xxxxxxxxxxxxxxxx.cx.internal.cloudapp.net:5500/em
Oracle Port 1521

(1).Set firewall New inbound rule in my VM, for port 1521.
(2).I have created inbound rule in my VM portal for 1521 and 5500

Ports are open,

Still can not access oracle database outside AzureVM
Please help me solve this issue.

Already there is one thread for same issue, is not working
https://social.msdn.microsoft.com/Forums/en-US/bb352d38-6957-4288-9f78-09f6c96c2a73/cannot-access-oracle-enterprise-manager-from-outside-the-vm?forum=WAVirtualMachinesforWindows

Please
Thanks

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,085 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. vipullag-MSFT 23,946 Reputation points Microsoft Employee
    2020-08-25T07:43:30.577+00:00

    @SKR

    Firstly, apologies for the delay in responding on this and any inconvenience this issue may have caused.

    Based on the port information shared, from this Azure documentation, I see that 1521 and 5502 ports need to be opened.

    To quickly check if the required ports are open as expected, you can quickly check using this tool. Please check if the public IP is opened the required ports. If you see the result as closed, the the NSG is not setup properly or there is any firewall blocking this access on your end.

    Please follow this document and let us know if you are still facing issue in accessing.

    Hope this helps.

    Please 'Accept as answer' if it helped, so that it can help others in the community looking for help on similar topics.

    1 person found this answer helpful.
    0 comments
  2. u201710729 (Luna Pino, Marcos Augusto) 6 Reputation points
    2021-03-17T02:29:15.28+00:00

    I had the same problem with the database and after several hours I solved it by editing the file listener.ora. Change "(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))" to "(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))".

    78500-oracle-listener.png
    Don't forget to restart the server.
    I hope the input helps.

    1 person found this answer helpful.
  3. SKR 1 Reputation point
    2020-08-25T10:50:35.407+00:00

    Dear Vipula,

    I already checked , port are open,
    as i said in first thread,
    (1) set firewall inbound rule in VM machine for 1521
    (2).In my VM portal (Public ip) i inserted inbound rule for 1521 and 5500.

    I really i did not understand what went wrong,
    I can connect database inside the VM perfectly both cantainer and pluggable database working , no issue at all

    Please
    Thanks