1 2 3 Previous Next 30 Replies Latest reply: Nov 7, 2012 4:33 AM by Paul M. Go to original post RSS
      • 15. Re: Imp dmp file in oracle 10g on linux
        khan786
        i have applied all yours post command but still my problem is not solved.
        actually i copy my dmp file into /mnt/erp folder.
        is there any folder where i have to copy the dmp file instead of /mnt???
        • 16. Re: Imp dmp file in oracle 10g on linux
          Osama_Mustafa
          Did you try to copy your dmp under oracle user to u01 , u02 for example
          • 17. Re: Imp dmp file in oracle 10g on linux
            khan786
            no...
            my oracle folder is /u01
            if i copy the dmp in /u01 then i should do this like
            file=/u01/file.dmp
            also mention then i need any rights to give on folder.
            • 18. Re: Imp dmp file in oracle 10g on linux
              khan786
              Yes osama i did this.copy the file into /u01 and then try to imp but this return same error file is failed to opened.
              first i created the user and then grants the dba rights.
              steps to imp.
              login as oracle user.
              imp
              user:
              passward
              then file=path
              • 19. Re: Imp dmp file in oracle 10g on linux
                Paul M.
                Your posts are inconsistent. At one time you see the file
                cd /mnt/erp
                ls -l this return as

                -rwxr-xr-x 1 root root 232288384 sep date and then name of dmp file that is file.dmp
                afterwards you don't see it anymore
                # cd /mnt/erp
                # ls -l | od -c

                i past this command but nothing is return....
                A file does not disappear by itself.
                still my problem is not solved.
                If you don't give us consistent information, then we'll not be able to understand what happens.
                actually i copy my dmp file into /mnt/erp folder.
                And immediately after that what's the result of
                # cd /mnt/erp
                # ls -la
                • 20. Re: Imp dmp file in oracle 10g on linux
                  khan786
                  thanks for reply..
                  i past this comand as
                  ls -la
                  drwxrwxrwx 2 root root 4096 oct date .
                  drwxr-xr-x 4 root root 4096 oct date ..
                  -rwxr-xr-x 1 root root 225617920 sep File.dmp
                  -rwxr-xr-x 1 root oinstall 232208384 sep date File_New_live.dmp

                  there are two dmp file located in erp folder ....
                  i tried for both but nothing is done.
                  • 21. Re: Imp dmp file in oracle 10g on linux
                    Paul M.
                    -rwxr-xr-x 1 root root 225617920 sep File.dmp
                    -rwxr-xr-x 1 root oinstall 232208384 sep date File_New_live.dmp

                    there are two dmp file located in erp folder ....
                    i tried for both but nothing is done.
                    Please post the exact command you tried.
                    • 22. Re: Imp dmp file in oracle 10g on linux
                      970035
                      Hi,
                      Change the permissions of the dump file till imp job is complete:
                      as root user :
                      chmod 777 dump-file-name

                      then run the imp command, once job is completed you can run this as roor:
                      chmod 700 dump-file-name.

                      Hope this helps.
                      • 23. Re: Imp dmp file in oracle 10g on linux
                        Paul M.
                        Change the permissions of the dump file till imp job is complete:
                        as root user :
                        chmod 777 dump-file-name
                        To do what ? The permissions posted are more than sufficient for oracle user to read the file.
                        • 24. Re: Imp dmp file in oracle 10g on linux
                          khan786
                          i log in as root and do
                          cd /mnt/erp
                          and ls -l
                          -rwxr-xr-x 1 775 oinstall 225617920 Sep 20 12:16 File is return

                          and i put this command
                          cat /etc/group
                          more than 14 row return but i oinstall and dba group user
                          oinstall:x:500
                          dba:x:501:oracle

                          if you require any information please free to ask....my problem is still not solved
                          • 25. Re: Imp dmp file in oracle 10g on linux
                            khan786
                            i also do this step to make the oracle is part of dba group as

                            chown oracle:dba /mnt/erp/File.dmp
                            chmod 775 /mnt/erp/File.dmp

                            and then log in as oracle user su - oracle
                            and do the imp but not solved yet...
                            • 26. Re: Imp dmp file in oracle 10g on linux
                              Paul M.
                              and then log in as oracle user su - oracle
                              and do the imp but not solved yet...
                              If you don't answer my questions, then I can't help you much...

                              PLEASE POST THE EXACT IMP COMMAND YOU TRIED.
                              • 27. Re: Imp dmp file in oracle 10g on linux
                                khan786
                                my guest os linux is installed on vmware and when i copied the whole command and there result to usb and but when i come to main host os that win 7 the command is disappear actually the txt file in which i past the command is not saved in usb.
                                thats why i am not able to paste the origional command.
                                i am unable to share the folder between two os.
                                • 28. Re: Imp dmp file in oracle 10g on linux
                                  Paul M.
                                  my guest os linux is installed on vmware and when i copied the whole command and there result to usb and but when i come to main host os that win 7 the command is disappear actually the txt file in which i past the command is not saved in usb.
                                  thats why i am not able to paste the origional command.
                                  i am unable to share the folder between two os.
                                  Well... looks like a very ordinary problem... there is surely more than one solution...

                                  1. Copy and paste the command directly from vmware to Windows, without writing any files

                                  2. Write the command into a file, and then transfer the file to Windows (ftp, winscp, ....)

                                  3. Configure SAMBA on linux, and then share the directory on Windows (this one might be a bit more difficult than other solutions).


                                  Anyway, couldn't you write the command directly here ? (exactly as you did execute it)
                                  • 29. Re: Imp dmp file in oracle 10g on linux
                                    khan786
                                    [root@lnxdb ~]# cd /mnt/erp
                                    [root@lnxdb erp]# ls -ltr

                                    total 578864

                                    -rwxr-xr-x 1 root root 133986304 Mar 30 2012 B300320121605.DMP

                                    -rwxrwxrwx 1 775 oinstall 225617920 Sep 20 12:16 File

                                    -rwxrwxrwx 1 775 oinstall 337503 Sep 29 12:17 F_LIVE_09_29_2012_12_15_26.TXT

                                    -rwxrwxrwx 1 oracle dba 232208384 Sep 29 12:17 F_LIVE_09_29_2012_12_15_26


                                    [root@lnxdb erp]# su - oracle

                                    [oracle@lnxdb ~]$ imp


                                    Import: Release 10.2.0.1.0 - Production on Wed Nov 7 03:37:47 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 > file=/mnt/erp/File


                                    IMP-00002: failed to open file=/mnt/erp/File.dmp for read
                                    Import file: expdat.dmp >


                                    not import helpl\