|
|
|
|
|
|
|
|
|
|
| Re: EXPDP error after recovering CONTROL and DATAFILES [message #682449 is a reply to message #682448] |
Sat, 24 October 2020 10:57   |
 |
Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Post the result of:
SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY;
select owner, object_name, object_type, status from dba_objects where status != 'VALID';
SELECT GRANTEE, PRIVILEGE FROM DBA_TAB_PRIVS WHERE TABLE_NAME= 'DBMS_METADATA'; [Updated on: Sat, 24 October 2020 10:58] Report message to a moderator |
|
|
|
| Re: EXPDP error after recovering CONTROL and DATAFILES [message #682450 is a reply to message #682449] |
Sat, 24 October 2020 11:20 |
 |
lucifer
Messages: 23
Registered: October 2020
|
Junior Member |
|
|
>>> Are you sure you executed the catproc.sql script for the correct version of the db?
Absolutely; there's only one instance, one version, one server (in this environment)
>>> SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY;
ORA-04063: package body "SYS.DBMS_REGISTRY" has errors
>>> select owner, object_name, object_type, status from dba_objects where status != 'VALID';
See the attached dba_objects_INVALID.txt for details
The INFRA_FULL Schema is of no use; it got copied with the relevant DATAFILES
>>> SELECT GRANTEE, PRIVILEGE FROM DBA_TAB_PRIVS WHERE TABLE_NAME= 'DBMS_METADATA';
PUBLIC EXECUTE
Actually, all these Production Schemas have DBA Privileges
(as set by the application vendor - the application works with that as a given)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: EXPDP error after recovering CONTROL and DATAFILES [message #682459 is a reply to message #682458] |
Sat, 24 October 2020 13:36 |
|
Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
The case is too complex to be solved in a forum.
We have to know what has exactly be done, investigate in the db to know the problem with the dictionary, know what you have (backups, files...), investigate the control files, trace files, the alert.log...
As I said:
Michel Cadot wrote on Sat, 24 October 2020 19:18
Quote:4. Therefore, I took a slightly older Server image (which I knew was clean) and attempted to sync with the latest CONTROL & DATAFILES
What did you do exactly for that?
This is the first step to diagnose the current state.
Try to export using the old "exp" is the only advice I can give you at my remote place.
If it does not work then find a consultant (a real expert one).
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: EXPDP error after recovering CONTROL and DATAFILES [message #682471 is a reply to message #682461] |
Sun, 25 October 2020 01:53 |
John Watson
Messages: 8944
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
I'll have a try. If I remember correctly, you can get errors like this if you have run the catalog scripts when you were not connected as SYSDBA. This is a well known script that attempts to fix this:set echo off
set pagesize 0
set feedback off
spool drop.sql
SELECT 'drop '||OBJECT_TYPE||' '||OWNER||'.'||object_name||';'
FROM all_objects
WHERE OWNER != 'SYS' AND OBJECT_TYPE != 'SYNONYM'
AND OBJECT_NAME IN
(SELECT OBJECT_NAME FROM ALL_OBJECTS
WHERE OWNER = 'SYS')
ORDER BY object_type, object_name;
spool off
set feedback on
set echo on
Then,
catalog.sql
catproc.sql
utlrp.sql
SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY; |
|
|
|
|
|
| Re: EXPDP error after recovering CONTROL and DATAFILES [message #682473 is a reply to message #682471] |
Sun, 25 October 2020 02:48 |
|
lucifer
Messages: 23
Registered: October 2020
|
Junior Member |
|
|
John, do I need to shutdown the database to run these?
I have not touched the database status for the previous runs
John Watson wrote on Sun, 25 October 2020 01:53I'll have a try. If I remember correctly, you can get errors like this if you have run the catalog scripts when you were not connected as SYSDBA. This is a well known script that attempts to fix this:set echo off
set pagesize 0
set feedback off
spool drop.sql
SELECT 'drop '||OBJECT_TYPE||' '||OWNER||'.'||object_name||';'
FROM all_objects
WHERE OWNER != 'SYS' AND OBJECT_TYPE != 'SYNONYM'
AND OBJECT_NAME IN
(SELECT OBJECT_NAME FROM ALL_OBJECTS
WHERE OWNER = 'SYS')
ORDER BY object_type, object_name;
spool off
set feedback on
set echo on
Then,
catalog.sql
catproc.sql
utlrp.sql
SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY;
|
|
|
|
|
|
| Re: EXPDP error after recovering CONTROL and DATAFILES [message #682475 is a reply to message #682471] |
Sun, 25 October 2020 05:13 |
|
lucifer
Messages: 23
Registered: October 2020
|
Junior Member |
|
|
Hi John
Ran all the scripts as advised, by SYS as SYSDBA
Here are the results - the output log files are too big to send over
The problem persists ...
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Administrator>expdp
Export: Release 11.2.0.1.0 - Production on Sun Oct 25 15:34:05 2020
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Username: bowreah
Password:
UDE-00018: Data Pump client is incompatible with database version 11.2.0.1.0
C:\Users\Administrator>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 25 15:35:59 2020
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys / as sysdba
Enter password:
Connected to:
Oracle Database 11g Release 11.2.0.1.0 - Production
SQL> SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY;
SELECT COMP_ID, COMP_NAME, VERSION, STATUS FROM DBA_REGISTRY
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REGISTRY" has errors
SQL>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
