This discussion is archived
3 Replies Latest reply: Sep 30, 2011 9:27 AM by 886568 RSS

Express edition 11g datafiles Issue

891432 Newbie
Currently Being Moderated
Hi All,

After installing the Oracle database express edition 11g on the 32 bit windows there are some issues with the datafile naming convention.

The datafile undotbs01.dbf belongs to the SYSAUX tablepsace & sysaux01.dbf belongs to the UNDO tablespace.

I don't knw the recurperssion of the same OR whether it is Bug ???

Please help.
  • 1. Re: Express edition 11g datafiles Issue
    Udo Guru
    Currently Being Moderated

    it's a known bug, as reported here: {thread:id=2207251} and here {thread:id=2289198} ...

  • 2. Re: Express edition 11g datafiles Issue
    clcarter Expert
    Currently Being Moderated
    And the fix is easy, as long as you don't mind shutting down the database and a startup mount;

    And don't move sysaux.dbf onto the existing undotbs1.dbf, using a slightly different name would be a Very Good Idea ...
    $ sqlplus /nolog
    shutdown immediate;
    ... database closed ...
    cd <.dbf files directory>
    mv sysaux.dbf undotbs01.dbf
    mv undotbs1.dbf sysaux.dbf
    $ sqlplus /nolog
    startup mount
    ... mounted ...
    alter database rename file '<dir>/sysaux.dbf' to '<dir>/undotbs01.dbf';
    alter database rename file '<dir>/undotbs1.dbf' to '<dir>/sysaux.dbf';
    alter database open;
    Of course, for those of you on Windows, it's going to cost four extra keystrokes ... mv ... move ;)
  • 3. Re: Express edition 11g datafiles Issue
    886568 Newbie
    Currently Being Moderated
    It is disappointing to know that an obvious bug that was reported during the beta process was not fixed. I thought that was the whole reason for doing a beta release. Hopefully it was just on oversight for this one bug, and other bugs were fixed.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points