DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: When running DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN

  1. #1
    Join Date
    Sep 2000
    Posts
    103
    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

  2. #2
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    Anything in the alert log. Is all_sites=>TRUE?


  3. #3
    Join Date
    Sep 2000
    Posts
    103
    nothing in the alert log file. Where do I find all_sites=true

  4. #4
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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?

  5. #5
    Join Date
    Sep 2000
    Posts
    103
    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

  6. #6
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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
  •  


Click Here to Expand Forum to Full Width