Error in REPLICAT - GoldenGate

Using Oracle GoldenGate 11g I get the following error when trying to do a Export/Replicat between two Oracle servers:
2010-11-25 16:35:18 ERROR OGG-01082 The call to the DBOCI_check_for_virtual_column function from get_odbc_table_def failed with return code 0.
This proces is running between two Oracle 11g R2 databases.
Does somebody know what's wrong? 

Michael,
It seems that there are one or more virtual columns in the tables that you are trying to replicate. Virtual columns can be replicated to normal columns only! Use this query to check out if you have any virtual columns:-
select owner,table_name,column_name,data_type,virtual_column
from dba_tab_cols
where owner='xxx' and virtual_column='YES';
Thanks,
Satish 

I did the same thingh with GoldenGate director and now it works correct.
Don't know what's wrong because the PRM files are identical
Will look into this further soon..

Related

GoldenGate Installation Queries...

Please help me on the below questions..??
I got some questions on oracle goldengate configuration:
1) My source and Destination are in different nodes, then do I need to configure listener # target db and Tns # source db?
2) If my source and destination are resides in the same system, can I user same port for the both source and target dbs?
3) I have tried GG in the single node with two dbs' called source and target. with different ports. But I installed goldengate two times in two locations (same node) each for source and target dbs respectively. Is it a right thing?
Also please find current my configuration:
Source : 11gR2, GG11, RHEL 4
Target : 11gR2, GG11, RHEL 4
I tried configuring GG, started manager,extarct at source db, and manager,replicat at target db.but table's DML is not getting replicated. I tried this in the same server ( as step 3).
Thank you,
Harry 
Try going through the tutorial first.
http://www.oracle.com/technetwork/middleware/goldengate/learnmore/ogg-tutorial-ora-to-ora-10-4-177139.pdf
You can reason out all of your questions.
On the target, with GG trying to apply DML against the database, how is DML done? Just like it is anywhere: from a connection to the database. What does it take to connect to an Oracle database, from a client perspective?
There is no reason why two databases (instances) cannot share the same listener.
If you want to work on two Word documents, do you need to install Office twice? No. If you have two databases (on the same server) running at the same release, do you need to install Oracle twice? No. Take a guess on what the answer to having to install GoldenGate twice is. 
Thank you, Awesome doc!

Frequently face ERROR OGG-01028!

Dear All,
I have a setup of golden gate one way replication from my production RAC, 2 node, 11gR2 on Linux to my standby 11gR2 on Linux.
Frequently when i run ggsci>info all;
One or 2 or more of my extract are in state ABENDED because of this error:
*2012-04-12 22:02:32 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, ext5.prm: Object with object number 80977 is compressed. Table compression is not supported.*
*2012-04-12 22:02:33 INFO OGG-00991 Oracle GoldenGate Capture for Oracle, ext5.prm: EXTRACT EXT5 stopped normally.*
When i check for the object 80977 in dba_objects, there is no such object. When i check compressed tables, I found nothing.
Simply, when i start the extract with command "start extract ext5" it starts again without any error.
Kindly help me to get rid of this error. Is there any way to skip this error by adding some line in extract parameter file?
Thanks, Imran 
Hi Imran,
Are you performing DDL replication too ?
If yes, please check below steps.
Step 1) Check if any advisory is running on the database
Step 2) check for the object_id in the GGS_DDL_HIST schema
select * from <golden_gate_schema>.GGS_DDL_HIST where OBJECTID=80977;
Step 3) If the step 2 gives (DBMS_TABCOMP_TEMP_CMP) or (DBMS_TABCOMP_TEMP_UNCMP) or (DBMS_TABCOMP_TEMP) in output, we need exclude this tables from replication.
Step 4) Add the below lines to the parameter files.
EXCLUDE OBJNAME "owner.DBMS_TABCOMP_TEMP*" &
EXCLUDE OBJNAME "owner.DBMS_TABCOMP_TEMP*" &
EXCLUDE OBJNAME "owner.DBMS_TABCOMP_TEMP*"
Reference: Bug 10377296: EXTRACT FAILS ON COMPRESSED TABLES
It would be helpful if you could provide the OGG version being used here.
Thanks,
Kamal. 
Dear Kamal,
Thank you very much for the detail reply.
Yes I am performing DDL replication.
This is the version of my Golden Gate
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x64, 64bit (optimized), Oracle 11g on Oct  4 2011 23:49:46
ADDM Advisory are scheduled that i have stopped.
select * from <golden_gate_schema>.GGS_DDL_HIST where OBJECTID=80977;
Returns: DBMS_TABCOMP_TEMP_CMP
I have added a line in my extract process
TABLEEXCLUDE GGS_OWNER.DBMS_TABCOMP_TEMP;*
Is this OK? I have to wait for the results. If there is anything else please let me know.
Regards and thanks, Imran 
Hi Imran,
That looks fine. Hopefully the issue should not have occured again.
Thanks,
Kamal. 
Thanks Kamal, it solved the problem.

