ITPub博客

首页 > 数据库 > Oracle > one oracle 10.2.0.3 for aix bug

one oracle 10.2.0.3 for aix bug

原创 Oracle 作者:ganquan 时间:2007-04-08 21:28:08 0 删除 编辑
SR Number 6251380.992 Open Date03-APR-07 12:31:07
Support Identifier 15177890 Namequan gan
Severity 2 Last Update06-APR-07 15:18:30
ProductOracle Database Configuration Assistant Product Version 10.2.0.3
PlatformAIX5L Based Systems (64-bit) Detailed StatusSoft Close
SR Reference n/a BUG Reference

Abstract

H:USING DBCA CREATE DB,FAILED TO RETRIEVE SIZE OF RAW DEVICE /DEV/RORA_RSPFILE
Resolution History


03-APR-07 12:31:07 GMT

The following files were uploaded for SR number 6251380.992:

F:dbca_err.rar


This SR was saved as a draft on: 03-APR-2007 03:32:42


~!CRITICAL_PRODUCTION!~
### Platform and O/S version, including patch set or service pack level? ###

AIX 5.3 ML5
### What version and patch set level of the database are you running? ###

oracle 10.2.0.3
### Are you running the most recent patch set? ###

have been the latest patchset
### Problem Description and its duration: ###

can't not using dbca to create database while choosing raw devices
### If you are receiving errors, please list the exact error messages and message text.###

failed to retrieve size of raw device "/dev/rora_rspfile",
exec():0509-036 cannot load program
/oracle/product/app/10.2.0.1/bin/rawutl because of the following errors:
0509-150 Dependent module /oracle/product/app/10.2.0.1/lib32/libttsh10.a(shr_ttsh10.o)could not be
loaded.
0509-103 The module has an invalid magic number."

### Did the error generate a trace file? ###

No
### List and describe files that you plan to upload: ###

none
### What was being done at time of error/any changes since this last worked? ###

none
### Error can be generated if SQL statement is run in SQL*Plus/Server Mgr: ###


### What is the frequency of the error? ###


### What is the impact to your business because of this problem? ###


### Are you running any third-party applications? ###

none
### Has the third-party Vendor been contacted? ###


Can you easily recover from, bypass or work around the problem?

No
Does your system or application continue normally after the problem occurs?

No
Are the standard features of the system or application still available; is the loss of service minor?

No
Error : exec():0509-036
Contact me via : MetaLink


03-APR-07 13:09:45 GMT

(Update for record id(s): 103139643,103140067,103140085,103140358)

ISSUE CLARIFICATION
===================
-- Problem Statement:
Can't not using dbca to create database while choosing raw devices.
failed to retrieve size of raw device "/dev/rora_rspfile",
exec():0509-036 cannot load program
/oracle/product/app/10.2.0.1/bin/rawutl because of the following errors:
0509-150 Dependent module /oracle/product/app/10.2.0.1/lib32/libttsh10.a(shr_ttsh10.o)could not be loaded.
0509-103 The module has an invalid magic number."



-- Steps To Reproduce:
x

-- Business Impact:
x

DATA COLLECTED
==============
Screen Shots
--------------------



DBCA screen shot

ISSUE VERIFICATION
==================
Verified the issue referencing data collected records as noted above.


UPDATE
======
Please upload following info to the bug

% ldd `which rawutl`
% ar -tv $ORACLE_HOME/lib/libttsh10.a
% ls -l `which rawutl`
% echo $LIBPATH
% echo $LD_LIBRARY_PATH


STATUS
======
@CUS -- Waiting for customer response




03-APR-07 13:09:48 GMT

Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn.


04-APR-07 02:50:07 GMT

New info : quan_gan@vandagroup.com.cn
[GXNX_APPB:/oracle]>ldd /oracle/product/app/10.2.0.1/bin/rawutl
/oracle/product/app/10.2.0.1/bin/rawutl needs:
/usr/lib/libc.a(shr_64.o)
/usr/lib/libpthreads.a(shr_xpg5_64.o)
/oracle/product/app/10.2.0.1/lib/libttsh10.a(shr_ttsh10.o)
/unix
/usr/lib/libcrypt.a(shr_64.o)
/usr/lib/libdl.a(shr_64.o)
/usr/lib/libc.a(aio_64.o)
/usr/lib/libodm.a(shr_64.o)
/usr/lib/libperfstat.a(shr_64.o)
/usr/lib/libcfg.a(shr_64.o)
/usr/lib/liblvm.a(shr_64.o)

[GXNX_APPB:/oracle/product/app/10.2.0.1/lib]>ar -tv libttsh10.a
[GXNX_APPB:/oracle/product/app/10.2.0.1/lib]>


[GXNX_APPB:/oracle/product/app/10.2.0.1]>ls -l /oracle/product/app/10.2.0.1/bin/rawutl
-rwxr-xr-x 1 oracle oinstall 9363 Oct 28 00:51 /oracle/product/app/10.2.0.1/bin/raw
utl


[GXNX_APPB:/oracle/product/app/10.2.0.1]>echo $LIBPATH
/oracle/product/app/10.2.0.1/lib:/oracle/product/app/10.2.0.1/ctx/lib

