Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> INIT.ORA included RE:- Unable to do a normal shutdown or Export

INIT.ORA included RE:- Unable to do a normal shutdown or Export

From: Tony Rees <tony_rees_at_stratexnet.com>
Date: Mon, 27 Jan 2003 09:39:40 -0000
Message-ID: <b12ula$fni$1$8302bc10@news.demon.co.uk> 





Sorry forgot to include the init.ora for this one.



#

# This is the Initialization file for the 816 REPORT Instance

#

#

# Copyright (c) 1991, 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.

#

############################################################################

###




db_name = "REPORT"



instance_name = REPORT



service_names = REPORT



db_files = 1024  # INITIAL


# db_files = 80                                                       #

SMALL



# db_files = 400                                                      #

MEDIUM



# db_files = 1500                                                     #

LARGE


control_files = ("f:\oracle816\oradata\REPORT\control01.ctl",
"f:\oracle816\oradata\REPORT\control02.ctl",
"f:\oracle816\oradata\REPORT\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 = 43750  # INITIAL


# db_block_buffers = 100                                              #

SMALL



# db_block_buffers = 550                                              #

MEDIUM



# db_block_buffers = 3200                                             #

LARGE




#shared_pool_size = 52428800  # INITIAL

# shared_pool_size = 3500000                                          #

SMALL



# shared_pool_size = 5000000                                          #

MEDIUM


shared_pool_size = 30000000                                          # LARGE


SHARED_POOL_RESERVED_SIZE = 15M




#large_pool_size = 614400



large_pool_size = 5000000


java_pool_size = 2097152



log_checkpoint_interval = 10000


log_checkpoint_timeout = 1800



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


log_buffer = 32768  # INITIAL


# log_buffer = 32768                                                  #

SMALL



# log_buffer = 32768                                                  #

MEDIUM



# log_buffer = 163840                                                 #

LARGE




# Optimizer Mode can be Choose, rule or cost

# optimizer_mode = Rule




#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=f:\oracle816\oradata\REPORT\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 = f:\oracle816\admin\REPORT\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 = f:\oracle816\admin\REPORT\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 = 10000000


sort_area_retained_size = 1000000


CONTROL_FILE_RECORD_KEEP_TIME = 0




#_SYSTEM_TRIG_ENABLED=FALSE


Received on Mon Jan 27 2003 - 03:39:40 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US