DBAsupport.com Forums - Powered by vBulletin

View Poll Results: Is it Useful topic !

Voters
1. You may not vote on this poll
  • Yes

    1 100.00%
  • No

    0 0%
Results 1 to 10 of 20

Thread: catproc.sql error

Threaded View

  1. #13
    Join Date
    Mar 2010
    Posts
    35
    Quote Originally Posted by hany View Post
    - What is the alert log file telling you?
    - Are you seeing the error right after the script starts executing, or on the creation of a specific package, procedure, ..
    - What are the values of memory related parameters in your pfile/spfile?


    Mon Mar 08 16:58:24 2010
    ORA-1655: unable to extend table SYS.SMON_SCN_TO_TIME by 2 in tablespace SYSTEM
    ORA-1655: unable to extend table SYS.SMON_SCN_TO_TIME by 2 in tablespace SYSTEM
    Mon Mar 08 16:58:24 2010
    Errors in file c:\oracle\product\10.2.0\db_1\admin\apps\bdump\india_smon_3148.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01655: unable to extend cluster SYS.SMON_SCN_TO_TIME by 2 in tablespace SYSTEM
    1:
    Mon Mar 08 17:03:25 2010
    ORA-1655: unable to extend table SYS.SMON_SCN_TO_TIME by 2 in tablespace SYSTEM
    ORA-1655: unable to extend table SYS.SMON_SCN_TO_TIME by 2 in tablespace SYSTEM
    Mon Mar 08 17:03:25 2010
    Errors in file c:\oracle\product\10.2.0\db_1\admin\apps\bdump\india_smon_3148.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01655: unable to extend cluster SYS.SMON_SCN_TO_TIME by 2 in tablespace SYSTEM


    2:
    Yes am seeing the Error after running that "catproc.sql".,
    few lines shows procedure created,, at final that was the error.

    3:
    here is the memory parameters,
    sga_target=200m;
    pga_aggregate_target=200m

    db_block_size=8192

    am using 10g.. so i didn't found any other parameters.
    Last edited by 4iappsDBA; 03-08-2010 at 08:05 AM.

Tags for this Thread

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