Oracle启动不了了,是怎么回事呢。昨天晚上突然断电了,今天打开就这样。。
3条回答 默认 最新
- Java面试专栏 2011-11-17 10:50关注
这是我机器上的oracle 9i启动文件,您可以参照修改下!
[code="sql"]#
Copyright (c) 1991, 1997, 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.
#
You may also consider using Database Configuration Assistant tool (DBCA)
to create INIT file and to size your initial set of tablespaces based
on the user input.
#
###############################################################################replace "%AVAILABLE_SID%" with your database name
db_name=%AVAILABLE_SID%
db_files = 80 # INITIAL
db_files = 80 # SMALL
db_files = 400 # MEDIUM
db_files = 1500 # LARGE
%seed_control%
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 = 1000 # INITIAL
db_block_buffers = 100 # SMALL
db_block_buffers = 550 # MEDIUM
db_block_buffers = 3200 # LARGE
shared_pool_size = 10000000 # INITIAL
shared_pool_size = 3500000 # SMALL
shared_pool_size = 5000000 # MEDIUM
shared_pool_size = 9000000 # LARGE
log_checkpoint_interval = 10000
log_checkpoint_timeout = 0processes = 59 # 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
dml_locks = 200
log_buffer = 8192 # INITIAL
log_buffer = 32768 # SMALL
log_buffer = 32768 # MEDIUM
log_buffer = 163840 # LARGE
sequence_cache_entries made obsolete
sequence_cache_entries = 10 # INITIAL
sequence_cache_entries = 10 # SMALL
sequence_cache_entries = 30 # MEDIUM
sequence_cache_entries = 100 # LARGE
sequence_cache_hash_buckets made obsolete
sequence_cache_hash_buckets = 10 # INITIAL
sequence_cache_hash_buckets = 10 # SMALL
sequence_cache_hash_buckets = 23 # MEDIUM
sequence_cache_hash_buckets = 89 # 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 5 Meg 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 = %ORACLE_HOME%\database\%%ORACLE_SID%%\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 = (r01, r02, r03, r04)
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
define directories to store trace and alert files
background_dump_dest=%ORACLE_HOME%\RDBMS\trace
user_dump_dest=%ORACLE_HOME%\RDBMS\tracedb_block_size = 2048
remote_login_passwordfile = shared
text_enable = TRUE
The following parameters are needed for the Advanced Replication Option
job_queue_processes = 2
job_queue_interval = 10The following is obsolete on 8.1.x and above
job_queue_keep_connections = false
DISTRIBUTED_LOCK_TIMEOUT parameter has been made obsolete
distributed_lock_timeout = 300
distributed_transactions = 5
open_links = 4
The following parameter is set to use some of the new 8.1 features.
Please remember that using them may require some downgrade
actions if you later decide to move back to 8.0.
compatible = 8.1.5.0.0
[/code]本回答被题主选为最佳回答 , 对您是否有帮助呢?解决评论 打赏 举报无用 1
悬赏问题
- ¥15 如何在scanpy上做差异基因和通路富集?
- ¥20 关于#硬件工程#的问题,请各位专家解答!
- ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
- ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
- ¥30 截图中的mathematics程序转换成matlab
- ¥15 动力学代码报错,维度不匹配
- ¥15 Power query添加列问题
- ¥50 Kubernetes&Fission&Eleasticsearch
- ¥15 報錯:Person is not mapped,如何解決?
- ¥15 c++头文件不能识别CDialog