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.
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:
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
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.
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 ,
from v$session s,
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
Don't blame me, I'm from Red Sox Nation.
Click Here to Expand Forum to Full Width