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 安卓adb backup备份应用数据失败
- ¥15 eclipse运行项目时遇到的问题
- ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
- ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
- ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站
- ¥50 成都蓉城足球俱乐部小程序抢票
- ¥15 yolov7训练自己的数据集
- ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)(相关搜索:51单片机|单片机|测试代码)
- ¥15 电力市场出清matlab yalmip kkt 双层优化问题
- ¥30 ros小车路径规划实现不了,如何解决?(操作系统-ubuntu)