Golden Gate Errors Out While Configuring?

Aug 18, 2011

I am trying to configure Golden Gate but i am running into the following errors while configuring. Given below is the contents of the configuration.

ggssci>edit params mgr
PORT 7809
USERID ggs_owner, PASSWORD ggs_owner
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/ex, USECHECKPOINTS

[Code].....

View 1 Replies


ADVERTISEMENT

Golden Gate Replication

Apr 29, 2013

Below questions are swirling in my mind while doing some research on Golden gate setup and replication

1) Can we put any time delay between source and target, so that the replication data will be applied after some set of time?

2) If I setup the Golden Gate between Oracle as source and SQL server as destination, then how the core of procedures/views/functions/packages will be replicated to SQL server target?

i.e. is only data replicates between the DBs or the other procedures/views/packages.. etc will also be replicated? If not,then do we need the manual involvement to replicate them?

3) Is it possible to replicate the schemas within the same DB using golden gate?

i.e. if TOOLS DB is shaving schemas A and B, can I replicate the A objects to B schema within the same DB TOOLS?

View 1 Replies View Related

Replication :: Golden Gate For Production Cut Over

Feb 4, 2012

I was planning to a production cut over from Aix to linux .I thought GG as an option so that i can have two DBs run parallel and replicate and do a cutover to linux during the change window.

Now the problem i see is that only half the tables have primary key.. so I THINK golden gate cannot be used an an option.

View 2 Replies View Related

Replication :: Golden Gate Software?

Jan 14, 2012

I want to learn Golden gate from the scratch.

1) Link for downloading golden gate software. I want to use it on oracle 11g on linux (X86). ( I have downloaded fbo_ggs_Linux_x64_ora11g_64bit.zip from oracle.com size 89mb but I'm not sure whether this is the actual version or not!)
2) Easy ,step by step guide to install the software.
3) Documents/link for performing basic operation.

View 3 Replies View Related

Golden Gate Bidirectional Replication Inconsistency

Mar 3, 2011

I was trying to test out the bidirectional replication using golden gate 11g . while doing some tests i did find out there are inconsistency in the database.

Scenario:

Database 11gee,Goldengate11g.

Set up a bidirectional replication replication it works fine until i hit the below scenario. I updated 1 record in the source database then i updated same record in the target database . Now i issued commit one by one on both the src/target. Now checking the record in src/target have different values. src containing the value which was committed in target and vice versa in target. leading to data integrity.

How can we resolve the above issues i have tried different options but nothing seems to work till now.

View 1 Replies View Related

Replication :: Golden Gate - Manager Not Starting?

Oct 3, 2010

Trying to configure oracle golden gate between oracle 10g and 9i golden gate Manager is not starting

Error in MGR.rpt

Source Context :
SourceModule : [mgr.main]
SourceID : [/home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34085]/perforce/src/app/mgr/mgr.c]
SourceFunction : [param_file_args]
SourceLine : [2854]

2010-10-03 09:27:48 ERROR OGG-00303 Unrecognized parameter (<CODE>PORT).
2010-10-03 09:27:48 ERROR OGG-01668 PROCESS ABENDING.

View 1 Replies View Related

Replication :: What Is Stream's Tag Equivalent In Golden Gate

Apr 13, 2012

What is the stream's "tag" equivalent in Golden gate ?My tables are already in GG replication, but i want to do few insert in to source which i dont want to replicate to target.

View 1 Replies View Related

Networking And Gateways :: Oracle Golden Gate For SQL Server

Mar 11, 2013

Currently we are loading data from oracle to sql server through oracle 11g gateway. during running scripts most of the queries takes a long time to complete. Because of this performance issue, we want to configure oracle golden gate to move data from oracle to sqlserver. whats the difference between oracle gateway & oracle golden gate? both are performing same functionality?

View 1 Replies View Related

Replication :: Meaning Of BOUNDED RECOVERY In Golden Gate

