ORACEL 11g tnsnames.ora配置文件如下:
---------------------------------------------
ORCL=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=localhost)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=orcl)
)
)
)APPOUT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.71.61)(PORT = 1621))
(CONNECT_DATA =
(SERVICE_NAME = app)
)
)
APPOUT2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.71.61)(PORT = 1621))
(CONNECT_DATA =
(SERVICE_NAME = app)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
--------------------------------
sqlnet.ora配置如下
------------------------------------SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
--------------------------------------------------本地数据库连接不存在问题(scott/tiger),远程tnsping也没有问题TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 23-5月 -
2011 14:15:12Copyright (c) 1997, 2010, Oracle. All rights reserved.已使用的参数文件:
D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.71.61)(PORT = 1
621)) (CONNECT_DATA = (SERVICE_NAME = app)))
OK (110 毫秒)但是用PLSQL连接APPOUT数据库的时候,PLSQL就一直死掉,不知道是什么原因,求指教。
---------------------------------------------
ORCL=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=localhost)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=orcl)
)
)
)APPOUT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.71.61)(PORT = 1621))
(CONNECT_DATA =
(SERVICE_NAME = app)
)
)
APPOUT2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.71.61)(PORT = 1621))
(CONNECT_DATA =
(SERVICE_NAME = app)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
--------------------------------
sqlnet.ora配置如下
------------------------------------SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
--------------------------------------------------本地数据库连接不存在问题(scott/tiger),远程tnsping也没有问题TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 23-5月 -
2011 14:15:12Copyright (c) 1997, 2010, Oracle. All rights reserved.已使用的参数文件:
D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.71.61)(PORT = 1
621)) (CONNECT_DATA = (SERVICE_NAME = app)))
OK (110 毫秒)但是用PLSQL连接APPOUT数据库的时候,PLSQL就一直死掉,不知道是什么原因,求指教。
解决方案 »
- 偶比较菜,想问下Oracle企业管理器中怎样查询数据啊?
- 请教诸位高手一个很基础的trigger问题
- 刚开始用的安装问题(新手)
- 求分析函数lead与lag用法例子
- 如何实现3个字段相同时保留另一个字段值最大的那条记录
- 有没有不用输入参数的function?或者代替的东西?
- 高分求教:各位是如何防范互联网上Oracle9i数据库被连接或攻击
- 启动oracleorahome81managementserver失败?如何解决。
- 求sql,两张表关联,如果关联的字段一张表中有,另一张中没有,如何把这些也查询出来
- 请教高手,如何对过程包里的代码加密!!!
- linux下安装oracle的问题
- 请问EXCEL如何访问ORACLE并更新数据
pl/sql developer远程连接oracle 11g