1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

expdp error

Discussion in 'Security, Backup and Recovery' started by Roknauta, Apr 3, 2014.

  1. Roknauta

    Roknauta Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Belo Horizonte
    Bom Dia, estou tendo problemas ao fazer export no Oracle, após validar usuário e senha, tenho este erro.
    UDE-06550: operation generated ORACLE error 6550
    ORA-06550: line 1, column 11:
    PLS-00201: identifier 'SYS.DBMS_UTILITY' must be declared
    ORA-06550: line 1, column 11:
    PL/SQL: Statement ignored
    Alguém sabe como resolvo isso?
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.

    Please publish messages in English.
    Escreva as suas mensagens em inglês.


    For a start check the rights of your user under which you log in to a database when exporting.
    Provide example of a call expdb and the error message
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    La cuenta de usuario que está utilizando no tiene privilegios de ese paquete. Usted necesita obtener privilegios que el usuario ejecute el DBMS_UTILITY.


    Please use English when posting further to this forum.
     
  4. Roknauta

    Roknauta Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Belo Horizonte
    Where do I check this?
     
  5. Roknauta

    Roknauta Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Belo Horizonte
    Strange, has only 1 user.
     
  6. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    1)
    If there is the active session under this user, then it is possible so:

    Code (SQL):

    SELECT * FROM session_privs;
    SELECT * FROM session_roles;
     
    2)
    Code (SQL):

    SELECT * FROM USER_SYS_PRIVS;
     SELECT * FROM USER_TAB_PRIVS;
    SELECT * FROM USER_ROLE_PRIVS;
     
    OR

    Code (SQL):

    SELECT * FROM dba_sys_privs  WHERE grantee ='your users' ;
    SELECT * FROM DBA_TAB_PRIVS  WHERE grantee ='your users';
    SELECT * FROM DBA_ROLE_PRIVS WHERE grantee ='your users';
     
     
  7. Roknauta

    Roknauta Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Belo Horizonte
    Appeared this error now.
    ORA-01219: database not open: queries allowed on fixed tables/views only
     
  8. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Tell, you shutdown a database?
    What shows request?

    Code (SQL):

    sqlplus /nolog
    CONNECT / AS sysdba

    SELECT open_mode FROM v$database;

     
     
  9. Roknauta

    Roknauta Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Belo Horizonte
    Appeared this error:
    ORA-01507: database not mounted
     
  10. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Code (SQL):


    sqlplus /nolog
    CONNECT / AS sysdba

    startup
     
     
  11. Roknauta

    Roknauta Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Belo Horizonte
    Total System Global Area 1235959808 bytes
    Fixed Size 2212896 bytes
    Variable Size 805309408 bytes
    Database Buffers 419430400 bytes
    Redo Buffers 9007104 bytes
    ORA-01102: cannot mount database in EXCLUSIVE mode
     
  12. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Oracle version ?
    what operating system?
     
  13. Roknauta

    Roknauta Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Belo Horizonte
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    Ubuntu 13.04 64bits
     
  14. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    On Ubunty there can be different problems with oracle... This clone of Linux officially isn't supported by Oracle

     
  15. Roknauta

    Roknauta Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Belo Horizonte
    Obrigado, farei os testes amanhã, está na hora de eu ir pra casa ja.
     
  16. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You have issues; check the alert log for errors as it appears the database cannot mount on restart.