installation

Hi,
We have a database replication requirement, We are going to use GoldenGate. Can you please help on the below questions,
Customer dont want install anything on production environment which is prod database running. Can you please confirm can we install goldengate software in some other environment and direct the extract process to prod database ? or can we use source environment gg software for target replicat process? Please guide how to achive without installing GG softwre on prod environments.
This is one way replication between two oracle database.. we have to replicat data from non-prod to prod. 
Where are the redo logs and archive logs stored ? ASM or normal file system ?
It is possible to run GG on a different machine but you need to keep in mind the network quality/performance as it will impact the GG performance. I wrote about it few days ago
http://amardeepsidhu.com/blog/2012/05/26/configure-goldengate-extract-to-read-from-remote-logs/ 
Hi Amar,
Thanks, please confirm,
1. Can we use the same approach for target environment? we dont want install GG on target environment. We have to replicate the data from source to target but we can install gg software on source . Like your blog details its a reverse requirement instead of configure extract here we have to configure replicat.
2. Also please confirm , in your blog , GG on host goldengate1 (192.***.*.109) is it a intermediate server between source and target? . or its a target environment ?
3. is this approach will work for bi directional?
4. so any way if we dont want install GG on any one server , then we need one more environment to achieve this ? right? we cant use target env binaries for source. the goldengate should be installed on both the servers or it should be any one intermediate server .... am i right? please confirm.... 
>
1. Can we use the same approach for target environment? we dont want install GG on target environment. We have to replicate the data from source to target but we can install gg software on source . Like your blog details its a reverse requirement instead of configure extract here we have to configure replicat. You can use some other machine. In case of a Replicat it just needs to connect to the target database. So you may run Replicat on some other machine. Check Oracle Installation guide page 24. It says
When Oracle GoldenGate connects remotely to the database server through SQL*Net, the following are required:
❍ Replicat: The Oracle client library and the Oracle GoldenGate build must have the
same Oracle version, bit type (32-bit, 64-bit, IA64), and operating system version.>
2. Also please confirm , in your blog , GG on host goldengate1 (192.***.*.109) is it a intermediate server between source and target? . or its a target environment ?No, it is not target. Just another intermediate machine.
>
3. is this approach will work for bi directional? It should. GG is doing the same thing that it does. Just that it is not running on the database host. And this shouldn't make any different to unidirectional or bi directional replicat.
4. so any way if we dont want install GG on any one server , then we need one more environment to achieve this ? right? we cant use target env binaries for source. the goldengate should be installed on both the servers or it should be any one intermediate server .... am i right? please confirm....Yes. Some intermediate machine from where you run Extract & Replicat. 
Excellent explanation Amar, As per your view , which one is the best approach to do the one way replication between two environments without installing gg software on target environment?????? 
I think best would be running the GG software on the database server itself as while running it from another machine you involve another component ie network that may impact your operations. But then there could be environments where it may not be allowed/possible. That leaves you with no other option than to run it on some intermediate machine. 
Thanks a ton Amar. This information very much helpful us.

Multiple Goldengate instance/installation on one Database

