Folks,
Hello. I installed Oracle Database 11gR2 Server in Oracle Linux 5 Virtual Machine with starter Database Instance PT853. Then I installed Oracle Database 11gR2 client for 32-bit Windows in my 64-bit Windows XP Virtual Machine. Now, I confront 2 VMs' connection issue as below:
In Linux Server Machine Net Manager:
Service Name: PT853
Connection Type: Database Default
Protocol" TCP/IP
Host Name: localhost.localdomain
Port Name: 1521
Listener: LISTENER
Protocol: TCP/IP
Host: localhost.localdomain
Port: 1521
I test the Service PT853 using UserID "SYSADM" and Password "SYSADM". The connection is successful.
In Windows XP Client machine, the information in Net Manager is the same, but the connection is not successful. Its details are as below:
Net Service Name: PT853
Protocol: TCP/IP
Host name of Database Machine: localhost.localdomain
Port Number: 1521
Database Service Name: PT853
Connection Type: Database Default
I test the Service using UserID "SYSADM" and Password "SYSADM" that are the same with Linux, but get this error: TNS: listener does not currently know of service requested in connect descriptor.
I follow this tutorial http://www.vmware.com/support/ws5/doc/ws_devices_serial_2vms.html to configure 2 VMs in Windows 7 Host machine.
In Windows XP Oracle Database Client Install Directory, the file "tnsnames.ora" has one entry that is the Service Name in Net Manager. In Linux Oracle Database Server install directory, the file "tnsnames.ora" has no entries because I installed Oracle Database Server with the starter Database instance PT853.
I have tried to test 2 VMs in the way as below:
In Linux, [user@localhost ~]$ping WindowsXP_HostName
Its output: unknown host WindowsXP_HostName
In Windows XP Command Prompt:
C:\ping localhost.localdomain
Its output: pinging localhost.localdomain 127.0.0.1 with 32 bytes of data...
Reply from 127.0.0.1: bytes=32 time=2ms, TTL=128
It replies a few times and then disconnected by itself. It seems that Windows XP is pinging itself and not Linux Server. The hostname of Linux Server is "localhost.localdomain" as well. It's a kind of confusing to me.
From the above infromation, we can see 2 VMs cannot connect with each other. Net Manager in Windows XP Oracle Client cannot connect its Service PT853 with Oracle Database Server in Linux.
My question is:
Can any folk tell me how to connect Oracle Client in Windows XP with Oracle Database Server in Linux ?
Very grateful in advanced.