Hi all,
I have a Windows 11 Pro machine with 32GB memory and 6TB hard drive running VMware Workstation 17.
I have created an Oracle Linux 9.5 virtual machine with 8GB memory and 100GB hard drive and installed Oracle Database 23ai using the preinstall RPM, the database RPM and finally run the configuration step as per Oracle Database 23ai installation guide. I am using the default database port 1521. I have successfully created and populated tables in the FREEPDB1 (default) database using the sqlplus command on the localhost.
I have created a Windows 11 Pro virtual machine with 8GB memory and 100GB hard drive and installed Oracle Instant Client (baselite, SDK & sqlplus) and added the installation to PATH.
When I attempt to connect to the database using sqlplus with easy connect naming (sqlplus user/password@//host:1521/FREEPDB1) to attempt to access the tables that I have created, I get the error ORA-12170 TCP connection error on the database server IP address and 1521 port.
Am I missing something. Am I supposed to configure the firewall on the Oracle Linux side or the Windows side?
Does anyone know how to fix this issue?
Thanks in advance for any assistance.