个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2020-01-24 11:00:42
用 srvctl 启动 rac 数据库有时会起不来，例如：
oracle@testdb01 ~]$ srvctl start database -d orcl
prcr-1079 : failed to start resource ora.orcl.db
crs-5017: the resource action "ora.orcl.db start" encountered the following error:
ora-27104: system-defined limits for shared memory was misconfigured
. for details refer to "(:clsn00107:)" in "/u01/app/grid/diag/crs/testdb02/crs/trace/crsd_oraagent_oracle.trc".
crs-2674: start of 'ora.orcl.db' on 'testdb02' failed
crs-2632: there are no more servers to try to place resource 'ora.orcl.db' on that would satisfy its placement policy
crs-5017: the resource action "ora.orcl.db start" encountered the following error:
ora-27104: system-defined limits for shared memory was misconfigured
. for details refer to "(:clsn00107:)" in "/u01/app/grid/diag/crs/testdb01/crs/trace/crsd_oraagent_oracle.trc".
crs-2674: start of 'ora.orcl.db' on 'testdb01' failed
看着报错挺吓人，日志很高深。不要怕，先手工试试
[oracle@testdb01 ~]$ sqlplus / as sysdba
看看提示些啥，结合alert.log就比较好定位原因了。
这个例子就是内存参数设置太大了。
sqlplus / as sysdba
create pfile='/tmp/init.ora' from spfile='xxx';
修改正确的sga db_cache_size shared_pool_size参数后再
create spfile=' datadg/orcl/parameterfile/spfile_orcl_new' from pfile='/tmp/init.ora';
startup force 解决。
oracle@testdb01 ~]$ srvctl start database -d orcl
prcr-1079 : failed to start resource ora.orcl.db
crs-5017: the resource action "ora.orcl.db start" encountered the following error:
ora-27104: system-defined limits for shared memory was misconfigured
. for details refer to "(:clsn00107:)" in "/u01/app/grid/diag/crs/testdb02/crs/trace/crsd_oraagent_oracle.trc".
crs-2674: start of 'ora.orcl.db' on 'testdb02' failed
crs-2632: there are no more servers to try to place resource 'ora.orcl.db' on that would satisfy its placement policy
crs-5017: the resource action "ora.orcl.db start" encountered the following error:
ora-27104: system-defined limits for shared memory was misconfigured
. for details refer to "(:clsn00107:)" in "/u01/app/grid/diag/crs/testdb01/crs/trace/crsd_oraagent_oracle.trc".
crs-2674: start of 'ora.orcl.db' on 'testdb01' failed
看着报错挺吓人，日志很高深。不要怕，先手工试试
[oracle@testdb01 ~]$ sqlplus / as sysdba
看看提示些啥，结合alert.log就比较好定位原因了。
这个例子就是内存参数设置太大了。
sqlplus / as sysdba
create pfile='/tmp/init.ora' from spfile='xxx';
修改正确的sga db_cache_size shared_pool_size参数后再
create spfile=' datadg/orcl/parameterfile/spfile_orcl_new' from pfile='/tmp/init.ora';
startup force 解决。
给主人留下些什么吧！~~