Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: ORA-00600: internal error code, arguments: [3051], [82], [73], [], [], [], [], []

    Hi Guys,

    I installed Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
    onto Unix machine (Tru64 Compaq 5.1A s.o).

    When i try to connect to the database, i recive this message:

    Oracle Server Manager Release 3.1.6.0.0 - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
    JServer Release 8.1.6.0.0 - Production

    SVRMGR> connect internal
    Connected.
    SVRMGR> startup
    ORACLE instance started.
    Total System Global Area 30347688 bytes
    Fixed Size 94632 bytes
    Variable Size 13295616 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 180224 bytes
    Database mounted.
    ORA-00600: internal error code, arguments: [3051], [82], [73], [], [], [], [], []
    ORA-00600: internal error code, arguments: [733], [8388688], [pga heap], [], [], [], [], []

    I try to shutdown force command and then startup, but the problem continuus.......i need some help to solve this problem.....

    The is thta the database is still open.........

    But i don't need how can solve this problem.......


    Thanks alot for your answers

    Bye

    Max

  2. #2
    Join Date
    Oct 2003
    Location
    Montreal
    Posts
    10
    Hi
    Your error seems to be related to an memory allocation problem.
    Verify your Operating system memory allocation, or reduce the size of your SGA in your init<$ORACLE_SID>.ora file

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Per Oracle's Metalink....

    Solution Description: ===================== You should increase the amount of physical memory on the system, or you may reduce the amount of memory which Oracle attempts to use. The SGA is usually the largest consumer of memory. To calculate the approximate size of an SGA, use the following formula with values from the "initSID.ora" file. ( ( db_block_size * db_block_buffers ) + shared_pool + log_buffer ) / .9 You can not adjust the "db_block_size" parameter unless you recreate the database, but the other parameters can be reduced to use less memory. If you make any changes to the "initSID.ora" file, you will need to shutdown and startup the instance again for the changes to become effective. Explanation: ============ There is not enough available memory to run the instance or concurrent instances with the present configuration. You must add additional memory or reduce the amount of memory used.


    HTH
    Gregg

  4. #4
    Join Date
    Oct 2003
    Posts
    2
    Originally posted by gbrabham
    Per Oracle's Metalink....

    Solution Description: ===================== You should increase the amount of physical memory on the system, or you may reduce the amount of memory which Oracle attempts to use. The SGA is usually the largest consumer of memory. To calculate the approximate size of an SGA, use the following formula with values from the "initSID.ora" file. ( ( db_block_size * db_block_buffers ) + shared_pool + log_buffer ) / .9 You can not adjust the "db_block_size" parameter unless you recreate the database, but the other parameters can be reduced to use less memory. If you make any changes to the "initSID.ora" file, you will need to shutdown and startup the instance again for the changes to become effective. Explanation: ============ There is not enough available memory to run the instance or concurrent instances with the present configuration. You must add additional memory or reduce the amount of memory used.


    HTH
    Gregg


    Thanks for your answer but i'm a beginner with tha Oracle's Installation.


    I have checked my initSID.ora (initacpdb.ora) but i don't know what i can do.


    i have those parameters configured in that file:
    $ vi initacpdb.ora
    "initacpdb.ora" 110 lines, 4325 characters
    #
    # Copyright (c) 1991, 1998 by Oracle Corporation
    #
    ################################################## ############################
    # Example INIT.ORA file
    #
    # This file is provided by Oracle Corporation to help you customize
    # your RDBMS installation for your site. Important system parameters
    # are discussed, and example settings given.
    #
    # Some parameter settings are generic to any size installation.
    # For parameters that require different values in different size
    # installations, three scenarios have been provided: SMALL, MEDIUM
    # and LARGE. Any parameter that needs to be tuned according to
    # installation size will have three settings, each one commented
    # according to installation size.
    #
    # Use the following table to approximate the SGA size needed for the
    # three scenarious provided in this file:
    #
    # -------Installation/Database Size------
    # SMALL MEDIUM LARGE
    # Block 2K 4500K 6800K 17000K
    # Size 4K 5500K 8800K 21000K
    #
    # To set up a database that multiple instances will be using, place
    # all instance-specific parameters in one file, and then have all
    # of these files point to a master file using the IFILE command.
    # This way, when you change a public
    # parameter, it will automatically change on all instances. This is
    # necessary, since all instances must run with the same value for many
    # parameters. For example, if you choose to use private rollback' segments,
    # these must be specified in different files, but since all gc_*
    # parameters must be the same on all instances, they should be in one file.
    #
    # INSTRUCTIONS: Edit this file and the other INIT files it calls for
    # your site, either by using the values provided here or by providing
    # your own. Then place an IFILE= line into each instance-specific
    # INIT file that points at this file.
    #
    # NOTE: Parameter values suggested in this file are based on conservative
    # estimates for computer memory availability. You should adjust values upward
    # for modern machines.
    #
    ################################################## #############################

    db_name = "acpdb"
    instance_name = acpdb

    service_names = acpdb


    control_files = ("/u01/oracle/oradata/acpdb/control01.ctl", "/u02/oracle/oradata/acpdb/control02.ctl", "/u03/oracle/oradata/acpdb/co
    ntrol03.ctl")

    open_cursors = 100
    max_enabled_roles = 30
    db_block_buffers = 2048

    shared_pool_size = 10485760

    large_pool_size = 614400
    java_pool_size = 0

    log_checkpoint_interval = 10000
    log_checkpoint_timeout = 1800

    processes = 50

    log_buffer = 163840

    # audit_trail = false # if you want auditing
    # timed_statistics = false # if you want timed statistics
    # max_dump_file_size = 10000 # limit trace file size to 5M each

    # Uncommenting the lines below will cause automatic archiving if archiving has
    # been enabled using ALTER DATABASE ARCHIVELOG.
    # log_archive_start = true
    # log_archive_dest_1 = "location=/u01/oracle/admin/acpdb/arch"
    # log_archive_format = arch_%t_%s.arc

    # If using private rollback segments, place lines of the following
    # form in each of your instance-specific init.ora files:
    #rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )

    # Global Naming -- enforce that a dblink has same name as the db it connects to
    # global_names = false

    # Uncomment the following line if you wish to enable the Oracle Trace product
    # to trace server activity. This enables scheduling of server collections
    # from the Oracle Enterprise Manager Console.
    # Also, if the oracle_trace_collection_name parameter is non-null,
    # every session will write to the named collection, as well as enabling you
    # to schedule future collections from the console.
    # oracle_trace_enable = true

    # define directories to store trace and alert files
    background_dump_dest = /u01/oracle/admin/acpdb/bdump
    core_dump_dest = /u01/oracle/admin/acpdb/cdump
    #Uncomment this parameter to enable resource management for your database.
    #The SYSTEM_PLAN is provided by default with the database.
    #Change the plan name if you have created your own resource plan.# resource_manager_plan = system_plan
    user_dump_dest = /u01/oracle/admin/acpdb/udump

    db_block_size = 8192

    os_authent_prefix = ""

    compatible = "8.1.0"
    sort_area_size = 65536
    sort_area_retained_size = 65536



    Thanks a lot

    Cheers

    Max

  5. #5
    Join Date
    Oct 2003
    Posts
    26
    First shutdown your database
    Try reducing db_block_buffers to 1024 in the init file and start your database.

    HTH
    Arvind

Posting Permissions

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