October 18, 2011 at 6:44 am
Whoever can tell me why this is happening is in fact a real SS2008 R2 Enterprise Guru!
I have done an extensive search and can't find anyone that has had this same issue. Any help would be greatly appreciated.
pulling a snapshot from Oracle 11g on another system.
I go to add a new oracle publisher. I get a list of tables in the articles window, when I go to expand them, I have no columns for any of the tables. However if I use the import/export tool I can see the tables and see the columns when I expand the tables.
I have the Cumulative 3 patch installed.
This server was working prior to an 11g upgrade, after which the distributer was dropped and recreated.
This does work when using a another 2008 r2 server to that same database, so I'm convinced that the issue is config related on the current server.
Thanks
Bob
Thanks is advance.
October 18, 2011 at 7:50 am
You're sure both servers have the same patch level? Both SQL Server and OS?
My first instinct would be that the working server has a different patch level then the non-working server. After that... I'd have to do more research.
October 18, 2011 at 8:07 am
Hi Brandie,
Thanks for the reply. Actually they both had no patches installed initially and the situation was the same. One worked, the other didn't, I found a KB article that mentioned missing columns that didn't work with Oracke 11g (but didn't pertain to the wizard) and decided to install the cumulative Patch to see if it rectified the issue. Which it didn't. Very strange. The steps that lead to this:
1. Database was running 10g, everything worked
2. Upgraded to 11g, replications could no longer see tables or views in the scheduled jobs.
3. I removed the distributor. Which removed all of the Oracle Publications (but not the subscriptions)
4. Recreated the distributor. AND a KEY point I forgot to mention. When I create a publisher to a 10g database using the New Publication Wizard, I am able to expand the tables and see the columns, only when I try it with the 11g database does it not work.
Thanks
Bob
October 18, 2011 at 8:30 am
Sounds like an incompatibility between the Oracle DB and the SQL driver that connects to the Oracle DB. Check out this link:
Does anything there help you?
I googled the phrase: SQL 2008 R2 replication Oracle 11g
EDIT: Oh, hey, I just found something on the MS KB link that was listed in the above link.
MS KB Article 960574 - RE: Cum. Update 3
This cumulative update package lets Oracle Publishing support Oracle 11g databases.After you apply this cumulative update package, you must manually drop and then re-create the data mapping table for replication by running the following stored procedures.
use msdb
exec sp_MSrepl_dropdatatypemappings
exec sp_MSrepl_createdatatypemappings
go
Did you do this?
October 18, 2011 at 8:42 am
Brandie! Thanks! That did it!
I really appreciate your help with that.
October 18, 2011 at 8:50 am
You are very welcome.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply