DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Setting up Replication Environment

  1. #11
    Join Date
    Nov 2000
    Posts
    245

    to LND


    you are good, I never thought I should check alert file
    here are tons of error in alert and 2 trace file:

    ORA-12012: error on auto execute of job 9
    ORA-02394: exceeded session limit on IO usage, you are being logged off
    ORA-06512: at "SYS.DBMS_DEFER_SYS", line 2883
    ORA-06512: at line 1
    *** SESSION ID:(9.37413) 2001.02.02.14.42.50.000
    *** 2001.02.02.14.42.50.000
    ORA-12012: error on auto execute of job 10
    ORA-02394: exceeded session limit on IO usage, you are being logged off
    ORA-06512: at "SYS.DBMS_DEFER_SYS", line 2883

    looks like I have problem for IO usage, how to solve it?
    I am on SCO unixware 7.1, oracle 8.0.5

    Jim


  2. #12
    Join Date
    Nov 2000
    Posts
    212
    maybe look into profiles (in SQL manual, create profile).
    view is DBA_PROFILE
    then what user has whar profile too.

  3. #13
    Join Date
    Nov 2000
    Posts
    245

    SQL> select * from user_resource_limits;

    RESOURCE_NAME LIMIT
    -------------------------------- ----------------------------------------
    COMPOSITE_LIMIT UNLIMITED
    SESSIONS_PER_USER UNLIMITED
    CPU_PER_SESSION UNLIMITED
    CPU_PER_CALL UNLIMITED
    LOGICAL_READS_PER_SESSION UNLIMITED
    LOGICAL_READS_PER_CALL UNLIMITED
    IDLE_TIME UNLIMITED
    CONNECT_TIME UNLIMITED
    PRIVATE_SGA UNLIMITED

    I just find out, this is known bug ora-02394 for 8.0.4 and fixed on 8.0.6 and 8.0.5.2 (this is our version)

    I guess there is no solution!



  4. #14
    Join Date
    Nov 2000
    Posts
    212
    does it make sense to limit to some high value?

  5. #15
    Join Date
    Nov 2000
    Posts
    245
    LND,

    believe or not, it works. what I did is bounce DB once.
    I tried few times, after setting up snapshot site, before
    shutdown instance, I can see the job is doing nothing
    (from dba_jobs). after bounce back, it refresh every
    6 seconds!!! any idea?

    Derek

  6. #16
    Join Date
    Nov 2000
    Posts
    212
    I will try to remember this idea: reboot, reboot even if not asked.

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