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
11-29-2001, 09:44 AM
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?
11-29-2001, 09:44 AM
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.
11-29-2001, 08:27 PM
I only created one database, "Master" while installation and one repository, the information:
(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]
11-29-2001, 08:34 PM
I am using 192 meg memory right now. here is the init.ora:
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)"
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?
11-29-2001, 09:42 PM
Confirm all your oracle services should not be automatic
11-29-2001, 09:58 PM
You mean that I should start them by myself?
11-29-2001, 10:19 PM
only three oracle services should be Automatic