OraFAQ Forum: Streams & AQ » How to find which two databases are configured for streams

Home » Server Options » Streams & AQ » How to find which two databases are configured for streams

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

How to find which two databases are configured for streams [message #75748]

Mon, 25 October 2004 22:43

Deepa
Messages: 269
Registered: November 2000

Senior Member

I am new to streams.Was given a box in which already streams has been setup between two Databases.
I have a box in which about 5 Databases are running.I know the source stream Database.
How to find out which is the Destination Database.

Report message to a moderator

Re: How to find which two databases are configured for streams [message #75752 is a reply to message #75748]

Thu, 04 November 2004 06:38

Ravi Kanth Perepu
Messages: 8
Registered: August 2004

Junior Member

Hi Deepa,
check the ALL_APPLY data dictionary for any records
i.e.,
select count(*) from ALL_APPLY;

the count>1 if the apply process was set for the target.
This should allow you to identify the target database.

Note:- You would need sysdba priveleges to perfom the above activity.
Regards
Ravi

Report message to a moderator

Re: How to find which two databases are configured for streams [message #75760 is a reply to message #75752]

Tue, 28 December 2004 21:11

Gangadhar
Messages: 3
Registered: April 2001

Junior Member

Check your database using the following query

Test your Streams configuration.
At the destination database
SQL> select apply_name,queue_name,apply_user, status from dba_apply;
SQL>
APPLY_NAME QUEUE_NAME APPLY_USER STATUS
------------------------------ ------------------------------ ---------------------
STRMADMIN_LOCAL STREAMS_QUEUE STRMADMIN ENABLED

At the source database
SQL> select capture_name,queue_name,status from dba_capture;
SQL>
CAPTURE_NAME QUEUE_NAME STATUS
------------------------------ ------------------------------ --------
STRMADMIN_CAPTURE STREAMS_QUEUE ENABLED

Report message to a moderator

Re: How to find which two databases are configured for streams [message #75769 is a reply to message #75752]

Tue, 08 February 2005 04:24

Krishnan Raghupathy
Messages: 1
Registered: February 2005

Junior Member

Hi Deepa

If it is a DownStream Database just query the DBA_DB_LINKS,DBA_REGISTERED_ARCHIVED_LOG in downstream database to get the information about source database.

If it is a Streams Replication environment database just query the DBA_PROPAGATION to get the information about source and destination databases.

Regards Raghu

Report message to a moderator

Previous Topic:	ORA-00942 in apply process
Next Topic:	oracle streams and multi byte data on SUN 8

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 13:14:01 CST 2024