Jan 8, 2012

whats the meaning of BOUNDED RECOVERY in golden gate. I just know RECOVERY in oracle.. What is the difference when you say BOUNDED RECOVERY.

View 1 Replies View Related

Replication :: Golden Gate - Replicate Data From Oracle To Sybase

Oct 17, 2007

Implemented the Golden Gate replication tool? In particular, to replicate data from Oracle to Sybase?

No details are needed, just a quick nod indicating "yes, it has been done successfully".

View 1 Replies View Related

Replication :: Bi-Directional Replication Through Golden Gate?

Aug 22, 2010

For using replication in our production, here i am testing golden gate as replication tool. I tested all scenario in Uni direction ( source to destination). Now have to test replication with DDL support in Bi-Direction. Not getting any Doc for doing replication in Bi-direction( Two Way). If any one has done the same, then please share limitation of replication in Bi-direction through Golden Gate.

View 7 Replies View Related

RAC & Failsafe :: Error While Configuring Css?

Jul 23, 2011

i got a problem while configuring asm in linux operation system for practice purpose and it troughs error the folllowing details are as fallows.

operting system = oracle enterprise linux 5
software =oracle 10g version= 10.1.0.2.0
oerating system kernel parameters=2.6.18-194.el5PAE

when i'as issuing commed(Localconfig add) on root users i'm getting the following error
[root@prod ~] localconfig add
/uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 392: /etc/init.d./init.cssd : no such file or directory
/bin/rm: cannot remove '/etc/init.d/init.cssd' no such file or directory
/uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 402: /etc/oracle/ocr.loc no such file or directory
in/rm : cannot remove /etc/oracle/ocr.loc' no such file or directory
bin/rm: missing operand
try '/bin/rm --help for more information

solution i tried for this errror
1.i tried to locate lidbl.so.2 libraies using locate libdl.so.2 and cpoied to location create soft link but still its the same error.
2)i tried ti install rpm pakages for kernel 2.6.18-194.el5PAE but still same eror.
3)i export the library path in bash_profile but still i got same problem

View 1 Replies View Related

PL/SQL :: Error While Configuring Emca

Sep 26, 2012

Below is the error returned, while configuring "emca" for "enterprise manager"

C:Documents and Settingsuser> emca -config dbcontrol db -repos create

STARTED EMCA at **** **:**:** PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: orcl
Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable.
at oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(DatabaseChecks.java:151)
at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:144)
at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163)
at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1272)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
------------------------------------------------------------------------------------------

orcl is the oracle sid on my computer and database status is RUNNING

View 3 Replies View Related

Application Express :: Configuring FOP For 4.2?

Mar 14, 2013

What do I have to do in order to configure FOP for APEX 4.2 ?

View 3 Replies View Related

Error While Configuring RMAN Script?

Aug 6, 2010

after configuring the rman sript when im running the script its giving the error like this

RMAN-00571:-----------------------------------------------------------------------------------------------------
RMN-OO569:--------------------ERROR MESSAGE STACK FOLLOWS-------------------------------------------
RMAN-00571:--------------------------------------------------------------------------------------------------------
RMAN-03008:error while performing automativ resync of recovery catalog
ORA-01580:error creating control backup file /disk1/oradata/car/rman/snapcf_car.f
ORA-02704:file create error unable to create file

View 1 Replies View Related

Configuring OEM Alerts For Mobiles To Send SMS

Aug 15, 2010

How to configure SMS alerts for mobiles from OEM. We have a very big setup managed by 10g grid and i want to configure Mobile SMS alerts from OEM Grid.

View 5 Replies View Related

Configuring Udev Rule For Raw Disks?

Jan 1, 2013

I am using oel 5.8, oracle 11.2.0.3. The raw disk permissions are getting changed when the node gets rebooted.I am trying to use udev rule to change the permission permanently but its not working.

