[askdba] Re: DB_BLOCK_BUFFERS - HELP

  • From: "Pepling, Todd C." <tpepling@xxxxxxx>
  • To: "'askdba@xxxxxxxxxxxxx'" <askdba@xxxxxxxxxxxxx>
  • Date: Thu, 4 Nov 2004 08:01:50 -0500

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.

Other related posts: