Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

Help Please ORA-17502 ksfdcre:4 Failed to create file '+xxxxxx+'

edited Sep 12, 2018 5:00AM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 4 commentsAnswered

Best Regards

Please help me

We have a oracle database Enterprice edition 12c R2, the actually storage is ZFS, to day installed de Grid Infraestructure (standalone), to substitute the ZFS by ASM.

i created the disk group, and all good, but when I try to create a tablespace, the error appears:

SQL> select ......

GROUP_NUMBER NAME                           SECTOR_SIZE BLOCK_SIZE    AU_SIZE STATE       TYPE     TOTAL_GB   TOTAL_GB

------------ ------------------------------ ----------- ---------- ---------- ----------- ------ ---------- ----------

           1 MIS_DATA                               512       4096   16777216 MOUNTED     EXTERN 10997.9375 10996.7031

           2 MIS_FRA                                512       4096   16777216 MOUNTED     EXTERN   999.8125 999.546875

           3 ODS_DATA                               512       4096   16777216 MOUNTED     EXTERN 10997.9375 10996.7344

           4 ODS_FRA                                512       4096   16777216 MOUNTED     EXTERN   999.8125 999.546875

SQL> CREATE BIGFILE TEMPORARY TABLESPACE TEMP01 tempfile '+MIS_DATA' size 700g;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center