Oracle启动不了了

Oracle启动不了了,是怎么回事呢。昨天晚上突然断电了,今天打开就这样。。

3个回答

这是我机器上的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 = 0

processes = 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\trace

db_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 = 10

The 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]

信息太少。。。是不是启动文件出错了,你检查下。

你是控制文件不对还是参数文件不对,是公司的库还是你自己的测试库。如果重要的库的话要对参数文件做备份的。

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问