Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

I got a problem when I created db in Oracle8i

SOLVED
Go to solution
Lee Joon Moon
Occasional Advisor

I got a problem when I created db in Oracle8i

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!!!

7 REPLIES
Hein van den Heuvel
Honored Contributor
Solution

Re: I got a problem when I created db in Oracle8i



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
Honored Contributor

Re: I got a problem when I created db in Oracle8i

Hi

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

rgds
Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Tim Sanko
Trusted Contributor

Re: I got a problem when I created db in Oracle8i

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
Honored Contributor

Re: I got a problem when I created db in Oracle8i

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
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Jeff Schussele
Honored Contributor

Re: I got a problem when I created db in Oracle8i

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
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
T G Manikandan
Honored Contributor

Re: I got a problem when I created db in Oracle8i

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
Honored Contributor

Re: I got a problem when I created db in Oracle8i

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