4 Replies Latest reply on Aug 15, 2019 2:00 PM by EdStevens

    nohup is not working and everytime is getting failed

    Jhil

      Hi All,

       

      Following command is getting failed - Why so ?

       

      [oracle@rac-p111 Desktop]$ nohup expdp directory=dpdir dumpfile=schema1.dmp logfile=schema1.log schemas=usr1,usr2,usr3 &

      [1] 9085

      [oracle@rac-p111 Desktop]$ nohup: ignoring input and appending output to `nohup.out'

       

       

       

      $ tail -f nohup.out

       

       

      Export: Release 11.2.0.3.0 - Production on Mon Jul 22 01:54:37 2019

       

      Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

       

      Username: UDE-00005: unexpected End-Of-File encountered while reading input

       

       

      OS : Oracle Linux 6.7

      DB : 11203

       

       

       

       

       

       

      Export: Release 11.2.0.3.0 - Production on Mon Jul 22 01:58:29 2019

       

       

      Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

       

       

      Username: UDE-00005: unexpected End-Of-File encountered while reading input

        • 1. Re: nohup is not working and everytime is getting failed
          Emad Al-Mousa

          you are exporting (performing expdp) using which account ?

           

          Regards,

          Emad

          • 2. Re: nohup is not working and everytime is getting failed
            Andris Perkons-Oracle

            As indicated by the error message, you have to provide a username (and a password). Since backgrounding a process and interactively providing input are mutually exclusive, you have to provide this information via a parfile or as part of the expdp command.

            Run your command in foreground and see what else is needed to run it without additional input.

             

            Andris

            1 person found this helpful
            • 3. Re: nohup is not working and everytime is getting failed
              Jhil

              Hi Andirs,

               

              [oracle@rac-p111 ~]$ nohup expdp "'/as sysdba'" parfile=exp1.par &

              [1] 8024

              [oracle@rac-p111 ~]$ nohup: ignoring input and appending output to `nohup.out'

               

              After execution of above command, i am not getting back cursor.

              How do i know whether job is successfully running or not ?

              Do i need to track  .log file ?  is this only way ?

               

              Using nohup is always recommended or not when we perform huge schema level backup ?

              We are performing export and import frequently.

               

              Regards,

              • 4. Re: nohup is not working and everytime is getting failed
                EdStevens

                Jhil wrote:

                 

                Hi Andirs,

                 

                [oracle@rac-p111 ~]$ nohup expdp "'/as sysdba'" parfile=exp1.par &

                From the documentation:

                 

                Invoking Data Pump Export

                The Data Pump Export utility is started using the expdp command. The characteristics of the export operation are determined by the Export parameters you specify. These parameters can be specified either on the command line or in a parameter file.

                Note:

                Do not start Export as SYSDBA, except at the request of Oracle technical support. SYSDBA is used internally and has specialized functions; its behavior is not the same as for general users.

                You have been told this before, here,