ORA-6553 error on export
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: ORA-6553 error on export

Hybrid View

  1. #1
    Join Date
    May 2001
    Posts
    8

    Question

    I can't seem to figure this out, maybe one of you know the answer. I am trying to export 2 user tables from oracle 8.1.5 on the NT platform. Whenever I try this, i get multiple ORA-6553 errorrs telling me PLS-213: package STANDARD not accessible
    I checked to see if the standard package exsists and it does to no suprise.. i try executing it, and it bombs on line 1.
    any ideas?? Is this some type of permission error??

    thanks,

    Steve Schroeder
    University of Arizona

  2. #2
    Join Date
    Dec 1999
    Posts
    217
    ARe you using the same version of the oracle export utilityas the database? There are some compatibility issues with reference to the different versions of Oracle.

    Chintz

  3. #3
    Join Date
    May 2001
    Posts
    8
    yep same version

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Try


    exp sys/passwd@instance FILE=exp.dmp TABLE=(schema_name.tablename, schema_name.table_name,...) COMPRESS=N LOG=EXP.log

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Dec 1999
    Posts
    217
    The meaning of this error is that the PL/SQL compiler could not find package STANDARD in the current Oracle database. To compile a program, PL/SQL needs package STANDARD.

    Troubleshoot the PLS-213 by verifying the information as follows:

    You need to verify the package STANDARD is valid and owned by SYS. Do the
    following:

    1) Check the status of the package STANDARD using:

    connect sys/
    SQL> SELECT * FROM DBA_OBJECTS WHERE OWNER = 'SYS'
    AND OBJECT_NAME = 'STANDARD';

    If you find the status is 'INVALID' then:

    SQL> ALTER PACKAGE STANDARD COMPILE;

    You may also find that a number of other packages are in 'INVALID'
    state. They should ALL be (re)compiled.

    If you find STANDARD does not exist then:

    Verify "$ORACLE_HOME/rdbms/admin/standard.sql" exists.

    If this file does not exist then:

    You probably did not install PL/SQL.
    You must use the Installer to install PL/SQL.

    If the file does exist then:

    Verify that your ORACLE_SID is set correctly:

    SQL> connect sys/
    SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql


    2) Verify that STANDARD is owned by SYS:

    SQL> SELECT * FROM DBA_OBJECTS WHERE OBJECT_NAME = 'STANDARD';

    If OWNER != SYS then catproc.sql was not correctly executed
    by SYS. You will have to drop these packages and rerun catproc
    as SYS.

    3) Try running "catalog.sql" and "catproc.sql" while opening a spool file
    to catch any errors that may have occurred.

    Look for Errors like:

    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 2192 bytes of shared memory ("shared pool,

    ","PROCEDURE$","KQLS heap","KQLS MEM BLOCK")

    Create or Replace:
    *
    ORA-06553: PLS-213: package STANDARD not accessible
    grant execute on STANDARD to public

    ORA-04042: procedure, function, package, or package body does not exist

    In this case, you would need to increase the "SHARED_POOL_SIZE" in the
    "init.ora".

    Then re-execute CATALOG and CATPROC.

    Increasing "SHARED_POOL_SIZE" will allocate more resources and
    allow the scripts to run successfully.


    Hopefully this fixes your problem.

    CHintz

  6. #6
    Join Date
    May 2001
    Posts
    8
    sam, i've allready tried that... i've even tried exporting the entire DB.. still the same error so it won't complete successfully.

    Steve

  7. #7
    Join Date
    May 2001
    Posts
    8
    Chintz, thanks alot! that worked beautifully.. where did you find that info??

    steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width