Migrate Oracle10gR2 data in AIX to Oracle11gR2 of the HP Cluster

Description: The AIX database is a 64-bit ORACLE10gR2 database and the HPUNIX database is a 64-bit ORACLE11gR2 database. Now, the data of a user in the AIX database is migrated to the HP database.

Description: The AIX database is a 64-bit ORACLE10g R2 database and the hp unix database is a 64-bit ORACLE11g R2 database. Now, the data of a user in the AIX database is migrated to the HP database.

Description: The AIX database is a 64-bit Oracle10g R2 database and the hp unix database is a 64-bit ORACLE11g R2 database. Now, the data of a user in the AIX database is migrated to the HP database.

1. operate on the AIX System
Check whether the expdp_dir directory is available in the database.
SQL> select * from dba_directories;

OWNER DIRECTORY_NAME
------------------------------------------------------------
DIRECTORY_PATH
--------------------
SYS EXPDP_DIR
/Oracle/oraarch/expdp_dir

If not, you can recreate it:
SQL> create directory expdp_dir as '/oracle/oraarch/expdp_dir ';

Authorization:
SQL> grant read, write on directory expdp_dir to bhomswas;

Grant succeeded.

Check whether/oracle/oraarch/expdp_dir exists in the operating system. If not, create a directory.
$ Mkdir expdp_dir

Export:
Expdp bhomswas/password DIRECTORY = expdp_dir DUMPFILE = bhomswas. dmp logfile = bhomswas. log

2. Operate on HP
Create the impdp_dir directory under the/home/oraoms directory
CBDBS01-> mkdir impdp_dir

Upload the data file bhomswas. dmp exported from aix to the/home/oraoms/impdp_dir directory of the hp system using ftp.

Ftp HPIP
Ftp> bin
Ftp> put bhomswas. dmp

Then the system authorization:
CBDBS01-> chmod 777 bhomswas. dmp
CBDBS01-> ls-l
Total 1679072
-Rwxrwxrwx 1 oraoms oinstall 859684864 Nov 23 bhomswas. dmp

4. Create a tablespace and its users in the HP Database
Check the data file path of the tablespace.
Select * from dba_data_files

Create 1 tablespace
-- 1
Create tablespace MLOG_NORM_SPACE
Datafile '+ DATADG/cboms/datafile/mlog_norm_space.dbf'
Size 5 M autoextend on

Create a user:
Create user bhomswas
Identified by password
Default tablespace PUB_NORM_SPACE

Grant dba to bhomswas;

Create a directory in the database and authorize
Create directory impdp_dir as '/home/oraoms/impdp_dir ';

Grant read, write on directory impdp_dir to bhomswas;

3. Operate on AIX

Modify tnsnames. ora and add
Cboms1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = HPIP) (PORT = 1568 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cboms)
(INSTANCE_NAME = cboms1)
)
)

Test to understand hp servers

Sqlplus user/password @ cboms1

Impdpbhomswas/password @ cboms1DIRECTORY = impdp_dir dumpfile = bhomswas. dmp logfile = Imp. log

Finished!

Appendix:

If the HP database is two RAC databases, the AIX database cannot be configured as follows.
Configure/oracle/oms/102_64/network/admin/tnsnames. ora to add information about the hp database.
CBOMS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = HPIP) (PORT = 1568 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.2.46.28) (PORT = 1568 ))
(LOAD_BALANCE = yes)
(FAILOVER = ON)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cboms)
(FAILOVER_MODE =
(TYPE = Select)
(METHOD = BASIC)
)
)
)

Import data to the hp Database
Impdpbhomswas/password @ CBOMSDIRECTORY = impdp_dir dumpfile = bhomswas. dmp logfile = Imp. log

ORA-39002: invalid operation.
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS. UTL_FILE", line 536
ORA-29283: invalid file operation

This error is reported because folders cannot be found on two servers of HP, so only one node can be configured.