- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: SQLPLUS core dump (Oracle 9.2.0.1)
Operating System - HP-UX
1753481
Members
4420
Online
108794
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2002 04:56 AM
тАО08-22-2002 04:56 AM
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
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!
- Tags:
- SIGSEGV
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2002 05:21 AM
тАО08-22-2002 05:21 AM
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
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2002 06:03 AM
тАО08-22-2002 06:03 AM
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.
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 Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP