If you work with Oracle GoldenGate long enough, you will eventually have to setup against a Microsoft SQL Server. Being that GoldenGate is a heterogeneous application, this isn’t a problem; however there are small differences. One such difference is how the exact/replicat will connect to the MS SQL Database.
In an Oracle-to-Oracle configuration, you would just use a command line the following from the command line:
GGSCI> dblogin useridalias [ alias name]
or
GGSCI> dblogin userid [ user name ] password [ password ]
In a MS SQL Server environment, you can still login at the GGSCI command prompt with the following:
GGSCI> dblgoin sourcedb [ dns ]
You will notice the difference, which is the use of an ODBC DNS entry. Although setting up the ODBC DNS entry is not the point of this post, just keep it in mind that is is required when connecting to MS SQL Server with Oracle GoldenGate.
After setting up the ODBC DNS, you will need to add the following to the extract/replicat parameter file to enable the process to connect to the database.
sourcedb [ dns ]
Note: I normally put my connection information in a macro to modularize my parameter files. Please it makes it easier if it needs to change.
MACRO #logon_settings
BEGIN
sourcedb [ dns ]
END;
Now, when you go to start the extract/replicat, you may get the following error:
ERROR OGG-00551 Database operation failed: Couldn’t connect to [ dns ]. ODBC error: SQLSTATE 37000 native database error 4060. [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database “db_name” requested by the login. The login failed.
The error message is a little bit misleading. It tells you that the process cannot connect to the database which you were able to connect to from the GGSCI command prompt with no issue. Why is this? The issue lies in the fact that the manager (MGR) process is running as a service and does not have the correct permissions to access the database from the service.
In searching MOS for this error, I was found Note ID: 1633138.1. In this note, notice that this issue is known as of Oracle GoldenGate version 12.1.2.x.x. The note also provides you a fix to this issue. In simple terms, since the manager process is running as a service; additional permissions have to be granted to manger.
To grant the SYSADMIN privilege for the manager process follow the below sequence of steps (on windows after all):
1. Manager is installed as service:
Open SQL Server Management studio -> Security ->login>select NT AUTHORITY\SYSTEM ->Right Click -> Properties–>Server Role –>Enable sysadmin role
2. ggsci>stop mgr
3. ggsci>start mgr
4. ggsci>start extract <extract-name>
After granting the sysadmin role, the extract will start.
Enjoy!
about.me:http://about.me/dbasolved
Please follow and like:
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Your article helped me a lot, is there any more related content? Thanks!
But if you decide to buy accutane online and use it, you should read the contraindications and side effects Instead, you will likely get a prescription for one of the other brand names like Asorica, Claravis, Sotret, Amnesteem, Myorisan, and Zenatane priligy at walgreens ABI och symtomatologi vid kronisk extremitetsischemi
Pretreatment with the time of the antiproliferative effects of medical sciences, and the skin infections viagra priligy
In summary, it should be stressed that the clinical diagnostic criteria are insensitive and nonspecific; false positive and false negative diagnoses are common priligy and cialis
Hello there! Do you know if they make any plugins to help with SEO?
I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good success.
If you know of any please share. Cheers! I saw similar article here: Wool product
Many thought a new age was coming, in which the chaotic spread of cancer would be hindered by drugs that would be precision targeted to block the replication of rogue cells want to buy priligy in pakistan
There were no differences observed in the type of loop diuretic used between patients continuing loop diuretics and control patients what is priligy tablets
Doublets were isolated and then transferred by pipette to a single well of RetroNectin coated 96 well plates in IMDM 10 FBS 20 ng mL recombinant rat SCF and 10 ng mL murine granulocyte macrophage colony stimulating factor, murine IL 3, and human IL 6 where buy cytotec pill
Sarah what it sayin is true but from the past two months I dont notice any cervical mucus in my 30 day cycles and before that i was fine buying cytotec Now it is nearly 2 months after the end of my PCT, my blood works are back to baseline, but my nipples are a little puffy, obv much better than they were but still puffy
Femara letrozole was not mutagenic in in vitro tests Ames and E where can i get generic cytotec without a prescription Petroleum jelly
Kato TS, Schulze PC, Yang J, et al how to order cytotec
89181 486560Thank you for the auspicious writeup. It in truth used to be a amusement account it. Glance complex to much more added agreeable from you! Nevertheless, how could we be in contact? 466172