In the same LAN, the client can not access the remote server, and after the personal summary of the online data, the following settings are required
(1) The exception must be set on the Oracle server servers:
Control Panel->windows Firewall, advanced settings, inbound rules, new rule: Select a port in the rule type, the next rule applies the TCP protocol, The rule application Port selects a specific local port and fills in the default port 1521 for Oracle (which can also be used with all the default ports), which is always selected by default, and then the name and description are filled in. When you are finished, double-click the new rule, and on the Scope tab, in the Remote IP address, select the following IP address and add the client IP to access the server.
(2) Setting in client Net Manager
To start clicking on Net Manager, always pop-up prompts to select the directory where you want to open the network configuration file as shown in. Later on-line query query, online method said will Oracle_home and tns_admin two environment variables can be deleted, not found Oracle_home, only remove tns_admin problem solved. (Modify the location of environment variables: Right-click My Computer, properties, advanced system settings, environment variables button)
In Net Manager, select Local--Service naming, select service naming, click Create in the menu edit, set in the Network Service Name Wizard, where the protocol chooses the TCP/IP protocol, the hostname fills in the IP of the server host, and the service name fills in the global database name of the server database.
Through the above two steps, you can access the remote server from the client in the LAN.
Oracle Client access to remote database related