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?
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.
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.
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.
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.
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?
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.
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
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
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.
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.
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 .
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
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....
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.?
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.
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'.
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; }
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?
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).
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.
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.
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"