Replication :: To Upgrade All Oracle 10g Master Sites / Databases To 11g Release

May 28, 2009

I want to upgrade all the Oracle 10g Release (10.2.0)master sites (bi-directional) databases to Oracle 11g Release (latest). In fact, we are using bi-directional oracle streams and snapshot replication, it means capture,propagate and apply process is running.

View 1 Replies


ADVERTISEMENT

Replication :: Network Requirements For Oracle Multi Master Replication?

Apr 1, 2010

what are the recommended network requirements for implementing Oracle Multi Master replication.

View 1 Replies View Related

Replication :: Removing Master Site Which Is In Multi-master Environment?

Sep 16, 2008

I want to remove the master site which is in the multi master replication environment.

I have a doubt here. When I try to suspend the master activity,I need to give the gname.

BEGIN
DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY (
gname => 'NAGADMIN');
END;
/

Where gname=master group name.But I have 9 master groups in my database. If i give one of the gname present in the master site will suspend the replication of the entire database from the replication.

eg; i am only giving NAGADMIN gname in the suspend activity script.. I have other gnames like, NAGUSER,NAGAUTH, etc....

View 3 Replies View Related

Replication :: Getting Error In Configuration Of Replication Between Two Databases

Jan 28, 2011

I Have configured the replication between two database's at table level. After few miniuts of successful configuration of replication between two db's at table level, I am getting the ORA-00001: unique constraint (%s_PK) violated error in dba_apply_error.

I checked constraint name,type and status on table replicated is same on both source and destination db.

View 4 Replies View Related

Replication :: Data Between 4 Databases In Network

Nov 22, 2012

We want to replicate the data between the databases.We have 4 databases in a network.If there will be any change in database 1,e.g. updation in any table,it should automatically replicate on other 3 databases.or user will change something in database 2 ,it should replicate on other 3 databases and vice versa. All 4 databases have same schema and same configuration.

View 1 Replies View Related

Replication :: Set Up Replication Between Three 10g R2 Databases

Jan 14, 2011

I need to set up replication between three 10g R2 databases.There will be one main database where the data will flow into two small databases. A little bit of information will flow back from these smaller databases into the main one.

I have been asked to evaluate ODI as an option. Unfortunately I cannot use Golden Gate due to the cost.I've had a play with ODI and it looks like it's all done on a GUI where I would much prefer to be using command line scripts for setup and monitoring.

It also looks like ODI is more geared to integrating data from many different sources but I'm just going from Oracle to Oracle so don't know if it's a bit overkill.

I'm thinking of just looking at CDC which I can set up with scripts and looks to be the basis behind ODI anyway (when it comes to taking data from Oracle) - again. I may even go down the streams route that I have used before.

View 7 Replies View Related

Upgrade Three 32bit 9i Databases To Single 64bit 11g

Jul 12, 2011

We are planning upgrade three 32-bit 9i databases (on three physical machines) to a single 64-bit 11g VMware box. Average size of DB is 300GB.Planning to move the first 9i DB by the end of this month, followed by 2 and 3.How to do this using hot backup?

View 6 Replies View Related

Replication :: Error During Add New Master In Not Acquiescing Mode

Oct 27, 2008

I have a multimaster replication between 2 sites (BASE1 and BASE3). BASE1 is the master definition site. I want to add a new master site without acquiescing the master group (named GM_ADMINISTRATEUR).

First, I have used the script provided by Oracle :

DBMS_REPCAT.SPECIFY_NEW_MASTER (
gname => 'GM_ADMINISTRATEUR',
master_list => 'BASE2.WORLD' );
and
DBMS_REPCAT.ADD_NEW_MASTERS( ....);

The first time, I had Errors, so I use the command

DBMS_REPCAT.UNDO_ADD_NEW_MASTERS_REQUEST

and I drop the master site BASE2 (connected as repadmin to BASE2 site).

The master site BASE2 is not present at BASE1 master definition site, The master repgroup is not present at BASE2 BUT, the master site BASE2 is always present at BASE3 master site. I think that the command UNDO_ADD_NEW_MASTERS_REQUEST undo the changes on BASE1 (the master definition site) but don't undo the changes on the site BASE3.

