Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: At my wits end with ASM file names...

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 09 Apr 2006 09:07:23 -0700
Message-ID: <1144598837.146289@yasure.drizzle.com>


Volker Hetzer wrote:
> 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

You've got me now. Perhaps someone else can help you and we will both learn something.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Apr 09 2006 - 11:07:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US