CODE[root@VM-PAGRAC3 rules.d]# more 99-asm.rules
KERNEL=="sd", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p",*
RESULT=="SATA_VBOX_HARDDISK_VB7a29b7ae-de673b56_",
NAME+="oracleasm/disks/DSK1#" OWNER="grid"
GROUP="asmadmin" MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p",
RESULT=="SATA_VBOX_HARDDISK_VB36f5d134-4e0e4c43_",

[code].....

View 8 Replies View Related

Configuring Loopback Adapter For Oracle

Jun 4, 2013

On my PC I have installed Oracle 10g & Oracle Forms & Reports 6i .My PC is on LAN ,to avoid problem of dynamic ip address & tns 12514 as PC get connected & disconnected from LAN regularly I have just installed Loopback Adapter.As my PC on LAN so it have old NETWORK CONNECTION which have specific ip address,subnet mask, default gateway,preferred DNS server , alternate DNS server.

How loopback adapter going to work & what I have to do after installing LOOPBACK ADAPTER? Can I give the same ip address,subnet mask, default gateway,preferred DNS server , alternate DNS server on my new network connection (generated after installing Loopback Adapter) as it is on my old network connection & delete or disable old Network Connection. And come in my original LAN with same settings on new Loopback Adapters newtwork connection. Or I have to keep both network connection .

View 5 Replies View Related

Exadata :: Configuring Dataguard With DR Server And DBM

Oct 10, 2012

Refer a MOS Note for configuring data-guard on Exadata with DR server being and Exadata DBM too.

View 4 Replies View Related

Server Administration :: Configuring IP Address Instead Of HOSTNAME

Apr 7, 2009

I have purchased LIVE IP on my application server to access it anywhere on the internet.I am calling application on the internet as URL>...And its working perfectly.

I have configured Sigle Sign On and using this code on "When-Button-Pressed" to call report

WEB.show_document('/reports/rwservlet?server='||:PARAMETER.reps
||'&ssoconn=default/oracledb/userid'
||'&report='||repid
||'&desformat=PDF'
||'&destype=CACHE'
||'&pyear='||:PARAMETER.pyear
||'&branch='||:PARAMETER.branch_id
||'&bk='||:transactions.book
||'&sno='||:transactions.srno
||'¶mform=no'
,'_blank');

From Client side When i press button "sigle sign on authentication page" of Internet Directory is not coming. Because URL is accessing the application server using the HOSTNAME of application server instead of IP ADDRESS like this URL....

How can i configure it to use only IP address.

View 25 Replies View Related

Enterprise Search :: Configuring Tags For A Keyword?

Jun 21, 2013

We have an Oracle UCM and Oracle SES implementation.Currently there are too many tags returned for certain keywords by SES which breaks the UI,some of the tags being irrelevant too.Is there any configuration variable in SES by which these tags can be limited to say 20 most relevant tags.?

View 0 Replies View Related

RAC & Failsafe :: Installing / Configuring Real Application Cluster Using NFS Instead Of ASM?

Feb 28, 2012

i want to install oracle real application cluster using shared file system and not using ASM. we are not creating LUN for our data to kept and SAN admin will give us NFS share where we will place the database.

View 5 Replies View Related

Networking And Gateways :: Listener Start Failed After Configuring?

Nov 2, 2011

i could not able to add and open listener to install Oracle database 11g R2 on window 7 ( 64 bit OS).

Steps :

1) i installed Oracle 11g R2 Software Only.

2) Started DBCA to configure Database

3) I got a message that i need to configure Listener first.

4) I opened NETCA and add a listener ( default name LISTENER)

5) Then re-opened DBCA to start Database configuration and found the same message configure listner.

6) I went to control panel-> Services -> i found no listeners there

7) i started NETMGR and add a listner and its location as well I started DBCA and found the same message add listener

9) i opened LSNRCTL and typed the command to START LISTENER and i found no listener error

10) When i am trying to add listener using NETCA ,during it's last step listener adding completion i found the below message :

