Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00214

1021200Aug 11 2013 — edited Aug 12 2013

Hello All,

Could anyone please help me to get my control file back. While opening the database I am getting below error.

SQL> startup

ORACLE instance started.

Total System Global Area  835104768 bytes

Fixed Size               2217952 bytes

Variable Size          562038816 bytes

Database Buffers       268435456 bytes

Redo Buffers             2412544 bytes

ORA-00214: control file '/u01/app/oracle/oradata/orcl/control01.ctl' version

1042 inconsistent with file '/u01/app/oracle/oradata/orcl/control03.ctl'

version 1039

I have my control file to belwo trace file.


/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4428.trc


Please guide me.



Thank You,

Michel

This post has been answered by Alvaro on Aug 11 2013
Jump to Answer

Comments

John JB Brock-Oracle

The only thing I can think of to look at first would be if the keyAttributes value that you have set in your DataProvider is truly a uniqueId and you do not have duplicates in your dataset.

User_77VTN

I have faced similar issue and the suggestion solved. I was using a column 'code' as id Attribute where in reality it is not unique between rows. So changed the idAttribute to 'id' instead of 'code'.(Note: 'id' is not a column. It just took its own ref). Then the data got auto refreshed as soon as the observable is changed.

----------------------------------------------------------------------------------------- JS code -----------------------------------------

self.testArr = ko.observableArray();

//self.testDS = new PagingDataProviderView(new ArrayDataProvider(self.testArr, { idAttribute: 'code' }));  ===> REFRESH NOT WORKING

self.testDS = new PagingDataProviderView(new ArrayDataProvider(self.testArr, { idAttribute: 'id' })); //// REFRESH WORKING

self.testCols = ko.observable();

self.testCols([{

        "headerText": "code",

        "field": "code",

        "id": "test_code"

      },

      {

        "headerText": "amount",

        "field": "amnt",

        "id": "test_amnt"

      }

      ]);

var dir1 ={ "code":"c1","amnt":100 };

self.testArr.push(dir1);

var dir2 ={ "code":"c1","amnt":20 };

self.testArr.push(dir2);

-----------table------------------------------------------------------------------------------------------------------------------

<oj-table aria-label="Test Table" id="test-details-table" data='[[testDS]]'

                        selection-mode='{"row": "single", "column": "multiple"}' columns='[[testCols]]'

                        columns-default='{"sortable": "disabled" }' row-renderer="[[testTableRowRenderer]]"

                        scroll-policy='loadMoreOnScroll' class="width100">

                        <oj-paging-control class="lastTab" id="test_paging" data='[[testDS]]'

                            page-options='{"type":"Number"}' page-size='5' slot='bottom'>

                        </oj-paging-control>

                    </oj-table>

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

User_77VTN

Check by changing keyAttributes --> from 'departmentId' ti 'id'

Philip Sommer

For completeness sake, let me make the following remarks:

  1. idAttribute is deprecated and you should use keyAttributes instead
  2. Specifying a non-existent field name as 1066874 recommends is not offically supported. Instead, you can simply not specify any keyAttributes, in which case the DataProvider will default to using the array index (which is guaranteed to be unique of course).

Source: https://www.oracle.com/webfolder/technetwork/jet/jsdocs/ArrayDataProvider.html#constructor-section

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 9 2013
Added on Aug 11 2013
11 comments
1,004 views