What the difference between these two command!

解决srvctl启动Oracle实例失败

最新推荐文章于 2025-12-03 13:04:04 发布

最新推荐文章于 2025-12-03 13:04:04 发布 · 85 阅读

文章标签：

#数据库

本文记录了使用srvctl命令启动Oracle RAC实例RPTS3时遇到的问题及解决过程。当srvctl命令无法正常启动实例时，通过SQL*Plus手动启动成功。问题可能与pfile设置有关。

Ready to do a restart but find the following issue with srvctl command then turn to use the startup from sqlplus.

But I guess the different is pfile use.

$ srvctl status instance -d RPTS -i RPTS3
Instance RPTS3 is running on node rac03-ud-us-eqx
$ srvctl status instance -d RPTS -i RPTS1
Instance RPTS1 is running on node rac01-ud-us-eqx
$ srvctl status instance -d RPTS -i RPTS2
Instance RPTS2 is running on node rac02-ud-us-eqx
$ srvctl stop instance -d RPTS -i RPTS3
$ srvctl start instance -d RPTS -i RPTS3
PRKP-1001 : Error starting instance RPTS3 on node rac03-ud-us-eqx
CRS-0215: Could not start resource 'ora.RPTS.RPTS3.inst'.

There is no more useful infomation from the alert log:

Tue Nov 9 20:35:08 2010
Starting ORACLE instance (normal)
Tue Nov 9 20:35:08 2010
WARNING: EINVAL creating segment of size 0x0000000380008000
fix shm parameters in /etc/system or equivalent

turn to use the traditional way to startup.

$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 9 20:36:22 2010

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1.5032E+10 bytes
Fixed Size 2056192 bytes
Variable Size 5486149632 bytes
Database Buffers 9529458688 bytes
Redo Buffers 14721024 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
$ srvctl status instance -d RPTS -i RPTS3
Instance RPTS3 is running on node rac03-ud-us-eqx