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%
Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20

Thread: catproc.sql error

  1. #11
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    also post the complete version of Oracle. you just installed the base version binaries or after base version have you applied any patch sets to upgrade...etc

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  2. #12
    Join Date
    Mar 2010
    Posts
    35
    Quote Originally Posted by 4iappsDBA View Post
    yes,, i am in sys user only,, still having the same result,, am really fed up with this,,

    am going to create another new database,, and am requesting u all to give me time to create it once again,,
    brothers.. i have created another database i successfully ran the catalog.sql file.,, afterwards i randed "catproc.sql" still same error..

    ERROR:
    ORA-03114: not connected to ORACLE


    i have created very correctly by my recorded syntax.. if anyone need i can give the syntax's for check!

  3. #13
    Join Date
    Mar 2010
    Posts
    35

    Post

    Quote Originally Posted by vnktummala View Post
    also post the complete version of Oracle. you just installed the base version binaries or after base version have you applied any patch sets to upgrade...etc

    Thanks,
    BANNER
    ----------------------------------------------------------------
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
    PL/SQL Release 10.2.0.1.0 - Production
    CORE 10.2.0.1.0 Production
    TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
    NLSRTL Version 10.2.0.1.0 - Production

  4. #14
    Join Date
    Dec 2001
    Posts
    320
    - 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?
    Anyone can hold the helm when the sea is calm.

  5. #15
    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.

  6. #16
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    use dbca to create a database, then learn how to do it - we are going round in circles here

  7. #17
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by davey23uk View Post
    use dbca to create a database, then learn how to do it - we are going round in circles here
    I agree with using dbca. And furthermore, if you use dbca there is an option to have the scripts created for you and someone can then either run those scripts manually or just read them to know what they are missing.

    But some people are just stubborn...

  8. #18
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    If you still don't want to use dbca, in your manual db creation script make sure SYSTEM and SYSAUX table spaces are at least 350 MB size and auto extend on.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  9. #19
    Join Date
    Mar 2010
    Posts
    35
    Quote Originally Posted by vnktummala View Post
    If you still don't want to use dbca, in your manual db creation script make sure SYSTEM and SYSAUX table spaces are at least 350 MB size and auto extend on.

    Thanks,
    Ok brother let me try on that way !.. thank u for all those who given me reply and useful tips..

    thanks a lot..


    Brothers and friends, i have tried in dbca, and its working fine without any error.
    now i came to a conclusion..

    if am not wrong !
    A Manual Creation Database should contain system and sysaux file must above 400MB. this is the best way i found from my scenario.

    thank u for ur all support to my first step on this field..
    Last edited by 4iappsDBA; 03-09-2010 at 12:40 AM. Reason: tested and varifield myself

  10. #20
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by 4iappsDBA View Post
    system and sysaux file must above 400MB
    mmmmhhhh somehow Yes. You are reaching this conclusion for all wrong reasons.
    Research SYSTEM, SYSAUX.
    Last edited by PAVB; 03-09-2010 at 09:17 AM. Reason: typo
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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