import into oracle in AIX using telnet

I was tried to import into an oracle 11.2 in AIX using telnet linking into server.

>telnet 10.217.200.121

And encountered an error:

$impdp CSMISGRM/CSMISGRM directory=AIXCSMISDBWS dumpfile=CSMIS.DMPDP logfile=impdp.log schemas=CSMISGRM remap_tablespace=CSMISGRM:CSMIS

error message:

With the Partition option

ORA-39002: invalid option

ORA-39070: Unable to open the log file

ORA-39283: invalid file operation

ORA-06512: at “SYS.UTL_FILE”, line 536

ORA-29283: invalid file operation

img_2743

then i tried using nologfile parameter,

$impdp CSMISGRM/CSMISGRM directory=AIXCSMISDBWS dumpfile=CSMIS.DMPDP nologfile=yes schemas=CSMISGRM remap_tablespace=CSMISGRM:CSMIS

and got:

With the Partition option

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31640: unable to open dump file “/oradata/AIXCSMISDBWS/CSMIS.DMPDP” for read

ORA-31640: unable to obtain file status

IBM AIX RISC System/6000 Error : 2: No such file or directory

Additional information: 3

img_2744

I had checked the directory, it had been given read and write authority to current user:

$chmod 777 /oradata/AISCSMISDBWS

Then using sqlplus logged into oracle and check the directory. Make sure to include “/” at the beginning (or the end) of the path, such as ‘/oradata/AIXCSMISDBWS/’ when creating the DIRECTORY in the database.

$sqlplus / as sysdba

>create or replace directory AIXCSMISDBWS as ‘/oradata/AIXCSMISDBWS/’;

>grant read,write on directory AIXCSMISDBWS to CSMISGRM;

But there still have the error. I google it and got the answer.

first, check the DATA_PUMP_DIR parameter by using echo command.

$echo “$DATA_PUMP_DIR”

i found the system don’t have this parameter.

then open the profile file of the system, and add this parameter, the value is the directory name:

DATA_PUMP_DIR=AIXCSMISDBWS

import again, bingo! success!

This entry was posted in Database. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s