安装ORACLE10 ora-22303 ora-00604 ora-04031

安装ORACLE10 ora-22303 ora-00604 ora-04031

ora-22303 ora-00604 ora-04031

日月明王BLOG  http://sunmoonking.spaces.live.com 

      在安装ORACLE10 的时候，默认SHARE POOL大小是80，觉得自己测试有点浪费，于是改成可以设置的最小值40，安装近50%的时候出现ora-22303 ora-00604 ora-04031 错误，错误解释如下。

22303, 00000, "type /"%s/"./"%s/" not found"

//  *Cause:  The user is trying to obtain information for a type that

//           cannot be found.

//  *Action: Check that the schema is correct and that the type has been

//           created correctly.

 

00604, 00000, "error occurred at recursive SQL level %s"

// *Cause:  An error occurred while processing a recursive SQL statement

//         (a statement applying to internal dictionary tables).

// *Action: If the situation described in the next error on the stack

//         can be corrected, do so; otherwise contact Oracle Support.

 

04031, 00000, "unable to allocate %s bytes of shared memory (/"%s/",/"%s/",/"%s/

",/"%s/")"

// *Cause:  More shared memory is needed than was allocated in the shared

//          pool.

// *Action: If the shared pool is out of memory, either use the

//          dbms_shared_pool package to pin large packages,

//          reduce your use of shared memory, or increase the amount of

//          available shared memory by increasing the value of the

//          INIT.ORA parameters "shared_pool_reserved_size" and

//          "shared_pool_size".

//          If the large pool is out of memory, increase the INIT.ORA

//          parameter "large_pool_size".

       通过设置60M SHARED POOL解决