3、打开Oracle的 listener.ora 文件：

# listener.ora Network Configuration File: /app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (SID_NAME = PLSExtProc)       (ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_1)       (PROGRAM = extproc)     )   ) LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))       (ADDRESS = (PROTOCOL = TCP)(HOST = suse10.site)(PORT = 1521))     )   )
修改它的 SID_LIST_LISTENER 中的内容，修改后的内容如下：
# listener.ora Network Configuration File: /app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (SID_NAME = PLSExtProc)       (ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_1)       (PROGRAM = extproc)     ) (SID_DESC =       (GLOBAL_DBNAME = ORCL)       (ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_1)       (SID_NAME = ORCL)     )   ) LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))       (ADDRESS = (PROTOCOL = TCP)(HOST = suse10.site)(PORT = 1521))     )   )
上面的粗体文字是增加的内容。 4、重启Oracle的监听器。