OraFAQ Forum: Streams & AQ » Streams in Enterprise Manager

Home » Server Options » Streams & AQ » Streams in Enterprise Manager

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Streams in Enterprise Manager [message #246128]

Wed, 20 June 2007 01:12

logina
Messages: 11
Registered: June 2007
Location: hyd

Junior Member

Hi all,
I set my database mode to ARCHIVELOG and i run the setup of Streams in Enterprise Manager. Finally after giving source database and dest database passwords. I got finally window like this i am attaching the window what i can do. sorry i am very new to replication.
Thank you.

Attachment: Document.zip
(Size: 166.92KB, Downloaded 3360 times)

[Updated on: Thu, 21 June 2007 00:50]

Report message to a moderator

Re: Streams in Enterprise Manager [message #246338 is a reply to message #246128]

Wed, 20 June 2007 11:47

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Did your OMS is configured?
run these scripts manullay from SQL prompt.

SQL>@e:\oracle\product\10.2.0\client_2\sysman\report\OTEST_ADMIN_NON_OMS_SETUP.sql
SQL>host e:\oracle\product\10.2.0\client_2\sysman\report\OTEST_ADMIN_NON_OMS_exportimport.bat
SQL>@e:\oracle\product\10.2.0\client_2\sysman\report\OTEST_ADMIN_NON_OMS_startup.sql

[Updated on: Wed, 20 June 2007 12:07]

Report message to a moderator

Re: Streams in Enterprise Manager [message #246339 is a reply to message #246338]

Wed, 20 June 2007 11:48

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Heres the Replication Tutorial.

Attachment: Oracle Replication Survival Guide.doc
(Size: 394.50KB, Downloaded 4256 times)

Report message to a moderator

Re: Streams in Enterprise Manager [message #246451 is a reply to message #246338]

Thu, 21 June 2007 00:48

logina
Messages: 11
Registered: June 2007
Location: hyd

Junior Member

Thank you very much for your reply.
Is the streams replication replicate only data or tables also.

[Updated on: Thu, 21 June 2007 03:13]

Report message to a moderator

Re: Streams in Enterprise Manager [message #246548 is a reply to message #246338]

Thu, 21 June 2007 05:07

logina
Messages: 11
Registered: June 2007
Location: hyd

Junior Member

Thank you very much DreamzZ. Cool

I run the commands from sql*plus. successfully those commands completed.
Now i got streams under source database and dest database.
But the data is not replicating. only single table i replicate. I inserted one record in the source database but the record is not coming in the dest database. Anything i need to do? Please tell me.
I am attaching the topologies of source ans dest databases.
Source database is in ARCHIVELOG mode. and dest database is in NOARCHIVELOG mode.
Thanks in advance.
Embarassed

Attachment: topologies.zip
(Size: 225.64KB, Downloaded 2364 times)

[Updated on: Thu, 21 June 2007 06:15]

Report message to a moderator

Re: Streams in Enterprise Manager [message #246666 is a reply to message #246548]

Thu, 21 June 2007 10:34

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

TAKE A look over here

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10728/toc.htm

Report message to a moderator

Previous Topic:	Replication using Streams
Next Topic:	[Queuing] parallel consumer processes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 17:49:03 CST 2024