ora-06553, PLS-213 package STANDARD not accessible - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 24

Thread: ora-06553, PLS-213 package STANDARD not accessible

  1. #11
    Join Date
    Sep 2001
    Posts
    76
    Sam,

    I happened to check my initPROD.ora file

    #shared_pool_size=300000000
    shared_pool_reserved_size=300000000

    I think i have to comment out shared_pool_reserved_size and then uncomment shared_pool_size

    RIght?

    then i will bounce the database and again run the catalog.sql

    correct me

  2. #12
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    OH YES!!!

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #13
    Join Date
    Sep 2001
    Posts
    76
    Thanks Sam,

    So, do i have to recreate the database and run sql.bsq,followd by catalog.sql
    or just correct the shared_pool_size and then run catalog.sql again ?

  4. #14
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    First just fix the shared_pool and try to open the database. Then try running the catalog.sql script and see the results. If that succeds procced with the rest.

    Else start from square one. But doubt that you got to run the sql.bsq

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #15
    Join Date
    Sep 2001
    Posts
    76
    Sam,
    fixing shared_pool_size did not have any effect. the problem still exists.

    Dont know what to do.

  6. #16
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Could you please post your init.ora file? May I know why you were trying to create the database through the scripts? Is there any reason behind it? Did you try the database configuration assistant "dbassist" and try?

    Looking forward to hear from you.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #17
    Join Date
    Sep 2001
    Posts
    76
    Sam,
    Thanks for responding. I will post the init.ora tomorrow. I am doing an upgrade of oracle applications 10.7SC to 11.5.5
    so after installing the 11.5.5, 8.1.7 database wont be there,we have to create it,so, I manually created it.
    I have to check if 'dbassist' utility is available.

    thanks

  8. #18
    Join Date
    Oct 2001
    Posts
    45

    run sql.bsq

    Hi, never heard who need to manually run sql.bsq. it's called by oracle automatically during creation of db. This script creates actural objects while catalog.sql create views/synonms of these objects. Your script look ok, pls try re-create db by running your script and login as sys to run catalog.sql and catproc.sql. Hope this can help.

  9. #19
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Most of the oracle installations would have the dbassist installed on the server. Make sure that you have that. Next confirm that your ORACLE_HOME, LD_LIBRARY_PATH, TNS_ADMIN, and PATH and ORACLE_SID set correctly before you start the db creation.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  10. #20
    Join Date
    Sep 2001
    Posts
    76
    Sam, here it is
    ###########################################################################
    #
    # Oracle Applications 11i - init.ora
    #
    # This file contains a listing of init.ora parameters for 8.1.6
    #
    # This is a reference file and contains the major initialisation
    # parameters used in Oracle Applications. It is intended to provide
    # a guide to the required parameters, but the actual values chosen
    # will be specific to each customer site, depending on the number
    # of OLTP users. This is in contrast to the CBO parameters
    # (ifilecbo.ora ), which are mandatory.
    #
    ###########################################################################


    db_name = PROD
    control_files = /u03/oracle/proddata/cntrl01.dbf,
    /u04/oracle/proddata/cntrl02.dbf,
    /u05/oracle/proddata/cntrl03.dbf

    db_block_size = 8192

    compatible = 8.1.7

    _system_trig_enabled = TRUE

    row_locking = always

    nls_date_format = DD-MON-RR # Is this still true with 11.5 ?

    nls_numeric_characters = ".,"
    nls_sort = binary
    nls_language = american
    nls_territory = america


    #audit_trail = true # if you want auditing

    max_enabled_roles = 40 # Some modules depend on
    # this feature.
    ifile = ?/dbs/ifilecbo.ora


    user_dump_dest = /u02/oracle/proddb/8.1.7/admin/udump
    background_dump_dest = /u02/oracle/proddb/8.1.7/admin/bdump
    core_dump_dest = /u02/oracle/proddb/8.1.7/admin/cdump

    max_dump_file_size = 10240 # trace file size

    timed_statistics = true

    # _trace_files_public
    _trace_files_public = TRUE

    processes = 75 # Max. no. of users x 2

    db_files = 500 # Max. no. of database files
    dml_locks = 500
    open_cursors = 500 # Consumes process memory, unless
    # using MTS.
    session_cached_cursors = 100
    enqueue_resources = 5000 # Max. no of concurrent database locks.

    db_block_buffers = 5000

    log_checkpoint_timeout = 72000 # Checkpoint at least every 20 mins.
    log_checkpoint_interval = 100000
    log_buffer = 1048576
    log_checkpoints_to_alert = TRUE


    rollback_segments = (rb1,rb2,rb3,rb4,rb5,rb6,rb7,rb8,rb9,rb10,rb11,rb12,rb13,rb14,rb15,rb16)
    #rollback_segments = (rbs1,rbs2)

    sort_area_size = 256000

    hash_area_size= 6000000

    #shared_pool_size = 300000000
    shared_pool_reserved_size = 30000000
    _shared_pool_reserved_min_alloc = 4100

    shared_pool_size = 300000000

    #java_pool_size = 50000000

    utl_file_dir = /usr/tmp

    aq_tm_processes = 1

    # log_archive_start = true # if you want automatic archiving

    parallel_max_servers = 8
    parallel_min_servers = 0

    optimizer_mode= choose
    _sqlexec_progression_cost= 0

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