Folks,
Hello. I installed Oracle Database Server 11gR2 in the Operating System Oracle Linux 5.
All clients (NetCA, DBCA, SOL Deveoper, SQL Plus ...) run on Database Server correctly. The listener LISTENER_PT853 is listening on the Client Tools in Linux successfully.
I also installed Oracle Database Client(SQL Developer, NetMgr, NetCA, sqlplus, ...) in Windows XP. In order for the Client Tools to login into the Database Server in Linux, the listener in Linux need to be listening on the service in Windows XP.
In Oracle Linux 5 Server Machine Net Manager:
Service Name: PT853
Connection Type: Database Default
Protocol" TCP/IP
Host Name: 192.168.196.102
Port : 1521
Listener: LISTENER_PT853
Protocol: TCP/IP
Host: 192.168.196.102
Port: 1521
I test the Service PT853 using UserID "SYS" and Password "SYS". The connection is successful.
In Windows XP Client machine, the information in Net Manager is below:
Service Name: PT853_Linux
Protocol: TCP/IP
Host name of Database Machine: 192.168.196.102
Port : 1521
I test the connection using UserID "SYS" and Password "SYS" and got this error: ORA-12514:TNS: listener does not currently know of service requested in connect descriptor. There may be an error in the fields entered or server may be ready for connection.
Then I check the listener status in Linux Server machine as below:
[user@localhost bin]$./lsnrctl status LISTENER_PT853
Its output: Service PT853 has 1 instance. Instance PT853, status READY, has 1 handler for this service.
From the above, we have seen the listener in Linux Server machine only listen to the service PT853 in Linux but not listen to the service PT853_linux in Windows XP client machine.
Both Windows XP(192.168.196.101) and Linux(192.168.196.102) can ping each other successfully. In order for Client Tools in Windows XP login into Database Server in Linux, the listener in Linux need to listen on the service in Windows XP at first.
In Linux Net Manager, I add one more address(TCP/IP, 192.168.196.101, PORT 1521) to LISTENER_PT853 but gets error.
My question is:
How to have the Listener in Linux Database Server listen to the service in Net Manager in Windows XP Client ?
Thanks in advance.