[askdba] Re: DB_BLOCK_BUFFERS - HELP

  • From: VuCanDo <vuquyen@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Thu, 4 Nov 2004 10:45:20 -0800

Here is the Alert log file and init.ora.  What's  the best method to
fix these problems?
Thanks,

Vu


On Thu, 4 Nov 2004 08:01:50 -0500, Pepling, Todd C. <tpepling@xxxxxxx> wrote:
> Just to be clear: db_block_buffers is still permitted in Oracle9i, so you
> technically you can use it.  It's just not ideal anymore, especially when
> there are new data-buffer cache parameters like
> 
>  db_2k_cache_size
>  db_4k_cache_size
>  db_8k_cache_size
>  db_16k_cache_size
>  db_32k_cache_size
>  db_cache_size
>  db_keep_cache_size
>  db_recycle_cache_size
> 
> Curious what the alert.log says.  Did you save the original init.ora (or
> save original settings), and if so, can it be used to start the database?
> 
> 
> 
> -----Original Message-----
> From: Deepa S. Kale [mailto:deepask@xxxxxxxxx]
> Sent: Wednesday, November 03, 2004 10:59 PM
> To: askdba@xxxxxxxxxxxxx
> Cc: ASKDBA; askdba-bounce@xxxxxxxxxxxxx
> Subject: [askdba] Re: DB_BLOCK_BUFFERS - HELP
> 
> what message comes in ur alert.log file ?
> because db_block_buffer parameter is deprecated in 9i by DB_CACHE_SIZE
> parameter.
> so my suggestion is instead of db_block_buffer , u use db_block_size
> parameter...
>                                                                       =
> 
> Also, DB_BLOCK_BUFFERS cannot be combined with the new dynamic        =
> 
> DB_CACHE_SIZE parameter; combining these parameters in the same parame=
> ter
> file will produce an error. DB_BLOCK_BUFFERS is retained for backward =
> 
> compatibility.                                                        =
> 
>                                                                       =
> 
>                                                                       =
> 
>                                                                       =
> 
>                                                                       =
> 
> Deepa Kale -DBA
> Jyoti Structures - Nasik(IT)
> 
>                                                                       =
> 
>             VuCanDo                                                   =
> 
>             <vuquyen@xxxxxxxx                                         =
> 
>             m>                                                        =
> To
>             Sent by:                  ASKDBA <askdba@xxxxxxxxxxxxx>   =
> 
>             askdba-bounce@fre                                         =
> cc
>             elists.org                                                =
> 
>                                                                   Subj=
> ect
>                                       [askdba] DB_BLOCK_BUFFERS - HELP=
> 
>             04-11-2004 07:58                                          =
> 
>             AM                                                        =
> 
>                                                                       =
> 
>                                                                       =
> 
>             Please respond to                                         =
> 
>             askdba@freelists.                                         =
> 
>                    org                                                =
> 
>                                                                       =
> 
>                                                                       =
> 
> Hi Guys,
> 
>   I was increased the DB_BLOCK_BUFFERS from 0 to 4096.  After
> shutdown and restart the database, this is what I got an errors.  I
> need help to start up the database that run on NT Server running on
> Oracle 9.2.0.1
> 
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> 
> Thanks,
> 
> Vu
> 
> =
> 
> 
> This email and any files transmitted with it are confidential and intended 
> solely for the use of the individual or entity to whom they are addressed. If 
> you have received this email in error please notify the system manager. This 
> message contains confidential information and is intended only for the 
> individual named. If you are not the named addressee you should not 
> disseminate, distribute or copy this e-mail.
> 
> 


-- 
Vu


-- Attached file included as plaintext by Ecartis --
-- File: initSPYDER.ora

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
 
###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_cache_size=25165824
db_file_multiblock_read_count=16
 
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
 
###########################################
# Database Identification
###########################################
db_domain=""
db_name=SPYDER
 
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=D:\oracle\admin\SPYDER\bdump
core_dump_dest=D:\oracle\admin\SPYDER\cdump
timed_statistics=TRUE
user_dump_dest=D:\oracle\admin\SPYDER\udump
 
###########################################
# File Configuration
###########################################
control_files=("c:\oracle\ora90\SPYDER\control01.ctl", 
"D:\oracle\ora90\SPYDER\control02.ctl", "c:\oracle\ora90\SPYDER\control03.ctl")
 
###########################################
# Instance Identification
###########################################
instance_name=SPYDER
 
###########################################
# Job Queues
###########################################
job_queue_processes=10
 
###########################################
# MTS
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=SPYDERXDB)"
 
###########################################
# Miscellaneous
###########################################
aq_tm_processes=1
compatible=9.2.0.0.0
 
###########################################
# Optimizer
###########################################
hash_join_enabled=TRUE
query_rewrite_enabled=FALSE
star_transformation_enabled=FALSE
 
###########################################
# Pools
###########################################
java_pool_size=33554432
large_pool_size=8388608
shared_pool_size=50331648
 
###########################################
# Processes and Sessions
###########################################
processes=150
 
###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300
 
###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=EXCLUSIVE
 
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=25165824
sort_area_size=524288
 
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1

-- Binary/unsupported file stripped by Ecartis --
-- Type: application/octet-stream
-- File: alert_spyder.log



Other related posts: