can't startup database (ASM) on reboot
708009Jun 21 2009 — edited Jun 24 2009Hi all!
I've just installed Oracle DB 11g on Oracle Enterprise Linux 5.
It works.
I stopped Oracle Enterprise Manager Database Control, Listener and Database.
I started them, and the Oracle Enterprise Manager works.
But, when i rebooted the operating system, database doesnt' work...
I run this command without problems:
emctl start dbconsole
lsnrctl start
but when I try to startup database, I get this error:
[oracle@oracleel ~]$ sqlplus
SQL*Plus: Release 11.1.0.6.0 - Production on Sun Jun 21 20:56:54 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/oracle_db/spfileoracledbo.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/oracle_db/spfileoracledbo.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL>
And here there is a screenshot of Oracle Enterprise Manager:
[http://www.nonsologuide.altervista.org/_altervista_ht/canc/screen_oracle_enterprise_manager.png]
(ASM use the same ORACLE_HOME)