search

utmapp / UTM

Virtual machines for iOS and macOS
https://getutm.app
Apache License 2.0
25.7k stars 1.3k forks source link

Unable to access oracle database installed on UTM windows 11 #5442

Closed CSEKU160212 closed 1 year ago

CSEKU160212 commented 1 year ago

I have installed the Oracle database on the virtual Windows 11.

I have found below IP address on the Windows virtual machine:

Screenshot 2023-07-09 at 12 50 38 PM

The IP address is: 192.168.102.158

From the Mac host, I can ping the address. Below is the ping result.

Screenshot 2023-07-09 at 12 52 45 PM

And the networking configuration for my virtual windows:

Screenshot 2023-07-09 at 12 48 07 PM

But when I want to access 1521 port from my host pc then the connection got refused. I can't be able to access Oracle database from the host SQLDeveloper. Here is the result:

Screenshot 2023-07-09 at 12 54 42 PM

Please help me to solve the issue.

Also, checked the Oracle database using sqlplus on the virtual windows and found okay. also windows firewall is deactivated.

CSEKU160212 commented 1 year ago

Now it is working. I had to change "localhost" to the windows machine IP on listener.ora and tnsnames.ora files.

BaneSameer commented 8 months ago

@CSEKU160212 I've changed localhost to IP address in both tnsnames.ora and listener.ora (in Virtual Machine Windows 11) Also, I'm able to ping my virtual machine windows 11 (Using UTM) from Mac OS machine. I'm using Oracle SQL Developer (Version 23.1.0.097) in MacBook Pro. Still, I'm getting error as "The Network Adaptor could not establish the connection" Do we need to configure tnsnames.ora or listener.ora in Mac OS? Could you please help me on this?