1.查看数据库的自启动方式是自动的
$srvctl config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /app/database/product/11.2.0/db
Oracle user: oracle
Spfile: +DATAVG/orcl/spfileorcl.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances: orcl1,orcl2
Disk Groups: DATAVG
Services:
Database is administrator managed
重新设置开启自启动也报错:
$srvctl enable database -d orcl
PRCC-1010 : orcl was already enabled
开启单个实例的自启动
$srvctl enable instance -d orcl -i orcl1
$srvctl enable instance -d orcl -i orcl2
重启之后仍然不能自启动。
2.查看数据库资源的相关属性
查看属性发现AUTO_START=restore,将这个属性更改为always。
#crs_stat -p
NAME=ora.orcl.db
TYPE=ora