6 Replies Latest reply: May 6, 2014 3:58 AM by Jr.raj RSS

    RAC Expdp Error

    Jr.raj

      HI guys

       

      i tried to expdp in RAC 11gr2 2 node database.

      expdp dumpfile=testenet_05052014%U.dmp logfile=testenet.log schemas=test_enet directory=backup compression=all cluster=N parallel=2

       

       

      Export: Release 11.2.0.4.0 - Production on Mon May 5 08:49:03 2014

       

       

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

       

       

      Username: test_enet

      Password:

       

       

      UDE-01034: operation generated ORACLE error 1034

      ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Linux-x86_64 Error: 2: No such file or directory

      UDE-00003: all allowable logon attempts failed

      Thanks in advance

      Raj

        • 1. Re: RAC Expdp Error
          Richard Harrison .

          Hi,

          It looks just like you have ORACLE_SID set to the wrong value.

           

          Cheers,

          Rich

          • 2. Re: RAC Expdp Error
            Jr.raj

            Thank you richard for your prompt response

             

            i have checked oratab,

             

            i dont have sys passwd, i could connect to sql plus from $prompt.

            i have created directory with 'test" user, i tried to expdp with test user only,

            Linux-x86_64 Error: 2: No such file or directory

            i assume this is the problem with permissions on directory?

            am not sure

             

            regards

            Raj

            • 3. Re: RAC Expdp Error
              Richard Harrison .

              Hi,

              When you say sqlplus is working how do you connect - expdp uses the same login process so if one works the other should too.

               

              are you doing sqlplus user/pass@db

               

              and expdp user/pass (without the @db?)

               

              That might be part of it (hence my question about ORACLE_SID).

               

              Be aware the 'directory' is an oracle directory object rather than a directory on the filesystem - so something like

               

              SQL> create directory test as '/tmp';

               

              expdp directory=test

               

              Cheers,

              Rich

              • 4. Re: RAC Expdp Error
                Jr.raj

                thank you richard

                 

                i tried in this way

                expdp test_enet@testenet dumpfile=userrs.dmp logfile=vurrs.log directory=backup tables=users cluster=n

                 

                 

                Export: Release 11.2.0.4.0 - Production on Tue May 6 01:43:11 2014

                 

                 

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

                Password:

                 

                 

                Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

                With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

                Data Mining and Real Application Testing options

                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

                Thanks & Regards

                Raj

                • 5. Re: RAC Expdp Error
                  Jr.raj

                  Thank you Richard

                   

                  Got it Richard, oracle user doesnt have permission on that directory

                   

                  Regards

                  Raj

                  • 6. Re: RAC Expdp Error
                    Richard Harrison .

                    Hi,

                    That looks like just a missing 'physical ' directory.

                     

                    select * from dba_directories where directory_name='BACKUP';

                     

                    check this path actually exists on all the nodes in the cluster - adding cluster=N just means it won't run on more than one instance - however you don't know which instance that will be - so it may be running on one you dont expect.

                     

                    Cheers,

                    Rich