允許外網訪問：
1.將oracle主程序和oracle監(jiān)聽添加到windows防火墻例外。

2.配置監(jiān)聽器
或者修改listener.ora為如下文件（1.修改SID_DESC? 2. (ADDRESS = (PROTOCOL = TCP)(HOST =xiong-PC)(PORT = 1521))）



SID_LIST_LISTENER =
? (SID_LIST =
??? (SID_DESC =
????? (SID_NAME = CLRExtProc)
????? (ORACLE_HOME = C:\app\xdw\product\11.2.0\dbhome_1)
????? (PROGRAM = extproc)
????? (ENVS = "EXTPROC_DLLS=ONLY:C:\app\xdw\product\11.2.0\dbhome_1\bin\oraclr11.dll")
??? )
?? ?(SID_DESC =
????? (GLOBAL_DBNAME = orcl)
????? (ORACLE_HOME = C:\app\xdw\product\11.2.0\dbhome_1)
????? (SID_NAME = orcl)
???? )
? )

LISTENER =
? (DESCRIPTION_LIST =
??? (DESCRIPTION =
????? (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
?? ?? (ADDRESS = (PROTOCOL = TCP)(HOST =127.0.0.1)(PORT = 1521))
?? ?? (ADDRESS = (PROTOCOL = TCP)(HOST =xiong-PC)(PORT = 1521))
??? )
? )