啟動oracle資料庫的時候報ORA-00205錯誤:
SQL> startup
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1220868 bytes
Variable Size 209719036 bytes
Database Buffers 398458880 bytes
Redo Buffers 2969600 bytes
ORA-00205: error in identifying control file, check alert log for more info
[root@tonykorn bdump]# vi alert_orcl.log
Sat Sep 1 15:58:23 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
sga_target = 612368384
control_files = /oracle/oradata/orcl/control01.ctl, /oracle/oradata/orcl/control02.ctl, /oracle/oradata/orcl/control03.ctl
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /oracle/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
background_dump_dest = /oracle/app/oracle/admin/orcl/bdump
user_dump_dest = /oracle/app/oracle/admin/orcl/udump
core_dump_dest = /oracle/app/oracle/admin/orcl/cdump
audit_file_dest = /oracle/app/oracle/admin/orcl/adump
db_name = orcl
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=7683
PSP0 started with pid=3, OS id=7685
MMAN started with pid=4, OS id=7687
DBW0 started with pid=5, OS id=7689
LGWR started with pid=6, OS id=7691
CKPT started with pid=7, OS id=7693
SMON started with pid=8, OS id=7695
RECO started with pid=9, OS id=7697
CJQ0 started with pid=10, OS id=7699
:$
sga_target = 612368384
control_files = /oracle/oradata/orcl/control01.ctl, /oracle/oradata/orcl/control02.ctl, /oracle/oradata/orcl/control03.ctl
db_block_size = 8192
__db_cache_size = 398458880
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /oracle/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
background_dump_dest = /oracle/app/oracle/admin/orcl/bdump
user_dump_dest = /oracle/app/oracle/admin/orcl/udump
core_dump_dest = /oracle/app/oracle/admin/orcl/cdump
audit_file_dest = /oracle/app/oracle/admin/orcl/adump
db_name = orcl
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=5011
PSP0 started with pid=3, OS id=5013
MMAN started with pid=4, OS id=5015
DBW0 started with pid=5, OS id=5017
LGWR started with pid=6, OS id=5019
CKPT started with pid=7, OS id=5021
SMON started with pid=8, OS id=5023
RECO started with pid=9, OS id=5025
CJQ0 started with pid=10, OS id=5027
MMON started with pid=11, OS id=5029
Wed Sep 5 15:52:37 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=5031
Wed Sep 5 15:52:38 2007
starting up 1 shared server(s) ...
Wed Sep 5 15:52:42 2007
ALTER DATABASE MOUNT
Wed Sep 5 15:52:42 2007
ORA-00202: control file: '/oracle/oradata/orcl/control01.ctl'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 2
Wed Sep 5 15:52:45 2007
ORA-205 signalled during: ALTER DATABASE MOUNT...
趕緊檢視一下raw的許可權
[root@tonykorn bdump]# ls -al /dev/raw/*
crw-rw---- 1 root disk 162, 1 Sep 4 22:08 /dev/raw/raw1
crw-rw---- 1 root disk 162, 11 Sep 4 22:09 /dev/raw/raw11
crw-rw---- 1 root disk 162, 12 Sep 4 22:09 /dev/raw/raw12
crw-rw---- 1 root disk 162, 13 Sep 4 22:09 /dev/raw/raw13
crw-rw---- 1 root disk 162, 14 Sep 4 22:09 /dev/raw/raw14
crw-rw---- 1 root disk 162, 15 Sep 4 22:09 /dev/raw/raw15
crw-rw---- 1 root disk 162, 16 Sep 4 22:09 /dev/raw/raw16
crw-rw---- 1 root disk 162, 17 Sep 4 22:09 /dev/raw/raw17
crw-rw---- 1 root disk 162, 18 Sep 4 22:09 /dev/raw/raw18
crw-rw---- 1 root disk 162, 19 Sep 4 22:09 /dev/raw/raw19
crw-rw---- 1 root disk 162, 2 Sep 4 22:08 /dev/raw/raw2
crw-rw---- 1 root disk 162, 20 Sep 4 22:09 /dev/raw/raw20
crw-rw---- 1 root disk 162, 21 Sep 4 22:09 /dev/raw/raw21
crw-rw---- 1 root disk 162, 22 Sep 4 22:09 /dev/raw/raw22
crw-rw---- 1 root disk 162, 23 Sep 4 22:09 /dev/raw/raw23
crw-rw---- 1 root disk 162, 24 Sep 4 22:09 /dev/raw/raw24
crw-rw---- 1 root disk 162, 3 Sep 4 22:09 /dev/raw/raw3
crw-rw---- 1 root disk 162, 4 Sep 4 22:09 /dev/raw/raw4
果然不對,修改。
[root@tonykorn bdump]# chown oracle:dba /dev/raw/*
[root@tonykorn bdump]# ls -al /dev/raw/*
crw-rw---- 1 oracle dba 162, 1 Sep 4 22:08 /dev/raw/raw1
crw-rw---- 1 oracle dba 162, 11 Sep 4 22:09 /dev/raw/raw11
crw-rw---- 1 oracle dba 162, 12 Sep 4 22:09 /dev/raw/raw12
crw-rw---- 1 oracle dba 162, 13 Sep 4 22:09 /dev/raw/raw13
crw-rw---- 1 oracle dba 162, 14 Sep 4 22:09 /dev/raw/raw14
crw-rw---- 1 oracle dba 162, 15 Sep 4 22:09 /dev/raw/raw15
crw-rw---- 1 oracle dba 162, 16 Sep 4 22:09 /dev/raw/raw16
crw-rw---- 1 oracle dba 162, 17 Sep 4 22:09 /dev/raw/raw17
crw-rw---- 1 oracle dba 162, 18 Sep 4 22:09 /dev/raw/raw18
crw-rw---- 1 oracle dba 162, 19 Sep 4 22:09 /dev/raw/raw19
crw-rw---- 1 oracle dba 162, 2 Sep 4 22:08 /dev/raw/raw2
crw-rw---- 1 oracle dba 162, 20 Sep 4 22:09 /dev/raw/raw20
crw-rw---- 1 oracle dba 162, 21 Sep 4 22:09 /dev/raw/raw21
crw-rw---- 1 oracle dba 162, 22 Sep 4 22:09 /dev/raw/raw22
crw-rw---- 1 oracle dba 162, 23 Sep 4 22:09 /dev/raw/raw23
crw-rw---- 1 oracle dba 162, 24 Sep 4 22:09 /dev/raw/raw24
crw-rw---- 1 oracle dba 162, 3 Sep 4 22:09 /dev/raw/raw3
crw-rw---- 1 oracle dba 162, 4 Sep 4 22:09 /dev/raw/raw4
[root@tonykorn bdump]#
關閉後重啟
SQL> shutdown
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1220868 bytes
Variable Size 209719036 bytes
Database Buffers 398458880 bytes
Redo Buffers 2969600 bytes
Database mounted.
Database opened.
SQL>
這個是一個虛擬機器安裝的測試用的,當時估計沒有修改raw檔案的許可權。
修改/etc/udev/permissions.d/50-udev.permissions檔案
把raw/*:root:disk:0660改為:raw/*:oracle:dba:0600
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/312079/viewspace-245755/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle啟動時出現ORA-00205錯誤的方法Oracle
- suse10啟動vsftp的時候報錯FTP
- 資料庫啟動時遇到ORA-01578錯誤資料庫
- 啟動資料庫的其中一個錯誤資料庫
- 從32位資料庫還原到64bit資料庫open的時候報錯資料庫
- ORACLE 18C啟動資料庫報錯ORA-04031Oracle資料庫
- 奇怪的問題: 資料庫使用者登入的時候報錯資料庫
- rman映象備份全庫的時候報ora-00600錯誤。
- 惡意程式造成資料庫啟動報錯資料庫
- linux oracle建立資料庫的時候報錯ORA-12547:TNS:lost contactLinuxOracle資料庫
- dbua後資料庫無法啟動錯誤的解決資料庫
- 系統關閉時候,oracle資料庫執行動作Oracle資料庫
- 資料庫啟動出現ORA-27037錯誤資料庫
- 恢復資料庫引數錯誤無法啟動資料庫
- 啟動資料庫出現ORA-9925錯誤資料庫
- 物理data guard備standby庫的時候報錯。
- MySQL 5.7啟動資料庫報錯'does not exist or is not executable'MySql資料庫
- 一次儲存故障引起的資料庫啟動錯誤資料庫
- 達夢資料庫啟動報code = -803 [Invalid ini config value]錯誤資料庫
- [重慶思莊技術分享]-資料庫啟動報:ORA-29702錯誤資料庫
- 啟動資料庫出現ORA-27123錯誤資料庫
- 資料庫啟動出現ORA-27102錯誤資料庫
- 資料庫啟動在mount狀態,無任何報錯資料庫
- ORA-00205錯誤分析
- Apache Hive啟動報NoClassDefFoundError錯誤ApacheHiveError
- 加大memory_max_target後,資料庫啟動報ora-00845錯誤處理資料庫
- 資料庫資料恢復-oracle資料庫報錯無法開啟的如何恢復資料?資料庫資料恢復Oracle
- 資料庫報ORA-01839的錯誤資料庫
- 資料庫資料恢復—MongoDB資料庫檔案丟失,啟動報錯的資料恢復案例資料庫資料恢復MongoDB
- AIX系統啟動資料庫出現ORA-27504錯誤AI資料庫
- 資料庫啟動出現ORA-30036錯誤資料庫
- 配置tsm在格式化資料庫資訊的時候報錯:This database name already exists資料庫Database
- 連線oracle資料庫時,報錯:{dataSource-1} init errorOracle資料庫Error
- 啟動Eclipse的時候報錯Failed to load the JNI shared library..EclipseAI
- asm磁碟組依賴導致資料庫自啟動報錯ASM資料庫
- AIX系統中,啟動資料庫報錯ORA-27504AI資料庫
- ORA-01653錯誤是Oracle資料庫中常見的錯誤Oracle資料庫
- oracle RAC dbca的時候報錯提示cluster nodes are not accessibleOracle