Home » RDBMS Server » Server Utilities » Migration 10.1.0.3 on tru64 -> 10.2.0.3 RHEL4
Migration 10.1.0.3 on tru64 -> 10.2.0.3 RHEL4 [message #244961] Thu, 14 June 2007 13:35 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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:
Re: Migration 10.1.0.3 on tru64 -> 10.2.0.3 RHEL4 [message #244986 is a reply to message #244983] Thu, 14 June 2007 15:56 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
What is the syntax to exclude the deferred rpc data from the export?



check it may be helpful.

http://www.unix.org.ua/orelly/oracle/bipack/ch17_02.htm
Previous Topic: export/import question
Next Topic: Import from Oracle7 to Oracle 10g
Goto Forum:
  


Current Time: Sun Dec 11 00:23:46 CST 2016

Total time taken to generate the page: 0.14484 seconds