Forum Stats

  • 3,827,526 Users
  • 2,260,790 Discussions
  • 7,897,291 Comments

Discussions

controlfile issue in oracle on linux machine.

2650954
2650954 Member Posts: 37
edited Apr 26, 2014 4:31AM in General Database Discussions

I got following error while creating database via script in linux. does anyone have any idea about this error.

ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/home/core/Databases/ControlFile/ctl2.dat'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 13: Permission denied

Tagged:

Best Answer

  • saam
    saam Member Posts: 22
    Answer ✓

    Hi

    7144389e-3944-4d5c-830e-46539d2d9971 wrote:
    
    I got following error while creating database via script in linux. does anyone have any idea about this error.
    
    ERROR at line 1:
    ORA-01501: CREATE DATABASE failed
    ORA-00200: control file could not be created
    ORA-00202: control file: '/home/core/Databases/ControlFile/ctl2.dat'
    ORA-27040: file create error, unable to create file
    Linux-x86_64 Error: 13: Permission denied

    Check the permissions on the directory for the user that is creating the database. That should solve your issue.

    Regards

    Adnan

Answers

  • top.gun
    top.gun Member Posts: 3,666 Gold Crown

    Are you naming your controlfile ctl2.dat ?

    Are you using the Oracle linux account, or the root account?

    top.gun
  • saam
    saam Member Posts: 22
    Answer ✓

    Hi

    7144389e-3944-4d5c-830e-46539d2d9971 wrote:
    
    I got following error while creating database via script in linux. does anyone have any idea about this error.
    
    ERROR at line 1:
    ORA-01501: CREATE DATABASE failed
    ORA-00200: control file could not be created
    ORA-00202: control file: '/home/core/Databases/ControlFile/ctl2.dat'
    ORA-27040: file create error, unable to create file
    Linux-x86_64 Error: 13: Permission denied

    Check the permissions on the directory for the user that is creating the database. That should solve your issue.

    Regards

    Adnan

  • ASulthan
    ASulthan Member Posts: 328 Bronze Badge

    Hi

    Check with you directory permission

    ASulthan
This discussion has been closed.