Home » Server Options » Streams & AQ » How to find which two databases are configured for streams
How to find which two databases are configured for streams [message #75748] Mon, 25 October 2004 22:43 Go to next message
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.
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous message
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
Previous Topic: ORA-00942 in apply process
Next Topic: oracle streams and multi byte data on SUN 8
Goto Forum:
  


Current Time: Thu Mar 28 07:24:04 CDT 2024