We help IT Professionals succeed at work.
Get Started

Create SYS Directory in Oracle ASM

Julie Kurpa
Julie Kurpa asked
Last Modified: 2012-06-27
I would like to create a directory in ASM for our existing database.   I've successfully been able to create the directory I want however it tells me the directory is a user defined directory.   In displaying the directory in ASMCMD, I can see a N under the SYS column.  Whereas the other directories have a Y.  

Here is the command I've used to create the directory through ASM SQL:


When displaying the directory struction through ASMCMD I see:

Type           Redund  Striped  Time             Sys  Name
                                                 Y    CONTROLFILE/
                                                 Y    DATAFILE/
                                                 Y    FLASHBACK/
                                                 Y    ONLINELOG/
                                                 N    PARAMETERFILE/
                                                 Y    TEMPFILE/

Notice the "N"?
How do I create a SYS defined directory?
Watch Question
Most Valuable Expert 2012
Distinguished Expert 2020
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE