When running DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN

Hi,

I created my replication group and objects at one of the master sites and now I'm trying to run
DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN from the other master site. But the db hangs and I'm not ab;e to log in from sqlplus or dos prompt. Is there any way out of this?

Thanks a lot in advance for yr help.

pst

Anything in the alert log. Is all_sites=>TRUE?

nothing in the alert log file. Where do I find all_sites=true

The deafault is false:

DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN (
gname IN VARCHAR2,
all_sites IN BOOLEAN := false);

What version Oracle? What operating system?

Are you using SQL*Plus from client machine or directly on the server?

This is oracle 8.1.7. And I'm running from the client machine.
I was just running it as
EXECUTE DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN('GRP1');

Thanks a lot for the help.

Should I try it the way you specified. The problem I have is I have to bring the database down by rebooting win2000 server. I cant restart the datbase otherwise.

thanks again

Bottom line : issuing Admin Request is so begein

Well...this is a trouble shooting type of thing.
Please allow me to first establish that the dB is okay

0. Test Your dB links!!!!
1. Try logging in to SQL*PLUS from the server and issue some SQL to make certain the dB is still running oaky.
2. is listener okay?
3. use SQL (from the server) or a tool (Top Session or OEM) to find the session that is hung:

select s.sid ,
s.serial#,
s.status,
s.osuser ,
s.username,
t.sql_text,
s.machine,
s.terminal,
p.program
from v$session s,
v$process p,
v$sqltext t
where t.address = s.sql_address
-- and s.status = 'ACTIVE'
and s.paddr = p.addr
and t.hash_value = s.sql_hash_value
order by p.spid, t.hash_value, t.piece