2009年4月7日星期二

oracle+asm模式启动,要先启动asm instance

我的测试环境:
[oracle@crdb11gtest ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Apr 8 17:12:24 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/crdb11gstd/spfilecrdb11gstd.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/crdb11gstd/spfilecrdb11gstd.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL> quit
Disconnected
[oracle@crdb11gtest ~]$
[oracle@crdb11gtest ~]$
[oracle@crdb11gtest ~]$ export ORACLE_SID=+ASM
[oracle@crdb11gtest ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Apr 8 17:13:04 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup;
ASM instance started

Total System Global Area 283930624 bytes
Fixed Size 2143704 bytes
Variable Size 256621096 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> quit
Disconnected from Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
[oracle@crdb11gtest ~]$ cd
[oracle@crdb11gtest ~]$ . .bash_profile
[oracle@crdb11gtest ~]$
[oracle@crdb11gtest ~]$
[oracle@crdb11gtest ~]$
[oracle@crdb11gtest ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Apr 8 17:13:29 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 6747725824 bytes
Fixed Size 2145024 bytes
Variable Size 3690988800 bytes
Database Buffers 3019898880 bytes
Redo Buffers 34693120 bytes
Database mounted.


Database opened.
SQL> SQL> SQL>

没有评论:

发表评论