05 Some Start Up Problems Fixed

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