配置oracle監(jiān)聽文件
直接復(fù)制使用
如果自己配置的監(jiān)聽文件總是出錯,可以復(fù)制下面的信息進(jìn)到自己配置文件中更改主機(jī)信息
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)
/ )
/ )
另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn,海內(nèi)外云服務(wù)器15元起步,三天無理由+7*72小時售后在線,公司持有idc許可證,提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案,具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價比高”等特點(diǎn)與優(yōu)勢,專為企業(yè)上云打造定制,能夠滿足用戶豐富、多元化的應(yīng)用場景需求。