Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Automatically starting grid and oracle db after server startup

raulk89Mar 23 2017 — edited Mar 23 2017

Hi

Shouldn't grid and oracle database start automatically after server boot..?

At least some of my servers it actually does start up on its own (grid and database).

At the moment, when I boot one or all of my rac server(s) (2 node rac), then crs won't start automatically.

[root@etmasterdb1 ~]# /oracle/11.2/gridInfra/bin/crsctl check crs

CRS-4639: Could not contact Oracle High Availability Services

But when I start crs, with command:

[root@etmasterdb1 ~]# /oracle/11.2/gridInfra/bin/crsctl start crs

CRS-4123: Oracle High Availability Services has been started.

Then it starts +ASM and listener etc, but it won't start database. Have to manually login with sqlplus and start it up on both nodes.

So far, I have registered database and asm with srvctl, added /etc/oratab +ASM and database entries.

[root@etmasterdb1 ~]# cat /etc/oratab

+ASM1:/oracle/11.2/gridInfra:N

etmaster:/oracle/11.2/db:N

Now I know you may say that change N -> Y, but have already tried this, no luck. In my opinion this feature should not work anymore at all, correct me if I am wrong..

Besides my other servers that start grid and db up beautifully after boot, there is always :N

Looking for a correct way to achieve this, I mean there has to be a way that oracle itself automatically starts it all up (at least some of my servers it does this, but I don't know why or how, because these servers were set up before I started working as dba).

This https://oracle-base.com/articles/linux/automating-database-startup-and-shutdown-on-linux cannot be the only way as in creating startup and shutdown scripts to achive this, am I right..?

Oracle grid and db 11.2

Kind regards

Raul Kaubi

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2017
Added on Mar 23 2017
25 comments
11,156 views