GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Enable xa support in Oracle Database version 10.2.0.1 in preparation for OIM installation

edited Feb 17, 2010 9:40PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
 Trying to setup a development environment for OIM. One of the pre-reqs is to install an Oracle DB and prepare it for use by OIM.

I installed Oracle DB 10.2.0.1 on Windows 2003 R2 server and I have run the prepare_xl_db.bat script to prep the DB.  However when I run the OIM diagnostic

dashboard to test the database. It fails and says that XA support is not enabled on Oracle DB.  I ran the initxa.sql script , in order to manually enable XA

support and I got a message saying the procedure executed successfully. However I also get a message saying that "Package created with compilation errors".

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center