国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

打開APP
userphoto
未登錄

開通VIP,暢享免費(fèi)電子書等14項(xiàng)超值服

開通VIP
霍鐵明的dba生活 | ORA-00205 error in identifying co...
ORA-00205 error in identifying control file 問題解決一例
===========================================================

在啟動(dòng)數(shù)據(jù)庫的時(shí)候,報(bào)ORA-000205錯(cuò)誤,詳細(xì)錯(cuò)誤信息如下:

idle> startup
ORACLE instance started.

Total System Global Area 209715200 bytes
Fixed Size 1218532 bytes
Variable Size 109053980 bytes
Database Buffers 92274688 bytes
Redo Buffers 7168000 bytes
ORA-00205: error in identifying control file, check alert log for more info

經(jīng)過檢查alert.log,發(fā)現(xiàn)如下內(nèi)容:


ALTER DATABASE MOUNT
Fri Feb 12 19:03:53 2010
Starting background process ASMB
ASMB started with pid=17, OS id=23258
Fri Feb 12 19:03:53 2010
ORA-00202: control file: '+DATA/cnhtm/controlfile/control01.dbf'
ORA-17503: ksfdopn:2 Failed to open file +DATA/cnhtm/controlfile/control01.dbf
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-15055: unable to connect to ASM instance
Fri Feb 12 19:03:57 2010

確認(rèn)是因?yàn)锳SM實(shí)例錯(cuò)誤導(dǎo)致數(shù)據(jù)庫實(shí)例無法啟動(dòng),下面著手解決ASM實(shí)例問題:

啟動(dòng)ASM實(shí)例:

ora_test@oracle[/oracle/app/10.1/dbs]> export ORACLE_SID=+ASM

ora_test@oracle[/oracle/app/10.1/dbs]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 12 19:14:12 2010

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
idle> startup
ASM instance started

Total System Global Area 79691776 bytes
Fixed Size 1217812 bytes
Variable Size 53308140 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted

經(jīng)過檢查,發(fā)現(xiàn)ASM的參數(shù)中沒有了asm_diskgroups參數(shù),增加

asm_diskgroups=DATA

修改后的asm的參數(shù)文件為:

ora_test@oracle[/oracle/app/10.1/dbs]> cat $ORACLE_HOME/dbs/init+ASM.ora
instance_type=asm
instance_name=+ASM
asm_diskgroups=DATA

然后再重啟asm實(shí)例,能夠正常啟動(dòng)

ora_test@oracle[/oracle/app/10.1/dbs]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 12 19:16:38 2010

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
idle> startup pfile='?/dbs/init+ASM.ora'
ASM instance started

Total System Global Area 79691776 bytes
Fixed Size 1217812 bytes
Variable Size 53308140 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted

用pfile生成spfile

idle> create spfile from pfile;

File created.

idle>

在asm實(shí)例正常啟動(dòng)之后,數(shù)據(jù)庫實(shí)例也能夠正常啟動(dòng)了

ora_test@oracle[/oracle/app/10.1/dbs]> export ORACLE_SID=cnhtm

ora_test@oracle[/oracle/app/10.1/dbs]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 12 19:17:20 2010

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


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

idle> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
idle> startup
ORACLE instance started.

Total System Global Area 209715200 bytes
Fixed Size 1218532 bytes
Variable Size 109053980 bytes
Database Buffers 92274688 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.

--end--

本站僅提供存儲服務(wù),所有內(nèi)容均由用戶發(fā)布,如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請點(diǎn)擊舉報(bào)。
打開APP,閱讀全文并永久保存 查看更多類似文章
猜你喜歡
類似文章
ORA-01547?????ORA-01194????ORA-01110
rman連接輔助數(shù)據(jù)庫ORA
打開關(guān)閉ORACLE
RedHat5.2下Linux Oracle 10g ASM 安裝詳細(xì)實(shí)錄-第二篇-ASM安裝
OCFS2+ASM 的RAC安裝文檔
10g單一實(shí)例數(shù)據(jù)庫轉(zhuǎn)化為RAC
更多類似文章 >>
生活服務(wù)
分享 收藏 導(dǎo)長圖 關(guān)注 下載文章
綁定賬號成功
后續(xù)可登錄賬號暢享VIP特權(quán)!
如果VIP功能使用有故障,
可點(diǎn)擊這里聯(lián)系客服!

聯(lián)系客服