3 Replies Latest reply: Sep 30, 2011 11:27 AM by 886568 RSS

    Express edition 11g datafiles Issue

    vinayak.pawar
      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
          Hi,

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

          -Udo
          • 2. Re: Express edition 11g datafiles Issue
            clcarter
            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 ...
            exit;
            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
              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.