After you move the core object table dependency $, the database is not started.

Source: Internet
Author: User

After you move the core object table dependency $, the database is not started.
Move table:
SQL> startup
ORACLE instance started.

Total System Global Area 281018368 bytes
Fixed Size 2083336 bytes
Variable Size 88081912 bytes
Database Buffers 184549376 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
SQL> alter table dependency $ move;

Table altered.

Restart oracle:

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 281018368 bytes
Fixed Size 2083336 bytes
Variable Size 88081912 bytes
Database Buffers 184549376 bytes
Redo Buffers 6303744 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced


Alert Log:
Sun Jan 18 23:39:59 2015
Errors in file/oracle/app/product/10.2.0/db_1/admin/orcl/udump/orcl_ora_27363.trc:
ORA-00704: bootstrap process failure.
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'sys. I _dependency1' or partition of such index is in unusable state
Sun Jan 18 23:39:59 2015
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704.
Instance terminated by USER, pid = 27363
ORA-1092 signalled during: alter database open...


Chown oracle. oinstall/oracle/app/product/10.2.0/db_1/bin/oracle
Chmod 6751/oracle/app/product/10.2.0/db_1/bin/oracle
Startup mount;
Alter session set events '2017 trace name context forever, level 12 ';

Oradebug setmypid
Oradebug tracefile_name
Alter database open;

/Oracle/app/product/10.2.0/db_1/admin/orcl/udump/orcl_ora_27422.trc


10046 trace:

Parsing in cursor #2 len = 84 dep = 2 uid = 0 oct = 3 lid = 0 tim = 1388333382888260 hv = 2686874206 ad = '70696c1'
Select o. name, u. name from obj $ o, user $ u where o. obj # =: 1 and o. owner # = u. user #
END OF STMT
PARSE #2: c = 1000, e = 1173, p = 0, cr = 0, cu = 0, mis = 1, r = 0, dep = 2, og = 4, tim = 1388333382888249
BINDS #2:
Kkscoacd
Bind #0
Oacdty = 02 mxl = 22 (22) mxlc = 00 mal = 00 scl = 00 pre = 00
Oacflg = 08 fl2 = 0001 frm = 00 csi = 00 siz = 24 off = 0
Kxsbbbfp = 2b4e28797e60 bln = 22 avl = 03 flg = 05
Value = 122
EXEC #2: c = 3000, e = 2453, p = 0, cr = 0, cu = 0, mis = 1, r = 0, dep = 2, og = 4, tim = 1388333382890953
WAIT #2: nam = 'db file sequential read 'ela = 55 file # = 1 block # = 98 blocks = 1 obj #=-1 tim = 1388333382891225
WAIT #2: nam = 'db file sequential read 'ela = 169 file # = 1 block # = 90 blocks = 1 obj #=-1 tim = 1388333382891502
FETCH #2: c = 0, e = 563, p = 2, cr = 5, cu = 0, mis = 0, r = 1, dep = 2, og = 4, tim = 1388333382891624
STAT #2 id = 1 cnt = 1 pid = 0 pos = 1 obj = 0 op = 'nested LOOPS (cr = 5 pr = 2 pw = 0 time = 573 us )'
STAT #2 id = 2 cnt = 1 pid = 1 pos = 1 obj = 18 op = 'table access by index rowid obj $ (cr = 3 pr = 0 pw = 0 time = 69 us)'
STAT #2 id = 3 cnt = 1 pid = 2 pos = 1 obj = 36 op = 'index unique scan I _OBJ1 (cr = 2 pr = 0 pw = 0 time = 41 us)'
STAT #2 id = 4 cnt = 1 pid = 1 pos = 2 obj = 22 op = 'table access cluster user $ (cr = 2 pr = 2 pw = 0 time = 492 us)'
STAT #2 id = 5 cnt = 1 pid = 4 pos = 1 obj = 11 op = 'index unique scan I _USER # (cr = 1 pr = 1 pw = 0 time = 174 us)'
ORA-00704: bootstrap process failure.
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'sys. I _dependency1' or partition of such index is in unusable state
EXEC #1: c = 551916, e = 2086867, p = 68, cr = 722, cu = 0, mis = 0, r = 0, dep = 0, og = 1, tim = 1388333383882751
ERROR #1: err = 1092 tim = 443696155


Select owner #, name, namespace, remoteowner, linkname, p_timestamp, p_obj #, nvl (property, 0), subname, d_attrs from dependency $ d, obj $ o
Where d_obj # =: 1 and p_obj # = obj # (+) order by order #
Back up the oracle binary file for restoration.
Use ue to find select owner #, name, namespace, remoteowner, linkname, p_timestamp, p_obj #, nvl (property, 0), subname, d_attrs from dependency $ d, obj $ o
Where d_obj # =: 1 and p_obj # = obj # (+) order by order #, delete "order by order #", add d_obj # + 0 and p_obj # + 0.


[Oracle @ bogon ~] $ Sqlplus/as sysdba

SQL * Plus: Release 10.2.0.4.0-Production on Mon Jan 19 00:53:03 2015

Copyright (c) 1982,200 7, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 281018368 bytes
Fixed Size 2083336 bytes
Variable Size 88081912 bytes
Database Buffers 184549376 bytes
Redo Buffers 6303744 bytes
Database mounted.
SQL> alter session set events '10046 trace name context forever, level 12 ';

Session altered.

SQL> oradebug setmypid
Statement processed.
SQL> oradebug tracefile_name
/Oracle/app/product/10.2.0/db_1/admin/orcl/udump/orcl_ora_28745.trc
SQL> alter database open;

Database altered.

When the database is open, the following error occurs in the alert Log.

Database Characterset is AL32UTF8
Mon Jan 19 00:53:45 2015
Errors in file/oracle/app/product/10.2.0/db_1/admin/orcl/bdump/orcl_smon_28730.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'sys. I _dependency2' or partition of such index is in unusable state
Mon Jan 19 00:53:45 2015
Errors in file/oracle/app/product/10.2.0/db_1/admin/orcl/bdump/orcl_smon_28730.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'sys. I _dependency2' or partition of such index is in unusable state
Mon Jan 19 00:53:45 2015
Errors in file/oracle/app/product/10.2.0/db_1/admin/orcl/bdump/orcl_smon_28730.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'sys. I _dependency2' or partition of such index is in unusable state
Opening with internal Resource Manager plan
Where numa pg = 1, CPUs = 4
Mon Jan 19 00:53:46 2015
Errors in file/oracle/app/product/10.2.0/db_1/admin/orcl/bdump/orcl_smon_28730.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'sys. I _dependency2' or partition of such index is in unusable state
Replication_dependency_tracking turned off (no async multimaster replication found)
Mon Jan 19 00:53:47 2015
Errors in file/oracle/app/product/10.2.0/db_1/admin/orcl/bdump/orcl_smon_28730.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'sys. I _dependency2' or partition of such index is in unusable state
Starting background process QMNC
QMNC started with pid = 19, OS id = 28758
Mon Jan 19 00:53:51 2015
Errors in file/oracle/app/product/10.2.0/db_1/admin/orcl/bdump/orcl_smon_28730.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'sys. I _dependency2' or partition of such index is in unusable state
Mon Jan 19 00:53:57 2015
Completed: alter database open

-- Re-Indexing
SQL> alter index SYS. I _DEPENDENCY1 rebuild;

Index altered.

SQL> alter index SYS. I _DEPENDENCY2 rebuild;

Index altered.

No error is reported in alert logs. After the oracle binary file is restored, the database is started normally.


Bytes -----------------------------------------------------------------------------------------------------------------
This site indicates that both original articles and translated articles are original articles. articles can be reproduced, but the source address must be indicated through links,
Otherwise, you will be held legally responsible! Some omissions are inevitable in the article. You are welcome to criticize and correct them.

QQ: 173386747

Email: hailong.sun1982@gmail.com

Blog: http://blog.csdn.net/card_2005


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.