配置oracle監(jiān)聽文件
直接復制使用
如果自己配置的監(jiān)聽文件總是出錯，可以復制下面的信息進到自己配置文件中更改主機信息

成都創(chuàng)新互聯(lián)專注于岳池企業(yè)網(wǎng)站建設,響應式網(wǎng)站開發(fā),商城系統(tǒng)網(wǎng)站開發(fā)。岳池網(wǎng)站建設公司,為岳池等地區(qū)提供建站服務。全流程定制設計，專業(yè)設計，全程項目跟蹤，成都創(chuàng)新互聯(lián)專業(yè)和態(tài)度為您提供的服務

TNS文件tnsnames.ora
/# tnsnames.ora Network Configuration File: /oracle/oracle/11g/network/admin/tnsnames.ora
/# Generated by Oracle configuration tools.
/
/ORCL =
/(DESCRIPTION =
/ (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.10)(PORT = 1521))
/ (CONNECT_DATA =
/ (SERVER = DEDICATED)
/ (SERVICE_NAME = orcl)
/ )
/)
監(jiān)聽文件listener.ora
# listener.ora Network Configuration File: /oracle/oracle/11g/network/admin/listener.ora
# Generated by Oracle configuration tools.

#粘貼后將/號去掉
/# listener.ora Network Configuration File: /oracle/oracle/11g/network/admin/listener.ora
/# Generated by Oracle configuration tools.
/
/LISTENER =
/ (DESCRIPTION_LIST =
/ (DESCRIPTION =
/ (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
/ (ADDRESS = (PROTOCOL = TCP)(HOST = master.example.com)(PORT = 1521))
/ )
/ )
/
/ADR_BASE_LISTENER = /oracle/oracle
/
/SID_LIST_LISTENER =
/ (SID_LIST =
/ (SID_DESC =
/ (GLOBAL_DBNAME = orcl)
/ (ORACLE_HOME = /oracle/oracle/11g)
/ (SID_NAME = orcl)
/ )
/ )