DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2000
    Pune, India

    ORA-4031 on database creation in 10g release 2


    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,


  2. #2
    Join Date
    Sep 2002
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.