[GXNX_APPB:/oracle/product/app/10.2.0.1]>echo $LD_LIBRARY_PATH
/oracle/product/app/10.2.0.1/lib:/usr/lib




04-APR-07 07:44:45 GMT

-- Client called back --


04-APR-07 08:19:58 GMT

(Update for record id(s): 103170346)

UPDATE
======
Thanks for providing the requested info,
.
Similar issue constituted the subject of Bug 5949863
Abstract: RAWUTL CANNOT LOAD LIBTTSH10.A(SHR_TTSH10.O) - INVALID MAGIC NUMBER
Which has been concluded as it is INSTALL issue , hence I transfer your SR to INSTALL team.

Bug Conclusion
-------------------------
Ldd on rawutl o/p clearly shows that you are using 64bit rawutl executable but the LIBPATH is set to lookup 32bit /ora
cle/product/app/10.2.0.1/lib hence this issue .

However this issue is due to 64bit rawutl found instead of 32bit rawutl
Similar bugs we see in 10.2.0.1 ( bug4529151) and also bug5956984

Regards
Hassan


STATUS
======
@WIP -- Work In Progress




04-APR-07 08:20:00 GMT

Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn.


04-APR-07 09:16:04 GMT

UPDATE
======
Hello Quan,

My name is Cristina Cercel and I have just been assigned this SR I will assist you further with this issue. We are currently reviewin
g/researching the situation and will update the Service Request (SR) or call you
as soon as we have relevant information. Thank you for your patience.

Best Regards,
Cristina
Global Customer Services

STATUS
=======

@WIP -- Work In Progress



04-APR-07 09:16:09 GMT

Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn.


04-APR-07 13:41:06 GMT

(Update for record id(s): 103182859)

CAUSE DETERMINATION
===================
You are facing the bug 5956984
Abstract: RAWUTL CANNOT LOAD LIBTTSH10.A(SHR_TTSH10.O) - INVALID MAGIC NUMBER RUNNING DBCA

Which is duplicate of
Bug 4529151
Abstract: INSTALL-10201-050630.0012:UPGRADE UTIL GAVE ERROW WITH RAWUTL




CAUSE JUSTIFICATION
===================
From bug :
dbua on AIX is using 32 bit JAVA.
@ When it tries to find the size of a raw device, it uses the binary
@ OH/bin/rawutl
@ .
@ But we are shipping a 64 bit 'rawutl'
@ .
@ So, when the 64 bit executable is invoked from 32 bit java with LIBPATH set
@ to OH/lib32 , it fails with the follwoing error :
@ $ bin/rawutl /dev/rhdisk41
@ exec(): 0509-036 Cannot load program bin/rawutl.bin because of the following
@ errors: 0509-150 Dependent module
@ /install/skaram/10gr2/lib32/libttsh10.a(shr_ttsh10.o) could not be loaded.
@ 0509-124 The program is a discontinued 64-bit object file.
@ .




04-APR-07 13:59:07 GMT

New info : quan_gan@vandagroup.com.cn
I want to know when I can get the fix about the bug?

I will waitting for creating database all the day.

thks!



04-APR-07 14:01:05 GMT

.
.
UPDATE
=======
Hi Quan,

Sorry for the delay. We will get back to you as soon as we can.

Best Regards,
Hassan
Global Customer Services

STATUS
=======

@WIP -- Work In Progress







04-APR-07 14:01:16 GMT

Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn.


05-APR-07 07:09:51 GMT

(Update for record id(s): 103209564)

UPDATE
======
Hi Quan,

Thanks for your continued patience as we work to deliver a solution.
Please standby for an update shortly.

Best Regards,
Hassan
Global Customer Services


STATUS
======
@WIP - Work In Progress




05-APR-07 07:09:53 GMT

Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn.


05-APR-07 07:34:40 GMT

(Update for record id(s): 103210176)

UPDATE
======
Dear Customer,

Apologies for the delay.
In Fact , after analyze, this issue appears to be addressed by Bug 5949863
Status: 11,Code Bug (Response/Resolution)
Severity: 2,Severe Loss of Service Fixed In Ver:
O/S: 212 AIX5L Based Systems (64-bit)
PL Group: Gen/Port: P Error #: - Pub: N

Abstract: RAWUTL CANNOT LOAD LIBTTSH10.A(SHR_TTSH10.O) - INVALID MAGIC NUMBER



the bug is currently being worked, but we can request the one-off patch requesting the 32bit rawutl executable
as one-off patch.

I need the following informations to request you for a fix :

1- Does this affect a major Milestone?
2- If yes, Milestone Date?
3- Date by which the fix must be installed on customers system?
4- Technical Impact of this bug?
5- Business Impact of this bug ?

I'm waiting your answers to ask a fix from developpement .
Regards
Hassan


STATUS
======
@CUS -- Waiting for requested information




05-APR-07 07:34:41 GMT

Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn.


05-APR-07 07:49:35 GMT

(Update for record id(s): 103210676)

UPDATE
======
I need to know also the list of the patchs already installed :