Hi All, I just want to ask if it's possible to install 2 goldengate accessing one single database? i need to test new goldengate configuration however we do not have a test environment, we cannot create one as the database size is too large. i'm thinking of installing another goldengate software on production environment (source) which already have an existing goldengate installation and config and use a simple PC as the target database. can this cause a problem on the database level and current goldengate setup? i tried googling up this but i dont see any answers. thanks in advance. Villy
You can, but you can also just create another data pump, read the same trails you have now from your primary extract, and send those to the replicat on the Windows database. It would be like the broadcast model. See chapter 6 of http://docs.oracle.com/cd/E35209_01/doc.1121/e29397.pdf.
Hi Steve, thanks for your advise, however i need a separate goldengate installation, i'm avoiding to mix-up the new config to the existing goldengate configurations. i will be testing a new configs for extract, pump, and replicats. i tried installing a new goldengate instance on a different directory and created a separate GG user, installation was successful however when i'm enabling DDL replication on the new GG instance i encountered an error. it didn't allow me to configure 2 DDL replication since i already have one under the schema of existing GG user. i guess i don't have any other choice but to mix-up the config or build another source for testing. thanks for the help Steve, it was helpful.  *ERROR at line 1:ORA-20783:ORA-20783:Oracle GoldenGate DDL Replication setup:*** INITIALSETUP used, but DDLREPLICATION package exists under different schema (GGS_OWNER). Please use ddl_remove.sqlto remove DDL installation from that schema firstORA-06512: at line 26
just a second thought, is it safe to use the existing GG user for the new goldengate instance? would it affect the checkpoint table? 
There isn't a checkpoint table for the Extract, so you should be safe using the same user and two Extracts, whether they are in the same OGG directory or not.  However, of course if they are in the same directory the Extract names need to be different, but since in this case there will be two OGG installations, you can even have the same name I think, as long as you haven't done any REGISTER EXTRACT extractname DATABASE operations in GGSCI, such as with an Integrated Extract.Caveat, I would test your config out in an actual dev environment before testing it in Production.

Installing Oracle GoldenGate on Linux to sync two database schemas on a single server

Hi All, I have to sync two database schemas (Oracle 12c) in a single RedHat Linux host to demonstrate and understand the use of OGG V12.1.2.1.0. I try to do it. But It's complicated and confusing me since I'm new to Oracle as well as Linux. I followed this tutorial ( Installing Oracle GoldenGate for Oracle 12.1.2 on Linux EL 6.x/RHEL 6.x/CentOS 6.x ). But It's difficult to understand how can I match this with two database schemas on a single server. And I found this tutorial (Oracle GoldenGate on Linux: Bidirectional Replication from Oracle 11gR2 to Oracle 11gR2). It says " If you do have only one host, it may be helpful to change the /etc/hosts file to make aliases forhost01.example.com and host02.example.com." What it really means? The second one seems to be helpful. But It's totally different from 1st one. Is this will help to my task since I'm using Oracle 12c database?Can I get some tips to continue my task?
Hi PrazSam, This is easily possible. Please go through the below documentation. The version is 10g and 11g But the steps and concepts are similar. Using Oracle GoldenGate for Real-Time Data Integration Please clarify the below.,1. Are you planning to use One GoldenGate Binary for both databases or each database has it's own GoldenGate Binaries.2. Are you going to use DataPump Extract process? The difference between having databases in different hosts and same hosts are, The RMTHOST parameter in the Datapump Extract file will have the same host name if the databases are in the same hosts. Also check the below links for Installation and Configuration of Oracle GoldenGate 12c on Oracle Database 11g (both DML and DDL configuration). http://www.oracle-scn.com/installing-oracle-goldengate-12-1-2-for-oracle-on-linux/http://www.oracle-scn.com/configuration-of-extract-and-replicat-using-oracle-goldengate-12c-on-linux/http://www.oracle-scn.com/ddl-replication-configuration-of-oracle-goldengate-11g/ Regards,Veera
Hi, Veera,Thanks for the help. The document you give has been done for Windows installation. Will the commands be same as on Linux. Are there any deviations. And what is your idea about the documents I mentioned? I'm going to use DataPump, Extract processes. And I have no idea yet about using one GoldenGate Binary for both databases or other way around? What will be most suitable? Up to now, I was assuming that I have to install it for both databases in the server. (Install 2 times only on the server) Is that correct? 
Here is another tutorial - http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/12c/OGG12c_Integrated_Replicat/index.html It has everything set up on a single Linux host.
I think this is it. Thank you very much.

Categories

Resources