DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-01034/ORA-27101

  1. #1
    Join Date
    Nov 2001
    Location
    Beijing China
    Posts
    29

    Question

    I installed Oracle8i on my computer, windows 2000 advanced server, right after I finished the installation, I created a new repostory, but I could not start Oracle Management Server. Now, I tried to create a new repostory or delete the old one. but I could not connect the database, it shows:

    ORA-01034: Oracle not available
    ORA-27101: Shared memory realm does not exist

    ???? Do I have to reinstall oracle again or there any other way to fix the problem? Thank you in advanced


  2. #2
    Join Date
    Sep 2001
    Posts
    163
    I also got those same error messages. But in my case, I was experimenting with some init.ora parameters. More specifically, the parameter I was playing with was the lock_sga=true. Oracle tried to lock my entire SGA into physical memory and it didn't work. Which I don't understand because I have 256 meg of memory and my SGA is only 111 meg.

    How much memory does your machine have and what are the settings in your init.ora file? Can you post your init.ora here?


  3. #3
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    Check your Services window.

    Best guess is that Oracle is not running.

    The other possibility, if I remember correctly, is that you created your repository in a different database, ie, you created two databases during the install. If this is so, hopefully two sets of services will show in the control panel services window.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  4. #4
    Join Date
    Nov 2001
    Location
    Beijing China
    Posts
    29

    Angry

    I only created one database, "Master" while installation and one repository, the information:
    Account:System
    Password:manager
    Server:memoillusion:1521:master
    (My computer name is Memoillusion)
    But I could not start OMS

    when I try to delete the old repository, it shows: ORA-03113: Communicate channel is over.
    if I try to create a new database, it shows: ORA-12571:TNS:Package program faild
    (I am using Chinese OS, it was something about could not write the packege.)

    so, now, I can not do anything with repository, not create, not delete, and can not delete or create database either. And I could not start the Database, Master.

    [Edited by Cappuccino on 11-29-2001 at 08:43 PM]

  5. #5
    Join Date
    Nov 2001
    Location
    Beijing China
    Posts
    29
    I am using 192 meg memory right now. here is the init.ora:

    #
    # Copyright (c) 1991, 2000 by Oracle Corporation
    #
    #####################################

    db_name = "MASTER"

    instance_name = MASTER

    service_names = MASTER

    db_files = 1024 # INITIAL
    # db_files = 80 # SMALL
    # db_files = 400 # MEDIUM
    # db_files = 1500 # LARGE

    control_files = ("E:\oracle\oradata\MASTER\control01.ctl", "E:\oracle\oradata\MASTER\control02.ctl", "E:\oracle\oradata\MASTER\control03.ctl")

    open_cursors = 300
    max_enabled_roles = 30
    db_file_multiblock_read_count = 8 # INITIAL
    # db_file_multiblock_read_count = 8 # SMALL
    # db_file_multiblock_read_count = 16 # MEDIUM
    # db_file_multiblock_read_count = 32 # LARGE

    db_block_buffers = 2048 # INITIAL
    # db_block_buffers = 100 # SMALL
    # db_block_buffers = 550 # MEDIUM
    # db_block_buffers = 3200 # LARGE

    shared_pool_size = 31457280 # INITIAL
    # shared_pool_size = 3500000 # SMALL
    # shared_pool_size = 5000000 # MEDIUM
    # shared_pool_size = 9000000 # LARGE

    large_pool_size = 614400
    java_pool_size = 20971520

    log_checkpoint_interval = 10000
    log_checkpoint_timeout = 1800

    processes = 150 # INITIAL
    # processes = 50 # SMALL
    # processes = 100 # MEDIUM
    # processes = 200 # LARGE

    parallel_max_servers = 5 # SMALL
    # parallel_max_servers = 4 x (number of CPUs) # MEDIUM
    # parallel_max_servers = 4 x (number of CPUs) # LARGE

    log_buffer = 32768 # INITIAL
    # log_buffer = 32768 # SMALL
    # log_buffer = 32768 # MEDIUM
    # log_buffer = 163840 # LARGE

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

    # Uncommenting the line below will cause automatic archiving if archiving has
    # been enabled using ALTER DATABASE ARCHIVELOG.
    # log_archive_start = true
    # log_archive_dest_1 = "location=E:\oracle\oradata\MASTER\archive"
    # log_archive_format = %%ORACLE_SID%%T%TS%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 )

    # If using public rollback segments, define how many
    # rollback segments each instance will pick up, using the formula
    # # of rollback segments = transactions / transactions_per_rollback_segment
    # In this example each instance will grab 40/5 = 8
    # transactions = 40
    # transactions_per_rollback_segment = 5

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

    # Edit and uncomment the following line to provide the suffix that will be
    # appended to the db_name parameter (separated with a dot) and stored as the
    # global database name when a database is created. If your site uses
    # Internet Domain names for e-mail, then the part of your e-mail address after
    # the '@' is a good candidate for this parameter value.
    # db_domain = us.acme.com # global database name is db_name.db_domain

    # 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

    oracle_trace_collection_name = ""
    # define directories to store trace and alert files
    background_dump_dest = E:\oracle\admin\MASTER\bdump
    #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 = E:\oracle\admin\MASTER\udump

    db_block_size = 8192

    remote_login_passwordfile = exclusive

    os_authent_prefix = ""

    # The following parameters are needed for the Advanced Replication Option
    job_queue_processes = 4
    job_queue_interval = 10
    open_links = 4

    distributed_transactions = 500
    mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
    # Uncomment the following line when your listener is configured for SSL
    # (listener.ora and sqlnet.ora)
    # mts_dispatchers = "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"

    compatible = 8.1.0
    sort_area_size = 65536
    sort_area_retained_size = 65536



  6. #6
    Join Date
    Nov 2001
    Location
    Beijing China
    Posts
    29

    Exclamation

    Is it about the Operating System? I was using Windows 2000 server and did not make it to be a Domain Server. Oracle was working well at the time. Now, I formated my disk and reinstalled OS, Windows 2000 Advanced Server and made it to be a Domain Server (Memoillusion.WorkStation.Memoillusion) and reinstalled Oracle. Is there any setting I have to change?

  7. #7
    Join Date
    Jul 2001
    Posts
    10
    Confirm all your oracle services should not be automatic
    on windows2000.

  8. #8
    Join Date
    Nov 2001
    Location
    Beijing China
    Posts
    29
    You mean that I should start them by myself?

  9. #9
    Join Date
    Jul 2001
    Posts
    10
    only three oracle services should be Automatic
    TNS Listener
    OracleDatabase
    WebAssistant

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