-
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
Don't blame me, I'm from Red Sox Nation.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|