| Migration 10.1.0.3 on tru64 -> 10.2.0.3 RHEL4 [message #244961] |
Thu, 14 June 2007 13:35  |
estrar
Messages: 2
Registered: June 2007
Location: Denver, Co
|
Junior Member |
|
|
Hi!
I am migrating a 10.1.0.3 database from tru64 to 10.2.0.3 on RedHat enterprise 4.
I did the following steps:
1.- created a skeleton database on RHEL4
2.- applied @$ORACLE_HOME/rdbms/admin/catalog.sql to old DB.
3.- Exported db as follow:
expdp system/<passwd> full=Y directory=BKP dumpfile=EGIS2.dmp logfile=Export.log
4.- Imported to new Machine.
impdp system/<passwd> DUMPFILE=EGIS2.dmp DIRECTORY=DATA_PUMP_DIR TABLE_EXISTS_ACTION=replace LOGFILE=IMPORT.LOG
5.- applied @$ORACLE_HOME/rdbms/admin/catalog.sql to new DB
6.- applied @$ORACLE_HOME/rdbms/admin/utlrp.sql
However, I am getting the following compilation error:
ORA-24237: object id argument passed to DBMS_UTILITY.INVALIDATE is not legal
ORA-06512: at "SYS.DBMS_UTILITY", line 1060
ORA-01403: no data found
Seems that it has to do with this import error message:
ORA-23327: imported deferred rpc data does not match GLOBAL NAME and platform of importing db,
What is the syntax to exclude the deferred rpc data from the export?
Thanks,
Estrar
|
|
|
|
| Re: Migration 10.1.0.3 on tru64 -> 10.2.0.3 RHEL4 [message #244965 is a reply to message #244961] |
Thu, 14 June 2007 13:44  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
ORA-23327
ORA-23327: imported deferred rpc data does not match string of importing db
Cause: Deferred rpc queues were imported from a database with a different global name or operating system than importing database.
Action: Deferred rpc data should only be imported into a database with the same global name and hardware and operating system.
try to create the same dump directory for IMPORT AS YOU CREATED IT FOR EXPORT.
|
|
|
|
| Re: Migration 10.1.0.3 on tru64 -> 10.2.0.3 RHEL4 [message #244983 is a reply to message #244965] |
Thu, 14 June 2007 15:22 |
estrar
Messages: 2
Registered: June 2007
Location: Denver, Co
|
Junior Member |
|
|
Hi!
I recreated the dump directory in target machine, however, still
having the same issue.
Thanks,
Estrar
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Processing object type DATABASE_EXPORT/DE_SYSTEM_PROCOBJACT/DE_PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/DE_SYSTEM_PROCOBJACT/DE_POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-06550: line 2, column 93:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
Failing sql is:
BEGIN
dbms_server_alert.set_threshold(2104,dbms_server_alert.operator_GT,'1200',dbms_server_alert.operator_NONE,'',1,3,'EGIS2',dbms_server_ alert.object_type_SYSTEM,'');COMMIT; END;
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match GLOBAL NAME and platform of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('TRU64SERVER.CO.US','DEC Alpha OSF/1, r1.1-8.1.0');
END;
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match GLOBAL NAME and platform of importing db
Failing sql is:
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
