Thanks to jgrijalba_at_novasoft.es and Raul Sosa, They help me with the theirs
tips, I change my file sysconfigtab , and now I can to install oracle.
Saludos
Julio
-----Mensaje original-----
De: jgrijalba [mailto:jgrijalba_at_novasoft.es]
Enviado el: viernes 6 de julio de 2001 3:16
Para: 'Julio Ramos'
Asunto: RE: oracle 8i installation
Hello Julio,
It could be an error because the machine has some parameters down.
I paste a mail of this list than can help you.
Maybe you have to change some of this parameters.
If you don't know how to change it, ask me.
Regards
PD: Do you speak spanish ? Then, you can write to me in spanish. (I speak
spanish)
Hi,
If you are looking for information in the man pages on shared memory or
stacks, forget it. Even the man on dxkerneltuner does not outline what
variables may be set or what effect they might have. There were a few
summaries in my collection that referenced stack overflow (my original
problem with running Oracle srvmgrl). However, all the summaries had errors
in them, either not mentioning that the place where these variables are set
is in /etc/sysconfigtab (which it turns out can be managed by dxkerneltuner)
or had miss-spellings of variable names (mostly _ replaced by - chars or the
_ just omitted) or even one summary which had a variable name that didn't
seem to be the munged name for any existing variable (maybe that was a Tru64
version thing). Anyway, cutting and pasting from emails to /etc/sysconfigtab
may not solve peoples problems.
I'm not sure of the total ramifications of my actions, but this is what I
modified part of my /etc/sysconfigtab to look like (I only used
dxkerneltuner to find out the correct spelling of the variable names and
their section location) -
proc:
maxusers=256
max_per_proc_address_space=42924967296
max_per_proc_data_size=42924967296
max_proc_per_user=2048
max_threads_per_user=2048
per_proc_data_size=42924967296
per_proc_stack_size=33554432
per_proc_address_space=42924967296
ipc:
shm_max=2139095040
shm_min=1
shm_mni=256
shm_seg=32
Then after a reboot, I was then able to run the create_db.sh script for my
Oracle 8.1.5 database.
Dennis
Thanks to:
(a) Roetman, Paul [PRoetman_at_CSXLines.com] whose reply is included
Yes, you are correct, the ipc parameters recommended by oracle are
(something like) below.
Other interesting commands are
ipcs -mcbpt
and
login into oracle using svrmgrl
show sga
The proc parameters also become important when you start to get larger
shared memory segments.
My ipc and process parameters (for ver5.0a) are:
proc:
max-per-proc-address-space=42924967296
max_per_proc_data_size=42924967296
max_proc_per_user=2048
max_threads_per_user=2048
per-proc-data-size=42924967296
per_proc_stack_size=33554432
per_proc_address_space=42924967296
ipc:
shm-max=2139095040
shm-min=1
shm-mni=256
shm-seg=32
(b) Riggs, Joan [JRiggs_at_kls.usaka.smdc.army.mil] whose reply was
Using dxkerneltuner, see the IPC section to change these variables.
(c) John Tan [John.Tan_at_asx.com.au] whose reply was
Sounds right from the things I have done.
The original question:
Hi,
I'm running 5.0A and have come up against an Oracle problem. The error
message looks like -
Stack overflow: pid 4291, proc oracle, addr 0x11f7ffff0, pc 0x3ff801bc8c4
I noticed in a summary that you can overcome this by increasing shared
memory to a whopping 256gb, but the summary didn't spell where you set the
parameters. My guess is that its in the file /etc/sysconfigtab and the entry
should look like
ipc:
SHMMAX 2139095040
SHMMIN 1
SHMMNI 100
SHMSEG 32
Can anyone confirm this.
######################################
Dennis Macdonell
Systems Administrator
AUSLIG
mail: PO Box 2, Belconnen, ACT 2617
email: mcdonell_at_auslig.gov.au
ph: 61 2 6201 4326
fax: 61 2 6201 4377
######################################
-----Mensaje original-----
De: tru64-unix-managers-owner_at_ornl.gov
[mailto:tru64-unix-managers-owner_at_ornl.gov]En nombre de Julio Ramos
Enviado el: jueves, 05 de julio de 2001 23:49
Para: 'tru64-unix-managers_at_ornl.gov'
Asunto: oracle 8i installation
Hi Managers :
I have one problem with the installation of oracle , when i used this
command /cdrom/installer
I received this messages ..........could tell me how can continue the
installation ?
Thanks & Saludos
Julio
OP>/cdrom/runInstaller
OP> Initializing Java Virtual Machine from /cdrom/install/../st
age/Components/oracle.swd.jre/1.1.8.4/1/DataFiles/Expanded/jre/decunix/bin/j
re.
Please wait...
SIGSEGV 11* segmentation violation
si_signo [11]: SIGSEGV 11* segmentation violation
si_errno [0]: Successful
si_code [1]: SEGV_MAPERR [addr: 0x3ffbfb38650]
sc_pc: 0x3ffbfb38650, r26: 0x3ffbfeffea8
stackbase=11fffbe00, stackpointer=11fffb430
Full thread dump:
"SIGQUIT handler" (TID:0xc16570, sys_thread_t:0x400c6f00, state:R,
pthread_t
: t_at_26375680, sp:0x0 threadID:0x20001927600, stack_base:0x20001925ac8
stack_size
:0x506000) prio=2
"Finalizer thread" (TID:0xc16110, sys_thread_t:0x400c6c80, state:CW,
pthread
_t: t_at_15824384, sp:0x0 threadID:0x20000f17600, stack_base:0x20000f15ac8
stack_si
ze:0x506000) prio=2
"main" (TID:0xc16160, sys_thread_t:0x400c6a00, state:R, pthread_t:
t_at_-107196
4160, sp:0x0 threadID:0x3ffc01b2000, stack_base:0x11fffbe00
stack_size:0x800000)
prio=5 *current thread*
oracle.sysman.oii.oiif.oiifm.OiifmSplashScreen.<init>(OiifmSplashScreen.
java:43)
oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:417)
Monitor Cache Dump:
Received on Thu Jul 12 2001 - 17:50:26 NZST