July 1, 2008 at 1:05 am
The operation on the Oracle database machine:
According to KB 193893, create two views in Oracle, please use the SYS account.
The default path is : oracleora92rdbmsadminxaview
2Add public authority to the new views:
SQLgrant select on v$xatrans$ to public with grant option;
SQLgrant select on v$pending_xatrans$ to public with grant option;
SQLgrant select any table to public;
Do the following on the computer which has the deployment of COM+ components:
According to KB 193893, modify the registry:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTCMTxOCI
“OracleXaLib”=”oraclient9.dll”
“OracleSqlLib”=”orasql9.dll”
“OracleOciLib”=”oci.dll”
If it is Windows 2003 or Windows XP, we also need to set up:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTCXADLL
Then, add the name: mtxoci.dll string keys
The content is: C:WINDOWSSYSTEM32MTXOCI.DLL
2. If you are using Windows 2003 or Windows XP, We need to set MSDTC account the corresponding authority. MSDTC is running on the Network Service account. Please add the Network Service account to the Administrators group inside.
3. Copy msvcrtd.dll to C:windowssystem32
4. Restart. Operate procedures.
About the content of Oracle is in http://www.DO NOT USE BRAINDUMPS.tw
August 9, 2008 at 11:49 am
... and the question is?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply