大橙子网站建设,新征程启航
为企业提供网站建设、域名注册、服务器等服务
配置oracle监听文件
直接复制使用
如果自己配置的监听文件总是出错,可以复制下面的信息进到自己配置文件中更改主机信息
成都创新互联专注于岳池企业网站建设,响应式网站开发,商城系统网站开发。岳池网站建设公司,为岳池等地区提供建站服务。全流程定制设计,专业设计,全程项目跟踪,成都创新互联专业和态度为您提供的服务
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)
/ )
/)
监听文件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)
/ )
/ )