SQL>startup pfile='/home/oracle/initgabsjsb.ora'; ORA-00371:notenough shared pool memory 几经折腾发现是参数文件中缺少processes这个参数而导致,如果没有设置process,process的默认值可能根据cpu的数量来估算,会是一个很高的值,进一步造成oracle认为需要很多shared
File created. 注意:如果在数据库安装目录下的dbs目录中没有找到spfile.ora文件,可以到目录下的database目录中寻找。*spfile文件一般为SPFILE实例名.ora...如我的实例名是ORCL,那么我的spfile文件为spfileORCL.ora。 3)pfile创建好之后,可以将里面的shared_pool_size修改为你需要的大小。 4)关闭数据库,从新建的pfi...
9 ORA-00371: not enough shared pool memory, should be atleast 750203385 bytes 1. 2. 3. 4. 5. 6. 7. 8. 9. 参数文件内容 pfile.ora 解决方法 按照提示将sharepool size设置为要求的大小 pfile.ora SHARED_POOL_SIZE=750203385 原因分析 这是oracle没有公布的一个bug Bug 13606499 - PHSB: DEFAUL...
1. Instance startup with default shared_pool_size fails with below error SQL> startup nomount pfile=/tmp/inittest.ora ORA-00371: not enough shared pool memory, should be atleast 'XXXXXX' bytes 2. The parameter file inittest.ora contains only DB_NAME parameter or no SHARED_POOL_SIZE para...
ORA-00371: Not Enough Shared Pool Memory signaled on Startup Database will not start even after restore. The Server has plenty of memory. A corruption occurred previously. Changes Restore was performed or other activity related to possible corruption. Cause Sign In To view full details, sign ...
ORA-00024: logins from more than one process not allowed in single-process mode Cause: Trying to login more than once from different processes for ORACLE started in single-process mode. Action: Logoff from the other process. ORA-00025: failed to allocate string Cause: Out of memory....
ORA-00371: not enough shared pool memory, should be at least string bytes Cause: The SHARED_POOL_SIZE initialization parameter was too small. Action: Increase the parameter value. ORA-00372: file string cannot be modified at this time Cause: attempting to modify the contents of a file...
ORA-01099: 如果在单进程模式下启动,则无法在 SHARED 模式下安装数据库 ORA-01100: 数据库已安装 ORA-01101: 要创建的数据库当前正由其它例程安装 ORA-01102: 无法在 EXCLUSIVE 模式下安装数据库 ORA-01103: 控制文件中的数据库名 ” 不是 ” ORA-01104: 控制文件数 () 不等于 ...
ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes 2011-11-05 15:05 − 问题如下: ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes 解决过程: 方法一: 首先确认'$ORACLE_HOME/dbs/spfileORCL.ora’下是否存在此文件,注意实例的大小写,... ...
ORA-00371: not enough shared pool memory, should be atleast 279260262 bytes SQL> create spfile from pfile='/u01/oracle/admin/xscen/pfile/init.ora.7272012173945'; File created. SQL> startup; ORACLE instance started. Total System Global Area 285212672 bytes ...