List of one-off patches applied since using the current patchset version:
%opatch lsinventory -detail

Regards
Hassan



STATUS
======
@CUS -- Waiting for requested information




05-APR-07 07:49:37 GMT

Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn.


05-APR-07 09:06:03 GMT

The customer : quan_gan@vandagroup.com.cn : has uploaded the following file via MetaLink:
F:opatch.10.2.0.3.txt



05-APR-07 09:37:45 GMT

(Update for record id(s): 103213641)

UPDATE
======
Still waiting answers for :


1- Does this affect a major Milestone?
2- If yes, Milestone Date?
3- Date by which the fix must be installed on customers system?
4- Technical Impact of this bug?
5- Business Impact of this bug ?

Without this , the request for a fix could be rejected by developpement .
Regards
Hassan

Regards
Hassan

STATUS
======
@CUS -- Waiting for requested information




05-APR-07 09:37:47 GMT

Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn.


05-APR-07 12:03:20 GMT

(Update for record id(s): 103218248)

UPDATE
======
Hi Quan,

I filed a one-off request with Oracle Development (BDE) for the related bug. The request is curren
tly under review. I will let you know as soon as I have more information.

Thank You,
Hassan
Global Customer Services


STATUS
======
@DEV - Waiting for Oracle Development response




05-APR-07 12:03:22 GMT

Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn.


05-APR-07 16:11:15 GMT

New info : quan_gan@vandagroup.com.cn
1- Does this affect a major Milestone?
Yes,because I can't create database using raw devices!
2- If yes, Milestone Date?
April 8,2007
3- Date by which the fix must be installed on customers system?
April 7,2007
4- Technical Impact of this bug?
I can't create database using raw devices!
5- Business Impact of this bug ?
My customer system will can't create new database using raw devices!!



05-APR-07 16:41:44 GMT

(Update for record id(s): 103231380)

UPDATE
======
Hi Quan,

I filed a one-off request with Oracle Development (BDE) for the related bug. The request is curren
tly under review. I will let you know as soon as I have more information.

Thank You,
Hassan
Global Customer Services


STATUS
======
@DEV - Waiting for Oracle Development response




05-APR-07 16:41:46 GMT

Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn.


06-APR-07 02:57:02 GMT

New info : quan_gan@vandagroup.com.cn
hi,

Thanks for your job!

I am afraid that My customer call me to create new database using raw devices!
I will waiting the fix about the bug all the day and night!

ganquan



06-APR-07 05:56:12 GMT


Cluster Technical Coordinator's update: (Published)
====================================================
Hi,

We have received your updates. The owning engineer is currently off-shift.
I will set the status of this issue to "Customer to be served" for the engineers attention and action upon return.

Thank You
Zulfiquar
Cluster Technical Co-ordinator

STATUS :
========
@ CTS Customer To Be Served


06-APR-07 07:57:54 GMT

(Update for record id(s): 103247151)

UPDATE
======
Unfortuantely, the request fo a fix has been rejected by Developpement because the bug 5949863 is not fixed
yet and it is under developpement . We cannot deliver a fix the 7th April for a
request filled the 5th Of April , Developpement estimate that is totally unreal
istic.
As Workaround , you can consider :



ACTION PLAN
===========
1- Create database manually using a script


STATUS
======
@CUS - Waiting for customer response




06-APR-07 07:57:56 GMT

Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn.


06-APR-07 08:36:02 GMT

New info : quan_gan@vandagroup.com.cn
Hi

I am sad!

Our customers think that your oracle product and services will not worth very much!


ganquan




06-APR-07 08:45:57 GMT

(Update for record id(s): 103247961)

UPDATE
======
I'm really Sorry but unfortunately the bug you are facing is not fixed yet.
As workaround You can pull the file from the old release than 10.2.0.1 and use that version of rawutl as a worka
round waiting that the bug is fixed definitively.
Or
Create the database using scripts generated through DBCA


Regards
Hassan

STATUS
======
@CUS -- Waiting for customer response




06-APR-07 08:45:59 GMT

Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn.


06-APR-07 15:15:52 GMT

(Update for record id(s): 103256966,103256969)

PROPOSED SOLUTION(S)
====================
As workaround You can pull the file from the old release than 10.2.0.1 and use that version of rawutl as a workaround waiting that the bug is fixed d
efinitively.
Or
Create the database using scripts generated through DBCA


PROPOSED SOLUTION JUSTIFICATION(S)
==================================
The fix for the Bug 5949863 you are facing is under developpemen.

SOLUTION / ACTION PLAN
======================
-- To implement the solution, please execute the following steps::
See PROPOSED SOLUTION section.



06-APR-07 15:17:49 GMT

.
UPDATE
=======

Hi Quan,

I am inactivating this Service Request, as I believe I have provided you with the solution to your issue. If this is not the case, p
lease update the Service Request within the next two weeks and I will be glad to
assist you further. Otherwise, no update is necessary and after two weeks, the
Service Request will automatically close.

Best Regards,
Hassan
Global Customer Services
[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/67233/viewspace-909362/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    20
  • 访问量
    497691