And now, when I want redo the add_new_masters, the command

DBMS_REPCAT.ADD_NEW_MASTER
return a error on the command ADD_NEW_MASTER in the DBA_REPCATALOG for the following reason:
ORA-00001: violation de contrainte unique (SYSTEM.REPCAT$_REPSCHEMA_PRIMARY)
ORA-06512: � "SYS.DBMS_REPCAT_UTL", ligne 4484
ORA-06512: � "SYS.DBMS_REPCAT_RPC", ligne 1758

And I can't continue because the new master site BASE2 does not appear at BASE1 master definition site. I think I have to drop the master site BASE2 at the master site BASE3, but I dont know how to do this.

**** Following information at BASE1 (master definition site : *****
prompt Replication schemas/ sites
Replication schemas/ sites
select
sname,
masterdef,

[code].....

View 14 Replies View Related

Replication :: Error During Addition Of Master Site

Oct 18, 2008

I get below error when i tried to add the master site to the master definition site.

SQL> BEGIN
2 DBMS_REPCAT.ADD_MASTER_DATABASE(
3 gname => 'TEST',
4 master=> 'testdb2',
5 use_existing_objects => FALSE,
6 copy_rows => FALSE,
[code].......

View 5 Replies View Related

Replication :: Create Data From MV Site To Master?

Dec 24, 2007

m trying to create replications of data from the M.V. site. to master site

/* AT MASTER SITE */

1. MASTER REPLICATE GROUP
2. MASTER REPLICATE OBJECT
3. REPLICATION SUPPORT
4. REPLICATION ACTIVITY
5. M.V. LOG

/* AT M.V. SITE */

1. MATERIALIZED VIEW (M.V)
2. DBMS_REFRESH.MAKE (REFRESH GROUP)

AND I AM NOT ABLE TO CREATE

1. CREATE_MVIEW_REPGROUP
2. CREATE_MVIEW_REPOBJECT

IN M.V. SITE , and i am getting following error while creating REPGROUP
CODE
SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
3 gname => 'emp_repg',
4 master => 'orc1',

[code]..

View 1 Replies View Related

Replication :: Replicating Master Site Via Materialized Views

Mar 4, 2011

while replicating the master site via materialized views, in mViewGroups i issued:

BEGIN
DBMS_REFRESH.MAKE (
name => 'mvadmin.hamza_refg',
list => '',
next_date => SYSDATE,
interval => 'SYSDATE + 1/1440', -- for test purpose i used such a small interval
implicit_destroy => FALSE,
rollback_seg => '',
push_deferred_rpc => TRUE,
refresh_after_errors => FALSE);
END;

in my previous attempt it worked all fine... i had a change in senerio, so i did my replication again from scractch using the same old spool in a new installation but even after 3 tries on replicating from scratch my objects are not getting refreshed automatically. even when i attempt to refresh the group it does not work. it works only when i refresh each of the participating object of the group manually.

View 4 Replies View Related

Replication :: Difference In Using Updateable Materialized View And Multi Master Async

Aug 21, 2008

I have 3 sites which want to be updated as soon as the other one updates its data.(in 5 seconds). So I have chosen multi master solution,sync regardless of the resource consideration.

1-what is the difference between multimaster async and updatable materialized view regardless of resource consuming in multimaster?because in both of them each site can receive and also propagate the data...I just know that in materialized view we can work offline and then apply it manually is there any other thing?

2-I can not understand the difference between multimaster sync and async (considering the 5 seconds,because 5 second is a little time)I mean in this case are they different from each other or not.

View 1 Replies View Related

Replicating One Rep Object In Multiple Sites

Oct 31, 2008

I have 8 databases in multi master replication. I need to replicate only one rep object in to master sites. But I have 8 rep objects in the master definition site. is it possible to replicate the required rep object only without bringing the other rep objects in to replication.

View 10 Replies View Related

Downgrade Oracle Database 10g Release 10.2.0.2.0 To 10.2.0.1.0?

Nov 29, 2011

am trying to downgrade my oracle database 10g release 10.2.0.2.0 to 10.2.0.1.0the reason for this is that i had to copy /oracle_home/bin utilities from 10.2.0.1 to 10.2.0.2 because of this most utilities like rman,dbca were not working.

i think i need to downgrade my oracle database 10g release to 10.2.0.1.0 right?i read some oracle documentations of database downgrade instruciting me to

>take full backup of oracle DB
>ORACLE_HOME/bin/emctl stop dbconsole
SQL> STARTUP DOWNGRADE
DROP USER sysman CASCADE;
>SQL> SPOOL downgrade.log

[code]....

View 1 Replies View Related

Replication :: Oracle Streams / Tried Schema Replication Through Enterprise Manager Grid Control

Feb 22, 2012

Actually am trying to replicate two db servers from one in hong kong and another in china. when am trying to establish the replication, am getting error 'ORA-04052: error occurred when looking up remote object' like this...

but the same way i have tried in my local network, it is working fine.i have tried schema replication through enterprise manager grid control..

View 6 Replies View Related

Windows :: Unable To Continue Oracle 11g Release 2 Installation

Jul 24, 2013

I was prompted by an error in the middle of Oracle 11g Release 2 installation and unable to continue further.

The error was file not found e:product11.2.0.dbhome_3oc4jj2eeoc4j_applicationsapplications em.ear.

View 2 Replies View Related

Forms :: Find Key Pressed And Release Action On Oracle 10g

Dec 14, 2012

we need to find the key pressed action and key release action on Oracle form 10g. On key pressed (i.e. key-up, key-down, key-page-up and key- page-down) the event will be fired and as soon as the user release the key, the event will be stop.

As current situation, we have one form which contains the database blocks. As per search condition, all the data populated in Database block, there are 1000 and more records. Now user going use any of key (i.e. key-up, key-down, key-page-up and key-page-down) as he pressed key ( say Key- down) it scrolled down but as soon as he release the key, the event is not stopped. its going on going down then stop.

Is it possible, as user release the key scrolling will stopped at same time ?

View 3 Replies View Related

Installation :: Oracle Database 11g Release 11.2.0.3.0 IBM AIX On POWER Systems (64-bit)

Mar 13, 2013

Is Oracle Database 11g Release 2 (11.2.0.3.0) available for IBM AIX on POWER Systems (64-bit), Or do we need to upgrade 11.2.0.1 to 11.2.0.3.0.

View 4 Replies View Related

Security :: How To Mask Data In Oracle 11g Database Release 1

Oct 16, 2012

how to mask data in oracle 11g database release 1

my environment is
Database: 11g release 1
os: AIX 6 (64 bit)
GC:10g release 1

View 12 Replies View Related

Upgrade :: Oracle 11.2.0.3.0 Database Upgrade Changes DATA_PUMP_DIR

Jun 6, 2012

Along with existing RMAN backups we do Exports - of our DB using and OS User and Oracle Wallet.Of the DB's we have upgraded the Data Pump Directory

Select * from dba_directories; (there are other commands to get this info as well).

I captured screens from the DBUA upgrades, but did not see an option to change this information.Is there a way to feed this information to the install moving forward. IE, ./DBUA -silent ?

Also, anyone tracked the percentage of storage increase from 10.2/11.1 to 11.2.

View 4 Replies View Related

Upgrade :: Patchset Number To Upgrade Oracle

Jun 14, 2012

Know the Patch set number to upgrade a Oracle 10.2.0.1 to 10.2.0.5 on Solaris 10 Spark 64bits?

View 1 Replies View Related

Server Administration :: How Many Users Can Be Created In Oracle 11g Release 2 Database

Dec 27, 2012

how many users we can create in oracle 11g release 2 database. Is there any specific limit or parameter for that.

View 1 Replies View Related

Reports & Discoverer :: Reporting Against Ap Invoice Hold Release Name In Oracle 11.5.10

May 9, 2012

why we seem to be unable to report against the ap invoice hold release date using Discoverer in Oracle 11.5.10? the person who wrote our current report used a decode statement to look at the last update date of the release lookup code to create a release date, but i am trying to recreate this in a different tool (Qlikview) and just wanted to understand why we seem to be unable to report on the field as is!

View 4 Replies View Related

Installation :: Install Latest Release Of Oracle Database On A Solaris 11 Zone

May 11, 2013

which is really a HA zone clustered in VCS(not important for installation of the database).

What parameters do I need to set or change in the Solaris zone, there seems to be no /etc/system file.

View 3 Replies View Related

Backup & Recovery :: Migrating Databases / Task To Migrate Total Databases

Mar 27, 2012

I have the task to migrate the total databases(Exact copy to be moved to another server).The current server is going for format.After I did the following steps I am getting the tablespaces(databases)-4 sizes same ,but I am facing issue like some default tablespaces i.e temp,system are not matching.

temp tablespace
***************
current server - 4.0(approximately)
Migrating server - 160 MB

System tablespace
*****************
current server - 580 MB
Migrating server - 220 MB

Also I checked the tables are also matching for the 4 databases.Also Provide the solution or method which is correct.

steps done for migrating(By me)
********************************
EXPORTING DATA USING DATAPUMP
*********************************

1 From command prompt MKDIR 'c:oraclexeapp mp';

2 From SQL prompt conn system/kotak;

3 create or replace directory dmpdir as 'c:oraclexeapp mp';

4 grant read,write on directory dmpdir to kotak;

5 From command prompt

expdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=expdpxe.log;
IMPORTING DATA USING DATAPUMP
*****************************
in another server machine

1 From SQL prompt conn system/kotak;

2 create or replace directory dmpdir as 'c:oraclexeapp mp';

3 grant read,write on directory dmpdir to kotak;

4 From command prompt set ORACLE_SID=xe;

5 impdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=impdpxe.log;

IN OUR PROCESS we created the below tablespaces and user before IMPORTING created 4 tablespaces

1. kotak
2. kotakdb
3. wired_data
4. ferrari

Created Users which are there in 219 server
1. KOTAK
2. KOTAKDB
3. FC_80
4. DEMOINTERNETBANK
5. DEMOINTERNETBANKDB
6. CREDITCARD

View 1 Replies View Related

Upgrade :: Oracle Upgrade 11.1.0.7 To 11.2.0.3 - Compatible

Jul 19, 2013

I am going to upgrade database from 11.1.0.7 to 11.2.0.3

1) If compatible is set to 10.2.0 in 11.2.0.3, will it work ?
2) If compatible set to maximum level, will it affect our application ?
3) Whether any code related problem occurred after upgrading like PL/SQL codes ?