Oracle Net Services Configuration:
Stopping Oracle Net Listener:
Running Listener Control:
d:apporacleproduct11.2.0dbhome_1inlsnrctl stop LISTENER
Listener Control complete.
Listener stop failed.

[code]....

View 4 Replies View Related

Forms :: Creating Domain Failed While Configuring Oracle Instance?

Feb 14, 2013

I have installed Weblogic Server 10.3.6 in my PC .While in installation i have chosen 'Custom' option instead of 'Typical' and Unchecked software Components 'Database Evaluation' and 'Oracle Coherence' and Installed 'Node Manager Service' then continued with Weblogic server installation .Weblogic Server installed Succesfully.

(In weblogic server home folder nodemanager.domains file also not created after weblogic server installation)

Now i started installation of Forms and Reports 11g R2 . While Configuring Instance 'Domain Creation is Failed'.

View 2 Replies View Related

Data Guard :: Error Occur While Configuring Standby Database

Apr 27, 2011

i have implemented dataguard successfully, but later on standby machine will change and i use another machine for standby and implement dataguard from beginning but it will generate the below mention error after executing duplicate target database for standby dorecover command.

contents of Memory Script:
{
switch clone datafile all;
}

[Code]....

View 2 Replies View Related

Data Guard :: Configuring RMAN For Incremental Backups In Environment

Aug 24, 2012

Here we have a dataguard environment with db1 as primary and db2 as physical standby database. We configured dataguard in 10g environments and we are not using grid control. What are the steps for configuring rman for incremental backups in this environment?

We want to schedule the backups to be taken in standby db, (that is applicable in case of switchover too). In the case of switchover to db2 what all do we need to do in rman manually to resume backups in db1?

View 1 Replies View Related

Data Guard :: Configuring Primary For A Failover (alternate) Remote Destination?

Aug 2, 2012

I have a situation where I want to configure primary database (11.2) with 2 remote destinations. dest_2 is the default and points to a standby on host_2. However, I also want the primary db to continue transporting redo to dest_3 on node_3 when node_2 is taken down (planned or unplanned).

1) Configure the ALTERNATE attribute of dest_2 to point to dest_3.

2) Configure tnsnames client-side failover on primary host to point to 2 nodes (node_2 and node_3).

View 1 Replies View Related

Enterprise Manager :: Configuring Grid Alerts For Two Different Groups Based On Database Environment

Aug 12, 2010

i have implemeted grid control for monitoring database. we have different database environment like PROD , STAGE, TEST, BETA.

Now my requirement is, i need to configure PROD & STAGE alert for one group (group1@oracle.com) means, what ever alerts generated by grid should sent notification to group1@oracle.com and TEST AND BETA database alerts should to group2@oracle.com.

Now i am following the oracle manual to configure notifications. unfortunately i could not find to complete my requirement.

[URL]

did any one implemented alerts to send different groups.

View 2 Replies View Related

Select Statement Errors

May 5, 2010

I have a question about select statements, as I am new to them and don't know how to work all the commands yet.

I'm making a select statement that is about half right... it is shown below:

select t.warehouse_id,
t.quantity_on_hand,
c.product_name
from pahtest3.inventories t
join pahtest3.product_information c using (product_id)
WHERE warehouse_id in (7);

I need to take this select statement and make it so it shows all the products that don't have any quantities in the warehouse in addition to the ones that are already being shown in that select statement.

View 2 Replies View Related

Getting Errors While Executing Procedure

Oct 4, 2010

I am getting errors while executing the following block.

create TYPE c_Rec as object(a VARCHAR2(1), b NUMBER);
DECLARE
-- TYPE c_Rec as object(a VARCHAR2(1), b NUMBER);
TYPE c_collection IS TABLE OF c_Rec;
l_coll c_collection := c_collection();
BEGIN
[code]........

error

06530. 00000 - "Reference to uninitialized composite"

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved