472,348 Members | 1,848 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,348 software developers and data experts.

Reply: Replication Of Oracle 9i in RH9

Frank <fb*****@nescape.net> wrote in message news:<bq**********@news1.tilbu1.nb.home.nl>...
Cherrish Vaidiyan wrote:

I have certain doubts regarding replication of Oracle 9i in Red Hat
Linux 9.

1) I want to implement asynchronous/synchronous multimaster
replication.I have heard about Replication Management Tool in OEM.
What are the steps to be taken initailly for using Replication
Management Tool ?

What - synchronous or async?
The OEM RMT helps setting up a replication environment. Point-and-shoot,
2) I have heard of certain steps

- Setup users, DB Links and schedules for Oracle Advanced

- Define replication groups with replication objects

- Remove replication support from database

- Monitor replication status, sites and groups.

Can anyone tell if for is the steps above are in order? If so, is
there any scripts to perform the above steps or do I have to use SQL
commands one bye one (for user creation, giving previlege)?

Yes - if you want to (I am all for that, and not for using OEM RMT)

3) Do anyone have the scripts or configuration procedure, who can
share with me.

Would be of little value, as your situation will not be mine, your
tables will be different, your requirement different, etc, etc, etc.

There are wonderful examples -scripts included- in the replication
4) Can anyone help me with the reference books which can help a
beginner like me to learn and implement all replications based on
situation? (I have got the concept,types,architecture through the
internet but I need to know what procedure to follow in SQL commands).

See tahiti.oracle.com (or docs.oracle.com), look for the replication
manuals - yes, plural!

Not one of the easiest fields for a beginner, though.


I want to implement replication by means of SQL commamnd prompt.Can u
help me with the sample script that you own.I can change the schema,
tables according to my need...Here is my situation of replication

I have 3 systems with RH 9. A database of Oracle 9i is to be
replicated in the 3 pc.
I thought of Synchronous replication first where a change made once in
a database is updated immediately in all the rest. but the drawback is
that if 1 database server is down the update wont work ie it will
rollback.but it wont have any conflicst if all servers are up.

But, I dont want rollback situation. So I want to implement
Asynchronous replication which means that a change made will be stored
initally as deferred transaction (I think v can set time for updates
say for 2 seconds etc.ie; every 2 sec cache and database will be
updated...but i dont know the paramaeter to set)and later updated in
all database.I know in such case I know in that case i have to handle
conflicts (that the second phase). but wont check if all the database
servers are up.

Hope u have understood my need and would help me ...pls reply
Cherrish Vaidiyan
Jul 19 '05 #1
0 2141

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Amy | last post by:
Hello All, We are currently looking into archiving our production system. I have looked into several different options to accomplish this, and...
by: Cherrish Vaidiyan | last post by:
Hello, I have certain doubts regarding replication of Oracle 9i in Red Hat Linux 9. 1) I want to implement asynchronous/synchronous...
by: Cherrish Vaidiyan | last post by:
Sir, I have implemented asynchronous replication on 2 database located in 2 different system. I did it with Replication Management GUI Tool....
by: Andras Kovacs | last post by:
We have a performance problem to replicate our environnement. Our java code is able to insert 100 000 rows in a table within 3 seconds using...
by: RYAN | last post by:
Hi All, I am new to Oracle and I have some question that I hope that someone out there can help me. I have heard the Oracle Rman can do...
by: steve | last post by:
Hi, several years ago , I implemented the oracle replication system. At that time our database was ported from an old Fox pro application. ( K...
by: Jan Wieck | last post by:
Dear community, for some reason the post I sent yesterday night still did not show up on the mailing lists. I have set up some links on the...
by: Pailloncy Jean-Gérard | last post by:
Hi, I just see that Mysql will propose at the end of the month a full synchronous replication system with auto-recovery....
by: mjan | last post by:
Hello, could you please advice on how to measure replication performance in Oracle, DB2 & MS SQL Server RDBMS installed in Windows servers ?...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.