04 Startup Problems for Bankstown
Overview
There are several unresolved start up problems with BANKSTOWN:
- The listener does not start automatically
- ASM likewise
- The raw disks have the wrong security settings.
Investigation
Here is the raw log of the investigation:
[oracle@bankstown ~]$ sudo su - asm [asm@bankstown ~]$ lnsrctl status -bash: lnsrctl: command not found [asm@bankstown ~]$ lsnrctl status LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-JAN-2012 10:19:03 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused [asm@bankstown ~]$ lsnrctl start LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-JAN-2012 10:19:09 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /u01/app/asm/product/11.1.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.1.0.6.0 - Production Log messages written to /u01/app/asm/diag/tnslsnr/bankstown/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bankstown.yaocm.id.au)(PORT=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production Start Date 10-JAN-2012 10:19:10 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/app/asm/diag/tnslsnr/bankstown/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bankstown.yaocm.id.au)(PORT=1521))) The listener supports no services The command completed successfully [asm@bankstown ~]$ lsnrctl status LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-JAN-2012 10:19:34 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production Start Date 10-JAN-2012 10:19:10 Uptime 0 days 0 hr. 0 min. 24 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/app/asm/diag/tnslsnr/bankstown/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bankstown.yaocm.id.au)(PORT=1521))) The listener supports no services The command completed successfully [asm@bankstown ~]$ sqlplus / as sysasm SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jan 10 10:20:17 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ASM instance started Total System Global Area 284565504 bytes Fixed Size 1299428 bytes Variable Size 258100252 bytes ASM Cache 25165824 bytes ORA-15032: not all alterations performed ORA-15063: ASM discovered an insufficient number of disks for diskgroup "RECOVERY" ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA" SQL> shutdown immediate ORA-15100: invalid or missing diskgroup name ASM instance shutdown SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [asm@bankstown ~]$ su - Password: [root@bankstown ~]# ls -l /dev/raw/raw[12] crw------- 1 root root 162, 1 Jan 10 06:58 /dev/raw/raw1 crw------- 1 root root 162, 2 Jan 10 06:58 /dev/raw/raw2 [root@bankstown ~]# chown asm:asmdba /dev/raw/raw[12] [root@bankstown ~]# chmod 660 /dev/raw/raw[12] [root@bankstown ~]# exit logout [asm@bankstown ~]$ sqlplus / as sysasm SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jan 10 10:24:27 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ASM instance started Total System Global Area 284565504 bytes Fixed Size 1299428 bytes Variable Size 258100252 bytes ASM Cache 25165824 bytes ASM diskgroups mounted SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options