View 6 Replies View Related

Upgrade :: Oracle Database Upgrade

Mar 13, 2013

We are planning to upgrade our database from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi to Oracle Standard Edition 11g . We also have oracle apex installed on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi database with oracle apex 3.1

No our plan to upgrade the database and oracle apex to 4.2. Since Oracle Enterprise Edition is licensing is very expensive we though of buying standard edition and upgrade to this version.

can we upgrade the oracle database from enterprise edition to latest standard edition?

View 3 Replies View Related

Replication :: Oracle Replication Between Different Versions?

Sep 17, 2008

I need to do a Oracle replication between databases. One resides on Oracle 8i which needs to be replicated to a database on Oracle 10G.

Is oracle replication supported between dissimilar versions of Oracle?

View 3 Replies View Related

Replication :: Oracle 8i Asynchronous Replication

Apr 9, 2012

I want to configured A Synchronous replication in oracle 8i. Noe using GUI i am bale to create replication but whatever i modify it remain in the transaction i have to manually run the job ,

I also tried to configured continuous asynchronous configuration by setting delay rate 500000. but it was also not working.

View 2 Replies View Related

Replication :: One Way Replication From MS Sql Server To Oracle 10g

Feb 11, 2010

Is it possible to replicate table data on real time from sql server (2005 32 bit or sql server 2000 32 bit)to oracle 10g running on linux 64 bit? If yes then what are the steps.

It will be one way replication from sql server to oracle. Which option is best sql server dts or Oracle Stream replication to replicate table data.

View 3 Replies View Related







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