Oracle Database Link Problems【Blog 搬家】
Oracle Database Link Problems
cle 8 資料鏈路在程式中不能支援: ODBC
資料不可提交,無錯誤,偶爾會有錯誤。
Microsoft OLE DB
資料不可提交,無錯誤
Oralce OLE DB (在BPCS上可以,但在Cimprod不可以)
錯誤為:
ORA-02041: client database did not begin a transaction
Oracle的說明:
cause: An update occurred at a coordinated database without the coordinator beginning a distributed transaction. This may happen if a stored procedure commits and then performs updates, and the stored procedure is invoked remotely. It could also happen if an external transaction monitor violates the XA protocol.
Action: If the cause is the former, check that any commit is not followed by an update.
暫無解決辦法,還是透過Procedure 透過DB link把資料轉入GSN DB.
SQL Server 的Link Server:
也發生如下狀況,一直好好的procedure突然出現,但Link server好好的。
[Microsoft][ODBC SQL Server Driver][SQL Server]對遠端伺服器的存取被拒絕,因為登入對應不存在。
臨時解決辦法把建立connect的使用者的許可權提高為Server administrator.
myhuaer 發表於:2005.05.17 18:00 ::分類: ( Oracle Infomation ) ::閱讀:(467次)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/34596/viewspace-661925/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle Database Link ProblemsOracleDatabase
- oracle ora-00997 problems【Blog 搬家】Oracle
- Database Link 建立注意的兩點【Blog 搬家】Database
- float datatype in Oracle database 【Blog 搬家】OracleDatabase
- oracle Database Event trace 設定【Blog 搬家】OracleDatabase
- Oracle backgroud Process【Blog 搬家】Oracle
- Database Triggers and event attributes--Database System Events【Blog 搬家】Database
- oracle Distinct|Unique 異同【Blog 搬家】Oracle
- oracle database linkOracleDatabase
- Oracle DDL 執行過程【Blog 搬家】Oracle
- Database Triggers and event attributes--Introduction[Blog 搬家]Database
- Link to - xsb oracle blogOracle
- Database Triggers and event attributes--Event Attributes【Blog 搬家】Database
- Database Triggers and event attributes--DDL/Client Events【Blog 搬家】Databaseclient
- Oracle event 10231 【Blog 搬家】Oracle
- Oracle Date Function 講解和事例【Blog 搬家】OracleFunction
- Oracle database link 詳解OracleDatabase
- oracle database link 應用OracleDatabase
- oracle database link 的使用OracleDatabase
- Captain blog linkAPTAI
- Oracle Optimizer -RBO (理解Rule-based 優化器)【Blog 搬家】Oracle優化
- oracle database link (dblink) 工作原理OracleDatabase
- HP -Data Protector Restore file system【Blog 搬家】REST
- V$SESSION_LONGOPS bug 【Blog 搬家】SessionGo
- 限制End User Session數量 【Blog 搬家】Session
- Trim() 函式的介紹【Blog 搬家】函式
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- database link概述Database
- CREATE DATABASE LINKDatabase
- Database Link使用Database
- 建立Database LinkDatabase
- Management on database linkDatabase
- ora -03232 問題解決【Blog 搬家】
- RMAN 只備份當前資料?【Blog 搬家】
- Database Link的建立Database
- ORACLE實驗(move表空間和database link)OracleDatabase
- Oracle10g V$OSSTAT 關於PHYSICAL_MEMORY_BYTES 的 Bug【Blog 搬家】Oracle
- oracle 9i database 在win2k server上搬家(轉摘)OracleDatabaseServer