Migrate Oracle10gR2 data in AIX to Oracle11gR2 of the HP Cluster

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.