创建数据库时报错:
AIX p550+hacmp5.3+oracle9.2.0.8 数据库已经安装完成,但是在创建数据库时报错:
ORA-01501 CREATE DATABASE failed
ORA-00200 controlfile could not be created
ORA-00202 controlfile:'/dev/rmdcontrol01'
ORA-27038 skgfrcre: file exists
磁阵上的lv是刚划分的。请各位大侠帮忙一下,搞了一天了。
采集了建库的设备和表空间脚本,请指导处理!
Common Options
Option Name Selected
Example Schemas false
Oracle Data Mining false
Oracle Intermedia false
Oracle JVM false
Oracle Label Security false
Oracle OLAP false
Oracle Spatial false
Oracle Text false
Oracle Ultra Search false
Oracle XML DB false
Initialization Parameters
Name Value
background_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/bdump
compatible 9.2.0.0.0
control_files ("/dev/rmdcontrol01", "/dev/rmdcontrol02", "/dev/rmdcontrol03")
core_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/cdump
db_block_size 8KB
db_cache_size 24MB
db_domain
db_file_multiblock_read_count 16
db_name smgw
fast_start_mttr_target 300
hash_join_enabled TRUE
instance_name smgw
java_pool_size 256MB
large_pool_size 8MB
open_cursors 300
pga_aggregate_target 24MB
processes 150
query_rewrite_enabled FALSE
remote_login_passwordfile EXCLUSIVE
shared_pool_size 256MB
sort_area_size 524288
star_transformation_enabled FALSE
timed_statistics TRUE
undo_management AUTO
undo_retention 10800
undo_tablespace UNDOTBS2
user_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/udump
Character Sets
Name Value
Database Character Set ZHS16GBK
National Character Set AL16UTF16
Control Files
Control file
/dev/rmdcontrol01
/dev/rmdcontrol02
/dev/rmdcontrol03
{ORACLE_BASE}/oradata/{DB_NAME}/
Tablespaces
Status Name Type Extent management
ONLINE INDX PERMANENT LOCAL
ONLINE SYSTEM PERMANENT LOCAL
ONLINE TEMP TEMPORARY LOCAL
ONLINE TOOLS PERMANENT LOCAL
ONLINE UNDOTBS1 PERMANENT , UNDO LOCAL
ONLINE UNDOTBS2 PERMANENT , UNDO LOCAL
ONLINE USERS PERMANENT LOCAL
Data Files
Status Name Tablespace Size(M)
ONLINE /dev/rmdindex INDX 2000
ONLINE /dev/rmdora92system SYSTEM 2000
ONLINE /dev/rmdtemp TEMP 2000
ONLINE /dev/rmdtools TOOLS 256
ONLINE /dev/rmdundo1 UNDOTBS1 2000
ONLINE /dev/rmdundo2 UNDOTBS2 2000
ONLINE /dev/rmduser USERS 256
Redo Log Groups
Group Size(K)
1 1000000
2 1000000
3 1000000
|