可以的话,把 tnsname.ora 文件贴出来,让大家帮你分析一下. :D
解决方案 »
- 现在求助 ORA-01461: can bind a LONG value only for insert into a LONG column
- oracle global_name问题 高手请帮忙解决!高分!
- 设置ODBC数据源添加Oracle驱动程序时 测试Test connection 出错
- 超级用户名进不去企业管理器怎么办?
- 求一段Orale PL/SQL程序
- 问一个关于sql 查询 的问题
- 请问如何只查某表的第一条记录,在线等
- SQL语句,ADO,表内数据匹配语句,内存访问0?
- oracle 复制一行记录保存,始终不行,各种报错
- order by 某字段,第N页和第N+1页的数据是一样的,这是怎么回事?
- 为什么我进不去Enterprise Manager Console?怎么也进不去
- 数据转换?
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DJZSF)
(SID_NAME = DJZSF)
)
)OEMREP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xlxiao)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OEMREP)
)
)SANELY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sanely)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xlxiao)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
(SID_NAME = DJZSF)
第一项里怎么会两个都有呢?好像只用一个的吧
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DJZSF)
(SID = DJZSF) !!!(SID_NAME-->SID,应该是SID吧)
)
)