I got a problem when I created db in Oracle8i

[Lee Joon Moon]

Hello Everyone

My HPUX is 5470/4GB/2CPU/OS: 11.1i/Disk 73*4EA

I installed Oracle 8i following orders
1. Installed Oracle 8i without creating DB
2. Installed patch 8.1.7.4 for HPUX
3. Created Oracle 8i, but I had a problem.
I wanted to save scripts, which are creating db. If I clicked save scripts, creating procedure aborted by itself.

* Kernel Parameter set up the recommondation of Oracle Documnet, which is Install Oracle8i on HPUX.

The error message is

=============================================

SIGSEGV 11* segmentation violation
stackbase=785EE000, stackpointer=785EFE18, pc=C304D70C

Full thread dump:
"CursorIdler" (TID:0x78ce2f18, sys_thread_t:0x4083d548 [lwp_id:3191], state:CW, thread_t: t@24, stack_base:0x7851e000, stack_size:0x20000, pc: 0xc02081a0) prio=8
java.lang.Object.wait(Object.java)
oracle.ewt.timer.Timer._waitTilScheduled(Unknown Source)
oracle.ewt.timer.Timer.run(Unknown Source)
java.lang.Thread.run(Thread.java)
"TaskScheduler timer" (TID:0x78d04818, sys_thread_t:0x408f6fa8 [lwp_id:3190], state:CW, thread_t: t@23, stack_base:0x7849a000, stack_size:0x20000, pc: 0xc02081a0) prio=8
java.lang.Object.wait(Object.java)
oracle.ewt.timer.Timer._waitTilScheduled(Unknown Source)
oracle.ewt.timer.Timer.run(Unknown Source)
java.lang.Thread.run(Thread.java)
"Screen Updater" (TID:0x78d03a20, sys_thread_t:0x402843d0 [lwp_id:3189], state:CW, thread_t: t@22, stack_base:0x784bb000, stack_size:0x20000, pc: 0xc02081a0) prio=8
java.lang.Object.wait(Object.java)
sun.awt.ScreenUpdater.nextEntry(ScreenUpdater.java:70)
sun.awt.ScreenUpdater.run(ScreenUpdater.java:90)
"AWT-Finalizer" (TID:0x78d0a9f8, sys_thread_t:0x408820f0 [lwp_id:3187], state:CW, thread_t: t@20, stack_base:0x7853f000, stack_size:0x20000, pc: 0xc02081a0) prio=8
java.lang.Object.wait(Object.java)
sun.awt.AWTFinalizer.run(AWTFinalizer.java:40)
"process reaper" (TID:0x78ce1968, sys_thread_t:0x401f0d80 [lwp_id:3170], state:CW, thread_t: t@8, stack_base:0x7858a000, stack_size:0x20000, pc: 0xc02081a0) prio=8
java.lang.Thread.run(Thread.java)
"AWT-Motif" (TID:0x78cdb360, sys_thread_t:0x40178ca0 [lwp_id:3169], state:CW, thread_t: t@7, stack_base:0x785ac000, stack_size:0x20000, pc: 0xc02081a0) prio=8
java.lang.Thread.run(Thread.java)
"AWT-Input" (TID:0x78cdb380, sys_thread_t:0x40173980 [lwp_id:3168], state:R, thread_t: t@6, stack_base:0x785cd000, stack_size:0x20000, pc: 0xc02097d8) prio=8
"AWT-EventQueue-0" (TID:0x78cdb398, sys_thread_t:0x401526c0 [lwp_id:3167], state:R, thread_t: t@5, stack_base:0x785ee000, stack_size:0x20000, pc: 0x0) prio=10 *current thread*
sun.awt.motif.MFileDialogPeer.create(MFileDialogPeer.java:23)
sun.awt.motif.MComponentPeer.init(MComponentPeer.java:102)
sun.awt.motif.MDialogPeer.(MDialogPeer.java:38)
sun.awt.motif.MFileDialogPeer.(MFileDialogPeer.java:26)
sun.awt.motif.MToolkit.createFileDialog(MToolkit.java:207)
java.awt.FileDialog.addNotify(FileDialog.java:121)
java.awt.Dialog.show(Dialog.java:196)
CreateSavePanel.doCreateLater(CreateSavePanel.java:215)
CreateSavePanel.OnFinish(CreateSavePanel.java:180)
DBCreateWizard.wizardFinished(DBCreateWizard.java:1070)
oracle.ewt.wizard.BaseWizard.processWizardEvent(Unknown Source)
oracle.ewt.wizard.BaseWizard.processEventImpl(Unknown Source)
oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
oracle.ewt.wizard.BaseWizard.doFinish(Unknown Source)
oracle.ewt.wizard.BaseWizard$Action.actionPerformed(Unknown Source)
oracle.ewt.button.PushButton.processActionEvent(Unknown Source)
oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
"SIGQUIT handler" (TID:0x78cd2280, sys_thread_t:0x40076288 [lwp_id:3166], state:R, thread_t: t@4, stack_base:0x7866f000, stack_size:0x20000, pc: 0xc020c228) prio=7
"Finalizer thread" (TID:0x78cd2068, sys_thread_t:0x4006c6c0 [lwp_id:3165], state:CW, thread_t: t@3, stack_base:0x78690000, stack_size:0x20000, pc: 0xc02081a0) prio=8
"main" (TID:0x78cd2090, sys_thread_t:0x40075a30 [lwp_id:0], state:CW, thread_t: t@1, stack_base:0xffffffff, stack_size:0x800000, pc: 0xc02081a0) prio=8
Monitor Cache Dump:
sun.awt.motif.MToolkit@78CDB420/7903B580: sys_mon = 0x400052b8, owner "AWT-EventQueue-0" (0x401526c0, 1 entry)
Waiting to be notified:
"AWT-Motif" (0x40178ca0)
sun.awt.AWTFinalizer@78D0A9F8/790AB458: sys_mon = 0x40007188,
Waiting to be notified:
"AWT-Finalizer" (0x408820f0)
oracle.ewt.timer.Timer@78D04778/790C8E30: sys_mon = 0x40007854,
Waiting to be notified:
"TaskScheduler timer" (0x408f6fa8)
oracle.ewt.timer.Periodic@78CE2F00/79126F90: sys_mon = 0x40006464,
Waiting to be notified:
"CursorIdler" (0x4083d548)
java.lang.Object@78CD65F8/79023C70: sys_mon = 0x40005f68, owner "AWT-EventQueue-0" (0x401526c0, 2 entries)
sun.awt.ScreenUpdater@78D03A20/790C5500: sys_mon = 0x400063f0,
Waiting to be notified:
"Screen Updater" (0x402843d0)
Registered Monitor Dump:
Fork_Wait_monitor: sys_mon = 0x7b01cb10,
Waiting to be notified:
"process reaper" (0x401f0d80)
Thread queue lock: sys_mon = 0x400756d8,
Waiting to be notified:
"main" (0x40075a30)
utf8 hash table: sys_mon = 0x4000c950,
String intern lock: sys_mon = 0x4000c890,
JNI pinning lock 31: sys_mon = 0x4000c7d0,
JNI pinning lock 30: sys_mon = 0x4000c710,
JNI pinning lock 29: sys_mon = 0x4000c650,
JNI pinning lock 28: sys_mon = 0x4000c590,
JNI pinning lock 27: sys_mon = 0x4000c4d0,
JNI pinning lock 26: sys_mon = 0x4000c410,
JNI pinning lock 25: sys_mon = 0x4000c350,
JNI pinning lock 24: sys_mon = 0x4000c290,
JNI pinning lock 23: sys_mon = 0x4000c1d0,
JNI pinning lock 22: sys_mon = 0x4000c110,
JNI pinning lock 21: sys_mon = 0x4000c050,
JNI pinning lock 20: sys_mon = 0x4000bf90,
JNI pinning lock 19: sys_mon = 0x4000bed0,
JNI pinning lock 18: sys_mon = 0x4000be10,
JNI pinning lock 17: sys_mon = 0x4000bd50,
JNI pinning lock 16: sys_mon = 0x4000bc90,
JNI pinning lock 15: sys_mon = 0x4000bbd0,
JNI pinning lock 14: sys_mon = 0x4000bb10,
JNI pinning lock 13: sys_mon = 0x4000ba50,
JNI pinning lock 12: sys_mon = 0x4000b990,
JNI pinning lock 11: sys_mon = 0x4000b8d0,
JNI pinning lock 10: sys_mon = 0x4000b810,
JNI pinning lock 9: sys_mon = 0x4000b750,
JNI pinning lock 8: sys_mon = 0x4000b690,
JNI pinning lock 7: sys_mon = 0x4000b5d0,
JNI pinning lock 6: sys_mon = 0x4000b510,
JNI pinning lock 5: sys_mon = 0x4000b450,
JNI pinning lock 4: sys_mon = 0x4000b390,
JNI pinning lock 3: sys_mon = 0x4000b2d0,
JNI pinning lock 2: sys_mon = 0x4000b210,
JNI pinning lock 1: sys_mon = 0x4000b150,
JNI pinning lock 0: sys_mon = 0x4000b090,
JNI global reference lock: sys_mon = 0x4000afc8,
BinClass lock: sys_mon = 0x4000af10,
Class loading lock: sys_mon = 0x4000ae50,
Java stack lock: sys_mon = 0x4000ad98,
Code rewrite lock: sys_mon = 0x4000acd8,
Heap lock: sys_mon = 0x4000ac20,
Has finalization queue lock: sys_mon = 0x4000ab58,
Finalize me queue lock: sys_mon = 0x4000aa98,
Waiting to be notified:
"Finalizer thread" (0x4006c6c0)
Monitor registry: sys_mon = 0x40004d28, owner "AWT-EventQueue-0" (0x401526c0, 1 entry)
./dbassist[107]: 2876 Abort(coredump)

