Unanswered: config Listener.ora and Tnsnames.ora ?
I'm a new in Oracle DB. I'm using Windows 2000 as server and Windows XP as client. I installed Oracle Enterprise on server and Oracle 8.1 on clients.
I have some client with 2 different IP address, 172.16.xx.xx and 192.168.xxx.xx whices I want to connect to the server DB. How can I set the Listener.ora & Tnsnames.ora so all clients could connect to server. Right now I can connect just only one IP and the other IP is offline, but when I switch the host name on both file .ora to other IP, then I could connect the server as the IP on hostname in the Listener.ora and Tnsnames.ora.
Anyone could help me...?
Thanks in advance.