Home » Infrastructure » Linux » Imp file in oracle 10g on linux
Imp file in oracle 10g on linux [message #568125] Tue, 09 October 2012 10:54 Go to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

I want to imp dmp file in oracle 10g on linux.
now my problem is my file is locate in /mnt/erp/erp/file.dmp
when i give the user and password then it asked for exdat.dmp>'full path'
at the path how i can mention the path that is /mnt/erp/erp/file
how.
Re: Imp file in oracle 10g on linux [message #568127 is a reply to message #568125] Tue, 09 October 2012 10:59 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is the file /mnt/erp/erp/file.dmp or /mnt/erp/erp/file?
Note that you can always specify your file on the command line.

Regards
Michel
Re: Imp file in oracle 10g on linux [message #568128 is a reply to message #568127] Tue, 09 October 2012 11:10 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

my dmp file is locate in erp folder and then i copy the erp folder in /mnt.
in window it is easy as we copy the full path like path='mnt/erp/erp/file.dmp'
but how i can do this in linux to access dmp file to imp...
Re: Imp file in oracle 10g on linux [message #568129 is a reply to message #568128] Tue, 09 October 2012 11:46 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The same way?
I don't understand your problem can you explain it with more details?

Regards
Michel
Re: Imp file in oracle 10g on linux [message #568130 is a reply to message #568125] Tue, 09 October 2012 11:58 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

dear sir..
when i login to user and giver paswword after that it want the path
thats is full='/mnt/erp/file.dmp'
it return erro that failed to opened the file...
please check the sytax of path is corect in linux???
Re: Imp file in oracle 10g on linux [message #568131 is a reply to message #568130] Tue, 09 October 2012 12:02 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste what you did and got.

Regards
Michel
Re: Imp file in oracle 10g on linux [message #568133 is a reply to message #568131] Tue, 09 October 2012 12:19 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

[root@lnxdb tmp]# tar zxpf /mnt/cdrom/VMware-workstation-full-7.0.0-203739.tar.gz
tar:
/mnt/cdrom/VMware-workstation-full-7.0.0-203739.tar.gz: Cannot open: No such file or directory
tar:
Error is not recoverable: exiting now
tar: Child returned status 2
tar: Error exit delayed from previous errors

[root@lnxdb tmp]#
*************************************************

[oracle@lnxdb erp]$ imp


Import: Release 10.2.0.1.0 - Production on Wed Oct 10 08:09:37 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Username: ftw_10oct2012

Password:


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
Production
With the Partitioning, OLAP and Data Mining options


Import file: expdat.dmp > FW_LIVE_09_29_2012_12_15_26.dmp


IMP-00002: failed to open FW_LIVE_09_29_2012_12_15_26.dmp for read
Re: Imp file in oracle 10g on linux [message #568134 is a reply to message #568131] Tue, 09 October 2012 12:23 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

Pleas consider after imp part...
which after ********************
Re: Imp file in oracle 10g on linux [message #568136 is a reply to message #568134] Tue, 09 October 2012 12:34 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ls -l FW_LIVE_09_29_2012_12_15_26.dmp


Regards
Michel
Re: Imp file in oracle 10g on linux [message #568142 is a reply to message #568136] Tue, 09 October 2012 12:51 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

ls -l FW_LIVE_09_29_2012_12_15_26.dmp
failed to open the file....error...

Re: Imp file in oracle 10g on linux [message #568143 is a reply to message #568142] Tue, 09 October 2012 12:53 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

My dmp file is in /mtn/erp/file.dmp

before imp i have to to that folder like cd /mnt/erp
after that i execute imp command....
please corect me...
Re: Imp file in oracle 10g on linux [message #568146 is a reply to message #568143] Tue, 09 October 2012 13:12 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to create and put your file in the directory you want before you can use imp on this file in this directory, of course, otherwise how Oracle will find the file?
And you have to take of the privileges of these directory and file to be sure that Oracle is able to read it.

Regards
Michel
Re: Imp file in oracle 10g on linux [message #568295 is a reply to message #568125] Wed, 10 October 2012 09:54 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

sir i have ealier mentioned that i create the folder that is name erp in /mnt folder.
now how i can giver the priveliged.
please
Re: Imp file in oracle 10g on linux [message #568296 is a reply to message #568295] Wed, 10 October 2012 10:02 Go to previous messageGo to next message
BlackSwan
Messages: 22691
Registered: January 2009
Senior Member
chmod 777 /mnt/
chmod 777 /mnt/erp/
Re: Imp file in oracle 10g on linux [message #568297 is a reply to message #568296] Wed, 10 October 2012 10:13 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

chmod 777 /mnt/
changing the permission of /mnt/ not permitted

i login as oracle user not root...
please
Re: Imp file in oracle 10g on linux [message #568308 is a reply to message #568297] Wed, 10 October 2012 11:15 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So ask your sysadmin to give you the privileges on the directory you use, or use another directory.

Regards
Michel
Re: Imp file in oracle 10g on linux [message #568311 is a reply to message #568308] Wed, 10 October 2012 11:26 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

sir.
iam the owner of sysadmin which is root...
i want to know how i grant right to oracle user from root.
is this corect wany
chmod 777 /mnt/erp to oracle ????
Re: Imp file in oracle 10g on linux [message #568350 is a reply to message #568311] Thu, 11 October 2012 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which privileges do you want to grant to "oracle" on this directory?
Do you know what are the privileges on files and directories on Linux and how to set them?

Regards
Michel
Re: Imp file in oracle 10g on linux [message #568516 is a reply to message #568296] Sat, 13 October 2012 01:06 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

sir,

i login as root and paste this command but its not works...
i want to grant right on folder to user oracle which is created for oracle installation and my group is dba or oinstall

[root@lnxdb ~]# chown oracle.dba /mnt/erp/file.dmp

chown: cannot access `/mnt/erp/file.dmp': No such file or directory


[root@lnxdb ~]# chown oracle:dba /mnt/erp/file.dmp

chown: cannot access `/mnt/erp/file.dmp': No such file or directory


[root@lnxdb ~]#
------------------------------
please help...
Re: Imp file in oracle 10g on linux [message #568518 is a reply to message #568516] Sat, 13 October 2012 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ls -l /mnt/erp/file.dmp

Regards
Michel
Re: Imp file in oracle 10g on linux [message #568522 is a reply to message #568518] Sat, 13 October 2012 02:15 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

login as root and paste the command
ls -l /mnt/erp/file.dmp
it return
-rwxr-xr-x 1 root root 232208384 sep date /mnt/erp/file.dmp

i want to change the right and giver the full right to the user oracle....
please give the command
Re: Imp file in oracle 10g on linux [message #568524 is a reply to message #568522] Sat, 13 October 2012 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To import you only need read privilege.
Post
ls -ld /mnt
ls -ld /mnt/erp

Regards
Michel
Re: Imp file in oracle 10g on linux [message #568525 is a reply to message #568524] Sat, 13 October 2012 02:33 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

i past your comand like
ls -ld /mnt
ls -ld /mnt/erp
after that i have log in as oracle user and try to imp but it still return error like
imp-00002 file to open the file....
Re: Imp file in oracle 10g on linux [message #568528 is a reply to message #568525] Sat, 13 October 2012 03:06 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste, everything.

Regards
Michel
Re: Imp file in oracle 10g on linux [message #568540 is a reply to message #568528] Sat, 13 October 2012 08:55 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

ls -ld /mnt
result is
drwxr-xr-x 4 root 4096 oct date /mnt

ls -ld /mnt/erp
result is

drwxrwxrwx 2 root 4096 oct date /mnt/erp
Re: Imp file in oracle 10g on linux [message #568544 is a reply to message #568540] Sat, 13 October 2012 09:14 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
COPY AND PASTE.

I give up.
We can't what is real and is faked in what you post.

Regards
Michel
Re: Imp file in oracle 10g on linux [message #568546 is a reply to message #568544] Sat, 13 October 2012 09:21 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

sir actuall my linux is installed on vmware and no vmtool is installed so it is very difficult for me to copy from vmware and past in win 7 becuase my net is on on win 7 thats whay i write the result of command.
Re: Imp file in oracle 10g on linux [message #568547 is a reply to message #568546] Sat, 13 October 2012 09:45 Go to previous messageGo to next message
BlackSwan
Messages: 22691
Registered: January 2009
Senior Member
irfankundi786@yahoo.com wrote on Sat, 13 October 2012 07:21
sir actuall my linux is installed on vmware and no vmtool is installed so it is very difficult for me to copy from vmware and past in win 7 becuase my net is on on win 7 thats whay i write the result of command.



so how EXACTLY do you get the dump file into the vmware environment?
post COPY & PASTE steps so we can see what you do & how OS responds.
Re: Imp file in oracle 10g on linux [message #568549 is a reply to message #568547] Sat, 13 October 2012 10:29 Go to previous messageGo to next message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

I copy the dmp file to usb and paste this in /mnt/erp folder in root user ..
thats it.

Re: Imp file in oracle 10g on linux [message #568564 is a reply to message #568547] Sun, 14 October 2012 04:29 Go to previous message
irfankundi786@yahoo.com
Messages: 214
Registered: February 2009
Location: pakistan
Senior Member

Waiting for yours expert views
Previous Topic: .bash_profile sourced automatically on login
Next Topic: rpm istallation of linux RHEL 5.1
Goto Forum:
  


Current Time: Sat Aug 23 02:49:04 CDT 2014

Total time taken to generate the page: 0.09164 seconds