Welcome 微信登录

首页 / 数据库 / MySQL / Oracle数据库识别不了存储Diskgroup ORA-01078，需要Mount

HOST-> sqlplus "/as sysdba" SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 1 10:13:58 2011 Copyright （c） 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startupORA-01078: failure in processing system parametersORA-01565: error in identifying file "+DATADG/xcoms/spfilexcoms.ora"ORA-17503: ksfdopn:2 Failed to open file +DATADG/xcoms/spfilexcoms.oraORA-15056: additional error messageORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATADG/xcoms/spfilexcoms.oraORA-17503: ksfdopn:2 Failed to open file +DATADG/xcoms/spfilexcoms.oraORA-15001: diskgroup "DATADG" does not exist or is not mountedORA-06512: at line 4SQL> exit  需要把存储的磁盘diskgroup组mount进来。  1、进入到asm的用户，asm已经启动HOST-> su - gridPassword: HOST-> sqlplus "/as sysdba" SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 1 10:32:27 2011 Copyright （c） 1982, 2009, Oracle. All rights reserved.  Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management options SQL> select * from v$instance;  SQL> select name,state from v$asm_diskgroup; NAME                          STATE------------------------------ -----------GRIDDG                        MOUNTEDDATADG                        DISMOUNTEDARCHDG                        DISMOUNTED  SQL> alter diskgroup archdg mount;alter diskgroup archdg mount*ERROR at line 1:ORA-15032: not all alterations performedORA-15260: permission denied on ASM disk group Oracle11g中asm实例不能使用sys用户，使用sysasm用户： SQL> conn /as sysasmConnected.SQL> alter diskgroup archdg mount; Diskgroup altered. SQL> select name,state from v$asm_diskgroup; NAME                          STATE------------------------------ -----------GRIDDG                        MOUNTEDDATADG                        DISMOUNTEDARCHDG                        MOUNTED SQL> alter diskgroup datadg mount; Diskgroup altered. SQL> select name,state from v$asm_diskgroup; NAME                          STATE------------------------------ -----------GRIDDG                        MOUNTEDDATADG                        MOUNTEDARCHDG                        MOUNTED SQL>  切换到数据库实例的用户su - oraoms  sqlplus "/as sysdba"SQL> startupORACLE instance started. Total System Global Area 4.7835E+10 bytesFixed Size                 2180736 bytesVariable Size           4.3889E+10 bytesDatabase Buffers        3892314112 bytesRedo Buffers              51732480 bytesDatabase mounted.Database opened.SQL>ORA-14452:问题处理Oracle+常用SQL+笔记相关资讯      Oracle数据库  Oracle入门教程  oracle数据库教程 
  • Oracle数据库全球化  （03月01日）
  • Oracle数据库日期过滤方法性能比较  （02/02/2015 13:20:26）
  • Oracle数据库安装中端口被占用问题  （10/29/2014 07:42:24）
  • 在CentOS 6.6上搭建C++运行环境并  （10/10/2015 19:44:40）
  • Oracle数据库无法使用localhost和  （11/14/2014 16:39:10）
  • 使用SQLT来构建Oracle测试用例  （08/28/2014 06:17:41）
本文评论 查看全部评论 （0）
表情： 姓名： 字数