listen.ora 文件是我从其它服务器拷过去的,也不知道改对了没有, “ ########## " 那一行是有改动的
--------------------------------------------------------------------------------------------------LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.103.111)(PORT = 1521)) ##########
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e:\oracle\ora92) ##########
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = tg4msql) ##########
(ORACLE_HOME = e:\oracle\ora92) ##########
(SID_NAME = sql) ##########
)
)
--------------------------------------------------------------------------------------------------LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.103.111)(PORT = 1521)) ##########
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e:\oracle\ora92) ##########
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = tg4msql) ##########
(ORACLE_HOME = e:\oracle\ora92) ##########
(SID_NAME = sql) ##########
)
)
解决方案 »
- 为何oracle存储过程的返回值SQL语句执行的一半
- 求助,oracle9i总是自动关闭!
- MyEclipse6.0中如何配置Oracle 10g数据库
- 数据库高速缓存命中百分比只有百分之60.32怎么办?
- 创建JOB问题
- 关于存储过程的一个问题,返回的是一个游标
- OTL模板库中可以使用自定义数据类型吗?
- 菜鸟求教:在JSP中如何在Oracle的存储过程执行时弹出提示框让用户选择,并根据用户的选择执行相应步骤
- 简单问题:如何把查询的结果存入一个新表中(在线等)
- Ora-19504 Ora-00257 archivelog 不能存档,明明有空间却报空间不足
- 更新没有主键的表
- 插入数据的时候出现ora-01536异常
--------------------------------------------------------------------------------------------------
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)local =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.103.111)(PORT = 1521))
)
(CONNECT_DATA =
(SID = sql)
)
(HS = OK)
)sql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.127.245)(PORT = 1521))
)
(CONNECT_DATA =
(SID = kk10)
)
(HS = OK)
)
SELECT * FROM PO_SALESORDER_HEADER@DB_SQL
*
ERROR 位于第 1 行:
ORA-12154: TNS: 无法处理服务名