ORA-15110: no diskgroups mounted

[root@odd etc]# /etc/init.d/init.cssd stop
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
[root@odd etc]# 
[root@odd etc]# 
[root@odd etc]# 
[root@odd etc]# 
[root@odd etc]# 
[root@odd etc]# 
[root@odd etc]# 
[root@odd etc]# 
[root@odd etc]# 
[root@odd etc]# 
[root@odd etc]# 
[root@odd etc]# /etc/init.d/init.cssd start
Startup will be queued to init within 90 seconds.
[root@odd etc]# su - oracle
[oracle@odd ~]$ export ORACLE_SID=+ASM
[oracle@odd ~]$ sqlplus


SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 21 20:50:28 2015


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


Enter user-name: /as sysdba
Connected to an idle instance.


SQL> startup
ASM instance started


Total System Global Area   83886080 bytes
Fixed Size                  1217836 bytes
Variable Size              57502420 bytes
ASM Cache                  25165824 bytes

ORA-15110: no diskgroups mounted

[oracle@odd dbs]$ sqlplus


SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 21 21:05:14 2015


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


Enter user-name: /as sysdba


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options


SQL> create pfile from spfile;


File created.


SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@odd dbs]$ ls -ltr
total 132
-rw-r----- 1 oracle oinstall  8385 Sep 11  1998 init.ora
-rw-r----- 1 oracle oinstall 12920 May  3  2001 initdw.ora
-rw-r--r-- 1 oracle oinstall   738 Jun  9  2014 init1.ora
-rw-r--r-- 1 oracle oinstall   465 Jun  9  2014 init2.ora
-rw-r--r-- 1 oracle oinstall   437 Jun  9  2014 initPROD.ora
-rw-rw---- 1 oracle oinstall  1544 Jun  9  2014 hc_PROD.dat
-rw-rw---- 1 oracle oinstall    24 Jun  9  2014 lkPROD
-rw-r--r-- 1 oracle oinstall   880 Sep 25 11:23 alert_PROD.log
-rw-r----- 1 oracle oinstall  2560 Oct 30 11:20 orapwPROD
-rw-r----- 1 oracle oinstall  1536 Dec 10 22:09 orapw+ASM
-rw-rw---- 1 oracle oinstall  1544 Dec 10 22:09 hc_+ASM.dat
-rw-rw---- 1 oracle oinstall    24 Dec 10 22:09 lk+ASM
-rw-rw---- 1 oracle oinstall  1544 Dec 11 07:38 hc_orcl1.dat
-rw-rw---- 1 oracle oinstall    24 Dec 11 07:38 lkORCL1
-rw-r----- 1 oracle oinstall  2560 Dec 15 14:22 spfilePROD.ora
-rw-r----- 1 oracle oinstall  1536 Dec 15 21:52 orapworcl1
-rw-r----- 1 oracle oinstall    37 Dec 15 21:53 initorcl1.ora
-rw-rw---- 1 oracle oinstall  1544 Jan 19 13:00 hc_pri.dat
-rw-rw---- 1 oracle oinstall    24 Jan 19 13:01 lkPRI
-rw-r----- 1 oracle oinstall  1536 Jan 19 13:02 orapwpri
-rw-r----- 1 oracle oinstall  3584 Jan 19 14:31 spfilepri.ora
-rw-rw---- 1 oracle oinstall  1544 Jan 20 11:37 hc_dbtest.dat
-rw-rw---- 1 oracle oinstall    24 Jan 20 11:39 lkDBTEST
-rw-r----- 1 oracle oinstall  1536 Jan 20 11:39 orapwdbtest
-rw-r----- 1 oracle oinstall  3584 Jan 20 13:09 spfiledbtest.ora
-rw-r----- 1 oracle oinstall  1536 Jan 21 21:04 spfile+ASM.ora
-rw-rw---- 1 oracle oinstall  1237 Jan 21 21:04 ab_+ASM.dat
-rw-r--r-- 1 oracle oinstall   335 Jan 21 21:05 init+ASM.ora
[oracle@odd dbs]$ more init+ASM.ora 
+ASM.asm_diskgroups=''#Manual Dismount
*.asm_diskgroups='PATH'
*.asm_diskstring='/dev/sdb1'
*.background_dump_dest='/u01/app/oracle/admin/+ASM/bdump'
*.core_dump_dest='/u01/app/oracle/admin/+ASM/cdump'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='SHARED'
*.user_dump_dest='/u01/app/oracle/admin/+ASM/udump'
[oracle@odd dbs]$ vi init+ASM.ora 


+ASM.asm_diskgroups='PATH'#Manual Dismount
*.asm_diskgroups='PATH'
*.asm_diskstring='/dev/sdb1'
*.background_dump_dest='/u01/app/oracle/admin/+ASM/bdump'
*.core_dump_dest='/u01/app/oracle/admin/+ASM/cdump'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='SHARED'
*.user_dump_dest='/u01/app/oracle/admin/+ASM/udump'
~
~
~
~
~
~
~
~
~
~
~
~
~
~
"init+ASM.ora" 9L, 339C written
[oracle@odd dbs]$ 
[oracle@odd dbs]$ sqlplus


SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 21 21:06:55 2015


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


Enter user-name: /as sysdba


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options


SQL> shutdown
ORA-15100: invalid or missing diskgroup name




ASM instance shutdown
SQL> create spfile from pfile
  2  ;


File created.


SQL> startup
ASM instance started


Total System Global Area   83886080 bytes
Fixed Size                  1217836 bytes
Variable Size              57502420 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值