ORA-4031 on database creation in 10g release 2
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-4031 on database creation in 10g release 2

  1. #1
    Join Date
    Jul 2000
    Location
    Pune, India
    Posts
    80

    ORA-4031 on database creation in 10g release 2

    Hello,

    While creating test database on Oracle 10g Release 2 and running files for data mining option we have receive this error.

    connect SYS/password as SYSDBA
    spool %ORACLE_HOME%\Admin\databaseName\Create\odmmetadata.log
    REM *** Run all sql scripts for the Data Mining option installation.
    @%ORACLE_HOME%\RDBMS\admin\dminst.sql SYSAUX TEMP;
    spool off

    Errror in log file shows:

    SQL> execute sys.dbms_registry.loaded('ODM');
    BEGIN sys.dbms_registry.loaded('ODM'); END;

    *
    ERROR at line 1:
    ORA-04031: unable to allocate 16 bytes of shared memory ("shared pool","select/*+ index(idl_sb4$ i_...","sql area","kglhin: temp")
    ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_UTILITY"
    ORA-06512: at "SYS.DBMS_STATS", line 13206
    ORA-00604: error occurred at recursive SQL level 2
    ORA-04031: unable to allocate 16 bytes of shared memory ("shared pool","select u.name, o.name, o.nam...","sql area","kglhin: temp")
    ORA-06512: at "SYS.DBMS_STATS", line 13523
    ORA-06512: at "SYS.DBMS_STATS", line 15859
    ORA-06512: at "SYS.DBMS_STATS", line 15901
    ORA-06512: at line 1
    ORA-06512: at "SYS.DBMS_REGISTRY", line 560
    ORA-06512: at "SYS.DBMS_REGISTRY", line 612
    ORA-06512: at line 1

    SGA parameters are given below...
    SGA_MAX_SIZE = 300M
    SGA_TARGET = 150M

    Kindly help us to solve this issue.

    Thanks & Regards,

    Shailesh

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you dont have a big enough shared pool, increase sga_target

    150m is pretty small

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