-----------------------------------------------

I don't know why this error occured.
If you know this problem. Please reply me.

Thank you.
Have a nice day!!!

[Hein van den Heuvel · Accepted solution]

Hmmm, sounds a bit like a Java (version) problem, but you did manage to run the runinstaller before, so maybe not.

Did it get anywhere? Anyting in the targetted $ORACLE_HOME/dbs
No alert log / bdump directory for now huh?
installer.log? Were you asked to run root.sh? Did you?

How about using a simple DB create SQL script as per Oracle doc? Maybe an interactive session shows a core problem rather then the GUI trying to fluff it up and getting confused in the process?
Once the basic db creates (system, redo, optional user, no more) can you run catproc and friends?

Good luck,
Hein.

[Andreas D. Skjervold]

Hi

Did you install the required JDK 1.2.2 & JRE 1.1.8.03 prior to installing Oracle.

rgds
Andreas

[Tim Sanko]

1st install java 1.3 sdk.
2nd make sure your patches are ready.
3rd make sure you have your kernel parms set correctly.
4. make sure you can link your oracle kernel before you think about building a database.

I suspect this is a kernel issue. Try cheking the kernel parms to see if they are set correctly.

Tim

[Jeff Schussele]

Hi,

Sure looks like you need to adjust either a max?siz parameter or expand swap space as the SIGSEGV 11 is *usually* an indication that you tried to exceed one of these values.

Rgds,
Jeff

[Jeff Schussele]

Oh & if their kernel parameter template tells you to set timeslice to 1 - IGNORE IT & leave it at the default of 10 (100/10).
If you set it to 1, you're performance will go to he11 in a handbasket.

Jeff

[T G Manikandan]

check your kernel parameters.

make sure that the max?siz parameters are bumped up.
If you are running 64 bit version of oracle check the 64 bit equ. of max?siz_64 in the kernel.

[T G Manikandan]

More than that I would like to know whether you have two installations on the same machine.

What are the oracle variables?

Do you have
ORACLE_HOME
ORACLE_SID
ORA_NLS33
set to.

Make sure you are pointing to the right directory!

Try this
$ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

Revert on results