Re: svrmgrl problem

From: Alexey Ovchinnikov <alexiss_at_svl.ru>
Date: Fri, 30 Nov 2001 16:05:56 +0300
Message-ID: <9u7vqc$atr$1@octopus.co.ru>

>
> The SGA settings are in init<SID>.ora in $ORACLE_HOME/dbs
>
> The main settings affecting memory are
> db_block_buffers (multiply by db_block_size to get the number of bytes
used)
> shared_pool_size (in bytes)
> large_pool_size (in bytes)
> java_pool_size (in bytes)
> log_buffer
>
> You didn't check alert<SID>.log, did you? Please do so.
>
> Hth
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>

first - thank you for your help :) But I still not reach my first database worked :(

ok - this is my /u01/app/oracle/product/8.1.7/rdbms/log/alert_svl.log file:

Fri Nov 30 07:32:31 2001
Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0

Starting up ORACLE RDBMS Version: 8.1.7.0.1. System parameters with non-default values:

  processes                = 50
  shared_pool_size         = 3500000
  large_pool_size          = 1000000
  java_pool_size           = 1000000
  control_files            = ora_control1, ora_control2
  db_block_buffers         = 100
  db_block_size            = 8192
  log_buffer               = 32768
  log_checkpoint_interval  = 10000
  db_files                 = 80
  db_file_multiblock_read_count= 8
  db_domain                = svlm.com
  global_names             = TRUE
  db_name                  = svl
  parallel_max_servers     = 5
  max_dump_file_size       = 10240

Fri Nov 30 07:32:32 2001
Errors in file /u01/app/oracle/product/8.1.7/rdbms/log/ora_376.trc: Fri Nov 30 07:34:36 2001
Errors in file /u01/app/oracle/product/8.1.7/rdbms/log/ora_344.trc: ORA-00445: background process "PMON" did not start after 120 seconds Fri Nov 30 07:34:37 2001
Errors in file /u01/app/oracle/product/8.1.7/rdbms/log/ora_377.trc: Fri Nov 30 07:34:45 2001
Errors in file /u01/app/oracle/product/8.1.7/rdbms/log/ora_378.trc: Fri Nov 30 07:34:54 2001
Errors in file /u01/app/oracle/product/8.1.7/rdbms/log/ora_379.trc: Fri Nov 30 07:34:55 2001
Errors in file /u01/app/oracle/product/8.1.7/rdbms/log/ora_380.trc:

as you see the total SGA memory size is: 100 * 8192 + 3500000 + 1000000 + 1000000 + 32768 = 5 614 688 - it's more less than 128Mb (my SHMMAX is 0x8000000 ). Also 'db_block_size', 'large_pool_size' and 'java_pool_size' was not in my initsvl.ora file and i was add its with above values. finally this is a beginning of
/u01/app/oracle/product/8.1.7/rdbms/log/ora_344.trc file for example:

Du/u01/app/oracle/product/8.1.7/rdbms/log/ora_344.trc Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option
JServer Release 8.1.7.0.1 - Production
ORACLE_HOME = /u01/app/oracle/product/8.1.7 System name: Linux
Node name: oracleserver

Release: 2.2.18
Version: #2 Fri Nov 30 05:17:04 PST 2001
Machine: i586

Instance name: svl
Redo thread mounted by this instance: 0 <none> Oracle process number: 0
344

• 2001-11-30 07:34:35.958 Exception signal: 11 (SIGSEGV)
• 2001-11-30 07:34:36.236 ksedmp: internal or fatal error ORA-00445: background process "PMON" did not start after 120 seconds Current SQL information unavailable - no session. ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ------------------------- --- ksedmp()+142 CALL ksedst()+0 ssexhd()+198 CALL ksedmp()+0 0 ? pthread_sighandler CALLr 00000000 608 ?

I think that problem not in memory but maby in pthread library?

Thanks
Ovchinnikov Alexiss Received on Fri Nov 30 2001 - 07:05:56 CST