Ive researched all these error codes for the last couple of days. I've got a tar in to oracle but i thought id check to see if anybody here had a quick suggestion.
At the request of one of our application vendors we applied Oracle 9i patch 7 to our 9.0.2.0.4 database. We applied it to a test db and didnt experience any problems. After a week with no problems we applied it to a production db and at the end we had all kinds of "deadlock" problems. We did all the backout procedures for the patch but still had problems, so I got our last good hot backup, installed a fresh version of 9i on a clean server, and did a recovery. After the recovery I cant do a full export. I recompiled most of the invalid objects in the new database, a few refuse to compile, mostly olapsys, and xdb objects. Ive followed up on all the error codes i get when trying to compile them too and didnt get anywhere.
At this point the db is back up, we havnt lost any data, and im not getting any errors except when doing full exports and hotbackups.
any quick suggestions?
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 22275 encountered
ORA-22275: invalid LOB locator specified
ORA-06512: at "SYS.DBMS_LOB", line 514
ORA-06512: at "SYS.DBMS_AW", line 106
ORA-06512: at "SYS.DBMS_AW", line 221
ORA-06512: at "SYS.DBMS_AW_EXP", line 264
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_info_exp
.....
. exporting views
EXP-00056: ORACLE error 21560 encountered
OCI-21560: argument 7 is null, invalid, or out of range
EXP-00056: ORACLE error 21560 encountered
OCI-21560: argument 7 is null, invalid, or out of range
EXP-00000: Export terminated unsuccessfully
At the request of one of our application vendors we applied Oracle 9i patch 7 to our 9.0.2.0.4 database. We applied it to a test db and didnt experience any problems. After a week with no problems we applied it to a production db and at the end we had all kinds of "deadlock" problems. We did all the backout procedures for the patch but still had problems, so I got our last good hot backup, installed a fresh version of 9i on a clean server, and did a recovery. After the recovery I cant do a full export. I recompiled most of the invalid objects in the new database, a few refuse to compile, mostly olapsys, and xdb objects. Ive followed up on all the error codes i get when trying to compile them too and didnt get anywhere.
At this point the db is back up, we havnt lost any data, and im not getting any errors except when doing full exports and hotbackups.
any quick suggestions?
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 22275 encountered
ORA-22275: invalid LOB locator specified
ORA-06512: at "SYS.DBMS_LOB", line 514
ORA-06512: at "SYS.DBMS_AW", line 106
ORA-06512: at "SYS.DBMS_AW", line 221
ORA-06512: at "SYS.DBMS_AW_EXP", line 264
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_info_exp
.....
. exporting views
EXP-00056: ORACLE error 21560 encountered
OCI-21560: argument 7 is null, invalid, or out of range
EXP-00056: ORACLE error 21560 encountered
OCI-21560: argument 7 is null, invalid, or out of range
EXP-00000: Export terminated unsuccessfully