05 Some Start Up Problems Fixed
04 Startup Problems for Bankstown
 

Overview

I have fixed the following problems raised in 04 Startup Problems for Bankstown :

  1. File permissions on raw devices for ASM
  2. Listener Startup

The following problems remain:

  1. ASM startup fails
  2. EXAMPLE database instance fails because of ASM failure

File Permissions Fixed for RAW Devices

Procedure

Remove all lines in /etc/sysconfig/rawdevices .

Add the following lines to /etc/udev/rules.d/60-raw.rules : 

ACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N", OWNER="asm", GROUP="asmdba", MODE="0660"
ACTION=="add", KERNEL=="sdb2", RUN+="/bin/raw /dev/raw/raw2 %N", OWNER="asm", GROUP="asmdba", MODE="0660"
ACTION=="add", KERNEL=="sde1", RUN+="/bin/raw /dev/raw/raw3 %N", OWNER="asm", GROUP="asmdba", MODE="0660"
ACTION=="add", KERNEL=="sde2", RUN+="/bin/raw /dev/raw/raw4 %N", OWNER="asm", GROUP="asmdba", MODE="0660"

These UDEV commands map the disk partions to the correct RAW device and sets the permissions needed by ASM.

Listener Startup Fixed

Added the following line to /etc/rc.d/rc.local : 

su -l asm -c "lsnrctl start"

Problem with ASM Startup

/var/log/messages shows the following errors: 

Jan 13 10:56:48 bankstown logger: Waiting for Oracle CSS service to be available before starting
Jan 13 10:56:48 bankstown logger:  ASM instance +ASM. Wait 10.
Jan 13 10:57:10 bankstown logger: Waiting for Oracle CSS service to be available before starting
Jan 13 10:57:10 bankstown logger:  ASM instance +ASM. Wait 11.
Jan 13 10:57:32 bankstown logger: Waiting for Oracle CSS service to be available before starting
Jan 13 10:57:32 bankstown logger:  ASM instance +ASM. Wait 12.
Jan 13 10:57:53 bankstown logger: Waiting for Oracle CSS service to be available before starting
Jan 13 10:57:53 bankstown logger:  ASM instance +ASM. Wait 13.
Jan 13 10:58:15 bankstown logger: Waiting for Oracle CSS service to be available before starting
Jan 13 10:58:15 bankstown logger:  ASM instance +ASM. Wait 14.
Jan 13 10:58:37 bankstown logger: Timed out waiting to start ASM instance +ASM
Jan 13 10:58:37 bankstown logger:   CSS service is NOT available.
Jan 12 18:58:38 bankstown logger: Waiting for Oracle CRS service to start ASM instance +ASM
Jan 12 18:58:38 bankstown logger: Wait 1.
Jan 12 18:59:38 bankstown logger: Waiting for Oracle CRS service to start ASM instance +ASM
Jan 12 18:59:38 bankstown logger: Wait 2.
Jan 12 19:00:38 bankstown logger: Waiting for Oracle CRS service to start ASM instance +ASM
Jan 12 19:00:38 bankstown logger: Wait 3.
Jan 12 19:01:39 bankstown logger: Waiting for Oracle CRS service to start ASM instance +ASM
Jan 12 19:01:39 bankstown logger: Wait 4.
Jan 12 19:02:39 bankstown logger: Error: Timed out waiting on CRS to start ASM instance +ASM