SQLPLUS core dump (Oracle 9.2.0.1) (531 Views)
Reply
Regular Advisor
Carlo Henrico_1
Posts: 188
Registered: ‎10-02-2000
Message 1 of 3 (531 Views)

SQLPLUS core dump (Oracle 9.2.0.1)

Sorry about the length of this, but the more info, the better we can solve this.

I have just installed Oracle 9.2.0.1 on HP-UX 11.0 64 bit. After having numerous problems, I decided to read the manual... :)
Patches (seem) up to date
Kernel Parameters are fix'd
Environment variables are fix'd (especially the lib/lib32 difference) and the NLS parameters are set.
However, whenever I try to run sqlplus, I get a Memory fault(coredump):

Running:
$ file core
$ core: ELF-64 core file - PA-RISC 2.0 from 'sqlplus' - received SIGSEGV

If I run "adb sqlplus core"
$c
afixdpt+4A4 from afixdpt
afixdpt(
cannot unwind -- no unwind entry. (1)

Running :
$ gdb sqlplus core
Detected 64-bit executable.
Invoking /opt/langtools/bin/gdb64.
HP gdb 2.1
Copyright 1986 - 1999 Free Software Foundation, Inc.
Hewlett-Packard Wildebeest 2.1 (based on GDB 5.0-hpwdb-20000630)
Wildebeest is free software, covered by the GNU General Public License, and
you are welcome to change it and/or distribute copies of it under certain
conditions. Type "show copying" to see the conditions. There is
absolutely no warranty for Wildebeest. Type "show warranty" for details.
Wildebeest was built for PA-RISC 2.0 (wide), HP-UX 11.00.
..(no debugging symbols found)...
Core was generated by `sqlplus'.
Program terminated with signal 11, Segmentation fault.
(no debugging symbols found)...
warning: The shared libraries were not privately mapped; setting a
breakpoint in a shared library will not work until you rerun the program.

warning: section .data not found in /oracle/app/product/920/lib/libwtc9.sl
(no debugging symbols found)...(no debugging symbols found)...
(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...
(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...#0 0x2193b4 in ?? ()
(gdb) bt
#0 0x2193b4 in ?? ()
#1 0xc0000000001e26d4 in gethrtime () from /usr/lib/pa20_64/libc.2
Running:
$ chatr sqlplus
sqlplus:
64-bit ELF executable
shared library dynamic path search:
LD_LIBRARY_PATH enabled first
SHLIB_PATH enabled second
embedded path enabled third /oracle/app/product/920/sqlplus/lib/:/oracle/app/product/920/lib/:/usr/lib/pa20_64:/opt/langtools/lib/pa20_64:
shared library list:
libwtc9.sl
libcl.2
librt.2
libpthread.1
libnss_dns.1
libdl.1
libm.2
libc.2
shared library binding:
deferred
global hash table disabled
shared library mapped private disabled
shared library segment merging disabled
shared vtable support disabled
segments:
index type address flags size
6 text 4000000000000000 z---c D (default)
7 data 8000000100000000 ---m- D (default)
executable from stack: D (default)
kernel assisted branch prediction enabled
lazy swap allocation for dynamic segments disabled

and lastly:
$ ldd sqlplus
libwtc9.sl => /oracle/app/product/920/lib/libwtc9.sl
libcl.2 => /usr/lib/pa20_64/libcl.2
librt.2 => /usr/lib/pa20_64/librt.2
libpthread.1 => /usr/lib/pa20_64/libpthread.1
libnss_dns.1 => /usr/lib/pa20_64/libnss_dns.1
libdl.1 => /usr/lib/pa20_64/libdl.1
libm.2 => /usr/lib/pa20_64/libm.2
libc.2 => /usr/lib/pa20_64/libc.2
libdl.1 => /usr/lib/pa20_64/libdl.1
libdl.1 => /usr/lib/pa20_64/libdl.1
libdl.1 => /usr/lib/pa20_64/libdl.1

Any help will be appreciated.

Thanks

Carlo
Live fast, die young - enjoy a good looking corpse!
Honored Contributor
Yogeeraj_1
Posts: 4,613
Registered: ‎11-25-2001
Message 2 of 3 (531 Views)

Re: SQLPLUS core dump (Oracle 9.2.0.1)

hi,

Try setting the NLS_LANG environment variable to match your database, example,

export NLS_LANG=AMERICAN_AMERICA.US7ASCII

you may also consider relinking everything again.

Hope this helps!
Best Regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Honored Contributor
Steve Steel
Posts: 2,909
Registered: ‎02-13-2000
Message 3 of 3 (531 Views)

Re: SQLPLUS core dump (Oracle 9.2.0.1)

Hi

Hi

http://metalink.oracle.com/


Steve Steel


Reduce your support time!

Oracle Support Services' premier web support, MetaLink,
can save what you value most -- TIME!

OracleMetaLink is:

Available Online, 24x7 -- Leverage the internet's speed and accessibility for technical support that accommodates your schedule and needs.

Faster and More Efficient -- Logging Technical Assistance Requests (TARs) online allows you to:

Use TAR templates, describe a problem in your own words, cut and paste error messages
ELIMINATE hold times and voicemail tag
Take advantage of automatic skill routing
Use TAR profiles - templates of your product, platform, version numbers, CSI and contact information, eliminating the need to repeat standard profile information
Monitor or update your open TARs online
Proactive -- Take preventive action by downloading and applying appropriate software fixes, workarounds, or plan future upgrades.

Track the progress of bugs associated with your licensed products
A Global Knowledge Repository -- MetaLink contains Oracle Support Services' technical best practices and expertise for enhanced business productivity and minimized business disruption.

Login or Register now (only for customers with an active support contract on their Oracle licenses)!

OracleMetaLink Features:

No Additional Cost - Premier web support service available at no cost to Oracle customers with active support service contracts

Available Online, 24x7 - Always available twenty-four hours a day, seven days a week

Technical Libraries - Access information that will aid you in using Oracle products, such as hot topics, product reference, installation assistance materials, white papers, problem/solution articles, and more

Knowledge Base Search - Full-text queries against all content in MetaLink's repositories, including technical forum postings and the bug database

Forums - Post questions for feedback from technical analysts and other Oracle customers

Product Lifecycle - Product availability, product alerts, certifications, and de-support information online

Bug Database Search - Query published bugs from the Oracle Bug Database

File Access - Download patches and patch sets directly from OracleMetaLink

Enter TARs Online - Submit, update, review, and close your TARs online (not available in some countries)

Skills-Based Routing - TARs submitted electronically are automatically matched to the right technical resource within Oracle Support Services (not available in some countries)

TAR Access and Reporting - Track issues by generating and viewing TAR reports

My Headlines - Customize your MetaLink account to receive only the information you want

User Profile - Customize your personal Oracle Support Services account information

User Administration - Manage access of your company's MetaLink users

Context-Sensitive Help - Learn the features of MetaLink and see "how to" instructions

Feedback - Enter feedback about MetaLink

How can you get access to our current MetaLink web site? Customers with an active support contract for their Oracle licenses can register for access today or login if already registered. MetaLink is a valuable tool that will help you get the most out of your Oracle products.


If you want truly to understand something, try to change it. (Kurt Lewin)
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.