Oracle open port (cannot be connected through port ing)

Oracle open port (cannot be connected through port ing) problem Oracle 9I is installed on Win2003, WIN2003 only opens port 1521, then remote telnet port 1521 can pass, but the database connection fails. The reason is as follows: www.2cto.com the Oracle client connects to the server. First, go to the 1521 listening port. Then, the server's 1521 listening port sends a request to the server process, returns a random port, and returns it to the client, connect the client to this port. Matalink provides three solutions. In fact, USE_SHARED_SOCKET is the most effective and convenient. Method 1: In the Windows 1521 registry, add the string value USE_SHARED_SOCKET = TRUE to hkey_local_machine \ software \ oracle \ home0 \, and enable TCP port on the server, restart the ORCALE server! Method 2: 1. Change the database instance to the shared server mode. 2. log on to SQLPLUS with SYSDBA and use SQLPLUS to generate the system's current parameter setting file pfile: create pfile = 'd: \ init. ora 'from spfile; 3. Modify d: \ init. add the ora file (edited with editplus ):*. service_names = 'Your service name' and *. dispatchers = '(address = (protocol = tcp) (host = localhost) (port = 1521) (dispatchers = 1)' 4. generate a new SPFILE: create spfile from pfile = 'd: \ init. ora '; 5. Restart the database. 6. open port 1521 in the firewall. Method 3: Start cman on the database side (or another machine, but the cman machine and the database must be behind the firewall, then open port 1630 on the firewall side (see what port is opened by cman), and then enable tnsnames on the client. add www.2cto.com cmantest = (description = (address_list = (address = <-first address is to CMAN (protocol = tcp) (host = hostname or ip of cman) to the ora file) (port = 1610) (address = <-second address is to Listener (protocol = tcp) (host = hostname or ip of listener) (port = 1521 ))) (connect_data = (s Id = sidname) (source_route = yes) Another: after installing the Windows version of Oracle 10G, you have enabled the firewall that comes with windows 2003 and found that you can access the oracle database on the local machine, however, if a remote connection fails, connection timeout is always reported. After the firewall is disabled, You can remotely connect to the Oracle 10G Database. But after the firewall is enabled, it cannot be connected, indicating that the problem lies in the firewall. If the firewall enables TCP port 1521, it still cannot connect to the database. The solution is as follows: www.2cto.com 1. If it is Oracle 8i, modify the Registry HKLM \ Software \ Oracle and add a string value USE_SHARED_SOCKET = TRUE. 2. If it is not Oracle 9i, open the % Oracle_Home % \ bin \ oracle. key File and add a string value USE_SHARED_SOCKET = TRUE according to the path in HKLM. 3. Restart the sub-host to make the Registry take effect. For Oracle in Linux, you only need to open TCP port 1521 in the firewall.