Re: At my wits end with ASM file names...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Sat, 08 Apr 2006 19:43:38 +0200
Message-ID: <e18so7$74b$1@nntp.fujitsu-siemens.com>

DA Morgan schrieb:

> Volker Hetzer wrote:

>> Hi!
>> I'm trying to create a database (10gR2, Linux) which uses asm.
>> Asm runs and I can query the views and everything.
>>
>> Now, on a different account I try to create the database.
>
> Use the DBCA.
Did it. I tried as simple as possible, getting the following init.ora: log_archive_dest_1='LOCATION=+DATA_STRUCTURED/colon/' log_archive_format=%t_%s_%r.dbf
db_block_size=8192
db_file_multiblock_read_count=16
open_cursors=300
db_domain=ecad.abg.fsc.net
db_name=colon

background_dump_dest=/vol1/oracle/admin/colon/bdump
core_dump_dest=/vol1/oracle/admin/colon/cdump
user_dump_dest=/vol1/oracle/admin/colon/udump

control_files=("+DATA_STRUCTURED/colon/control01.ctl", "+DATA_STRUCTURED/colon/control02.ctl", "+DATA_STRUCTURED/colon/control03.ctl") db_recovery_file_dest=+DATA_STRUCTURED
db_recovery_file_dest_size=2147483648
job_queue_processes=10
compatible=10.2.0.1.0
processes=150
sga_target=444596224
audit_file_dest=/vol1/oracle/admin/colon/adump remote_login_passwordfile=EXCLUSIVE
dispatchers="(PROTOCOL=TCP) (SERVICE=colonXDB)" pga_aggregate_target=147849216
undo_management=AUTO
undo_tablespace=UNDOTBS1

The result was:
g`"ORACLE instance started.

Total System Global Area 444596224 bytes

Fixed Size                  1219880 bytes
Variable Size             130024152 bytes
Database Buffers          306184192 bytes
Redo Buffers                7168000 bytes

SQL> CREATE DATABASE "colon"

   2 MAXINSTANCES 8
   3 MAXLOGHISTORY 1
   4 MAXLOGFILES 16
   5 MAXLOGMEMBERS 3
   6 MAXDATAFILES 100
   7 DATAFILE '+DATA_STRUCTURED' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED    8 EXTENT MANAGEMENT LOCAL
   9 SYSAUX DATAFILE '+DATA_STRUCTURED' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED   10 BIGFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '+DATA_STRUCTURED' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED   11 BIGFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '+DATA_STRUCTURED' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED   12 CHARACTER SET AL32UTF8
  13 NATIONAL CHARACTER SET UTF8
  14 SET DEFAULT BIGFILE TABLESPACE
  15 LOGFILE GROUP 1 ('+DATA_STRUCTURED/colon/redo01.log') SIZE 51200K,   16 GROUP 2 ('+DATA_STRUCTURED/colon/redo02.log') SIZE 51200K,   17 GROUP 3 ('+DATA_STRUCTURED/colon/redo03.log') SIZE 51200K   18 USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword"; CREATE DATABASE "colon"
*
ERROR at line 1:

ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '+DATA_STRUCTURED/colon/control01.ctl'
ORA-15012: ASM file 'colon/control01.ctl' does not exist
ORA-17502: ksfdcre:5 Failed to create file +DATA_STRUCTURED/colon/control01.ctl
ORA-15081: failed to submit an I/O operation to a disk

SQL> spool off

Lots of Greetings!
Volker Received on Sat Apr 08 2006 - 12:43:38 CDT