【TNS】listener.ora模板;tnsnames.ora模板
好多人使用监听的时候误操作,将监听弄的不好使了,这次这个模板,不光是针对大家出现的这种问题,也是给我自己留一个记录,方便他人,方便自己。
listener.ora模板样例
--------------------------------------------------------------------------------
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = xxx.xxxx.xxxx)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = xxxx)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxxxxxx)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
--------------------------------------------------------------------------------
tnsnames.ora模板样例
--------------------------------------------------------------------------------
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
XXXXX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xxxxxxxxxxx)
)
)
--------------------------------------------------------------------------------
以上带xxxx的这种都需要自己设定,host可以设定hosts文件中的名称,或者IP,service_name可以在oracle中输入
SQL>show parameter name;
sid可以在进程中查看
$ ps -ef | grep ora_
或者
$ echo $ORACLE_SID
最新文章
- 【原】如何改变表单元素的外观(for Webkit and IE10)
- 使用 xcode 8 构建版本 iTunes Connect 获取不到应用程序的状态的解决办法
- 一个小玩意 PHP实现微信红包金额拆分试玩
- 代码里面执行bat
- 典型的 SQL 注入过程(转)
- HDU5627--Clarke and MST (bfs+位运算)
- 自定义JSON配置器
- linux Apache rotatelogs 故障原因及解决方案未生效
- 1209:Catch That Cow(bfs)
- 批量下载验证码 shell
- poj 3168 Barn Expansion 几何yy
- Postgre Sql获取最近一周、一月、一年日期函数
- 5-15 bootcss 之 modal 以及 jquery ui 之datepicker 小记
- java学习(权限修饰符)
- Python:安装MYSQL Connector
- uoj #14.【UER #1】DZY Loves Graph
- opencv中的图像形态学——腐蚀膨胀
- mybatis中多条件判断---choose when的用法
- poj1179 Polygon【区间DP】
- about route